FEATURED: What to watch in the markets today  - read our article!

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

Marketers aren’t always sure of a way to show their value and preserve their activity. in ingPeople regularly think that what we do in PPC is both the black arts or is as easy as selecting some key phrases, advert reproduction, and focused on. We know it’s plenty greater complicated than that. We also know it could regularly be tough to reveal what you do to everyone within the employer. This put up will assist you in discerning out what your bosses care about and how you may display PPC fees on a dashboard.

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

One thing that I even have found out operating on brands like ASOS, WealthBar, and Telstra is that there are simplest three people you really want to meet in an enterprise:

  • Yourself.
  • Your boss.
  • Your boss’s boss.

Making sure you are glad at paintings has to be crucial because we spend 30 percent of our lifestyles on paintings. Making certain your boss and their boss are glad is more intricate, but this put up will help you with that. Here’s the way to find your North Star, show the cost of your work, ensure your data is correct, and speak with anyone within the business enterprise.

What Is Your North Star?

If your boss came around for your desk tomorrow and asked you how the enterprise became doing, what could you inform them? Could you rattle off performance numbers for the final 60 days? Knowing your overall performance numbers interior and out indicates you care approximately the enterprise. Every enterprise ought to have a North Star; that one variety every branch and business unit seems to make sure they are making the enterprise more profitable with each preference they make. To positioned it any other way, it’s the one number that the entire enterprise rallies around to make sure anyone is pushing the company in the identical direction.

Mel Gibson’s North Star in “Braveheart” becomes freedom for his human beings. Love or hate the film, his individual knew the way to rally all of us together. -, If you work in some other enterprise, then your North Star will be something one of a kind. If you work in ecommerce, you definitely care about common order price (AOV) or return on ad spend (ROAS). In software program-as-a-provider (SaaS), you have a look at value per acquisition (CPA) or lifetime cost (LTV). Many pals who paintings for apps care about price consistent with set up (CPI) or average sales in step with the user (ARPU). They lattfocusessed on paying customers, and now, only everyone has hooked up the app. Once you understand your North Star, you want to lay it out in your Excel sheet. If we stick with ecommerce as our instance, we recognize that they clearly focus on going back on ad spend (ROAS) for our one metric of achievement.

Finding All Your Data

Where do your boss and boss’s boss pull their records from?

Making certain you and your supervisor are searching on equal numbers is prime for this being a fulfillment. There is nothing worse than you questioning you did 400 income closing month; however, your boss says it’s simplest 375 because you had a few returns and refunds now not taken into account. I even have visible people pull numbers from a Google Ads account, while a chairman pulls it from Google Analytics or even a statistics warehouse like Domo.

If you don’t have to enter the records warehouse, you want to invite your boss to get the right of entry. Explain which you want to assist make sure all and sundry is speakme approximately the equal numbers, and we’re evaluating apples to apples. Since we need to construct a dashboard searching at ROAS, I would pull sales numbers for the ultimate two calendar years and the modern-day year.

Plus, make certain you get all your advert spend out of your ad platform. If you may get your sales number damaged down for every ad platform, that might be a great way to get greater granular with reporting. If you’re pulling from an ad account or Google Analytics, my agency is a massive fan of the use of Supermetrics as our information reporting tool. We discover Supermetrics is top-notch for pulling facts from multiple advertising and analytic sources.

Plus, Supermetrics may be set up to vehicle-update facts every day or every hour. If you need to tug from Domo or some other facts warehouse, you could need to load the data right into a CSV. A CSV may be upload into Excel or Google Sheets. Now that you have all of your statistics, you need to place them together in a dashboard that updates. I would stay with a weekly replacement. Though round Black Friday or a primary sale, you could need to replace it every day to keep on the pinnacle of performance numbers.

Setting Up Your Executive Dashboard

The photograph above is a superb instance of how I could lay out my facts. There are two areas you want to expose off in your manager and their boss: How is paid doing on its own (paid marketing channel tab). How is paid to do compared to the rest of the enterprise or natural traffic (KPI Dashboard)?

Access the spreadsheet right here.

Paid and organic tend to be 2 of the top 3 site visitors sources for an ecommerce enterprise. They generally make feel to examine to every other. You might also need to ask why if you are having a gradual month or numbers are down for a month.

Layout your months alongside column A, followed through your spending and sales for year one. Since we want to use ROAS as our North Star, determine what your ROAS would be for the primary 12 months for each month. Duplicate the system once more in your 2nd year. The next three columns evaluate yr over year (YOY) performance for spending, revenue, and ROAS among your first and 2nd 12 months. For example, how did January 2017 do compared to January 2018? I always include a totals column on the cease to assist track every year’s overall performance properly. This helps you to look at how paid is doing on its own for the yr.

How is paid doing as compared to organic? No marketing channel ought to function in a silo. It’s proper to see how you’re doing towards the rest of the business. Plus, if there’s a wide difference in overall performance, it’s a good time to test with the character doing organic and see if there are gaining knowledge of opportunities among the two channels. The spend underneath organic might come from the search engine marketing character’s revenue and blessings. If you had affiliate information on your dashboard, you would possibly be positioned spend as earnings of the person dealing with your associate sales, plus how much you needed to pay out to affiliates. Basically, all of the prices of jogging the affiliate channel.

Since the paid marketing channel records should be overwhelming, I continually make a 2d tab that simply appears at the KPI dashboard. This tab will have a look at year-over-year performance for the present-day month. This tab quick lets your bosses see how you’re doing 12 months-over-year compared to the entire enterprise. You ought to upload a phase under that provides why performance is up or down. This comes all the way down to how unique your bosses want to get.


Figuring out what your business enterprise’s North Star is essential. What is the one quantity all and sundry on your business enterprise rallies behind? Make sure you’re looking at the identical information as your bosses. Assemble the spreadsheet above and help make sure everybody is on an equal page. One final be aware, you may want to do a month-to-month electronic mail out to the advertising crew. That ought to provide an explanation for in greater detail what is going on behind the numbers. You can also say what your plans are for the subsequent month. Never be afraid to overshare your job and feature facts freely flowing from your department to the corporation.

About author

Digital marketing is the process of gaining customers through online activities. It involves search engine optimization, paid ads, social media marketing, email marketing, and website design. As a blogger, I write about SEO, paid ads, and other digital marketing issues. I have worked in the digital marketing industry since 2010. You can find out more about me by visiting my website, www.bloggerse.com.
    Related posts

    Learn the Basics of Pay-Per-Click Advertising and Boost Your Business


    How to Optimize Your PPC Campaigns for Maximum Revenue


    How To Use Amazon PPC Keyword Research


    Make Money With Pay Per Click 

    Sign up for our Newsletter and
    stay informed