Reconciliation with the Order System: Weekly Ratio, Status Bands, Trend with SLOPE & a FORECAST.LINEAR Warning Light
Lessons in this course
- Event Match Rate: Matched Share by Event Type, Unmatched Events, the Weighted Overall Rate & Status FlagsFree
- Match Keys: Identifier Coverage, Match Rate When Sent, Match Rate by Number of Identifiers & Average Identifiers per Event Locked
- Delivery Reliability: Acceptance Rate, Final Delivery Rate after Retries, Days below Target & Events Lost for Good Locked
- Browser vs Server: Distinct Purchases, Browser-Only and Server-Only Groups, Source Coverage & the Overlap Rule Locked
- Event ID Deduplication: Records per ID and Name, Value Counted Once, Overstatement & Name Mismatches Locked
- Deduplication Window: Arrival Gap between Browser and Server, Status, Pairs Counted Twice & Fast Pairs Locked
- Parameter Completeness: Completeness, Validity, Usable Rate, a Weighted Score & Parameters below Target Locked
- Value Accuracy: Difference and Error % against Order Totals, Tolerance Checks, Net vs Absolute Error & a Scatter Check Locked
- Delay Distribution: Delay Bands with COUNTIFS, Cumulative Share, Median, 90th Percentile & the Mean Trap Locked
- Late Events vs Attribution Window: Shares, Cumulative Share, Events and Value Beyond the Window Locked
- Conversions Recovered by Server Events: Browser Capture, Capture with Server, Uplift in Points & Recovered Value Locked
- Consent-Respecting Measurement: Consent Rate, Events Sent without Consent, Share within Consent & an Audit Flag Locked
- Attribution Impact: ROAS Before and After Server Events, Reported Change, Overall ROAS & Campaign Rank Locked
- Match Quality by Segment: Match Rate, Shortfall vs Target, Rank, Weighted Device Rates & a Heat Map Locked
- Event Quality Score: Weighted Scores with SUMPRODUCT, Grades with IFS, Ranks & the Biggest Weighted Loss Locked
- Is the Improvement Real? Two-Proportion z-Test for Match Rate: Pooled Rate, Standard Error, z, p-Value & Confidence Interval Locked
- Monitoring: A Baseline Match Rate, Daily Lower Control Limits for a Proportion, Alerts & a Control Chart Locked
- What If? A Scenario Grid for CPA: Match Rate × Sending Coverage, Mixed References, Needed Match Rate & Target Cells Locked
- Reconciliation with the Order System: Weekly Ratio, Status Bands, Trend with SLOPE & a FORECAST.LINEAR Warning Light Locked
- Final Project: Server-Side Event Quality Scorecard with Four Rates, Recovery Uplift, a Weighted Score, Rank, Flags & a Combo Chart Locked