Submit a request

Call Us: 1-888-339-3304

What fields should I use in the Long file download of a Ranking Consumption - Trade Area Report?

The Long file output of a Ranking Consumption - Trade Area Report includes Incidence and Incidence % fields that aren’t present in the dashboard.

See images below. 

(NOTE: This example is showing dollar values as the consumption data but if you were using a non-dollar variable, the 'Consumption Unit' column or 'Aggregate $' column is still total aggregate consumption.)

 

Ranking Consumption - Trade Area Report: Dashbord output

mceclip0.png

 

Ranking Consumption - Trade Area Report: Long File Download

mceclip1.png

 

Field name reconciliation:

Dashboard   Download
Consumption Unit  -  Aggregate $
Unit/Hhld  -  $/Hhld
% Comp  -  % Incidence
Base Consumption Unit  -  Base Aggregate $
Base Unit/Hhld  -  Base $/Hhld
Base % Comp  -  Base % Incidence
Index Unit/Hhld  -  Index: $/Hhld
Index % Comp  -  Index: $/Incidence

 

The Incidence values in the Long File Download are the aggregate consumption values of the variable. 

It is our recommendation that if you download the HouseholdSpend and FoodSpend Consumption Profile Reports by Long File, use only the following fields from the download:

  • Aggregate $
  • $/Hhld
  • % Incidence
  • Base Aggregate $
  • Base $/Hhld
  • Base % Incidence
  • Index: $/Hhld
  • Index: $/Incidence
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Please sign in to leave a comment.

Powered by Zendesk