Sunday, July 26, 2015
Ad$pender - The Problem of Zero Results
Ad$pender is usually a wonderful database that gives you advertising budgets for categories of products, companies and brands. You can use the database from off-campus with your regular net ID and password.
HOWEVER, a common problem is building your query and getting no results.
This is because a data point is missing. Instead of n/a in your results, you just get a big fat zero for the whole thing. Through trial and error, you'll have to adjust your query in order to get results.
I'll let AdSpender explain.
What does “There were no results for the report you requested” mean? This means that there was no activity found for the report you ran. This could happen for a number of reasons. For example, the brands included in your report may not have had any activity during the time period you requested, or perhaps dollars or ratings were not yet available for the time period you included in the report. In this situation you should check data availability or change some of your selections before running your report again.
Note: This tutorial is excellent, but it starts with the old library page. AdSpender still works exactly the same - just find Ad$pender here.