Consumer Spending Industry No Zip Timeseries

Snowflake table name : CYBERSYN.CONSUMER_SPENDING_INDUSTRY_NO_ZIP_TIMESERIES

View documentation here.

NameDescriptionTypeExample

AGGREGATION_TYPE

The type of categorization that the data is aggregated to such as MCC codes, NAICS codes, MARTS segments, or total consumer spending.

VARCHAR

MARTS Segment

AGGREGATION_ID

The ID for the type of categorization that the data is aggregated to such as a specific MCC code or NAICS code. For MARTS Segments, this ID represents the series identifier from the FRED database and is joinable to Cybersyn's table FINANCIAL_FRED_VARIABLE_SERIES_ID_CROSSWALK based on the SERIES_ID field.

VARCHAR

RSXFSN

AGGREGATION_NAME

The name or description for the type of categorization that the data is aggregated to such as a MARTS segment name or an MCC code description.

VARCHAR

Retail Sales: Retail Trade

MEASURE

Metric being counted or aggregated (e.g., Sales, Transactions, AOV, Sales_YoY).

VARCHAR

AOV

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

$61K-80K

CHANNEL

Purchase channel - 'Online' and 'Offline'. 'All Channels' when not applicable.

VARCHAR

Online

CONSUMER_GEO_LEVEL

The geographic level or hierarchy (e.g., Country, State, CensusCoreBasedStatisticalArea) represented by the CONSUMER_GEO_ID.

VARCHAR

Country

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

MERCHANT_GEO_LEVEL

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

VARCHAR

CensusCoreBasedStatisticalArea

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

South Carolina

DATE

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

DATE

2019-08-11

VALUE

Value for the given date and timeseries.

FLOAT

8514.0

UNIT

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

VARCHAR

Percent

Last updated

Copyright © 2024 Cybersyn