Consumer Spending Timeseries

Snowflake table name : CYBERSYN.CONSUMER_SPENDING_TIMESERIES

View documentation here.

Name	Description	Type	Example
COMPANY_ID	Unique identifier assigned by Cybersyn to each company. Joinable to the company_index table.	VARCHAR	00019d8511ea291495001084e1b3a864
COMPANY_NAME	The name of the company.	VARCHAR	PARAMOUNT+
PURCHASER_PRIMARY_GEO_ID	A unique identifier assigned by Cybersyn for a purchaser's location. Joinable to the GEOGRAPHY_INDEX table. 'country/USA' when not applicable.	VARCHAR	geoId/24
PURCHASER_PRIMARY_GEO_NAME	A name for a purchaser's location. 'United States' when not applicable.	VARCHAR	North Carolina
PURCHASE_LOCATION_GEO_ID	A unique identifier assigned by Cybersyn for a purchase location. Joinable to the GEOGRAPHY_INDEX table. 'country/USA' when not applicable.	VARCHAR	country/USA
PURCHASE_LOCATION_GEO_NAME	A name for a purchase location. 'United States' when not applicable.	VARCHAR	United States
VARIABLE	Unique identifier for the distinct measure. Joinable to the consumer_spending_attributes table	VARCHAR	73463a0cced153f42742a24cdb077a65
VARIABLE_NAME	Human-readable version of the variable. Factors that make up a distinct variable include the measure (transactions, revenue, AOV), panelist age, panelist income, and more	VARCHAR	AOV (USD) | Week - Monday Start | All Income Brackets | Unknown ...
DATE	The date for the corresponding value. Denoted as the end of the given period.	DATE	2022-07-30
VALUE	Value for the given date and variable.	FLOAT	63.27