Implementing Megalytic for Client Reporting: A Case Study with Digital Agency SEO Exposed

Published October 13, 2015
Client reporting – it’s the great time-suck that nobody seems to plan for. We know report time is coming, it always comes, but there we are at the end of each month, scrambling to get the reports done before all the important client meetings.
Stop us when the scene begins to sound familiar…
Analytics staff are copying and pasting from Google Analytics, AdWords, and other tools directly into Excel or PowerPoint. Project managers are reviewing the work, asking for additional data, and writing up summaries to highlight KPIs and explain the meaning of the data to clients. Meanwhile, lots of other work needed attention and other deadlines were looming... now they’re missed. Its chaos and it’s engulfing the agency.
SEO Exposed, a rapidly-growing Cincinnati-based agency, was facing this exact problem. Reporting was taking up too much time from too many people, and it needed to automate reporting so staff could get back to doing client work. The agency selected Megalytic, and according to Chief Operating Officer (COO), Richard Walker, “The impact has been huge. Megalytic helps the agency be much more efficient so we can focus on execution for clients.”


SEO Exposed Case Study


A Data Driven Agency

SEO Exposed is a growing agency serving B2C and B2B companies in the areas of search engine optimization (SEO), paid search marketing, and email marketing. The agency’s clients are a mix of SMBs and large, national brands.

For an agency like SEO Exposed, web analytics provides the foundation for the strategies developed and executed for clients. Everything it does for clients is backed by data. It is only natural, then, that reporting is a very important component of the agency/client relationship.

Every month SEO Exposed prepares an analytics report for each of its clients. Reports are also created for special occasions, like an important website review meeting. That’s a lot of reports, and it was a lot of time spent creating reports. Time the agency didn’t have.

Reporting Problems - Before Megalytic

In early 2015 SEO Exposed did a Survey Monkey sent to all of their clients to better understand how clients actually felt about their service and their reporting. They were shocked at the responses. Their clients gave a very favorable review of their service and their product, but almost every client specifically noted that they were eager to work with SEO Exposed to enhance reporting and tailor it to their specific needs. Some clients wanted more detail in their reports and some wanted their reports to be simplified.

SEO Exposed immediately realized that there was a great opportunity to provide additional value to their customers through enhanced reporting. The agency feels that reporting is crucial to strong communication with clients and helping them understand what you are working on as an agency and how their campaign is performing. So, they felt that their existing reporting communication had to be improved in order to better serve their client’s needs. That is why they made the shift to Megalytic in a big way, and since then they have received very favorable feedback from clients about their reporting.

Before implementing Megalytic, reporting was very labor-intensive. Staff members would export data from both Google Analytics and AdWords, and then import into Excel or PowerPoint. Sometimes, staff would copy and paste charts and graphs directly from the Google tools into the reports. But, much of the time, they needed to work with the raw data exports, and massage these to produce the metrics and KPIs needed to analyze how well each client’s strategy was performing.

It involved a lot of Excel work, summarizing data, creating pivot tables, grouping on different dimensions. And once the data was processed, charts needed to be created. 7-8 people, including project manager, were often involved, working late into the night to prepare the necessary reports before a client meeting.

The reporting burden was putting a big strain on the company and it pulled people away from executing on client strategies. The agency couldn’t afford for this to keep happening. The company was growing, so people were busy already, and the added burden of reporting was just too much. What they needed was a solution that automated reporting and made the process easier. If it could also improve the quality of their reports, that would be a bonus.

Linda Walters, the Operations Manager, was tasked with finding a tool to help the agency do just that. Linda looked at a variety of products (e.g., Raventools, Automatic Emails through Google Analytics), and, ultimately, recommended Megalytic because it was both easy to use and very powerful. Specifically, Linda found that Megalytic checked all the boxes they were looking for:

  • Megalytic was easy to use.
  • Reports were easy to customize to individual client needs.
  • Megalytic provided report templates and let you create your own templates.
  • Reports looked great whether printed in PDF format or viewed online.
  • Clients could easily understand the reports.

The company decided to follow Linda’s advice and started moving monthly reporting over to Megalytic.

Reporting After Megalytic

After implementing Megalytic, SEO Exposed found it could create reports in a fraction of the time previously required. As described by COO Richard Walker, “There was a huge impact in time savings. Megalytic got us out of the weeds where we were struggling with reports, and put us back in client-focused execution mode”.

Report Templates

SEO Exposed creates reports according to a standard pattern. KPIs go on top with the detailed data further down in the report. There are sections for various types of data – traffic trends in one place, and conversions in another. Furthermore, some clients require data that others do not (e.g., AdWords).

With Megalytic’s templating features, the company has been able to define a few standard report layouts. This has created a starting point for each client report that has come after! When a new client comes onboard, the agency picks the closest template to what is needed, uses that to generate the report, and then modifies that report as needed to meet the client’s precise needs. No more starting from scratch every time a report is due.

Being able to use templates to get a jumpstart on each new report has been a huge time saver. The company not only has created its own templates for different styles of reports, but also for monthly, weekly, and quarterly versions of reports.

Report Scheduling

A majority of SEO Exposed’s reports also take advantage of Megalytic’s scheduling features. Using scheduling, a report can be set up to be automatically delivered to the client on a monthly, weekly, or even daily basis. SEO Exposed has created distribution lists for each report, so that it is delivered to all the people who need to see it.

Typically, a distribution list includes one recipient at the client, along with a project manager at SEO Exposed. By including internal staff on the distribution list, the company ensures that it is always on the same page as the client in terms of seeing the latest data; and can be prepared to answer questions and discuss opportunities whenever the client is ready.

Even Better: Clients Love the New Reports

Clients have reacted favorably to the new Megalytic-generated reports. The reports are perceived as insightful, easy to understand, and high quality. If fact, the clients often distribute the reports internally, using them as a go-to source of data at internal meetings.

Megalytic is privileged to work with great customers like SEO Exposed. The agency’s embrace of reporting and deep understanding of the role it plays in managing client relationships has helped us further develop our vision for the product. We are inspired by their rapid growth and hope to be partners in their success for a long time to come.

Ready to see how Megalytic can help your digital agency reporting? Sign up for a free 30-day trial!


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.