The Final Google Advertisements Pacing Dashboard For 2023 (Free Looker Studio Template)

The Ultimate Google Ads Pacing Dashboard For 2023 (Free Looker Studio Template)

It’s been a 12 months since I printed my Google Advertisements Pacing Dashboard to Search Engine Journal, and digital advertising modifications fairly rapidly in a 12 months.

Google Information Studio modified the way it handles blended data, then modified its identify altogether (Whats up, Looker Studio!).

What hasn’t modified is that we nonetheless can’t add objectives and targets to the Google Advertisements platform, so we nonetheless want separate dashboards to trace pacing and progress.

The Ultimate Google Ads Pacing Dashboard For 2023 (Free Looker Studio Template)Screenshot of Looker Studio, November 2022

On this tutorial, we’ll cowl find out how to entry and use the pacing dashboard, what’s new, and find out how to get essentially the most out of it.

Then, we’ll take a broader take a look at what a fantastic pacing dashboard will need to have that can assist you in your profession.

Step 1: Entry And Prep Your Templates

A completely automated pacing dashboard requires actuals, targets, and a solution to mix the 2:

The Ultimate Google Ads Pacing Dashboard For 2023 (Free Looker Studio Template)Picture created by creator, November 2022
  • Actuals: Google Advertisements Account Efficiency Information: A direct connection to a Google Advertisements account provides you real-time spend and conversion information and historic tendencies.
  • Targets: Inside Targets and Targets Set Manually in Google Sheets: By recording KPI objectives in a Google Sheet, you possibly can populate month-to-date and every day pacing targets.
  • Mixed: Looker Studio Blended Information: Looker Studio will use blended data to calculate metrics from each Advertisements and Sheets.

Now that you simply perceive how this may work, it’s time to get your templates.

1. Seize The Templates

First, use this hyperlink to download your free templates.

There are two dashboard variations to select from:

  • Conversions (for lead technology).
  • Income (for ecommerce).

As defined above, you want each the Looker Studio and Google Sheets information for this pacing dashboard to work accurately.

2. Replace Your Copy Of Google Sheets Pacing Template

That is the place you’ll enter essential data like your account identify and targets.

  1. Click on “Make a duplicate” of the Google Sheets Pacing Template.
  2. Change the identify of the Google Sheet to mirror your account(s).
  3. In Column A, enter the identify of your Google Advertisements account. (The account identify capabilities because the blended information “be part of key,” so it should match precisely!)
  4. Enter your spend and KPI objectives in Columns D and E.
The Ultimate Google Ads Pacing Dashboard For 2023 (Free Looker Studio Template)Screenshot of creator’s Google Sheet template, November 2022

That’s it for this sheet! The whole lot else is calculated robotically.

3. Replace Your Copy Of The Looker Studio Dashboard

  1. Open the Looker Studio Pacing Report and click on the three dots on the highest proper to “Make a duplicate.”
  2. You’ll be prompted to decide on New Information Sources. Choose your Google Advertisements account and the Google Sheets pacing template you simply created. It’s possible you’ll have to “Add New Information Supply” to entry them.
Image of Looker Studio prompt to copy reportScreenshot from Looker Studio, November 2022

Step 2: Overview The Dashboard Structure

We’ll undergo the Income Dashboard part by part right here.

Replace your information and templates earlier than strolling by the dashboard, so you possibly can test for inconsistencies and determine customizations you’ll make within the subsequent step.

Your Google Advertisements information and month-to-month targets needs to be correct, however you’ll have to make some changes to the every day pacing charts and widgets afterward.

KPI Relationships Part

The dashboard leads with KPIs for spend and income (or conversions, relying on which model you’re utilizing). You’ll know precisely what the aim for the month is, what real-time efficiency is, and the way you’re pacing.

Monitoring MTD aim progress in opposition to how a lot of the month has handed lets you already know whether or not it’s time to watch or time to behave.

Key efficiency indicators in a number of codecs (uncooked numbers, ratios, percentages) present pacing and information relationships with out requiring you to divide giant numbers by 30.4 in your head to reach at every day averages.

The Ultimate Google Ads Pacing Dashboard For 2023 (Free Looker Studio Template)Screenshot from Looker Studio, November 2022

Charts And Scorecards Used:

  • Month Progress: Right now’s date, % of month accomplished, and remaining.
  • KPI Aim Scorecards: Income (or conversion) aim and month-to-month finances.
  • KPI Pacing Widget: A single-cell desk that returns a press release primarily based on pacing.
  • MTD Goal Scorecards: MTD goal worth, % completion of MTD goal, and whole month-to-month aim.
  • Gauge With Vary: KPI efficiency to this point with progress visualization.
  • MTD Scorecards: worth distinction between precise efficiency and objectives.

Return Ratio

This part compares spend to return. The goal is robotically populated primarily based on objectives and doesn’t have to be set individually.

