Worksheet · Marketing Analytics · Looker Studio
Marketing KPI dashboard
From the lesson Setting Up Looker Studio
Work through each step on paper or on screen. Use a real business, a project of your own or a friend’s idea. Keep this page for your portfolio.
1Connect one data source.
2Check the numbers.
3Start a report.
Worked example to compare with: A one-page dashboard
- Top row: sessions, leads and conversion rate as three number tiles.
- Middle: a line chart of leads over time.
- Bottom: a table of top sources.
- Date range: last 30 days compared to the previous 30.
- Check: can a manager understand it in 30 seconds?
Check yourself
- I can explain "Setting Up Looker Studio" in one sentence.
- I used a real business or project, not just an idea.
- I know what I will do next, and by when.
Notes
Free course worksheet · https://studentmarketers.com