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	3963569d4eebdd3074706021abb5ed22
MERCHANT_NAME	The name of the merchant.	VARCHAR	STRAIGHT TALK
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	SHERATON HOTELS
MEASURE	Metric being counted or aggregated (e.g., Sales, Transactions, AOV, Sales_YoY).	VARCHAR	AOV_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	All Age Brackets
MEMBER_INCOME	Income bracket for a subset of users (e.g., $41K-60K, $81K-100K). 'All Income Brackets' when not applicable.	VARCHAR	$41K-60K
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	CensusCoreBasedStatisticalArea
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	geoId/18
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	Indiana
MERCHANT_GEO_LEVEL	The geographic level (e.g., Country, State, CensusCoreBasedStatisticalArea) 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	2020-08-02
VALUE	Value for the given date and timeseries.	FLOAT	4427.0
UNIT	Unit of measure for the timeseries (e.g., USD, Percent).	VARCHAR	Count