Megalytic for Client Reporting – A Case Study with Digital Agency drumBEAT Marketing

Published January 29, 2015
When you work for a digital marketing agency, your clients want data. Or more accurately, they expect data. They expect it in the form of reports that show:
  • how well campaigns are doing, and how they can be improved;
  • the cost effectiveness of the search advertising;
  • the demographics of their website visitors, and how well social media is doing at bringing the desired demographic to the website;
  • etc, etc., …
And if you work for an agency, you already know this. You know client reporting has become a key service because you’re the person responsible for handling that reporting. Now, you must not only be a master of doing the work, you need to be able to show your results and the value the agency is providing.
Building better reports, faster is one reason many agencies have selected Megalytic as their client reporting solution. In this blog post, we look at one such agency – drumBEAT Marketing from Houston, TX – to understand the role client reporting plays in its business and how it uses Megalytic to better serve clients.


Tracking YouTube's Impact using Google Analytics

Published January 28, 2015
This we know: Online video consumption is growing. We also know that online video offers businesses and marketers a powerful way to promote their brand, connect with their audience, drive traffic and get their message (or products) out in a memorable way.
And like a good marketer, you’ve taken notice!
You’ve created a YouTube brand channel, you’re showcasing your products and you’re engaging with your audience in front of the camera. Even better – as you continue to create videos, more and more people are watching and sharing them.
But, how can you determine the value that these videos and these users are providing to your business?
Google Analytics offers multiple reports to see how many users are coming to your site via YouTube, where they’re going, how well they’re engaging and how many are converting.
In this post, we’ll take a look at a few ways to analyze YouTube traffic. Our example brand, a site promoting healthy living and eating, uses videos to demonstrate recipe preparation, review organic products and showcase promotional appearances by the site owner.


How to Filter Out Fake Referrals and Other Google Analytics Spam

Published January 23, 2015
If you work with Google Analytics, chances are you’ve run into some of these websites in your Referrals report (Acquisition > All Traffic > Referrals) lately:
What are these sites and why are they linking to your site? Well, actually, they’re not linking to you at all. These sites represent fake referrals. They are created in your Google Analytics account to trick you into visiting spammy websites. If you open one of these URLs in your browser, you will likely be redirected to an online store, marketing scam or malware site. Nice, right?
Welcome to the world of Google Analytics spam, where spammers mess with your Google Analytics data to drive traffic to shady websites!
In this post, we look at the impact these spam sites have on your metrics as well as steps you can take to eliminate the spam from Google Analytics. If you are looking for ways to filter this spam out of your Megalytic reports, see: Removing Semalt and other Referer-Spam from Megalytic Reports.


Creating an Online Marketing Report Template for In-House Marketers

Published January 21, 2015
It’s a simple truth: in-house online marketers face different challenges than agency marketers. Working in-house requires producing reports for the people whom you work directly with each day. Your colleagues are coming to you with different money metrics, and you need to show how current marketing is hitting (or not hitting) their goals.
In-house marketers are also often required to wear many hats, especially in small businesses, balancing reporting duties with other tasks like writing content for the website, sending email campaigns and managing other search engine optimization efforts. You need to be able to able to update your team on the success of the website and digital marketing campaigns, as well as customize the information for them. And it needs to be done quickly because you have other things to do!
Let’s step into the shoes of a marketing professional working for a small, local college. She’s responsible for preparing a monthly analytics report for the college’s executive team.
The leaders of this school have multiple concerns to address. Obviously, they want to see that potential students are showing interest in attending the school. But they also want to see engagement around the new bachelor’s programs recently added to the school’s offerings, as well as how the website is helping to encourage people to sign up to visit the campus.
To start her report, our marketing friend wants to provide enough data to answer the questions she knows her colleagues will inevitably have about website performance, without overwhelming them and sending them running for the hills. She’ll start by creating a new report in Megalytic and proceeding to add widgets that present data to address the school leaders’ specific concerns.


Custom Analytics Reports – How to Present the Right Data to your Client

Published January 16, 2015
For digital marketing agencies, custom reporting has become a fact of life. Clients expect data and they expect reports. But, that doesn’t mean they necessarily know what they want to see included in those reports, or even what information would be most helpful to see. And you may not immediately know either. Even as an analytics expert, it can take time and relationship building to truly understand the client’s business priorities and what’s most important to show them.
But you don’t always have time. You’ve been tasked with creating the client’s monthly analytics report today – now what? What do you include?
Luckily, there are a few rules of thumb to help guide you.
  • Use historical context
  • Include text to describe the data
  • Drill down on high level stats
  • Understand, define and report on Goals
This post breaks out how to apply the items above to create a custom analytics report for a client.


Google Analytics Checkup for the New Year

Published January 14, 2015
It happened.
Another New Year has rolled around. While you’re still making good on your resolutions and promising to be better, faster and stronger than last year, don’t forget to take some time to assess your analytics account. Look at how your site performed over the last 12 months. Flag problems with engagement or conversions. Understand how users are accessing and browsing your site. And then use this information to guide potential decisions to revise the site for the coming year.
Where should you begin?


How to Create Report Templates In Megalytic

Published January 9, 2015
You need to get a report out for your boss or client, quickly. You already know exactly what needs to be included – twelve or so charts and tables showing traffic, new accounts, Ecommerce and revenue, plus comparisons with last month. You’ve done this before.
But pulling the data out of Google Analytics takes up so much time. You need to open each report, set up the date ranges, copy and paste charts, export the data for tables, etc. Then, you need to format everything in Microsoft Word to make it look professional and readable to a normal human.
Don’t you wish all this work could be automated – saving you hours of precious time? Wouldn’t it be nice if you could set up a report template and just press a button to load the right data?
Well, with Megalytic you can.
Megalytic allows you to create a report once, and then save it as a template. Then, when you need to create the same report again, whether for the same site or a different one, all it takes is a few clicks. Headache gone.
This post looks at when to use templates and how to create them to automate your Google Analytics reporting.



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.


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.
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.