Consumer Spending POI Timeseries

Snowflake table name : CYBERSYN.CONSUMER_SPENDING_POI_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
POI_CITY_NAME	Name of the city	VARCHAR	COLUMBUS
POI_COUNTRY_NAME	Name of the country	VARCHAR	UNITED STATES
POI_ID	Unique identifier assigned by Cybersyn to each point of interest (POI). Joinable to the POI_INDEX table.	VARCHAR	a2cc250bb8e2bee39e24100ee71c22b9
POI_STATE_NAME	Name of the state	VARCHAR	IN
POI_STREET_ADDRESS	Name and number of the street address	VARCHAR	2260 N NATIONAL RD
POI_ZIP	5-digit code identifying the location of an address	VARCHAR	47201
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