Helpful Articles (filter at right)

2 Help Resources Available

The Analytics Edge help site has plenty of resources available for learning and assistance with reporting. This article explains what is available and highlights the ‘account not found’ problem people experience when sharing workbooks. More →

Account Reference Names

Analytics Edge takes account security very seriously. When you use the add-in or one of the connectors to access one of your accounts, the product will encrypt a security token and save it to your computer. You will be asked for an account reference name for this token. More →

Combining Google Search Console And Google Analytics Data

Easily combine data from Google Search Console with Google Analytics 4 — Analytics Edge makes it easy.

  • no copy-paste
  • no downloading data
  • pulls data direct from API’s
  • no coding required
  • no 1000-row limit
  • less than 5 minute’s work
  • the whole workflow automated
  • click to refresh

Error: Account not found. Check Account wizard

This error usually occurs when you share workbooks with coworkers, or after a computer move or rebuild. Analytics Edge stores a reference to the account in the workbook, but the actual security tokens are stored on your computer.  More →

Error: Invalid/missing dates

This error usually occurs when the cells you referenced in a query have moved or the contents are changed. Analytics Edge connectors offer the ability to use cell references for the dates, but the references can get out of alignment if you add rows or columns in the worksheet, or if you renamed the worksheet. More →

Misunderstood Metrics: GA 4 Time on Page / Session Duration

Time on page and session duration are old metrics from the early days of web analytics. You can find the equivalent in Google Analytics 4, but I don’t recommend using them as they are fundamentally flawed as explained below. User engagement is what you should be focusing on in today’s web metrics, so User engagement/Total users is the preferred measure.

Add this calculated metric to your property so you can include it in your reports.

More →

Using the Repeat Macro Function

The Repeat Macro function in Analytics Edge lets you cycle through a list of items, repeating the rest of the Analytics Edge macro for each line in the source list. This article shows you how to use it. More →

Using the Run Macro Function

The Run Macro Function in the Analytics Edge Add-in lets you run other Analytics Edge macro or Excel VBA macros. This would typically be used to create a ‘master’ macro that runs through a specific sequence of other macros. With v7 of the Add-in, you can also trigger Excel VBA macros, which opens the door to running custom VBA code that does things Analytics Edge does not enable. More →

When Is a Space Not a Space?

Trying to replace spaces in your text, or split text by the spaces, but it won’t work? Did you get the text from a web page? Then the ‘space’ is probably not a ‘space’ — it is a ‘non-breaking space’. Here’s how to deal with it. More →