How do I interpret the long file download of a Homescan Profiles - Ranking Variable report?

The long file output of Homescan Profiles - Ranking Variables reports includes fields that aren’t present in the ENVISION dashboard output. Here's how to reconcile and interpret these fields.

ENVISION Dashboard

Screenshot of report in ENVISION

Long File Download

Screenshot of report in Excel

Screenshot of report in Excel

Field Name Reconciliation
Dashboard Field Name Download Field Name Definition
Buyer Hhld Incidence The count of households in the selected input that buy the line item.
Buyer % Pen % Incidence Of all households in the selected input, % Pen is the percentage of households that buy the line item.
Base Buyer Hhld Base Incidence The count of households in the benchmark that buy the line item.
Base Buyer % Pen Base % Incidence Of all the households in the benchmark, % Pen is the percentage of households that buy the line item.
Buyer Index Index: % Incidence Measures how likely the households in the selected input are to buy the line item compared to buyers in the benchmark. An index of 100 is average.
$ Aggregate $ The amount, in dollars, spent on the line item by all households in the selected input.
$/Hhld $/Hhld The average amount, in dollars, spent on the line item by each household in the selected input.
Base $ Base Aggregate $ The amount, in dollars, spent on the line item by all households in the benchmark.
Base $/Hhld Base $/Hhld The average amount, in dollars, spent on the line item by each household in the benchmark.
$/Hhld Index Index: $/Hhld A measure of comparison of how much each household in the selected input spends on the line item compared to each household in the benchmark. An index of 100 is average.
$/Buyer Hhld $/Incidence The average amount, in dollars, spent on the line item by buyer households in the selected input.
$/Buyer Hhld Index Index: $/Incidence A measure of comparison of how much each buyer household in the selected input spends on the line item compared to each buyer household in the benchmark. An index of 100 is average.
  Base $/Incidence The average amount, in dollars, spent on the line item by buyer households in the benchmark.