Tabellab
Marketing Analytics Intermediate

Tracking Plans & Tag Management: Event Taxonomy, Tag QA, UTM Governance, Data-Layer Checks, Duplicates & Discrepancy Audits

Find out whether your marketing numbers can be trusted in 20 hands-on labs. You will audit a tracking plan for coverage by funnel stage and priority, check event names and parameters against a taxonomy, compare expected with fired tags, build governed UTM links and size the unassigned traffic, validate data-layer pushes and remove duplicate transactions, then reconcile platform clicks and claimed conversions with analytics and real orders, measure consent and capture rates, weight tag coverage by traffic, clean up a tag inventory, run a release QA, monitor event volumes with z-scores, forecast a decaying capture rate, size audit samples, build a what-if grid for the true cost per order, prioritise fixes and finish with a measurement health dashboard. 20 hands-on labs, fictional shop data from Pedalwick Cycles, every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course teaches the working side of marketing measurement: how to check whether the numbers in your reports were collected completely and correctly. In 20 interactive spreadsheet labs you audit the tracking plan of Pedalwick Cycles, a fictional online shop for bicycle parts. You measure event coverage by funnel stage, test event names and parameters against a taxonomy, compare expected with fired tags, build governed UTM links, validate data-layer pushes and remove duplicate transactions. Then you reconcile platform clicks and claimed conversions with analytics and the order system, measure consent and capture rates, clean up a tag inventory, monitor event volumes, forecast a decaying capture rate, size audit samples and finish with a measurement health dashboard. Every formula is typed by you and checked at once. All companies, campaigns and numbers are fictional and for learning only.

Lessons

  1. The Tracking Plan: Event Inventory, Live Status, Coverage by Funnel Stage and Priority-Weighted CoverageLabFree
  2. Event Naming: Length, Case and Separator Checks with LEN, EXACT and SUBSTITUTE, and a Clean snake_case NameLab Locked
  3. Event Parameters: Required Parameters per Event Type with XLOOKUP, Completeness and a Status with IFSLab Locked
  4. Tag QA: Expected vs Fired, Fire Rate, Under- and Over-Firing with IFS and a Highlight RuleLab Locked
  5. UTM Governance: Clean Campaign Values, an Allowed-Medium Check with COUNTIF and a Tagged URL Built with &Lab Locked
  6. UTM Audit: Case-Sensitive Medium Checks with EXACT, Sessions per Channel with SUMIFS and the Unassigned ShareLab Locked
  7. Data-Layer Checks: Missing IDs, Text Instead of Numbers, Currency Codes and a Verdict per Purchase PushLab Locked
  8. Duplicate Events: Finding Repeated Transaction IDs with COUNTIF, Keeping the First Hit and De-Duplicated RevenueLab Locked
  9. Discrepancy Audit I: Platform Clicks vs Analytics Sessions, Gap per Campaign, a Tolerance Flag and the Overall GapLab Locked
  10. Discrepancy Audit II: Platform-Claimed Conversions vs Analytics and Orders, the Over-Claim Factor and Scaled ConversionsLab Locked
  11. Consent and Measured Share: Consent Rate, Order Capture Rate, the Untracked Share and the Weakest SegmentLab Locked
  12. Tracking Coverage: Tag Coverage per Page Template, Untracked Pageviews and Pageview-Weighted Coverage with SUMPRODUCTLab Locked
  13. Tag Inventory: Days Since the Last Fire, Stale and Ownerless Tags with IFS, Load Time at Stake and the Next Audit DateLab Locked
  14. Release QA: Test Cases per Area, Pass Rates with COUNTIFS, Critical Failures and a Go / No-Go DecisionLab Locked
  15. Monitoring: Baseline Mean and Standard Deviation, z-Scores for New Days and an Alert Flag for Tracking DropsLab Locked
  16. Capture Rate Trend: Weekly Tracked vs Real Orders, SLOPE, FORECAST.LINEAR and the Week a Threshold Is CrossedLab Locked
  17. Audit Sampling: Error Rates from a Sample, the 95 % Margin of Error, an Upper Bound for Faulty Events and the Sample SizeLab Locked
  18. What-If Grid: True Orders from Reported Conversions, Duplicate Share × Capture Rate and the True Cost per OrderLab Locked
  19. Remediation Backlog: a Priority Score, RANK.EQ, LARGE, the Top Issue with INDEX-MATCH and Quick Fixes with SUMIFSLab Locked
  20. Final Project: Measurement Health Dashboard with Pass Rates per Area, Status, a Weighted Health Score, the Weakest Area and a ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy