Explore: Daily Company Metrics

Description

Contains the aggregated daily company metrics. Aggregates traffic, orders, units, revenue, and marketing spend by day.

Common Use Cases

Evaluate company-wide metrics like conversion rate, cost per order (CPO), cost per acquisition (CPA), or revenue by day.

Fields

Daily Company Metrics: daily_company_metrics
Filters, Dimensions and Measures Category Description
Daily Company Metrics: Amazon Gross Margin measure Gross margin totals from Amazon orders
Daily Company Metrics: Amazon Gross Sales measure Gross sales totals from Amazon orders
Daily Company Metrics: Amazon Net Sales measure Net sales totals from Amazon orders
Daily Company Metrics: Amazon New Customers measure New customer totals from Amazon orders
Daily Company Metrics: Amazon Valid Orders measure Valid Amazon orders
Daily Company Metrics: Amazon Valid Units measure Valid Amazon units sold
Daily Company Metrics: BSD Gross Margin measure Gross margin totals from manually entered orders in the BSD sheet
Daily Company Metrics: BSD Gross Sales measure Gross sales totals from manually entered orders in the BSD sheet
Daily Company Metrics: BSD Net Sales measure Net sales totals from manually entered orders in the BSD sheet
Daily Company Metrics: BSD New Customers measure New customer totals from manually entered orders in the BSD sheet
Daily Company Metrics: BSD Valid Orders measure Valid orders from manually entered orders in the BSD sheet
Daily Company Metrics: BSD Valid Units measure Valid units from manually entered orders in the BSD sheet
Daily Company Metrics: Other Gross Margin measure Gross margin totals from non-Shopify, Amazon, or BSD orders
Daily Company Metrics: Other Gross Sales measure Gross sales totals from non-Shopify, Amazon, or BSD orders
Daily Company Metrics: Other Net Sales measure Net sales totals from non-Shopify, Amazon, or BSD orders
Daily Company Metrics: Other New Customers measure New customer totals from non-Shopify, Amazon, or BSD orders
Daily Company Metrics: Other Valid Orders measure Valid orders from non-Shopify, Amazon, or BSD orders
Daily Company Metrics: Other Valid Units measure Valid units sold from non-Shopify, Amazon, or BSD orders
Daily Company Metrics: Shopify Gross Margin measure Gross margin totals from Shopify orders
Daily Company Metrics: Shopify Gross Sales measure Gross sales totals from Shopify orders
Daily Company Metrics: Shopify Net Sales measure Net sales totals from Shopify orders
Daily Company Metrics: Shopify New Customers measure New customer totals from Shopify orders
Daily Company Metrics: Shopify Valid Orders measure Valid Shopify orders
Daily Company Metrics: Shopify Valid Units measure Valid Shopify units sold
Daily Company Metrics: Marketing Spend measure Total marketing spend from integrations and spend manually entered in BSD sheet
Daily Company Metrics: Sessions measure Total website sessions
Daily Company Metrics: Total Gross Margin measure Gross margin totals from all orders
Daily Company Metrics: Total Gross Sales measure Gross sales totals from all orders
Daily Company Metrics: Total Net Sales measure Net sales totals from all orders
Daily Company Metrics: Total New Customers measure New customer totals from all orders
Daily Company Metrics: Total Valid Orders measure Valid orders
Daily Company Metrics: Total Valid Units measure Valid units sold

 

Calendar: retail_calendar
Filters, Dimensions and Measures Category Description
Calendar: 1 - Pivot by Yesterday dimension Pivot Dataset by Yesterday: TY vs LY. To Use, Pivot This Field and Add a Filter for 'Dimension is Not Null'
Calendar: 2 - Pivot by Week dimension Pivot Dataset by Current Week: TY, LY, & LW. To Use, Pivot This Field and Add a Filter for 'Dimension is Not Null'
Calendar: 3 - Pivot by Month dimension Pivot Dataset by Current Month: TY, LY, & LM. To Use, Pivot This Field and Add a Filter for 'Dimension is Not Null'
Calendar: 4 - Pivot by Quarter dimension Pivot Dataset by Current Quarter: TY vs LY. To Use, Pivot This Field and Add a Filter for 'Dimension Is Not Null'
Calendar: 5 - Pivot by Year dimension Pivot Dataset by Current Year: TY vs LY. To Use, Pivot This Field and Add a Filter for 'Dimension is Not Null'
Calendar: 6 - Pivot by Previous Period Selected dimension The reporting period as selected by the Previous Period Filter and Add a Filter for 'Dimension is Not Null'
Calendar: Calendar Date dimension Calendar date
Calendar: Calendar Day of Week dimension The day of the week
Calendar: Calendar Day of Week Index dimension A number representing the day of the week, with Monday = 0 And Sunday = 6
Calendar: Calendar Month dimension The calendar month in YYYY-MM format
Calendar: Calendar Month Name dimension The calendar month name
Calendar: Calendar Month Num dimension The month number from 1 to 12
Calendar: Calendar Quarter dimension The quarter number in YYYY-Q# form
Calendar: Calendar Time dimension The full calendar timestamp
Calendar: Calendar Week dimension The retail calendar week in YYYY-MM-DD form
Calendar: Calendar Week of Year dimension The numbered calendar week from 1-52
Calendar: Calendar Year dimension The calendar year in YYYY form
Calendar: Retail Day of Week dimension Day of Week of Selected Date Based on Sunday Week Start (NRF Calendar)
Calendar: Retail Week dimension Retail Week Based on the NRF Calendar
Calendar: Retail Week Day Number dimension Retail Day of Week Based on the NRF Calendar
Calendar: Retail Year dimension Retail Year Based on the NRF Calendar
Calendar: Previous Period Filter filter Use this filter for period analysis - i.e. select This Year vs. Last Year for the Period using Pivot #6

Using Explores

Exploring data can be insightful and fun! Before you start your exploration, make sure to go through our Using Explores Bootcamp.

Views

View Cardinality Relationship Join
daily_company_metrics - self -
retail_calendar left_outer one_to_one ${base_shopping_stage.visit_date} = ${retail_calendar.calendar_date}

Flow

All content © Daasity 2021. Do not copy, share or distribute.