Admit it – you dread the first day of every month. That’s when it’s time to start cranking out the monthly marketing reports. Whether you are a consultant, an in-house marketer or an analyst at a corporate agency, reporting is a mandatory part of the job.
And every month, it’s the same routine – you spend a frustrating chunk of your time exporting data from Google Analytics, importing it to Excel, massaging it, building charts and analyzing it so your client or team can understand the key takeaways. Or maybe you cut and paste screen shots into Word or Google Docs, add some explanatory text and format everything to look nice.
The problem, of course, is that putting the report together takes up most of your time, cutting into the precious hours you need for real analysis and insight.
Maybe you’ve thought about automating the reports, but it doesn’t seem possible. After all, your reports change each month. You’re not just cranking out cookie-cutter analysis here. Part of your job is explaining the impact of the latest initiatives, how they performed and using that intelligence to guide your next steps. You just wish you had a way to do it faster, without sacrificing the value.
We completely get it – but there are viable ways to have your analysis and automate it too. Let’s start with the basics.
There’s no need to reinvent the wheel. At least, that’s what they tell you. But somehow it seems like every time a report is due, you find yourself back at square one. So maybe you’ve decided it’s time to find a Google Analytics reporting template that you can use over and over again.
Awesome. We can help.
It’s absolutely possible to build a reusable reporting model. But with that said, what you build should take into account several factors, and be easy to customize based on changing needs, goals and variables. To see Megalytic’s Google Analytics sample templates or to get easy, pre-made examples, sign up for our free 14-day trial
. If you’re looking for ideas and inspiration, read on!
Megalytic has customers all over the world, many in countries where English is not the primary language. Many have been asking us to provide translation capabilities, so that they can create reports in the language preferred by their readers. As a result, I am extremely pleased to announce that we have just released Support for Multiple Languages
The following languages are supported, with more to be added in the near future.
Megalytic users can set a default language for their reporting and override that default for individual reports. For example, a multi-national based in the UK can set their reports for English by default, but still publish reports for their European subsidiaries in German, French, Spanish, or Italian. Users can even create a report in one language (e.g., English), and publish in another (e.g., Arabic).
Over the past month, we’ve been working to expand our support for Facebook Ads Metrics. Megalytic is committed to providing best in category reporting capabilities for Facebook Advertising analytics. Today, we are pleased to announce support for the following additional metrics.
Ad Engagement Metrics
- Link Clicks – The number of clicks on ad links to select destinations or experiences, on or off Facebook-owned properties.
- Post Engagement – The total number of actions that people take involving your ads (or all posts, in some cases).
- Page Engagement – The total number of actions that people took on your Facebook Page and its posts, attributed to your ads.
- App Engagement – The number of actions, including app installs, credit spends and uses, that were recorded as app events and attributed to your ads.
- Video Views (3-Second) – The number of times your video was watched for an aggregate of at least 3 seconds, or for nearly its total length, whichever happened first.
- Video Views (10-Second) – The number of times your video was watched for an aggregate of at least 10 seconds, or for nearly its total length, whichever happened first.
Ad Performance Metrics
- Cost per Post Engagement – The average cost for each post engagement.
- Cost per Page Engagement – The average cost for each page engagement.
- Cost per App Engagement – The average cost for each desktop app engagement.
- CTR (Link) – The percentage of times people saw your ad and performed a link click.
- CPC (Link) – The average cost for each link click.
Purchase (Facebook Pixel) – The number of purchase events tracked by the pixel on your website and attributed to your ads.
Purchase Conversion Value (Facebook Pixel) – The total value of purchase (Facebook pixel) conversions.
Add to Cart (Facebook Pixel) – The number of add to cart events tracked by the pixel on your website and attributed to your ads.
Initiate Checkout (Facebook Pixel) – The number of initiate checkout events tracked by the pixel on your website and attributed to your ads.
- Lead (Facebook Pixel) – The number of lead events tracked by the pixel on your website and attributed to your ads.
- Cost per Lead (Facebook Pixel) – The average cost of each lead (Facebook pixel).
- Lead – The number of form responses submitted after people clicked on Facebook lead ads.
- Cost per Lead – The average cost of form responses submitted after people clicked on Facebook lead ads.
- Page Like – The number of likes of your Facebook Page attributed to your ads.
- Cost per Page Like – The average cost for each Facebook Page like.
Numbers may not lie, but how we present them can make all the difference. Data can easily become overwhelming for people who don’t love wading ankle deep in spreadsheets. That’s why part of a marketer’s job is finding the right way to report metrics that are clear, concise and informative. Fortunately there’s technology that helps our data tell its story.
Whether you’re measuring performance for a large or small business, accurate reporting is crucial. You need to start with a framework for thoroughly tracking how people got to your website, what they viewed, and what led them to convert (or hindered them from converting) into paying customers.
An overwhelming array of options faces marketers today. Of course, you can start with Google Analytics, the free go-to web tracking solution in use on millions of websites
. While a properly configured Google Analytics setup will take most businesses a long way in monitoring online performance, it can’t solve all the problems faced by marketers.
How do you connect the dots to a transaction that occurred via face-to-face interaction months after an online form was submitted? How can you create a simple report template that makes sense to your CEO when a Google Analytics dashboard isn’t enough? In this article we’ll look at your different options along with how and when to use them.