Consumer Spending Merchant No Zip Timeseries

Snowflake table name : CYBERSYN.CONSUMER_SPENDING_MERCHANT_NO_ZIP_TIMESERIES

View documentation here.

Name	Description	Type	Example
MERCHANT_ID	Unique identifier assigned by Cybersyn to each merchant.	VARCHAR	65c66a076c35285b5a2e2cf873e75ff2
MERCHANT_NAME	The name of the merchant.	VARCHAR	FAMOUS FOOTWEAR
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	MARRIOTT HOTELS
MEASURE	Metric being counted or aggregated (e.g., Sales, Transactions, AOV, Sales_YoY).	VARCHAR	Transactions_YoY
FREQUENCY	Frequency of the timeseries measurement (e.g., Month, Quarter). Joinable to CALENDAR_NAME from the CALENDAR_INDEX table.	VARCHAR	Month
MEMBER_AGE	Age range for a subset of users (e.g., 25-34, 35-44, 65+). 'All Age Brackets' when not applicable.	VARCHAR	55-64
MEMBER_INCOME	Income bracket for a subset of users (e.g., $41K-60K, $81K-100K). 'All Income Brackets' when not applicable.	VARCHAR	All Income Brackets
CHANNEL	Purchase channel - 'Online' and 'Offline'. 'All Channels' when not applicable.	VARCHAR	Online
CONSUMER_GEO_LEVEL	The geographic level or hierarchy (e.g., Country, State, CensusCoreBasedStatisticalArea) represented by the CONSUMER_GEO_ID.	VARCHAR	Country
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/05
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) 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	2018-09-23
VALUE	Value for the given date and timeseries.	FLOAT	0.12998966
UNIT	Unit of measure for the timeseries (e.g., USD, Percent).	VARCHAR	Percent