Megalytic Category

Megalytic Adds Charts to the CSV Widget

Megalytic has announced the addition of charting capabilities for our CSV Widget.
The CSV widget enables you to integrate CSV files and Google Sheets with your Megalytic reports. Using it, you can import data from nearly any source. Furthermore, you can link to editable Google Sheets, so that changes in those spreadsheets are automatically reflected in the Megalytic report.
Now, you can use the CSV widget to create charts as well as tables. All the data visualization capabilities available in other widgets are now available for use in the CSV widget as well. You can now create line, bar, pie, and time-series charts from your imported data.
As this video demonstrates, creating charts from external data in CSV files or Google Sheets is very easy.

Tracking and Reporting on Email Campaigns

Email campaigns are one of the oldest forms of digital marketing. They predate Facebook, they predate Google – heck, email predates the World Wide Web.
As a digital channel with relatively low costs and a high potential for ROI, email campaigns are not going away anytime soon. Even though most of us are well acquainted with how email works there can still be an initial learning curve when it comes to using it as a marketing tool. In this post, we’ll cover the basic ins and outs of tracking and reporting on email marketing efforts.

Tracking and Reporting on Email Campaigns
Read more

An Example Facebook Report Template for Agencies

A good Facebook report template can save your agency a lot of time and money while delivering real value that your clients will appreciate.
Your agency manages Facebook Pages and advertising for clients. Maybe dozens, or even hundreds of clients. You are busy creating content, video, images for all those Pages. Not to mention promoting posts, creating ad campaigns, designing landing pages, and optimizing the performance of it all to ensure that you are getting a good return on all the time and money you are putting into Facebook.
In addition to all that work, your clients expect a monthly report. It makes sense. They want to know what they are getting in return for the money being invested in Facebook content and advertising. But, how do you find time to create a custom performance report for every Facebook client each month? And what data belongs in that Facebook report?
Creating a report from scratch for each client is too time-consuming and will not scale as you add more clients. Fortunately, with Megalytic you can easily create a Facebook report template to jump-start the process for each client. Building a Facebook report template provides the starting point for all subsequent reports. This foundation becomes a customizable Facebook report that can be adapted to each of your clients.
To get started, consider the data you need to include for all (or at least most) clients and also what metrics you should show from Facebook Page Insights and Facebook Ads Manager, and any other sources that help demonstrate the value of the work you are doing for your clients.
Whether or not you use Megalytic for reporting, this post provides an example of the structure and key data point to include in your Facebook report template.

Facebook Report Template for Agencies


Read more

An Example AdWords Report Template for Agencies

A common question asked by digital marketing agencies is what should be included in a client’s AdWords report?
Your agency probably creates and manages AdWords campaigns for a variety of clients. Your activities may involve keyword selection, bidding strategies, ad creation, conversion tracking, and optimization. If its an E-commerce client, maybe you even manage to a target return on ad spend (ROAS).
You cannot really communicate detailed metrics on all the activities that you perform for a typical AdWords client. The client would be overwhelmed by detail! Instead, you need to focus on a few key performance indicators (KPIs) that provide your client with the information they need in order to make good business decisions.
Of course, the primary rule of reporting is to develop KPIs that are customized to each client’s business. For AdWords reporting, that means you need to provide big picture numbers like total leads, clicks, conversions, spend, etc. But, you also need to drill down, so the client can see data at the campaign, ad group, ad, and keyword level. While the big picture numbers tell your client if their goals are being met, the details help with allocation decisions like moving spend from display to search ads or eliminating poorly performing ad copy.
Creating such a report from scratch for each client can be a time-consuming and intimidating task. Fortunately, Megalytic provides a simple interface for creating AdWords report templates. Creating an AdWords report template provides your agency with a starting point for future reports. For each new client, you can begin with the template, and customize it to create an AdWords report meeting the specific needs of that client.
Whether or not you decide to use Megalytic for reporting, here are some important ideas to consider when creating an AdWords report template for your agency.


Example AdWordsReport Template


Read more

How To Manage Dozens (or Hundreds!) of Facebook Pages

Managing multiple Facebook Pages can become a challenge for agencies and large organizations alike. Perhaps you run social for several clients or your business has multiple Pages for different business lines, products or locations. Either way, the primary issue is scale. You have all the challenges of running a single Facebook Page, only multiplied across all of the Pages you manage.
But in social media, scaling rarely just means more manpower or minutes. It means more dimensions, more variables. The number of Pages means a wider range of needs and goals from social engagements. Those in turn demand a wider range of strategies to execute to achieve them. It may also mean additional reporting needs to inform planning, execution and accountability.
Running 50 Facebook Pages isn’t quite the same as taking the work to run a single Page and multiplying it by 50. And even for single businesses running multiple brand/product/location Pages, there will be unique factors for each one that complicate efforts to simplify Page management.
Philosophy, process and structure will make or break your ability to consistently manage dozens (or hundreds!) of Facebook Pages. In this post, we’ll give you a framework flexible enough to use for any Facebook Page but sturdy enough to scale out and use consistently over time. To manage multiple Facebook Pages at scale, you need to solve problems across five dimensions: team, schedule, technology, permissions, and process. Organize your management processes in these areas, and you’ll be able to skillfully handle a high volume of Facebook Pages.


Managing Facebook Pages


Read more