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 output.

Note: The example below 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: Dashboard Output

Dashboard output

Ranking Consumption - Trade Area Report: Long File Download

Long file output

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 opens in new window and FoodSpend opens in new window 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