The Google Search API now supports a full 16 months of historical data, but the only date-related field is ‘date’, so this is how to get all that data out in a meaningful way. To get your numbers in weekly or monthly buckets, the Google Search Connector from Analytics Edge provides a MultiQuery tab. More
What is this green worksheet with the message “ANALYTICS EDGE – active table in memory…”? When you are editing a query or stepping through an Analytics Edge macro, a green worksheet will appear (AE Step Results). This temporary worksheet shows you what it is currently in memory — the results of the last function step — before you formally write it out to a worksheet. More
With the MailChimp Connector, Analytics Edge lets you automate more than just a data download – it lets you create a finished report that you can refresh with just a click. In this article, we’ll show how one click can get you a subscriber activity report for the most recent MailChimp campaign. More
The Analytics Edge Standard and Core Add-ins allow you to append the results of a query to the existing data in a worksheet. While the function is simple, there are some scenarios where you can experience problems. This article describes the problems you could experience and the solutions.
Dimensions That Look Like Numbers
The Append function looks for columns that are not numbers, and it uses all of those columns to try to align the rows of the new query with the existing data in your worksheet. If a column, like Week of Year or Month of Year (e.g. 201810) is not formatted as Text, then the Append function will ignore the value when it aligns the rows — the result: mashed up numbers.
Solution: make sure the existing column of data is formatted as ‘Text’ in Excel (not ‘General’).
Dates That Aren’t Dates
Sometimes you get data that looks like a date, but it is actually text. In Excel, a date is actually stored as a ‘serial number’ and formatted to appear as a date. In some Analytics Edge connectors, dates can be downloaded as text strings, and it can be difficult to tell them apart. IF you are appending data with one data type into a worksheet with the other, strange things can happen (extra columns, improper row alignment).
Solution: In Excel, select the worksheet cell and check the format – if it shows ‘Date’, then you are dealing with a date. If the query column is Text, the add-in will try to convert it into a date, and things should work as expected.
Solution: If the worksheet data is formatted as Text, and it is not in the 2018-10-31 format, Analytics Edge will likely be unable to align the rows properly — you may get duplicate rows with different date formats (actually text strings). Change the existing data to a Date in Excel (how it is displayed as not important), or change the text to 2018-10-31 representation to be consistent with the connectors.
The filtering capability in Google Search Console is very restrictive (single phrase match), making it useless for separating branded from non-branded search terms in all but the simplest cases. Enter the Analytics Edge Standard and Core Add-ins — a quick regular expression filter and your work is done. More
With Analytics Edge, your reporting gets a whole lot easier with single-click refreshes, and you don’t lose any of the flexibility that makes Microsoft Excel so popular for Constant Contact reporting. Here’s an example of one engagement that went from idea to “This is AMAZING!!” in 24 hours. More
Analytics Edge is licensed by computer, so the add-in keeps track of the computer it is licensed for (even the free product is licensed). Sometimes a Windows Update or hardware change will mess up the license, and you will get an error saying “License issued to a different computer”. More
Google Analytics provides a New vs Returning report to measure the pull of your site and the extent to which you are encouraging first time users to return. Making this report with Analytics Edge allows you to easily track these metrics the way you want to see. More
Long-tail keyword phrases are often made up of many different combinations of similar words, making it difficult to tell when there is a common topic of interest. This article walks through the creation of a keyword analysis report, based on weekly snippets of data from Google Search Console. More
“I want to increase the number of returning visitors.” Now you need a report to track your progress. This article will help you navigate Google Analytics to find the right data, and to produce a meaningful report using Analytics Edge. More
The wizard-based automation provided by the Analytics Edge Core Add-in for Excel makes it easy to combine data from multiple sources. This article explores how you can build a Waterfall Report that includes data from Google Webmaster Tools (now Google Search), Bing Webmaster Tools, Google Analytics and an external database. More
This article explores how to use date values in your Excel workbook to drive Analytics Edge connector queries, opening the door to a more interactive reporting experience within Excel. More