Consumer Spending Merchant Timeseries

Snowflake table name : CYBERSYN.CONSUMER_SPENDING_MERCHANT_TIMESERIES

View documentation here.

Name	Description	Type	Example
MERCHANT_ID	Unique identifier assigned by Cybersyn to each merchant.	VARCHAR	1e6d84e0b6955457035a67e4c247d186
MERCHANT_NAME	The name of the merchant.	VARCHAR	INSTACART
MERCHANT_CATEGORY_CODE_DESCRIPTION	The most commonly used merchant categorization for purchases at a given merchant. Based on merchant category code (MCC) classifications from the International Organization for Standardization (ISO).	VARCHAR	EATING PLACES AND RESTAURANTS
MEASURE	Metric being counted or aggregated (e.g., Sales, Transactions, AOV, Sales_YoY).	VARCHAR	Sales_YoY
FREQUENCY	Frequency of the timeseries measurement (e.g., Month, Quarter). Joinable to CALENDAR_NAME from the CALENDAR_INDEX table.	VARCHAR	Week - Monday Start
MEMBER_AGE	Age range for a subset of users (e.g., 25-34, 35-44, 65+). 'All Age Brackets' when not applicable.	VARCHAR	45-54
MEMBER_INCOME	Income bracket for a subset of users (e.g., $41K-60K, $81K-100K). 'All Income Brackets' when not applicable.	VARCHAR	$81K-100K
CHANNEL	Purchase channel - 'Online' and 'Offline'. 'All Channels' when not applicable.	VARCHAR	Offline
CONSUMER_GEO_LEVEL	The geographic level or hierarchy (e.g., Country, State, CensusCoreBasedStatisticalArea, CensusZipCodeTabulationArea) represented by the CONSUMER_GEO_ID.	VARCHAR	State
CONSUMER_GEO_ID	A unique identifier assigned by Cybersyn for the location in which a consumer lives. Based on the primary billing address of the consumer. Joinable to the GEOGRAPHY_INDEX table. 'country/USA' when not applicable.	VARCHAR	country/USA
CONSUMER_GEO_NAME	Name of the location in which a consumer lives. Based on the primary billing address of the consumer. 'United States' when not applicable.	VARCHAR	United States
MERCHANT_GEO_LEVEL	The geographic level (e.g., Country, State, CensusCoreBasedStatisticalArea, CensusZipCodeTabulationArea) represented by the MERCHANT_GEO_ID.	VARCHAR	Country
MERCHANT_GEO_ID	A unique identifier assigned by Cybersyn for a merchant's physical location. Joinable to the GEOGRAPHY_INDEX table. 'country/USA' when not applicable.	VARCHAR	country/USA
MERCHANT_GEO_NAME	Name of the location in which a physical merchant is located. 'United States' when not applicable.	VARCHAR	United States
DATE	The date for the corresponding value. Denoted as the end date of the given period.	DATE	2023-12-17
VALUE	Value for the given date and timeseries.	FLOAT	0.11642099
UNIT	Unit of measure for the timeseries (e.g., USD, Percent).	VARCHAR	USD