Customizing Megalytic: AdWords Campaigns Widget

Published October 15, 2015
By now you’ve heard the news – Megalytic now integrates with AdWords!
With this integration, we’ve given PPC advertisers a better way to showcase campaign results to clients in a highly customizable and easily readable format. Megalytic’s new AdWords widgets pull in precise data from your campaigns, allowing you to include stats for clicks, impressions, costs, conversions, and more. You can then show this information in bar graphs, line charts, or tables, depending on how you want to portray data for your clients – giving you total control and flexibility.
We’ve already received some great feedback about this new integration. Today, we wanted to give you a closer look at how you can customize one of our key AdWords report widgets – The AdWords Campaign widget.


Megalytics AdWords Widget - Comparing Costs


Using the AdWords Campaign Widget

The AdWords Campaigns widget allows you to break down performance by campaign, selecting the metrics most important for your report, shown in the chart format you desire. When you add this widget to a report, you’ll first be asked to select an AdWords account to use, or to connect one if not already connected with your Megalytic account.

Once you’ve chosen your desired AdWords account, you’ll see the widget displaying a table format with four default metrics: Clicks, Impressions, CTR (clickthrough rate), and Avg. CPC (cost per click).


Megalytic AdWords Widget Default


Customizing the Table View

Before use, you’ll likely want to tweak the widget further to display additional metrics or to show data in a different format. First, let’s examine a few ways to customize the default table format. Click the gear in the upper left to see the widget options.

Perhaps you want to break down data by ad group or keyword instead of by campaign. You can do so by selecting the “Dimension” dropdown within the widget options, choosing from Campaign, Ad Group, Ad, Keyword, or Account.


Megalytic Selecting AdWords Dimension in the Widget


In this example, we’ve chosen to show data by Keyword, so you can see how the final report updates to include keywords from the AdWords account. If you’d like to filter data to keywords from a particular campaign or ad group, use the respective dropdowns that now appear under the Dimension dropdown. You could even create multiple widgets, each showing keywords from a different campaign.

You may want to show more than ten keywords in your table. You can do so using the “Number of Rows” dropdown, adding up to 300 rows. The opportunity to display anywhere from 10 to 300 rows makes this widget useful both for high level performance reports and in-depth analysis. Your CEO can see the top ten keywords, while your marketing team can see a breakdown of hundreds of keywords to closely assess which ones were most effective.

Changing Table Columns


Megalytic AdWords Widget - Customizing the Table


If you want to change the table columns from the default options, use the “Columns” section at the bottom of the widget options. Choose your desired column(s) from the dropdown and click “Apply Section” to add to the report. You can also click and drag the current columns listed below the dropdown to rearrange their order (be sure to click the stack of three lines on the left to move any of these).

For instance, you’ll likely want to show conversion results in your report. To add a Converted Clicks column, find that metric in the Columns dropdown and select it to add. Once you’ve chosen “Apply to Selection,” you can move that metric to the top of the list to make it the first column. Note that Megalytic will sort data by the first column of any widget.


Megalytic AdWords Widget - Adding a Conversions Column


Using a Line Chart to Show Trends

To show trends in your AdWords account over time, use a line chart to demonstrate how metrics have gone up or down. Choose your chart type from the icons at the top of the widget options (Line Chart is first in the list). Next, you can customize the Dimension (Campaign, Ad Group, etc.) and Metric (Clicks, Impressions, etc.) you’d like to show in the chart.

In this example, we’re choosing to show clicks by ad group over the past 13 weeks. The final chart provides a quick snapshot of how these three ad groups compare in click volume, as well as when clicks have gone up or down for each, providing a window into how interest has varied over time for different sets of keywords.


Megalytic AdWords Widget - Using Line Chart for Trends


You can also select the specific ad groups (or whatever dimension you’re using in the chart) using the Series dropdown, which appears at the bottom of the widget options. This replaces the Columns dropdown previously shown.

Comparing Cost Per Click Over Time

The Time Series Bar Chart offers a handy way to compare how cost per click averages have changed over time, looking at specific cost figures for each campaign. Choose the third icon in the row of chart types to create this chart.

Note that this chart format also allows you to select one Dimension and one Metric to show. Checking the “Display Values on Bars” box will toggle showing the specific numbers for each bar in the graph (in this case, dollar amounts for CPC). Once again, you can also select your dimensions using the Series dropdown at the bottom of the widget options.


Megalytics AdWords Widget - Comparing Costs


In this case, we’re comparing weekly average CPC for our three main campaigns over the past four weeks. This way, we can quickly and easily show our client how these costs have changed over time, separating by different formats of online advertising with different styles of bids.

If you want to change labels on the line chart, you can do so easily. For instance, you may want to clarify to your client that CPC stand for Cost Per Click. Selecting the Axis dropdown, you can customize the text for the X (horizontal) or Y (vertical) axis. In this case, we’ve updated the Y axis label to read Average Cost Per Click.

Comparing Date Ranges

If you’d like to compare data between two date ranges, the Table Graph widget offers a straightforward method to show this information. First, we’ll select the Table Graph icon from the widget options (last in the row of chart types) and choose to compare clicks by campaign. We’ll set the date range to the past four weeks, comparing to the previous period.

[screenshot: comparing-date-ranges]

Now, we can see graphs and numbers comparing clicks by campaign for each timeframe. This data shows that total clicks remained roughly the same, with the “Display” campaign increasing and the “Remarketing” campaign decreasing (hint: add a Notes widget to point out stats like these in your report!).


The AdWords Campaigns widget offers endless possibilities to show results from your PPC efforts. Breaking down data by campaign, ad group, or keywords, you can select just the right type of chart to portray your desired data to help you tell the right story. Start making better AdWords reports by customizing Megalytic widgets to show the data that matters for your clients!


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.