Consumer Spending Attributes

Snowflake table name : CYBERSYN.CONSUMER_SPENDING_ATTRIBUTES

View documentation here.

Name	Description	Type	Example
VARIABLE	Unique identifier for the distinct measure. Joinable to the consumer_spending_timeseries table	VARCHAR	5287dac8b467524f3f52d37405f6ab3d
VARIABLE_NAME	Human-readable version of the variable. Factors that make up a distinct variable include the measure (transactions, revenue, AOV), panelist age, panelist income, and more	VARCHAR	AOV (USD) | Week - Monday Start | All Income Brackets | All Age ...
MEASURE	Metric being counted or aggregated (e.g., Sales, Transactions, AOV, Sales_YoY, etc.).	VARCHAR	AOV
UNIT	Unit of measure for the variable (e.g., Percent)	VARCHAR	USD
FREQUENCY	Frequency of the variable measurement (e.g., Week, Month, Quarter)	VARCHAR	Month
MEMBER_INCOME	Income bracket for a subset of users (e.g., $41K-60K, $81K-100K, etc.). 'All Income Brackets' when not applicable.	VARCHAR	$41K-60K
MEMBER_AGE	Age range for a subset of users (e.g., 25-34, 35-44, 65+, etc.). 'All Age Brackets' when not applicable.	VARCHAR	All Age Brackets
CHANNEL	Purchase channel - 'Online' and 'Offline'. 'All Channels' when not applicable.	VARCHAR	Online
AGGREGATION_TYPE	The type of categorization that the data is aggregated to such as MCC codes, NAICS codes or merchants.	VARCHAR	MCC
AGGREGATION_VALUE	The value for the type of categorization that the data is aggregated to such as a specific MCC code, NAICS code or merchant name.	VARCHAR	MARTS Segment: Retail Sales: Beer, Wine, and Liquor Stores