How to Build an Executive/KPI Dashboard to Prove Your PPC Value

Marketers aren’t usually positive about the way to show their fee and preserve their activity.

This post will help you determine what your bosses care about and how you may display PPC’s price on a dashboard.

People frequently think that what we do in PPC is either the black arts or is as simple as picking a few key phrases, advert reproduction, and focused on. We are aware of it’s plenty more complicated than that.

9 Executive Dashboard Examples for CEOs to Power Up | DashThis

We additionally realize it can frequently be tough to expose the cost of what you do to everyone inside the business enterprise.

One thing that I even have discovered working on brands like ASOS, WealthBar, and Telstra is that there are only three people you actually need to fulfill in an employer:


Your boss.
Your boss’s boss.

Making positive you are happy at work should be vital because we spend 30 percent of our life at paintings.

Making sure your boss and their boss is satisfied is a lot more difficult, but this post will assist you with that.

Here’s a way to discover your North Star, show your work’s fee, ensure your facts is correct, and communicate with everybody in the corporation.

What Is Your North Star?

If your boss got here around on your table the day after today and asked you how the commercial enterprise was doing, what might you tell them? Could you rattle off overall performance numbers for the final 60 days?

Knowing your overall performance numbers internal and out indicates you care approximately the business. Every commercial enterprise ought to have a North Star; that one wide variety each department and enterprise unit appears at to make sure they’re making the organization more profitable with each choice they make.

To place it in some other manner, it’s the only variety that the whole organization rallies around to make sure everybody is pushing the enterprise within the same course.

Mel Gibson’s North Star in “Braveheart” turned into freedom for his humans. Love or hate the film, his character knew a way to rally anybody collectively.

If you figure in e-commerce, you definitely care about the average order cost (AOV) or return on advert spend (ROAS). In software-as-a-provider (SaaS), you study value according to acquisition (CPA) or lifetime cost (LTV).

If you work in any other industry, then your North Star can be something special. Many friends who paintings for apps care approximately price according to set up (CPI) or average revenue consistent with the consumer (ARPU). The latter is focused on paying customers, and now not everyone who has installed the app.

Once you understand your North Star, you need to put it out on your Excel sheet. If we stay with e-commerce as our instance, we realize that they indeed recognition on the go back on ad spend (ROAS) for our one metric of achievement.

Finding All Your Data

Where does your boss and boss’s boss pull their information from?

Making sure you and your manager are looking at equal numbers is prime for this being an achievement. There is not anything worse than you thinking you probably made four hundred sales remaining month; however, your boss says it’s simplest 375 due to the fact you had some returns and refunds not taken into consideration.

I actually have visible human beings pull numbers from a Google Ads account, whereas a boss pulls it from Google Analytics or records warehouse-like Domo.

If you don’t have access to the statistics warehouse, you need to invite your boss to access it. Explain that you need to help make specific each person is talking approximately the same numbers, and we are comparing apples to apples.

Since we need to build a dashboard searching at ROAS, I would pull revenue numbers for the remaining calendar years and the modern-day year.

Plus, make sure you get all your advert to spend from your advert platform. If you can get your sales quantity damaged down for each advert platform, that could be an excellent manner to get extragranular with reporting.

If you’re pulling from an advert account or Google Analytics, my agency is a huge fan of using Supermetrics as our records reporting tool. We discover Supermetrics is high-quality for pulling data from a couple of advertising and analytic assets.

Since we want to construct a dashboard searching at ROAS, I would pull revenue numbers for the closing calendar years and the contemporary yr.

Plus, make sure you get all of your ads to spend from your advert platform. If you can get your sales to range damaged down for each advert platform, that might be a remarkable way to get more granular with reporting.

If you’re pulling from an advert account or Google Analytics, my business enterprise is a big fan of the usage of Supermetrics as our records reporting tool. We discover Supermetrics is fantastic for pulling statistics from a couple of advertising and analytic resources.

Plus, Supermetrics may be set up to vehicle-update statistics each day or each hour. If you want to drag from Domo or every other facts warehouse, you would need to download it into a CSV. A CSV maybe uploads into Excel or Google Sheets.

Now that you have all your information, you want to position it together in a dashboard that updates. I might stay with a weekly replacement. Though round Black Friday or a significant sale, you can want to update it daily to keep on the pinnacle of performance numbers.

The photograph above is an excellent instance of how I could lay out my statistics. There are regions you want to expose off for your manager and their boss:

How is paid to do on its own (paid advertising and marketing channel tab)?
How is paid doing compared to the relaxation of the business or natural site visitors (KPI Dashboard)?

Access the spreadsheet here.

Paid and organic tend to be 2 of the pinnacle 3 visitor resources for an e-commerce enterprise. They generally make feel to examine every difference. You may also want to consist of why you are having a slow month or numbers are down for a month.
Paid Advertising Channel Tab

Layout your months alongside column A, accompanied by your spend and revenue for 12 months one. Since we want to use ROAS as our North Star, determine out what your ROAS would be for the primary year for every month. Duplicate the technique again in your 2nd 12 months.

The subsequent three columns examine yr over yr (YOY) overall performance for spending, revenue, and ROAS between your first and 2nd yr. For instance, how did January 2017 do in comparison to January 2018?

I always consist of a totals column at the cease to help yearly tune performance as correctly. This helps you to observe how paid is doing on its own for the year.

How is paid to do as compared to natural? No advertising channel ought to operate in a silo. It’s exact to peer how you are doing against the rest of the commercial enterprise.

Plus, if there’s a broad distinction in overall performance, it’s perfect for testing it with the man or woman doing organic and notice if there are gaining knowledge of possibilities between the 2 channels. The spend under natural could come from the search engine marketing character’s earnings and advantages.

If you had affiliate statistics to your dashboard, you might place spend as revenue of the man or woman dealing with your associate sales, plus how much you had to pay out to associates—basically, all the expenses of jogging the associated channel.

Since the paid advertising channel’s information should be overwhelming, I usually make a 2d tab that just looks on the KPI dashboard. This tab will study 12 months over 12 months’ overall performance for the modern-day month.

This tab fast lets your bosses see how you’re doing yr-over-yr in comparison to the whole business. You could upload a phase below that adds why overall performance is up or down. This comes all the way down to how specified your bosses like to get.


Figuring out what your company’s North Star is critical. What is the only number anyone to your business enterprise rallies in the back of?

Make sure you are looking at the identical records as your bosses. Assemble the spreadsheet above and help make sure anybody is on the same web page.

One very last notice, you can want to do a month-to-month electronic mail out to the advertising crew. That could explain in more element what is going on at the back of the numbers.

You can also say what your plans are for the subsequent month. Never be afraid to overshare your activity and have records freely flowing out of your department to the organization.

More Resources:

PPC one hundred and one: A Complete Guide to Pay-Per-Click Marketing Basics
3 Critical PPC Tasks You Should Do Every Day
five Useful & Easy Google Ads Metrics You Should Monitor


I have been working in the field of SEO and content marketing since 2014. I have worked with over 500 clients and more than 100 websites. I started blogging in 2012 and have now made my first steps into the world of freelancing. In my spare time, I like to read, cook or listen to music.