Most Likely List
Most Likely List
Most likely list is a report of past advertisers of the 5 years that are most likely to re-advertise with us. Most likely list needs to be done once previous issue closes
Open Maghub:
Reports - All Reports - Consolidated Sales Report
Choose the “Brand” you are pulling the report for. (i.e Golf, National Jurist, PreLaw) - Choose “Publication” (Magazine you are running the report on) - Choose “Issues” (issues in the past 5 years) Run a separate report for current year
For “Probability” you will want to pick 10% or higher. (Probability is the status of the IO, 10% IO started- 100% IO complete)
Run report at 90% Golf, Inc, Crittenden Report & Crittenden Medical
Run at 10% for PreLaw, National Jurist & International Jurist
Run report and export the results. Copy excel report and create a tab in the current google sheet in Most Likely Folder: Most Likely Lists
Cleaning up the report:
Once the report is exported you will want to delete all columns except: Company, Publication, Issue, Ad Size Decimal, Order Rep & Cash.
Add columns for each year for Ad Size and Cash and organize columns in this order:
Order Rep - Company - Issue - Ad Size Decimal - Cash
Ad columns for each year i.e GI 2022 - Cash - GI 2021 - Cash
Organize each company onto one line by year issues and cash amount.
Check with the editorial department for the “add in” list. This list is companies that editorial has included in the issue. Create a column for the “add in” or “in stories” list and update accordingly.
If there is an ad size but $0 cash amount, check in Maghub what the charge was for and put in a quick explanation under the year. I.e “added value” “comp ad”
Add up each year and create a total sales at the end of report and add up each year:
Before completion combine any duplicate companies and data.
The “Sales Rep” should be updated for each company to the correct sales person. If you don’t know who is over that account you can look that up in Maghub.
Once done you can remove “Issue” and any blank columns. Add border lines and to separate years to make the report easier to read for the sales team:
Related Articles
Conference Attendee List - Rules for the Sponsors list and for the Attendees list
Conference Attendee List Rules for Sponsors and for Attendees Table of Contents Link to Main Section 1 Link to Main Section 2 Overview of the SOP - Describes the rules for distribution of conference attendee lists Resources Conference Attendee Lists ...Create the list for Attendees and Sponsors (RegFox Widget)
Create the list for Attendees and Sponsors (RegFox Widget) Table of Contents Link to Main Section 1 Link to Main Section 2 Additional Instructions Other Details Overview of the SOP - This document is intended to show how to create the list we submit ...Supply List
Supplies needed for every conference: Clear attendee badge holders Badge ribbon labels (speaker, sponsor, VIP, etc.) Small colored dot stickers - to put on badges when needing to signify a special registration Metal bulldog clips for badges Lanyards ...Dynamic Attributes in MagHub
Dynamic Attributes in MagHub Table of Contents Resources & Definitions How to Create or Edit How to Import Data into a Dynamic Attribute Overview - How to create or edit a Dynamic Attribute in MagHub. Dynamic Attributes are the dropdown lists that we ...Instructions for Golf Inc. Competitions
Instructions for Golf Inc. Competitions Deadlines for each competition The call for entries date for each Competition is noted on the production calendar. ...