Consumer Spending Merchant No Zip Timeseries

Snowflake table name : CYBERSYN.CONSUMER_SPENDING_MERCHANT_NO_ZIP_TIMESERIES

View documentation here.

NameDescriptionTypeExample

MERCHANT_ID

Unique identifier assigned by Cybersyn to each merchant.

VARCHAR

218e81f55087ad5340edabb9a033c0a8

MERCHANT_NAME

The name of the merchant.

VARCHAR

OLO

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

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

$151K+

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) 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

geoId/C41700

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

MERCHANT_GEO_LEVEL

The geographic level (e.g., Country, State, CensusCoreBasedStatisticalArea) represented by the MERCHANT_GEO_ID.

VARCHAR

State

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

geoId/36

MERCHANT_GEO_NAME

Name of the location in which a physical merchant is located. 'United States' when not applicable.

VARCHAR

Minneapolis-St. Paul-Bloomington, MN-WI Metro Area

DATE

The date for the corresponding value. Denoted as the end date of the given period.

DATE

2022-01-09

VALUE

Value for the given date and timeseries.

FLOAT

3174467.0

UNIT

Unit of measure for the timeseries (e.g., USD, Percent).

VARCHAR

USD

Last updated

Copyright © 2024 Cybersyn