An Example AdWords Report Template for Agencies

Twitter Facebook Linkedin Email
A common question asked by digital marketing agencies is what should be included in a client’s AdWords report?
Your agency probably creates and manages AdWords campaigns for a variety of clients. Your activities may involve keyword selection, bidding strategies, ad creation, conversion tracking, and optimization. If its an E-commerce client, maybe you even manage to a target return on ad spend (ROAS).
You cannot really communicate detailed metrics on all the activities that you perform for a typical AdWords client. The client would be overwhelmed by detail! Instead, you need to focus on a few key performance indicators (KPIs) that provide your client with the information they need in order to make good business decisions.
Of course, the primary rule of reporting is to develop KPIs that are customized to each client’s business. For AdWords reporting, that means you need to provide big picture numbers like total leads, clicks, conversions, spend, etc. But, you also need to drill down, so the client can see data at the campaign, ad group, ad, and keyword level. While the big picture numbers tell your client if their goals are being met, the details help with allocation decisions like moving spend from display to search ads or eliminating poorly performing ad copy.
Creating such a report from scratch for each client can be a time-consuming and intimidating task. Fortunately, Megalytic provides a simple interface for creating AdWords report templates. Creating an AdWords report template provides your agency with a starting point for future reports. For each new client, you can begin with the template, and customize it to create an AdWords report meeting the specific needs of that client.
Whether or not you decide to use Megalytic for reporting, here are some important ideas to consider when creating an AdWords report template for your agency.

 

Example AdWordsReport Template

 

Start Off with KPIs

Begin your report with KPIs (key performance indicators) that summarize the performance of the client’s AdWords account at a glance. In Megalytic, the AdWords Multi-KPI Widget enables you to display up to four metrics across the top and compare performance with previous time periods. Clients like to have the date comparisons so they can measure month-over-month and year-over-year performance.

 

AdWords KPIs

 

This example shows the client’s metrics for January 2018 compared with last month (December 2017) and a year ago (January 2017). Here you can see that conversions are up 38.75% from last month (111 vs 90) and 6.73% vs year-ago (111 vs 104). However, the cost per conversion has gone up a lot and the number of clicks has gone way down.

[BTW: If you want to follow along and create a report like this for a client or prospective client, they will first need to share their AdWords access with your agency.]

Widgets like these are highly customizable, so you can tailor the presentation of data to meet the specific needs of your agency. For a quick summary of how to do these customizations and save the results to a template, watch this video.

Use Notes to Provide Explanations

It’s a good idea to meet with your client each month to review the performance of their AdWords account, and this report should be delivered prior to the meeting. To help your client understand the trends and strategy behind the numbers being reported, you can include text annotations in your report. Megalytic provides the Notes Widget for this purpose. Here is a note being used to explain the KPI widget example above.

 

Megalytic Notes Widget for Annotating a Report

 

KPIs for Campaign Level Data

In addition to account level KPIs, your client may also want to see KPIs at the campaign level. To do this, you can use the same Multi-KPI widget, but with a specific campaign selected.

Here, the campaign “Search – Facebook/Social Reporting” has been selected from within the widget editor. The metrics displayed (e.g., Clicks, Avg. CPC, Conversions, Cost / conv.) now reflect the performance of this single campaign.

 

AdWords KPIs for a Single Campaign

 

KPI Trends

For some KPIs, your client may also want to see trends. Cost (i.e Spend) and Cost/conv. are typical examples of metrics where it is helpful to see how the values are moving over time. For this purpose, Megalytic provides single KPI widgets that provide a view of a single metric, along with date comparisons and a sparkline chart.

For this client, these two KPIs show a Cost that has been relatively flat over the last 12 months (but with a spike this January), and a Cost / conv. that jumped up mid-year. The increasing Cost/conv. reflects additional competition entering the marketplace mid-year.

 

KPIs with Trend Chart (Sparkline)

 

KPIs for All Campaigns

Rounding out the KPI section of your report, many clients like to see a summary of the KPIs for all the campaigns. In this type of table, you may also want to include a column showing the Status (i.e., Enabled, Paused, Stopped) for each campaign, so the client can tell which ones are currently running.

