Crosstab Segmentations

Purpose

Show a cross tabulation of 2 or 3 segmentation schemes.  The content of the report cells is the intersection of the household behavior of the households in the designated segments.

Be aware that assumptions and filters in place for each of the participating segmentations are in effect. CrosstabSegmentation

Instance

Location – This is the standard selector for groups of stores. You have access to

  • store hierarchies where you can select a node in a hierarchy, and
  • store attributes where you can select an attribute of store

The report will aggregate the results for all stores you define into a total for the report.

Product – This is the standard selector for groups of items.  You have access to

  • product hierarchies where you can select a node in a hierarchy, and
  • product attributes where you can select an attribute of items

The report will aggregate the results for all items you define into a total for the report.

Time – This is the standard selector for time

Segments in Rows – Select the segmentation whose values you would like to display in the rows of the report.

Segments in Columns– Select the segmentation whose values you would like to display across the columns of the report.

Segments on Each Page – Select the segmentation whose values you would like to be select-able for paging.  If no third segmentation breakout is desired, select “None” here.

Runtime Choices

Page Segment Displayed – when the Segments on Each Page selection is not “None” this selector will appear with the segmentation values of the selected Page direction segmentation.

Metric – select the metric to be displayed.

  • # HHs – count of individual households
  • $ – net price paid (list price less item markdown)
  • $/HH  – dollars per household
  • $/Txn – dollars per transaction
  • Disc $ – sum of the markdown dollars
  • Txns per HH per Wk – Transactions per household per week.

 

Rows

Segment values of the segmentation selected from the Segments in Rows dropdown.

Columns

Segment values of the segmentation selected from the Segments in Rows dropdown.