BLOG

How to Show Spreadsheet Data & Images in Megalytic

Published November 16, 2015
Marketers love Megalytic because it allows them to portray and filter data from Google Analytics, AdWords and Search Console in near endless ways. This allows marketers to present better marketing insights to their boss or client to inform decisions and see greater results. However, sometimes the data you want to show isn’t coming from Google—it’s coming from a third-party source that may not directly integrate. In these occasions, marketers are able to add data to Megalytic reports in different ways – they can use the CSV widget within Megalytic to import data as a table within the report or use the image widget to enter the data as a screenshot.
In this post, we’ll show you how to include spreadsheet data and images in Megalytic. Let’s start with how to use the CSV widget.

 

Megalytic Image Widget Showing Facebook Data

 

Setting up the CSV Widget

There are several use cases where marketers may need to use the CSV widget to import data from a spreadsheet directly into a report. Some include:

  • Showing data from advertising platforms that don’t integrate directly with Megalytic (Facebook Advertising, Twitter Ads, Bing Ads)
  • Showing results from website call tracking platforms
  • Showing sales results tracked within a company
  • Reporting information submitted through website forms (names, emails, phone numbers)
  • Reporting results from email marketing campaigns

You’ll find the CSV widget listed under the “External Data” category within the list of available Megalytic widgets. Note that you can also use the search bar to pull the widget up directly.

 

Megalytic's CSV Widget

 

Once you’ve located the widget, drag it to the desired position in your report to add it. You’ll immediately see a prompt to upload a file.

 

Uploading a file into the Megalytic CSV Widget

 

Now, locate the CSV file on your computer that you wish to add to the report. When creating your file, keep in mind that you can currently show up to six columns within this widget. If you include more than six columns in your file, you’ll want to choose which columns to show from the widget options.

If your file contains a header row (e.g., Clicks, Reach, etc.), leave the “My file has no column headings” unchecked. That way, the widget will format the top row differently, as headings. Once you click “Save,” you’ll now see the data from your file shown in the widget.

 

Example of CSV File in Megalytic

 

In this example, we’re showing data from a Facebook Advertising account. Most ad platforms will allow you to export data as a CSV, so you can easily pull the numbers you want and modify the spreadsheet in Excel to contain your desired columns before uploading.

Once the data is in the widget it can be customized in several ways. First, choose which columns from your spreadsheet you want to show. Using the “Columns” dropdown, click columns from the list to check or uncheck them based on which ones you’d like to appear in the report. “Apply Selection” under this dropdown will update the report with your choices.

 

Choosing columns using Megalytic's CSV Widget

 

To rename a column, click the name of that column in the options and type in your new text. For instance, you may want to rename “Conversions” to “Form Submissions” to clarify what this metric means to your client.

To rearrange the order of columns in your report, click the “hamburger” (stack of three lines) icon on your desired column and drag to the proper position. You can also further customize each column by clicking the “down” arrow on the right side from within the options. You’ll now see several options for formatting the data within that column.

 

Customizing a Column in Megalytic's CSV Widget

 

First, you can choose to align text to the left or right if you’re not satisfied with the automatic alignment. Next, you can format the text as a number, percent, or currency.

You can also choose how many decimal places you’d like to show; for instance, you may want to show dollar amounts down to the level of cents. Finally, you can choose between several currency symbols; for instance, you may want to show pounds instead of dollars.

Note that if your original Excel document was set up to include currency symbols or decimal points, these will automatically upload with the same formatting. However, the options outlined above allow you to tweak the data after it is in Megalytic.

Hosting Spreadsheets Online

Instead of uploading a file directly to Megalytic, you can also host a CSV file online using a cloud service such as Dropbox or Google Drive. You’ll just need to make sure the file URL is set to be publicly accessible. When you’re adding data to your CSV widget, simply enter your file’s URL into the available text field and apply to your report to update the data.

 

Integrating Hosted CSV Files with Megalytic

 

This service is especially helpful when you’re consistently creating monthly reports that require regular data, eliminating your need to re-upload data into Megalytic each time. Your Megalytic report template can reference the same file, so information will auto-update as you update the file in your cloud storage service.

In order to preserve the file link in your templates, be sure to choose the option to “Save with File/URL” while saving the template, as shown below. Now, when you create your next report using the same template, this widget will automatically pull fresh data from the same CSV file.

 

Saving a Hosted CSV File by URL in Megalytic

 

Using the Image Widget in Megalytic

Besides spreadsheets, you may also want to include screenshots or other imagery in your report. You can do this using Megalytic’s Image Widget. Here are a few possible uses for this widget:

  • Including screenshots of data from your social media profiles (Facebook business page analytics, examples of tweets posted during the last month)
  • Including screenshots of display ad creative for which you show stats
  • Including screenshots of pages on your website mentioned in the report
  • Showing performance graphs from advertising platforms
  • Showing examples of email marketing pieces

You’ll find this widget under the “External Data” category shown earlier. Upon adding the widget, you’ll see a prompt to upload an image to your report. You can include jpg, jpeg, png, or gif files.

Note that you can also point to a file hosted in the cloud, just as with the CSV widget. For a template report showing monthly results, you could update an image file with the same file name each month. The “Alignment” dropdown allows you to align the image to the left, center, or right in your report.

 

Megalytic Image Widget Showing Facebook Data

 

In this example, we’re including a screenshot of Facebook Insights to show recent performance for a business page. This allows us to quickly break down social media results for the client, including a screenshot, as opposed to manually typing in the data.

Below an Image widget, you could also add a Notes widget to further explain the graphic shown. For instance, you could explain how your posts and advertising efforts contributed to the growth in likes and reach over the previous period.

Conclusion

CSV and image widgets allow marketers to show data beyond the systems automatically integrated with Megalytic. Your reports can include a full picture of your marketing efforts, whether you’re showing Facebook page stats, ad campaign results, or sales figures. Take some time to learn how you can customize these widgets to add the right data to your reports and best communicate to your clients.

ALSO IN THIS BLOG

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