This type of table does not include any time period comparisons, but instead shows a variety of important metrics (e.g., Clicks, Cost, Impressions, CTR, Avg. CPC, Conversions, Cost/conv.). At a glance, your client can tell which campaigns are performing the best and which might need further optimization.

 

AdWords Campaign KPIs with Status

 

Some clients might also like to see KPI performance by Campaign over time – like the last 12 months. As shown below, you can add a time-series chart to your report template and select the campaigns that you would like to display. You can also select the metric (in this case Clicks).

 

AdWords Campaigns Over the Last 12 Months

 

Top Performing Keywords

Clients also usually like to examine the performance of the keywords you are bidding on – particularly the top performing keywords. With Megalytic, you can easily create a table showing the top keywords sorted by Clicks (or whatever metric you like).

Along with Clicks, its a good idea to provide a selection of other important metrics. Here, we have selected Avg. CPC, Quality Score, All conv. (conversions), Cost / conv., and Search Impr. share. Notice that the Keyword column also includes (optionally) the Campaign and Ad Group information.

 

Top AdWords Keywords

 

Here we have defined “Top Keywords” in terms of Clicks. So these are the keywords sending the most traffic to our landing pages. But, depending on your client’s goals, you might want to focus on another metric to define the top keywords. Cost/conv. is a popular choice (with lower being better). In Megalytic, you can tweak this table to make Cost/conv. the first column, and sort on it.

Month over Month Comparison for Keywords

In addition to reporting keyword performance during the previous month, you should also show your clients how this month’s results compare with last month. For example, this table shows where spending has increased/decreased, by keyword, since last month.

 

Keyword Spend Month over Month

 

Notice that in this table we have removed the Campaign and Ad Group information. Some clients will prefer this, less cluttered, look. Others will like the additional information.

Search vs Display Networks

If you are doing both Search and Display Network advertising for your client, it makes sense to provide a summary of where the traffic is coming from. Here, we show the monthly trend in Clicks from Search vs Display. You can see that we started out investing more heavily in Display, but over time have shifted focus to the Search Network.

 

Traffic from Search vs Display

 

Here, we are showing the Search and Display Networks, but you should include all those where your Client is advertising, such as YouTube Videos or Search Partners.

AdWords Performance by Device

Lastly, you should include some data showing the relative performance of your client’s ads across devices. While mobile grabs an increasing share of overall traffic, that doesn’t necessarily mean that mobile is the most important device category for your client’s ads. That’s going to depend on your client’s product and how the client’s customers like to engage.

 

AdWords Performance by Device

 

This table shows performance across a set of key metrics. You’ll notice that while Computers are generating the most Clicks, they have a lower CTR and a much higher Cost / conv. In this case, it is worth a discussion with the client about whether they would like to shift spending to mobile.

Finalizing and Saving Your Template

Continue adding widgets until you have communicated the important information. Make sure to include statistics showing both the big picture perspective and the important details your client cares about. You will need to use your judgement to decide how many widgets to include. Some clients love tons of data, and others just want to see a few KPIs.

Since you are creating a template, it is probably best to err on the side of too much data. You can always delete widgets from reports for individual clients. That way, the clients that crave data can get the full picture, for and those that want a short summary you can remove a lot of the detail.

Once you are satisfied with the widgets, save your template for future use. To do this, simply click the “Save as Template” button right above your report in Megalytic.

 

Save Megalytic Report As Template

 

Give your report a name, a description (optional), save it, and you’re ready to access it whenever you build your next AdWords report.

To use an existing template, create a new report and select the My Templates tab. You’ll then see a list of your custom-built templates where you can choose the one you wish to use. The one we just created is shown here as “My AdWords Template”.

 

Create a Report from a Megalytic Template

 

After you select the template, the next step is to choose the AdWords account for generating the report. Megalytic will show you all the AdWords account you have connected. Pick one, and the template will be populated with data from that account to create the report.

 

Select AdWords Account

 

Once you’ve created a report with a template, you can modify the date range, edit widgets, and includes notes as needed for your client.

Conclusion

Building a template for your agency’s AdWords report will jumpstart reporting for all your AdWords clients. The template you create provides a starting point for building individualized reports for each client by automating all the repetitive work. While you should not rely solely on the same template for every client, save time by creating a template with stats that you know you will need, and move forward to customize the report to communicate the most important information to each individual client.

Subscribe to us

Leave a Reply