Set yourself up for more success. Learn how to take your PPC dashboard from good to great using Google Looker Studio.
You get your data source connected, open up a new file, and you have no idea what to do next.
There are no instructions. No guide rails. Just you and an empty page to fill.
And while you can start with a template (Looker Studio Report Gallery has several), it’s still tough to know how to customize it to perfectly fit your needs.
Here are some tried-and-true elements to include in PPC dashboards and reports that will banish blank-page syndrome and give your stakeholders the insights they crave.
1. Titles, subheads and context
When you add a chart in Looker Studio, you select the data source, dimensions, metrics and date range from the Setup Panel to populate your visualization.
But your reader doesn’t see the Setup Panel and won’t know what your chart is about unless you take an extra step to include it in your dashboard.
The two graphs below show identical data visualizations. Figure A includes only the chart, while Figure B includes written titles and context.
</li>
<li>If multiple data sources are used throughout your dashboard, clarify which is used in specific charts.</li>
</ul>
<p><strong>How to do it:</strong></p>
<ol>
<li>Add a text box and write out your titles and descriptions.</li>
<li>This will open up a “Text Properties” panel to edit fonts, text size, and styling elements.</li>
</ol>
<figure class=)
key performance indicators (KPIs).
But while you’re planning out your dashboard, pay special attention to where to include them.
Your KPIs matter most in your report and deserve top billing.
That means showcasing your KPIs with scorecards like so:
, rather than vanity and traffic metrics like impressions and clicks.</p>
<p><strong>How to do it:</strong></p>
<ol>
<li>Use <em>Chart > Scorecard</em>.</li>
<li>In the “metric” section of the Setup Panel, add your KPI. Repeat as needed.</li>
<li>Control format and size in the Style Panel.</li>
</ol>
<p>Having KPIs appear in tables and other charts isn’t a problem, but give them added attention by using scorecards.</p>
<h2>3. Goal pacing</h2>
<p>Some advertisers use fixed monthly or annual marketing budgets with no room for adjustments.</p>
<p>Others have sales or efficiency goals they need to hit with flexible budgets.</p>
<p>No matter what the approach, your dashboard should answer the question:</p>
<p><strong>Are we meeting our objectives, and how do we know?</strong></p>
<p class=)
</li>
</ol>
<p>Including goal pacing gives your reader confidence in how to interpret performance data.</p>
<h2>4. Trends and historical comparisons</h2>
<p>Trends and historical comparisons let your reader know if things are improving – or need improvement – over time.</p>
<p>Maybe you fell short of the goal, but you always miss it because it’s unrealistic.</p>
<p>Maybe you hit your goal, but you’re down compared to last year, and you need to take corrective action.</p>
<p><strong>Don’t</strong> make your reader wonder whether current performance is average, down or “best month ever.”</p>
<h3 id=)
Snapshot (single-metric) comparisons
Tables and scorecards give you an easy way to show your reader how performance for this period compares to another, using color-coded arrows to indicate the direction of the change (delta).
.</li>
<li>You can also format Scorecards to <a href=)
show both YoY and MoM comparisons.
Line charts
You can get a complete picture of performance trends using time series charts.
Rather than just comparing this period to the last period, you’ve got an entire history revealing trends in seasonality, market impact and more.
 or designate a comparison time period.</p>
<p>Here’s how that same data looks as a Year over Year (YoY) Time series chart. Note that the comparison year will show as a lighter shade of this period’s line:</p>
<figure class=)
:
<ul>
<li>Select a Line chart</li>
<li>Set the “Dimension” to Month</li>
<li>Set the “Breakdown Dimension” to Year</li>
<li>Set the “Sort” to Month</li>
<li>Set the “Secondary sort” to Year</li>
</ul>
</li>
</ul>
<p>A few important notes for trends and historical comparisons –</p>
<ul>
<li>Only use these for your<strong> KPIs or metrics that directly contribute to your KPIs</strong>. Don’t add a CTR trend chart just for the sake of including a trend chart.</li>
<li>There’s almost never a reason to show daily granularity in these charts. Zoomed in that closely, you’ll miss the signal for the day-to-day noise. Look for trends at a <strong>monthly level</strong>.</li>
</ul>
<h2>5. Categorical tables</h2>
<p>Okay, so tables aren’t that glamorous.</p>
<p>But if your Looker Studio dashboard doesn’t have a table, something’s probably missing.</p>
<p>Why? Because there are times when your audience needs to compare multiple categories across multiple metrics. And nothing does that more efficiently than a table.</p>
<p>Tables are great for comparing default categories like:</p>
<ul>
<li>Campaigns</li>
<li>Ad groups</li>
<li>Keywords</li>
<li>Search terms</li>
<li>Final URLs</li>
</ul>
<p>And depending on the complexity of your PPC dashboard, you can create tables for:</p>
<ul>
<li>Engines and platforms</li>
<li>Channels and networks</li>
<li>Funnels / intent / stages of awareness</li>
<li>Brand vs. nonbrand</li>
<li>Pivots of time segments, conversion types, and other categories</li>
</ul>
<figure class=)
How to do it:
- Chart > Table (or Pivot table)
- Dimension(s): the category or categories you want to compare
- Metrics: your KPIs and supporting metrics
- From the Style Panel, you can format your table to include heatmaps, bars and targets
It’s easy to build tables and add metrics, and it’s easy to get carried away. Exercise some restraint and limit the number of metrics in your table, so it remains useful to your reader.
Bonus: Shiny charts
Our list constrained us to five categories, but here’s one bonus for making it to the end:
Shiny charts.
What are shiny charts?
Shiny charts are visualizations that your audience loves and gets excited about, even if they’re not super actionable.
Your readers may not learn anything new, but they’ll feel like they learned something new.
Maps are a great example.
not to use map charts; there are better ways to communicate location data.
But try to find a client or stakeholder who doesn’t love to see performance data on a map. Go ahead. I’ll wait.
Sure it’s a bit counterintuitive when you’re trying to build out an actionable dashboard. Maybe even a bit controversial. And you don’t have to do it. But a chart that makes your audience feel good just for seeing it has its own merit.
Putting it all together
While your Looker Studio dashboard can technically include whatever you want, it should at a minimum include:
- Title and context
- KPI scorecards
- Goal pacing
- Historical comparisons
- Categorical tables
These don’t need to (and can’t) all be discrete sections. One scorecard can include a title, KPI, pacing, and time comparison.
There are many other charts and visualizations that can take your PPC dashboard from good to great. Getting started with this list will set you up for success and give you a dashboard worth the time it took to build.