Consumer Spending POI Timeseries

Snowflake table name : CYBERSYN.CONSUMER_SPENDING_POI_TIMESERIES

View documentation here.

NameDescriptionTypeExample

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

Last updated

Copyright © 2024 Cybersyn