Consumer Spending POI Timeseries
Snowflake table name : CYBERSYN.CONSUMER_SPENDING_POI_TIMESERIES
Last updated
Snowflake table name : CYBERSYN.CONSUMER_SPENDING_POI_TIMESERIES
Last updated
Copyright © 2024 Cybersyn
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