Explore: Performance Trend Benchmarks

Description

This explore contains your data for key metrics that has been transformed to show you if your business performance is on track and within 1 standard deviation of typical performance.

Common Use Cases

Determine if your current results reflect what is expected based on your recent business performance.

Fields

Performance Trend Benchmarks: performance_trend_benchmarks_history
Filters, Dimensions and Measures Category Description
Performance Trend Benchmarks: Forecast Date dimension Calendar date from GA
Performance Trend Benchmarks: Forecast Day of Week dimension The day of the week from GA
Performance Trend Benchmarks: Forecast Day of Week Index dimension A number representing the day of the week from GA, with Monday = 0 And Sunday = 6
Performance Trend Benchmarks: Forecast Month dimension The calendar month from GA in YYYY-MM format
Performance Trend Benchmarks: Forecast Month Name dimension The calendar month name from GA
Performance Trend Benchmarks: Forecast Month Num dimension The month number from GA from 1 to 12
Performance Trend Benchmarks: Forecast Quarter dimension The quarter number from GA in YYYY-Q# form
Performance Trend Benchmarks: Forecast Week dimension The calendar week from GA in YYYY-MM-DD form
Performance Trend Benchmarks: Forecast Year dimension The calendar year from GA in YYYY form
Performance Trend Benchmarks: Store Name dimension Name of the source integration
Performance Trend Benchmarks: $ / Visit measure SPV benchmark
Performance Trend Benchmarks: $ / Visit Lower Bound measure sales_per_visit: median minus 3 standard deviations
Performance Trend Benchmarks: $ / Visit Upper Bound measure sales_per_visit: median plus 3 standard deviations
Performance Trend Benchmarks: $ / Visit Variance measure SPV: 3 standard deviations
Performance Trend Benchmarks: AOV measure aov benchmark
Performance Trend Benchmarks: AOV Lower Bound measure aov: median minus 3 standard deviations
Performance Trend Benchmarks: AOV Upper Bound measure aov: median plus 3 standard deviations
Performance Trend Benchmarks: AOV Variance measure aov: 3 standard deviations
Performance Trend Benchmarks: Conversion measure conversion benchmark
Performance Trend Benchmarks: Conversion Lower Bound measure Conversion: median minus 3 standard deviations
Performance Trend Benchmarks: Conversion Upper Bound measure Conversion: median plus 3 standard deviations
Performance Trend Benchmarks: Conversion Variance measure conversion: 3 standard deviations
Performance Trend Benchmarks: UPO measure upo benchmark
Performance Trend Benchmarks: UPO Lower Bound measure upo: median minus 3 standard deviations
Performance Trend Benchmarks: UPO Upper Bound measure upo: median plus 3 standard deviations
Performance Trend Benchmarks: UPO Variance measure upo: 3 standard deviations

 

Performance Trends: performance_trends
Filters, Dimensions and Measures Category Description
Performance Trends: Created Date dimension -- missing description --
Performance Trends: Created Day of Week dimension -- missing description --
Performance Trends: Created Day of Week Index dimension -- missing description --
Performance Trends: Created Month dimension -- missing description --
Performance Trends: Created Month Name dimension -- missing description --
Performance Trends: Created Month Num dimension -- missing description --
Performance Trends: Created Quarter dimension -- missing description --
Performance Trends: Created Week dimension -- missing description --
Performance Trends: Created Year dimension -- missing description --
Performance Trends: GA Last Click Channel dimension Modified Last Click Google Analytics Channel Based on Your Custom Logic
Performance Trends: Marketing Attribution Channel dimension The Marketing Channel Based on Custom Sources - EX: discount code, ga, surveys, and etc.
Performance Trends: Store Country dimension Country entered in the Daasity UI for the Integration
Performance Trends: Store Integration Name dimension The Name from the Location otherwise the name from the Daasity UI
Performance Trends: Store Type dimension Type selected in the Daasity UI for the Integration
Performance Trends: UTM Medium dimension UTM Medium from GA
Performance Trends: UTM Source dimension UTM Source from GA
Performance Trends: $/Visit measure Units per Transaction = Total Units/Number of Orders
Performance Trends: $/Visit measure Average Units Revenue = Total Sales/Number of Units
Performance Trends: AOV measure Average Order Value = Total Sales/Number of Orders
Performance Trends: AOV measure Average Order Value = Total Sales/Number of Orders
Performance Trends: AUR measure Average Units Revenue = Total Sales/Number of Units
Performance Trends: AUR measure Average Units Revenue = Total Sales/Number of Units
Performance Trends: Conversion measure Total Orders/Total Sessions
Performance Trends: Conversion measure Total Orders/Total Sessions
Performance Trends: Orders measure Total number of orders attributed to last click channel
Performance Trends: Orders measure Total number of orders in attribution channel
Performance Trends: Sales measure Total amount of sales attributed to last click channel
Performance Trends: Sales measure Total amount of sales in attribution channel
Performance Trends: Sessions measure Total number of session attributed to last click channel
Performance Trends: Sessions measure Total number of session in attribution channel
Performance Trends: UPT measure Units per Transaction = Total Units/Number of Orders
Performance Trends: UPT measure Units per Transaction = Total Units/Number of Orders
Performance Trends: Units measure Total number of units attributed to last click channel
Performance Trends: Units measure Total number of units in attribution channel

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
performance_trend_benchmarks_history - self -
performance_trends left_outer one_to_many ${performance_trend_benchmarks_history.__shop_id} = ${performance_trends.__shop_id} AND ${performance_trend_benchmarks_history.forecast_date} = ${performance_trends.created_date}

Flow


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