Google Sheets for marketing teams · Hradec Králové, CZ
Four evening sessions where Czech marketing teams bring their own Facebook Ads and GA4 exports and leave with pivot tables, a dashboard that refreshes itself, and a chart their CEO reads in half a minute. No new software, no subscriptions, just Google Sheets you already have open.
Built for people already staring at spreadsheets, not for people shopping for analytics tools.
Another CSV from Ads Manager, another export from GA4. Filenames like "final_v3" multiply on the desktop while nobody opens the older ones again.
Every week someone copies numbers into a new tab, formats it by hand, and hopes it looks roughly like last week's version.
A single follow up question during a meeting and the whole spreadsheet needs reopening, recalculating, and re-explaining.
The person who built it left, changed roles, or is on holiday. The formulas are a mystery and everyone is afraid to click anything.
Not "how pivot tables work" in the abstract, but which field goes where when someone asks which campaign drove the most leads last quarter, or which audience segment is quietly overspending. You practise on your own Facebook Ads export until the structure becomes automatic.
A separate data tab, a query or pivot that references it, and charts that pull from the pivot rather than from raw numbers. Paste a fresh export in and the dashboard recalculates itself, no rebuilding required.
Choosing the chart type that matches the question, trimming the clutter, and labelling so a manager scanning it between meetings understands the trend without asking what an axis means.
Matching campaign names between two exports that spell things slightly differently. Flagging which rows are above or below target automatically. These two formulas quietly do most of the manual matching marketers still do by hand.
Turning a raw Facebook Ads or GA4 export into a pivot table that answers "which campaign, which week, which audience" without touching a formula bar.
Separating raw data from presentation, so pasting a new export updates every chart and number without rebuilding anything.
Picking chart types that match the question being asked, and removing everything that makes a manager squint at a legend.
Working through the two formulas that solve most of the manual copy pasting between Facebook Ads and GA4 exports.
Each session opens with a short explanation of the concept for that evening, maybe fifteen minutes, followed by working time where every participant applies it directly to their own Facebook Ads or GA4 export rather than a shared demo file. Questions come up naturally because the data is messy in the ways real marketing data is messy: renamed campaigns, missing weeks, currency formatting that Sheets reads oddly.
The course does not sell or bundle any analytics software, dashboard subscription, or reporting tool. Everything is built inside Google Sheets, which most marketing teams in Czechia already have through a standard Google Workspace or free account. What participants leave with is a set of working files and the ability to rebuild the same logic on the next export, not a licence key.