You’ll see a unique part relying on whether or not you’re utilizing the Income or Conversion Dashboard.

The Income Dashboard for ecommerce shows ROAS (return on advert spend). The Conversion Dashboard for lead technology and normal conversion monitoring shows CPL (price per lead).

roas target vs actual screenshotScreenshot from Looker Studio, November 2022

Day by day Progress And Course Correction

Right here, you possibly can see the way you’ve been doing (common every day efficiency) and the way you’re doing (latest every day efficiency).

schreenshot of daily pacing for revenue and cost mtd dataScreenshot from Looker Studio, November 2022

Within the account used on this screenshot, my every day income will at all times path beneath the goal. That’s due to conversion lag time, and I’m going to notice it however not fear about the truth that yesterday’s income is just a 3rd of the every day aim. In two weeks, it’ll inform a unique story.

Charts And Scorecards Used:

  • Day by day Pacing Goal: Goal divided by days within the month.
  • Efficiency Scorecards: Right now, yesterday, and common.
  • Time Sequence Chart: Cumulative efficiency in comparison with pacing goal.

I’ve discovered that additional particulars, resembling MTD tables with every day variance, distract my focus from the larger image (are we pacing to hit our objectives?), so I didn’t embrace it within the dashboard.

If you happen to’re the sort of one that desires to see the specifics of previous every day efficiency each time you test in on pacing, you possibly can actually add it to your report.

Historic Efficiency Part

Most of us don’t have a photographic reminiscence of how seasonality impacts every account, so there’s a reference part for that within the dashboard.

screenshot of charts showing past 30 days and past 13 months performance on a google ads accountScreenshot from Looker Studio, November 2022

These historic charts provide you with pattern information and context for real-time efficiency.

Charts Used:

  • Time Sequence Chart: Final 30 days for KPIs.
  • Time Sequence Chart: Final 13 months for KPIs.

In case your base information seems correct, it’s time to maneuver on to customizations. (If you happen to see errors, leap right down to Step 5 for troubleshooting assist.)

Step 3: Customise And Replace Your Dashboard

These edits and customizations offers you full management over the dashboard to mirror your individual wants and preferences. Don’t skip this part, or your targets received’t match your precise objectives.

1. Replace Chart Pacing Targets

To get chart ranges to match your targets, you’ll have to do some mild customization. As a result of it entails arduous coding, you’ll need to preserve them up-to-date whenever you get new targets.

Hardcode The Gauge Chart Max Axis

The “Axis Max” on the gauge charts received’t mirror your goal with out handbook enter.

Enter the axis of your gauge charts by doing the next:

  • Choose the gauge chart within the dashboard.
  • Choose the Model panel.
  • Change the Axis Max to match the month’s aim proven above the chart.
screenshot of entering pacing targetScreenshot from Looker Studio, November 2022

Hardcode The Time Sequence Pacing Metric

Create a continuing every day pacing goal with these steps:

  • Choose the every day pacing time sequence chart within the dashboard.
  • From the Setup panel, choose the calculated Pacing metric.
  • Replace the primary quantity within the method to match the pacing goal above the chart. (Observe: “[Metric] * 0” doesn’t have to be up to date, it merely calculates as “0”, which is required for the method to validate.)
screenshot of style axis max updateScreenshot from Looker Studio, November 2022

The Day by day Pacing Goal above the chart will robotically replace as the times in a month change. You’ll simply have to edit the hardcoded Pacing Metric within the time sequence chart to match that new worth.

2. Modify The KPI Pacing Widget (Non-compulsory)

Subsequent to every KPI is a color-coded button indicating the pacing standing. You’ll be able to customise the colours, textual content, and intervals.

screenshot of various pacing widget buttonsScreenshot from Looker Studio, November 2022

Edit the dimension’s calculated area to alter phrasing or interval. The finances pacing area will seem like this by default:
WHEN (Value/MTD Spend Goal) < .9 THEN "Underpacing"
WHEN (Value/MTD Spend Goal) >= .91 and (Value/MTD Spend Goal) < 1.1 THEN "On Observe"
WHEN (Value/MTD Spend Goal) > 1.1 THEN "Overpacing"

You’ll be able to change the values if, for example, you need “on observe” to be inside 5% of the aim moderately than 10%. It’s also possible to create extra variants or edit the return statements.

To vary the background and textual content colour, merely edit the conditional formatting within the Model panel.

screenshot of conditional format sectionScreenshot from Looker Studio, November 2022

Different Customizations

As a result of the template is 100% customizable, you may make any updates you need, from altering the foreign money to setting totally different weekend/weekday and even every day pacing objectives. It’s also possible to arrange a single Google Sheet as a knowledge supply for all of your reviews.

Step 4: Use Your Dashboard To Make Selections

I don’t just like the phrase “let the info determine” as a result of information doesn’t make selections. We do.

