Worksheet · Marketing Analytics · Looker Studio

Marketing KPI dashboard

From the lesson Creating Reports

NameDate

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.

1Choose five KPIs.

2Build a one-page report.

3Add a short summary.

Worked example to compare with: Writing a summary

  • "Leads rose 18 percent this month, mainly from search. Cost per lead fell to $22. The email campaign underperformed. Next month we will rewrite the subject lines and add two new search pages."
  • Why it works: result, reason and next step.
  • Check: could someone decide what to do after reading only the summary?

Check yourself

  • I can explain "Creating Reports" 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

Back to the lesson

Free course worksheet · https://studentmarketers.com