Episode 2Connect AI Directly to Google Analytics (No Exports)
Ask Google Analytics questions in plain English, then build the same dashboard straight from live data.
Dashboards your team will actually use. Built with AI, in an afternoon.
Step-by-step videos and free sample data show you how to turn your Google Analytics and spreadsheet exports into clear, shareable dashboards with AI. No Looker Studio, no data team. Prefer to hand it off? I'll build it for you.
Harbor City History Museum · website traffic (sample data)
How it works
From export to dashboard in three steps
1
Export your data
Pull a few CSV files from Google Analytics, your ad accounts or a spreadsheet, or connect AI to Google Analytics directly.
2
Build it with AI
Paste our tested prompts into Claude or ChatGPT. You steer; the AI does the heavy lifting.
3
Share it
You get one HTML file that opens in any browser. Email it, or turn it into a link in a minute.
Learn it step by step
Every lesson comes with a video, the exact prompts and free sample data.
Episode 2
Episode 1Build a Website Traffic Dashboard with AI (No Looker Studio)
Turn four Google Analytics exports into a one-page dashboard with Claude or ChatGPT in about an hour.
See what you can build
Every dashboard here runs on invented sample data for a fictional organization, so you can explore it freely.
LiveWebsite Traffic
Visits, channels, top pages, devices and cities, with date and channel filters. Built from standard Google Analytics exports.
Sales Dashboard
Orders, best-selling products and online vs. in-store sales from a messy spreadsheet.
Donor Dashboard
Gifts by month, donor retention and progress toward campaign goals.
Services
Rather not build it yourself?
It's less expensive than you think. I design and build dashboards for museums, nonprofits, local businesses and campaigns, including dashboards that update automatically at an interval of your choosing. Pricing depends on complexity, and dashboards start at $500.
I'm Matt, a digital marketer with 20+ years in analytics, ads and e-commerce. I started Dashboard Workshop because most small organizations have the data but never look at it. The tools to fix that finally exist; they just need a guide.
More about me →Your data already has the answers.
Start with the free website traffic lesson, or get in touch about your own dashboard.