Consumer Spending Merchant Product Retention Timeseries
Snowflake table name : CYBERSYN.CONSUMER_SPENDING_MERCHANT_PRODUCT_RETENTION_TIMESERIES
Name | Description | Type | Example |
---|---|---|---|
| Unique identifier assigned by Cybersyn to each merchant. | VARCHAR |
|
| The name of the merchant. | VARCHAR |
|
| A unique identifier for the product (e.g., Hulu Live TV vs. Hulu Streaming) assigned by Cybersyn to each transaction for a merchant. | VARCHAR |
|
| The name of the product (e.g., Hulu Live TV vs. Hulu Streaming) | VARCHAR |
|
| 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 |
|
| Metric being counted or aggregated (e.g., User Retention, Sales Retention, etc.) | VARCHAR |
|
| Frequency of the timeseries measurement (e.g., Month, Quarter). Joinable to CALENDAR_NAME from the CALENDAR_INDEX table. | VARCHAR |
|
| Age range for a subset of users (e.g., 25-34, 35-44, 65+). 'All Age Brackets' when not applicable. | VARCHAR |
|
| Income bracket for a subset of users (e.g., $41K-60K, $81K-100K). 'All Income Brackets' when not applicable. | VARCHAR |
|
| Purchase channel - 'Online' and 'Offline'. 'All Channels' when not applicable. | VARCHAR |
|
| The geographic level or hierarchy (e.g., Country, State, CensusCoreBasedStatisticalArea, CensusZipCodeTabulationArea) represented by the CONSUMER_GEO_ID. | VARCHAR |
|
| 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 |
|
| Name of the location in which a consumer lives. Based on the primary billing address of the consumer. 'United States' when not applicable. | VARCHAR |
|
| The geographic level (e.g., Country, State, CensusCoreBasedStatisticalArea) represented by the MERCHANT_GEO_ID. | VARCHAR |
|
| A unique identifier assigned by Cybersyn for a merchant's physical location. Joinable to the GEOGRAPHY_INDEX table. 'country/USA' when not applicable. | VARCHAR |
|
| Name of the location in which a physical merchant is located. 'United States' when not applicable. | VARCHAR |
|
| 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 |
|
| The retention rate for the given period. | FLOAT |
|
| Unit of measure for the timeseries (e.g., Percent). | VARCHAR |
|
Last updated