Data Quality: Reconciling Analytics Orders with the Back Office, Gap % and Tolerance Flags
Lessons in this course
- Traffic Source Mix: Session Share, Conversion Rate and Revenue Share by ChannelFree
- Conversion by Channel: Add-to-Cart Rate, Checkout Completion and the Store-Wide Benchmark Locked
- Revenue per Session: Average Order Value, RPS Index and Channel Concentration Locked
- AOV Lever 1: Bundles, Items per Order and Margin per Order with COUNTIFS and AVERAGEIFS Locked
- AOV Lever 2: The Free-Shipping Threshold, the Stretch Zone and the Net Profit Effect Locked
- Repeat Purchase Rate: One-Time vs Repeat Customers by Acquisition Channel with COUNTIFS Locked
- Cohort Retention Curve: Active Customers by Month Since First Order and the Right Denominator Locked
- Contribution Margin per Order: Product Cost, Shipping, Payment Fees and Packaging by Channel Locked
- Blended ROAS vs Platform ROAS: Total Ad Spend, Reported Revenue and the Overlap Check Locked
- Customer Acquisition Cost: CAC by Channel, First-Order Profit and Orders to Pay Back Locked
- Break-Even and Target ROAS: Margin Before Ads, Profit Goal and Status by Product Line Locked
- Discount Codes: Orders, Discount Rate and Margin per Order by Code with SUMIFS and AVERAGEIFS Locked
- Returns and Net Revenue: Return Rate, Refund Rate and the Channels Above the Store Average Locked
- Product Category Mix: Gross Margin, Margin Share, Rank and the Top-Two Concentration Locked
- Email Flows vs Campaigns: Revenue per 1,000 Recipients, Order Rate and Unsubscribes Locked
- Marketing Calendar: Event Length, Days Until Start, Planned ROAS and Budget by Month Locked
- Bundle What-If: Discount Depth, Take Rate and Monthly Profit with Locked Assumptions Locked
- Spend Response: ROAS, Marginal ROAS, Slope and a Linear Forecast for Paid Social Locked
- Data Quality: Reconciling Analytics Orders with the Back Office, Gap % and Tolerance Flags Locked
- Final Project: Half-Year Store Dashboard with Blended ROAS, Margin After Ads, a Flag and a Combo Chart Locked