The fantastic thing about this pacing dashboard is that it provides you immediate entry to the info it’s essential make strategic, knowledgeable selections.

A script can robotically pause campaigns when spend is excessive, however it may’t seek the advice of along with your shopper about how to answer market modifications.

Since most of us handle accounts that have to hit conversion objectives and never merely “spend X finances each month,” realizing precisely how spend and returns are pacing in opposition to targets can elevate your administration abilities.

Right here’s how one can take motion on dashboard insights in a approach that positions you as a strategic accomplice to your purchasers.

paid search pacing matrix: spend and returnPicture created by creator, November 2022

Scorching/Excessive: Alternative.

When efficiency is stronger than anticipated, discuss to your shopper about rising the finances to fulfill the demand, so that you don’t depart gross sales and leads on the desk.

Scorching Spend/Low Returns: Optimize.

Once you’re overspending and don’t have a lot to point out for it, it’s time to optimize for efficiency. Decrease bids and budgets, and pause or take away poor performers.

Chilly Spend/Excessive Returns: Examine.

When the spend is low, however the return is above the aim, the temptation is to have a good time. Earlier than you do, take a deeper look into find out how to use the accessible finances for top-of-funnel efforts or better returns.

Chilly/Low: Regulate Expectations.

If the demand simply isn’t there, it is likely to be greatest to regulate the finances, shifting allotted funds to a interval that wants it.

Step 5: Troubleshooting And Upkeep

If one thing isn’t working in your dashboard, begin by checking these areas:

“Null” Or “No Information” Errors

  • Is the blended information “be part of key” in Looker Studio precisely the identical in each your Sheets and Google Advertisements information sources? Examine the identify of the account within the prime left nook of the dashboard and ensure there are not any typos within the cell AI of your Google Sheet.
  • Are you utilizing the proper information supply? Observe that this template works instantly with the Google Advertisements platform, not Google Analytics information about Google Advertisements campaigns.

Pacing Or Accuracy Errors

  • Is the date vary set to customized (month to this point, and many others.)? It needs to be on customized, not auto.
  • Have you ever accurately hardcoded the axis and pacing fields along with your targets? Overview Step 3 above.

Do not forget that as a result of the pacing template requires some arduous coding for visualizations, you’ll have to edit your targets within the dashboard to remain present when your objectives change.

The Use Case For The Google Advertisements Pacing Dashboard

As paid search managers, generally we don’t have all of the instruments we have to do our job. Even easy duties like Google Ads pacing may be a lot more durable than they need to be.

That’s as a result of you possibly can’t enter your finances or conversion targets instantly into the platform.

With out that primary context of objectives vs. actuals, it turns into arduous to know the fitting motion to take.

Most third-party software program and DIY pacing sheets making an attempt to resolve this drawback simply aren’t helpful to paid search managers.

They’re both too primary to supply insights or too busy to be understood at a look.

Screen shot of single donut chart that is too basic, and spreadsheet that is too busyPicture created by creator, November 2022

As a result of I couldn’t discover the right automated dashboard, I made a decision to construct my very own.

Pacing Dashboard Necessities

A pacing dashboard wants to offer you quick access to information that drives strategic selections and motion.

Right here’s my very own top-five want checklist for what I would like in a pacing dashboard. As you possibly can see, this checklist instantly knowledgeable the template I finally constructed:

  1. KPI snapshots and relationships. I want to grasp the connection between what ought to occur (objectives and month-to-date targets) and what’s occurring (actuals).
  2. Present every day progress. I need to see the every day pacing targets wanted to succeed in month-to-month KPIs and whether or not the account is constantly hitting these targets. What course correction, if any, has occurred? What modifications nonetheless have to be made?
  3. Present context. I need to see how this month’s efficiency compares to latest and longer-term tendencies.
  4. Automated. Except my finances or income objectives change mid-month, I shouldn’t have to the touch or replace something.
  5. Accessible and shareable. Let me entry and share with my crew or purchasers with out logins, downloads, or attachments. (Reviews are easily sharable from Looker Studio.)


Having immediate entry to efficiency objectives and actuals provides you insights that may make you a extra strategic paid search marketer.

This Google Advertisements pacing dashboard isn’t fully plug-and-play, however hopefully, you’ll discover that the worth you get from it far outweighs the “funding” of retaining it up to date.

Use the dashboard to fulfill the calls for of your individual pacing wants and drive higher administration selections to your purchasers.

Extra Assets:

Featured Picture: fizkes/Shutterstock

Source link

Leave A Comment



Our purpose is to build solutions that remove barriers preventing people from doing their best work.

Giza – 6Th Of October
(Sunday- Thursday)
(10am - 06 pm)

No products in the cart.

Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
  • Attributes
  • Custom attributes
  • Custom fields
Click outside to hide the comparison bar