Consumer Spending Industry No Zip Timeseries

Snowflake table name : CYBERSYN.CONSUMER_SPENDING_INDUSTRY_NO_ZIP_TIMESERIES

View documentation here.

Name	Description	Type	Example
AGGREGATION_TYPE	The type of categorization that the data is aggregated to such as MCC codes, NAICS codes, MARTS segments, or total consumer spending.	VARCHAR	MCC
AGGREGATION_ID	The ID for the type of categorization that the data is aggregated to such as a specific MCC code or NAICS code. For MARTS Segments, this ID represents the series identifier from the FRED database and is joinable to Cybersyn's table FINANCIAL_FRED_VARIABLE_SERIES_ID_CROSSWALK based on the SERIES_ID field.	VARCHAR	451
AGGREGATION_NAME	The name or description for the type of categorization that the data is aggregated to such as a MARTS segment name or an MCC code description.	VARCHAR	Gasoline Stations
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	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	$101K-150K
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/C46140
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	St. Louis, MO-IL Metro Area
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-01-31
VALUE	Value for the given date and timeseries.	FLOAT	4100258.93
UNIT	Unit of measure for the timeseries (e.g., USD, Percent).	VARCHAR	Percent