ADVE 4100 - Media Planning: Ad spending

Need Help?
Ask Us!

Report access
issues here
.

Ad spending - an easier source

Ad$pender - a harder source

Kantar Media (formerly Competitive Media Reporting) monitors advertising that is placed in certain consumer media, and then estimates the amounts spent.  You can extract data by company, product, or brand; and the data are available monthly, quarterly, and annually.  Please note the following limitations:

  • The data are not comprehensive.  Ad$pender monitors a defined 'universe' of consumer media only.  (~200 consumer magazines, ~200 newspapers, x TV stations, x radio stations, etc.)
  • The data are estimated.  Once the producer of Ad$pender has calculated how much advertising time (space) has been used, they estimate the cost of that time/space based on "off-the-shelf" and confidential advertising prices

Ad$pender - "Create report" tips

There is a user manual available (the PDF document linked after the database name), but it is very long and detailed!  Below are shorter instructions to get you started:

From the Ad$pender homepage, under Custom Reports, click "create".  This opens a 6-step worksheet that walks you through setting up a report.

  1. Media.  Choose which media you want data for.  Highlight and click the right arrow to select.
  2. Time period.  First click the "Show Data Availability" button:  This tells you the dates for the latest available data, which vary by media channel.  With that information, make your selections.
  3. Product set.  Things to know:
    • Be aware that products are listed in order by classification code, not alphabetically!  
    • Search drop-down menu.  Here you can see the hierarchical levels of the classification scheme from broad to narrow (global product groups to microcategories for product categories; ultimate owner to products for brands/products). 
    • "Show all" button versus "Search" button:  You can browse by clicking the Show all button. Keyword searching works well IF you already know the terminology used in the classification scheme! 
    1. When just beginning, start near the top of the classification hierarchy (for example, with industry), and click Show All. Then you can find the base classification code (1 letter, 1 digit; e.g. F2) you'll need when browsing in the narrower levels of the scheme.
    2. Change the search drop-down menu to Categories or subcategories and click Show All again to get more detailed product choices.
    3. Make your selections.
  4. Report format:  pick what works for you.
  5. Report options:  at least increase the font size?
  6. Run report:  this will take a minute or several minutes, depending on how many variables you’ve selected.