Home / Courses
Free course · English

Build a UTM Tracker & Dashboard with Google Sheets & GA

Create a live campaign performance dashboard using UTM tags, Google Analytics, and Sheets

9 lessons about 6 hours beginner
Build a UTM Tracker & Dashboard with Google Sheets & GA

This beginner-friendly course is for Indian students and career switchers who want a practical, job‑ready skill in marketing analytics. You'll learn how to design UTM parameters, pull data from Google Analytics, and visualise campaign performance in Google Sheets.

By the end of the course you'll have built a fully automated dashboard that updates daily and can be shared with stakeholders.

You’ll be able to set up tracking for any digital campaign, generate actionable reports, and showcase a real‑world analytics project on your resume.

What you will work through

1 Understanding UTM Parameters Social Media Examiner · 9 min 2 Setting Up Google Analytics for Data Export Leon Korteweg · 5 min 3 Google Sheets Basics for Data Handling Kevin Stratvert · 23 min 4 Connecting GA to Sheets with the GA Add‑on (Project 1) MeasureSchool · 12 min 5 Cleaning & Transforming Data with QUERY Leila Gharani · 13 min 6 Designing Charts for Campaign Insights Endless Knowledge · 22 min 7 Automating UTM Generation with Formulas (Project 2) video coming soon 8 Sharing & Publishing the Dashboard DNhanlab · 6 min 9 Course Recap & Next Steps Matt Tutorials · 11 min
Final project Campaign Performance Dashboard Unlocks after all 9 lessons 0 of 9 lessons passed Locked
Final project

Campaign Performance Dashboard

Submit a public link Checked by a reviewer Unlimited attempts

Create a live Google Sheets dashboard that tracks a mock multi‑channel marketing campaign using UTM parameters and Google Analytics data.

What to submit:

  • Shareable link to the Google Sheet (view‑only)
  • Short video (max 3 min) walking through the dashboard

Reviewer checklist:

  • Correct UTM structure and naming convention
  • Data import from GA using the API or Add‑on
  • Automatic refresh (daily) set up
  • Clear visualisations (charts, tables) for each channel
  • Insight summary section with key metrics
  • Clean layout and proper documentation
Sign in to take partYour progress and project are saved to your account.
Sign in
The teaching videos are made by independent creators and play from YouTube, with the creator credited on every lesson. Nexgino builds the path, the notes, the project and the certificate.
9 lessons · free Start free