Consumer Spending Merchant Retention Timeseries

Snowflake table name : CYBERSYN.CONSUMER_SPENDING_MERCHANT_RETENTION_TIMESERIES

View documentation here.

Name	Description	Type	Example
MERCHANT_ID	Unique identifier assigned by Cybersyn to each merchant.	VARCHAR	e2e2f37caf4dcede5fb117f5d251bc1e
MERCHANT_NAME	The name of the merchant.	VARCHAR	APPLE
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	FAST FOOD RESTAURANTS
MEASURE	Metric being counted or aggregated (e.g., User Retention, Sales Retention, etc.)	VARCHAR	Sales Retention
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	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	All Channels
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/34
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	South Carolina
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
PERIODS_SINCE_FIRST_PURCHASE	Number of periods (i.e., months) since the user made their first purchase as a given merchant. Period 0 is the period in which the initial purchase was made.	NUMBER	38
VALUE	The retention rate for the given period.	FLOAT	0.01411101
UNIT	Unit of measure for the timeseries (e.g., Percent).	VARCHAR	Percent