Creating Custom Google Analytics Reports for Clients

Published November 7, 2014
Your client relies on data to see how their website and marketing campaigns are performing. In theory, they could log in to Google Analytics to gather this information themselves but they don’t really know how to use it and they are too busy to learn. Also, that’s why they keep you around, to help them understand.
So, how can you, their expert, present them the right data?
You could export some of the standard Google Analytics reports and email them over. But, from your client’s perspective, the standard Google Analytics reports don’t provide much insight. They don’t look at the right metrics, explain what those metrics mean, or focus on the most important goals of their business.
As a marketer, we want to do right by our clients. That means moving beyond generic Google Analytics screenshots and, instead, giving our clients customized analytics reports to show the right data and tell the right story.
In this post, we show you how to use Megalytic to build a custom report that puts the right data in front of your client and tells a story that relates the information to their business.

megalytic chart showing trial accounts by campaign


A Case Study – Comparing Two Campaigns

Suppose your client just switched campaigns and they want a report comparing the before and after performance. This report will help them gauge early success of the new campaign, and see if it’s more or less profitable than the earlier campaign. Start off with a simple chart that shows the traffic generated by the two campaigns.

megalytic chart showing weekly sessions by campaign

The new campaign is named “Search – General” and it has been running for three weeks. You can see from the chart above we have six weeks’ worth of data for the two campaigns – the last three of the old campaign (in blue), which is named “Best with Keyword Insertion” – and three weeks from the new campaign (in red).

This chart shows Sessions (or visits to the website) from new users, and it looks like the new campaign is generating more than twice as much traffic as the old campaign. Presenting this data is a good start. But remember, clients want data specific to their needs. So, we should go beyond showing just the traffic and compare these campaigns to see how well they are delivering on specific business objectives.

If you’d like to work along with this post and create a similar report using your own data, you can create a free 14-day trial Megalytic account. After each section in this case study, there is a short video tutorial showing how to use Megalytic to create the report element just described.

Video Tutorial
Learn how to compare Sessions from two campaigns

[youtube id=uQrH2liSuhk]


Comparing Lead Generation from the Two Campaigns

In this case, the client’s objective for these campaigns is lead generation. In their Google Analytics account, qualified leads are measured by Goal Completions. Specifically, the client has set up a Google Analytics Goal to measure when new trial accounts are created. To help them compare the effectiveness of these campaigns, we should provide a similar chart that measures the number of trial accounts produced by each campaign.

Megalytic chart comparing the Goal Completions from two campaigns

Again, the new campaign looks pretty good – it is generating twice the number of trial accounts as the old campaign.

This chart can easily be created by duplicating the previous chart and changing the metric being displayed from Sessions to Goal Completions. To see how that is done, watch this video.


Video Tutorial
Learn how to compare Goal Completions from two campaigns

[youtube id="ex7y0Wi0HRs"]


Adding a Summary Table to Compare Key Metrics

The two charts just created show campaign performance over time. To give your client the full picture, you should also include a summary table that shows some key metrics over the entire six week period.

Some reasonable metrics for looking at the performance of these campaigns are:

Sessions - to indicate the total number of visits generated by each campaign.
Bounce Rate - to measure the engagement level of the visitors coming from the campaigns.
Goal Completions - to show the total number of trial accounts created by each campaign.
Conversion Rate - to measure the effectiveness of each campaign in delivering traffic that converts to trial accounts.


Megalytic table comparing summary metrics from multiple campaigns


From this table, the client can quickly and easily compare the campaigns across key metrics. The new campaign is bringing in a more engaged audience – as you can tell by the significantly lower bounce rate. Although the conversion rates are roughly the same, because the new campaign is generating a higher volume of traffic, it ends up generating more than double the number of trial accounts.

In Megalytic, this table can be created simply by changing the display type of the Weekly Trial Accounts by Campaign chart (above), from a bar chart to a table. Watch the video to learn how.


Video Tutorial
Learn how to create a summary table that compares metrics from multiple campaigns.

[youtube id="JdaRg6sjjE8"]


At this point, there is still one key piece of information the client needs to completely evaluate the performance of these campaigns – the cost.

Comparing the Cost Effectiveness of the Campaigns

Since these are both AdWords campaigns, the cost information for each is available in AdWords and in the client’s linked Google Analytics account. As a result, you can use Megalytic to create a table that compares the performance relative to cost of these two campaigns. This table will include these metrics:

AdWords Clicks - to measure the number of clicks generated by each campaign. This should roughly correspond to the Sessions, but will be a bit lower, since Sessions counts repeat visits. If a user clicks on an ad, and then comes back the next day via a direct visit, then Google Analytics will count two sessions but only one AdWords click.
AdWords Cost - the total cost of each campaign.
Goal Completions - this is the number of trial accounts created, as measured by Google Analytics Goal Completions.
AdWords Cost per Goal Completion - the cost efficiency of the campaign, showing the average spend required for each trial account.


Megalytic table comparing costs from two AdWords campaigns


