Cube Data Dictionary¶
Cube: Spend¶
FIELD |
DATA TYPE |
DESCRIPTION |
CONFIG_ID |
TEXT |
Unique identifier that groups a Cube customer’s selected configurations including competitors. |
CUBE_TYPE |
TEXT |
The grouping methodology used to define a row. |
CUBE_TIME_UNIT |
TEXT |
The calendar aggregation of a CUBE_TYPE. |
CUBE_TIME |
DATE |
The date shown signifies the first date in the CUBE_TIME grouping. e.g., CUBE_TIME = ‘2024-01-01’ and CUBE_TIME_UNIT = ‘Year’ is the year beginning 2024-01-01 |
PRIMARY_ENTITY |
TEXT |
The merchant used to define a group of shoppers. e.g., PRIMARY_ENTITY = ‘MCDONALDS’ shows MCDONALDS customers. |
PRIMARY_MCC |
TEXT |
The merchant category code (MCC) of the PRIMARY_ENTITY. MCC is a number used by card issuers to classify the type of business where a purchase is made. |
PRIMARY_ENTITY_TYPE |
TEXT |
The entity categorization of the PRIMARY_ENTITY. Entity types distinguish the merchant where a transaction occurred from the payment agent used to make a payment , the delivery agent used to make an order, or the MCC categorization of the transaction. The PRIMARY_ENTITY can be any of those entity types. When calculating industry levels or total numbers, avoid combining multiple PRIMARY_ENTITY_TYPEs. For example, calculating total fast food spending in New Jersey by summing where SHOPPER_STATE = ‘NJ’ would include spend from MCDONALDS, a merchant, and UBER EATS, an intermediary. That means transactions at MCDONALDS using UBER EATS would be counted twice. |
SHOPPER_CARD_TYPE |
TEXT |
The payment card type used by the shopper such as a credit, debit card, etc. |
SHOPPER_GENERATION |
TEXT |
The age generation of the shopper. |
SHOPPER_COUNTRY |
TEXT |
The country of the shopper. This is from the shopper’s address associated with their payment card. |
SHOPPER_REGION |
TEXT |
The US Census region of the shopper. This is from the shopper’s address associated with their payment card. |
SHOPPER_STATE |
TEXT |
The US state of the shopper. This is from the shopper’s address associated with their payment card. |
SHOPPER_MSA |
TEXT |
The metropolitan statistical area (MSA) of the shopper. This is from the shopper’s address associated with their payment card. |
PAYMENT_AGENT |
TEXT |
The third party processor, digital payment network, or other payment party associated with a transaction. e.g. PAYPAL |
INTERMEDIARY |
TEXT |
The delivery agent or platform associated with a transaction. e.g. DOORDASH |
MERCHANT_DISTANCE_FROM_HOME |
NUMBER |
Distance from the merchant to the shopper’s home zip code, in miles. Values shown reflect transaction was less than or equal to that distance in miles. 251 shows transactions greater than 250 miles away. e.g. MERCHANT_DISTANCE_FROM_HOME = 5 shows purchases less than 5 miles but greater than 1 mile away from the home location. |
CHANNEL |
TEXT |
The payment channel used for the transaction. Card Present is typically interpreted as an in-person transaction, while Card Not Present is typically interpreted as an online transaction. |
DAYPART |
TEXT |
The time of day the transaction occurred, grouped into dayparts. |
SHOPPER_SEGMENT |
TEXT |
Custom defined groupings that define a user group beyond the available fields. E.g., a MCDONALDS customer who spent more than $50 a month in 2024. |
SPEND |
NUMBER |
The amount of total spend for the given CUBE_TIME and shopper-cohort at the listed PRIMARY_ENTITY. |
TRANSACTIONS |
NUMBER |
The total number of transactions for the given CUBE_TIME and shopper-cohort at the listed PRIMARY_ENTITY. |
SHOPPER_INCOME_BRACKET |
TEXT |
The income of the shopper, grouped into income brackets. |
SHOPPER_KIDS |
TEXT |
Flag for whether the shopper has kids. |
SHOPPER_GENDER |
TEXT |
PLACEHOLDER FIELD The gender of the shopper. |
AS_OF_DATE |
DATE |
The date when the row was updated. |
Cube: Cross Shopping¶
FIELD |
DATA TYPE |
DESCRIPTION |
|
CONFIG_ID |
TEXT |
Unique identifier that groups a Cube customer’s selected configurations including competitors. |
|
CUBE_TYPE |
TEXT |
The grouping methodology used to define a row. |
|
CUBE_TIME_UNIT |
TEXT |
The calendar aggregation of a CUBE_TYPE. |
|
CUBE_TIME |
DATE |
The date shown signifies the first date in the CUBE_TIME grouping. e.g., CUBE_TIME = ‘2024-01-01’ and CUBE_TIME_UNIT = ‘Year’ is the year beginning 2024-01-01 |
|
PRIMARY_ENTITY |
TEXT |
The merchant used to define a group of shoppers. e.g., PRIMARY_ENTITY = ‘MCDONALDS’ shows MCDONALDS customers. SECONDARY_ENTITY shows the merchant where spend occurred. e.g., PRIMARY_ENTITY = ‘MCDONALDS’ and SECONDARY_ENTITY = ‘TACO BELL’, this shows spend at TACO BELL from MCDONALDS customers. |
|
PRIMARY_MCC |
TEXT |
The merchant category code (MCC) of the PRIMARY_ENTITY. MCC is a number used by card issuers to classify the type of business where a purchase is made. |
|
SECONDARY_ENTITY |
TEXT |
SECONDARY_ENTITY shows the merchant where spend occurred. PRIMARY_ENTITY shows the merchant used to define a group of shoppers. e.g., PRIMARY_ENTITY = ‘MCDONALDS’ and SECONDARY_ENTITY = ‘TACO BELL’, this shows spend at TACO BELL from MCDONALDS customers. |
|
SECONDARY_MCC |
TEXT |
The merchant category code (MCC) of the SECONDARY_ENTITY. MCC is a number used by card issuers to classify the type of business where a purchase is made. |
|
SHOPPER_CARD_TYPE |
TEXT |
The payment card type used by the shopper such as a credit, debit card, etc. |
|
SHOPPER_GENERATION |
TEXT |
The age generation of the shopper. |
|
SHOPPER_COUNTRY |
TEXT |
The country of the shopper. This is from the shopper’s address associated with their payment card. |
|
SHOPPER_REGION |
TEXT |
The US Census region of the shopper. This is from the shopper’s address associated with their payment card. |
|
SHOPPER_STATE |
TEXT |
The US state of the shopper. This is from the shopper’s address associated with their payment card. |
|
SHOPPER_MSA |
TEXT |
The metropolitan statistical area (MSA) of the shopper. This is from the shopper’s address associated with their payment card. |
|
SHOPPER_SEGMENT |
TEXT |
Custom defined groupings that define a user group beyond the available fields. E.g., a MCDONALDS customer who spent more than $50 a month in 2024. |
|
SPEND |
NUMBER |
The amount of total spend for the given CUBE_TIME and shopper-cohort at the listed PRIMARY_ENTITY by shared customers of the PRIMARY_ENTITY and SECONDARY_ENTITY. |
|
TRANSACTIONS |
NUMBER |
The total number of transactions for the given CUBE_TIME and shopper-cohort at the listed PRIMARY_ENTITY by shared customers of the PRIMARY_ENTITY and SECONDARY_ENTITY. |
|
CARDS |
NUMBER |
The total number of cards, a proxy for customers, for the given CUBE_TIME and shopper-cohort who purchased at both the PRIMARY_ENTITY and SECONDARY_ENTITY. |
|
SECONDARY_ENTITY_SPEND |
NUMBER |
The amount of total spend for the given CUBE_TIME and shopper-cohort at the listed SECONDARY_ENTITY by shared customers of the PRIMARY_ENTITY and SECONDARY_ENTITY. |
|
SECONDARY_ENTITY_TRANSACTIONS |
NUMBER |
The total number of transactions for the given CUBE_TIME and shopper-cohort at the listed SECONDARY_ENTITY by shared customers of the PRIMARY_ENTITY and SECONDARY_ENTITY. |
|
SHOPPER_INCOME_BRACKET |
TEXT |
The income of the shopper, grouped into income brackets. |
|
SHOPPER_KIDS |
TEXT |
Flag for whether the shopper has kids, either Has Kids, No Kids, or N/A. |
|
SHOPPER_GENDER |
TEXT |
PLACEHOLDER FIELD The gender of the shopper. |
|
AS_OF_DATE |
DATE |
The date when the row was updated. |
Cube: Customer Journey¶
FIELD |
DATA TYPE |
DESCRIPTION |
CONFIG_ID |
TEXT |
Unique identifier that groups a Cube customer’s selected configurations including competitors. |
CUBE_TYPE |
TEXT |
The grouping methodology used to define a row. |
CUBE_TIME_UNIT |
TEXT |
The calendar aggregation of a CUBE_TYPE. |
CUBE_TIME |
DATE |
The date shown signifies the first date in the CUBE_TIME grouping. e.g., CUBE_TIME = ‘2024-01-01’ and CUBE_TIME_UNIT = ‘Year’ is the year beginning 2024-01-01 |
PRIMARY_ENTITY |
TEXT |
The merchant used to define a group of shoppers. e.g., PRIMARY_ENTITY = ‘MCDONALDS’ shows MCDONALDS customers. |
PRIMARY_MCC |
TEXT |
The merchant category code (MCC) of the PRIMARY_ENTITY. MCC is a number used by card issuers to classify the type of business where a purchase is made. |
SECONDARY_ENTITY |
TEXT |
SECONDARY_ENTITY shows the merchant where spend occurred. PRIMARY_ENTITY shows the merchant used to define a group of shoppers. e.g., PRIMARY_ENTITY = ‘MCDONALDS’ and SECONDARY_ENTITY = ‘TACO BELL’, this shows spend at TACO BELL from MCDONALDS customers. |
SECONDARY_MCC |
TEXT |
The merchant category code (MCC) of the SECONDARY_ENTITY. MCC is a number used by card issuers to classify the type of business where a purchase is made. |
SHOPPER_CARD_TYPE |
TEXT |
The payment card type used by the shopper such as a credit, debit card, etc. |
SHOPPER_GENERATION |
TEXT |
The age generation of the shopper. |
SHOPPER_COUNTRY |
TEXT |
The country of the shopper. This is from the shopper’s address associated with their payment card. |
SHOPPER_REGION |
TEXT |
The US Census region of the shopper. This is from the shopper’s address associated with their payment card. |
SHOPPER_STATE |
TEXT |
The US state of the shopper. This is from the shopper’s address associated with their payment card. |
SHOPPER_MSA |
TEXT |
The metropolitan statistical area (MSA) of the shopper. This is from the shopper’s address associated with their payment card. |
SHOPPER_SEGMENT |
TEXT |
Custom defined groupings that define a user group beyond the available fields. E.g., a MCDONALDS customer who spent more than $50 a month in 2024. |
MERCHANT_DISTANCE_FROM_HOME |
NUMBER |
Distance from the merchant to the shopper’s home zip code, in miles. Values shown reflect transaction was less than or equal to that distance in miles. 251 shows transactions greater than 250 miles away. e.g. MERCHANT_DISTANCE_FROM_HOME = 5 shows purchases less than 5 miles but greater than 1 mile away from the home location. |
CHANNEL |
TEXT |
The payment channel used for the transaction. Card Present is typically interpreted as an in-person transaction, while Card Not Present is typically interpreted as an online transaction. |
DAYPART |
TEXT |
The time of day the transaction occurred, grouped into dayparts. |
TRANSACTIONS |
NUMBER |
The total number of transactions for the given CUBE_TIME and shopper-cohort at the listed SECONDARY_ENTITY by customers of the PRIMARY_ENTITY. |
SHOPPER_INCOME_BRACKET |
TEXT |
The income of the shopper, grouped into income brackets. |
SHOPPER_KIDS |
TEXT |
Flag for whether the shopper has kids. |
SHOPPER_GENDER |
TEXT |
PLACEHOLDER FIELD The gender of the shopper. |
AS_OF_DATE |
DATE |
The date when the row was updated. |