All courses Marketing Analytics

Looker Studio · Lesson 11 of 11

Creating Reports

Looker Studio has several features and tools for building comprehensive reports.

1 Learn the concept

Looker Studio has several features and tools for building comprehensive reports. A good report is clear, short and focused on a few KPIs. This lesson shows how to apply charts, tables and filters so that the report tells a story and leads to decisions.

A checklist for writing a useful marketing reportREPORT CHECKLISTStart with the goal and the resultShow the trend compared to last periodExplain why it happenedRecommend two or three next stepsKeep it to one page where possible
A report is only useful if it leads to a decision.

2 See it in action

  • Lead with the most important numbers.
  • Use the right chart for each question.
  • Add date filters and notes.
  • Keep the design clean and consistent.

Worked example

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?

3 Study an example

Example scenario

A weekly report shows five KPIs, a trend chart and a short note on what changed. The client reads it in two minutes and knows what to do next.

4 Apply it and download

  1. Choose five KPIs.
  2. Build a one-page report.
  3. Add a short summary.

Worksheet Marketing KPI dashboardOpen, print or save as PDF

Ready to get started?

Businesses get matched with vetted marketing interns. Interns get real experience and a mentor. Pick your path and get started in minutes.