The key metric in this table is the AdWords Cost per Trial Account. The client’s goal is generating trial accounts, so they want to know the cost per trial account for running each campaign. Here, we can see that the new campaign (“Search – General”) costs slightly more than the old campaign (“Best with Keyword Insertion”).

Which campaign should the client prefer? Probably, the new one. Although it costs a little bit more to run, the “Search – General” campaign produces more than double the number of trial accounts. To answer this question definitively, we need to know the value of a trial account. Hopefully, the value significantly exceeds the cost for each campaign. In that case, the client makes more money running the new campaign because of its increased volume.

Creating this table in Megalytic makes use of one of the AdWords widgets. Watch the video to learn how.


Video Tutorial
Learn how to create a summary table that compares cost metrics from multiple AdWords campaigns.

[youtube id="5Yys45MeocY"]


Include Comments and a Cover Page

Once your report shows the right data for your client, add comments and a cover page to produce a truly professional result.

Comments, in particular, help the reader to interpret the data in your report. Not everyone immediately grasps the message conveyed by a chart or table. Text provides context, drives home the key insights and helps tell a story.

The cover page can be used to provide a short summary of what is contained in the report, the key conclusions and any recommendations. For this report, a cover page could contain text like this:

As the company has recently switched campaigns, this report compares the performance to determine which campaign is working better. It looks at the last six weeks, comparing three weeks of the new campaign with three weeks of the old campaign.


As you can see, the new campaign produces more traffic and more trial accounts. However, it costs slightly more per trial account produced.


We recommend sticking with the new campaign since the value of a trial account is still much higher than the average cost per trial account ($38.55) and the volume of trial accounts generated per week has more than doubled.

It is also a good idea to include comments either below or above any charts and tables in your report. This helps your client to understand the message behind each graphic and to move through the story the data is telling.

For example, beneath the first chart in this report (Weekly Sessions by Campaign), the following text helps your client to understand the context for the rest of the report, as well as grasp the key insight from the chart.

This chart looks at two campaigns over the last six weeks. The old campaign (“Best with Keyword Insertion”) ran during the last week of September and first two weeks of October. The new campaign (“Search – General”) replaced it and ran during the last two weeks of October and the week of November. As you can see, the new campaign has more than doubled the traffic to the website compared with the old campaign.

Here is how the comment looks with the chart positioned above it.

Megalytic chart with a comment underneath

Megalytic includes features that make it easy to add a cover page and comments to your report. Watch this video to learn how.


Video Tutorial
Learn how to add comments and a cover page to your report.

[youtube id="IpWiur1Wy68"]


The Completed Report

The completed report can be downloaded from Megalytic as a PDF file. You can also share the report using a link to a web page.

Here is the PDF version of the report created in this blog post.


As marketers, we all want to do right by our clients. That means taking the time to understand our client’s business concerns, and then building customized analytics reports to specifically address them – answering both the questions they have asked and the questions you know they should have asked. Once you know what data you want to present, a reporting tool like Megalytic can help you tell that story in an attractive and easy-to-understand way. In doing so, you’ll not only help your client to succeed by reporting on the right metrics, but you’ll establish yourself as a partner in their business.


When the client first came to you, you talked up the value of Google Analytics. You emphasized the importance of seeing where your traffic was coming from. You went on and on about how Google Analytics can show traffic sources to pinpoint whether people came from search, social media or a specific site referral, and how valuable this data was. You sold them on it, so much so that your client looked forward to receiving that first report, the magical day when they would finally understand where visitors were coming from.
But then the report came, and it looked like this:



It showed that 10% of your client’s traffic came from “(direct)/(none)”. What does this label mean? How do you explain Direct traffic to your client? Better yet, how do you explain “none”?
Let’s take a closer look at understanding Direct traffic in Google Analytics and how we can address it with clients.
Digital marketers spend a lot of time focused on PPC and SEO campaigns in order to drive desirable traffic to a website. The phrases we’re ranking for and bidding on get meticulous attention, so much so that we often forget about some of the other ways that visitors find us.

We put a tremendous amount of the effort we put into reviewing organic search data and PPC campaign performance in analytics. But how closely do we monitor referral reports?

If that’s not a channel you review regularly, you may be missing out on seeing traffic that is coming directly from links you’ve obtained around the web, local business listings, news mentions, and more. Many times, links are only considered as a means to an end, a metric that Google uses in determining how to rank sites in the SERPs (search engine results pages). But the fact is, many of a site’s links may be directly contributing to its traffic.

In this article, we’ll review how to look at referral reports in Google Analytics, and some of the many ways to use that data to better inform your web marketing decisions.


Remember how your mom told you not to stand too close to the television because it might hurt your eyes?

The same rules can apply to data. If you’re too close, you may miss the patterns and trends that are crucial to understanding your website’s performance. You can’t judge a site’s performance looking at data in the bubble of a single day, you must consider any day’s traffic compared to the days before and after.

Google Analytics makes it fairly easy to analyze trends over long periods of time. But it also allows you to stand right in front of that TV, to look at more granular levels of time, right down to the hour.
There’s a better way to get that close to the data, without burning your retinas. We’ll cover how to analyze traffic effectively in today’s post.