Monthly Archives: April 2015

Using Regular Expressions in Google Analytics

The more time you spend managing a Google Analytics account, the more you’ll wish you could do… well, more. The default Google Analytics reports don’t give you the level of control you need to get the information you want – you need to look at the data on a more granular level. For example, you may find the standard search bar limiting in filtering data when trying to show a specific list of sources or keywords. Regular expressions are a powerful filtering tool and give you a higher level of control over the data you see in your Google Analytics reports.
A regular expression (sometimes shortened to regex) is a string of characters used to create a search pattern. It’s similar to a wildcard – helping you to be more purposeful in your filtering. But, rather than just having a single wildcard character, regex provides a variety of special characters that can be assembled into filters.
Here are some of the special characters used in regular expressions:
^ A caret signifies the start of a line. For example, filtering search terms by ^megalytic would match any instances where megalytic was the first word in the search term.
$ A dollar sign signifies the end of the line. For example, filtering search terms by megalytic$ would match any instances where megalytic was the last word in the search term.
| A vertical pipe essentially means “or.” For example, filtering sources by google|bing would match instances of either google or bing.
. A dot matches any single character except for a line break. For example, filtering by megal.tic would match instances of either megalytic or a misspelling like megalitic.
\ A backslash “escapes” the character following it. For example, when entering a URL, should you place a backslash in front of the period, it would ensure it’s treated not as a wildcard but as part of the text string, as in megalytic\.com.
* A star matches zero or more of the previous character. For example, megalyt*ic would match megalytic, megalyttic, or megalytttttttic.


Blog Image - Regular Expression


Read more

Building a Quarterly SEO Report Template with Megalytic

As analysts, we are often asked by marketing teams or clients to put together a Quarterly Report. This report may be in addition to monthly reports, or it may replace the monthly one four times each year. In either case, you may be left wondering what to include.
You are probably thinking that a Quarterly Report is a little different than what you provide your on a monthly basis – and that’s true. Quarterly Reports often need to provide more detail. They are designed to step back, take stock and give readers a broad perspective on the highlights of the quarter – comparing performance with previous ones.
You can use Megalytic to produce these reports that are longer than their monthly counterparts and dive deeper into the metrics. For example, you may look at the results of multiple campaigns that happened during the past three months. You may also want to include boilerplate – like definitions of terms for those who are not expert in Analytics terminology.
Let’s have a look at some of the techniques you can use to build out a Quarterly Report in Megalytic.

Blog Image - Quarters

Read more

Megalytic Upgrade – April 2015

We’ve upgraded Megalytic with improvements for report formatting, user interface, and scalability. Megalytic has now been stress-tested and proven reliable for organizations with dozens of user producing hundreds of reports each month.
New features include:

  • Robust Headers and Footers – Customize and upgrade the look of your reports. Create headers and footers using text and images –details here.
  • Use Text and Images in Custom Templates – You can now save boilerplate text and images in your templates, making report creation with Megalytic even faster. – details here.
  • Improved Dashboard UI – Our new dashboard provide a more intuitive interface for managing your reports. – details here.
  • Better Scalability – We’ve been working hard on those behind the scenes improvements that make Megalytic more robust. – details here.
  • Coming Soon … AdWords – We are very close to releasing direct AdWords integration – something that many of you have been waiting for. Look for an email about that within a few weeks.

Read more

Value of Hiring an In-House Analytics Professional

You’re the marketing coordinator at a medium-sized B2B company. It’s your job to know who is coming to the site and what they’re doing, and use that knowledge to strategize new ways to keep visitors engaged. Obviously, you’ve set up Google Analytics to track your company’s website traffic and User interactions.
Two months later, though, the CEO asks you to pull a report. So, you log into the Google Analytics account, ready to pull stats, only to find that the tracking code was never actually set up on the site. In the midst of your other countless marketing responsibilities, you just assumed analytics would be set up properly. You never followed up to ensure it was.
Immediately, you know two things.
  1. This is not going to be a fun conversation with your CEO.
  2. You need help managing reporting.
Sure, maybe you should have been more on top of ensuring the analytics code was in place and tracking properly. But you’re busy. What if, instead, you had an internal team member dedicated to managing analytics? Someone with a knowledge, and an understanding, of analyzing data with the bandwidth to closely set up and monitor tracking?
This crisis you’re now facing – it never would have happened. In this post, we outline the value that having an analytics professional in-house can bring to an organization.


In-House Analytics Professional


Read more

Ways to Save Time on Analytics Reports

It’s that time again! The time when you need to get out the analytics reports – all of them. Whether you are an in-house marketer or work at an agency, the amount of reporting you’re responsible for has increased. Management needs their reports. Clients need their reports. Everybody has a reporting deadline and they are all expecting you to meet it.
How are you going to get it all done?
You’re going to use Megalytic.
Fortunately for marketers, Megalytic provides a variety of features that can help you crank out reports faster than you ever imagined.
Let’s look at some of these time-saving features in detail.


Blog Image - Save Time on Analytics Reporting


Read more