Author Archives: free reports

CTR vs Position Analysis

Core Add-inGoogle Search Connector

When embarking on an SEO review for a website, it helps to be able to see what queries are already ranking and how successful they are (click-through rate) at generating traffic. This workbook lets you easily visualize the queries that a specific page ranks for, contrasted to the click-through rate for the past 90 days.

Download the workbook:
GoogleSearch-CTRAnalysis-1-0.xlsx

Continue reading

Google Search Position Distribution

Core Add-inGoogle Search Connector

The Google Search Console metric for “position” is an average, and it doesn’t tell the whole story. This report looks at the individual queries used for each of your pages over the past 12 weeks, groups them by position, and shows you the distribution of impressions and clicks by position.

Using the power of the Analytics Edge Core Add-in, the workbook macros will download your website data and do all the analysis work for you.

Download the workbook:
GoogleSearch-PositionDistributions-1-0.xlsx

 

WTF is Happening to My Traffic?

googleanalytics-wtfJoe Kelly of Workshop Digital created this custom dashboard to easily analyze what is causing organic search traffic to decline, and I adapted it to work with the free Analytics Edge Basic Add-in. Just enter your Google Analytics view ID number and refresh.

The dashboard will help you see:

  • If you’re losing organic visibility in a specific city where you previously dominated
  • If there’s a high probability that top landing pages lost valuable organic positions
  • If the drop in organic traffic is impacting conversion metrics
  • If other traffic sources are down, which can help identify the impact of other marketing channels
  • If the drop in traffic is specific to a device type

Read the original Workshop Digital blog article with a Google Sheets version.

Download the workbook:
GoogleAnalytics-WTF-is-Happening-to-My-Traffic-Dashboard-2-0.xlsx

Tabular Summary Report

Core Add-in, Google Analytics Connector
googleanalytics-summary-report-1-0This quick overview report shows all the key performance metrics for the past year in a single tabular view. All the overview, acquisition, behavior and conversion metrics you expect in a quick summary report.

Everything is automated; just Refresh All with the Analytics Edge Core Add-in. Easy to modify and rebrand – make it your own!

Download the workbook: GoogleAnalytics-Summary-Report-1-0.xlsx

 

 

SEO Summary Report

Core Add-in, Google Search Connector
Search Engine Optimization is a changing market. It’s not about keywords, it’s about topics and long-tail in aggregate. This free report summarizes your website’s appearance in search, showing the distribution of the # of keywords, impressions and clicks by position.

seo-summary-report-2

 

The included Analytics Edge macro downloads the last 12 weeks worth of Google Search Analytics data and extracts the data, excluding your branded search terms if desired.

Download the workbook: GoogleSearch-SEOSummaryReport-2-0.xlsx

v2.0 Updated to display counts for position 1 at the bottom of the charts, and added counts for position 21+ at the top.

Configuration: Enter your account and website on the Data worksheet in the highlighted cells, enter any brand terms to be excluded on the Brand Terms worksheet. Click Refresh All.

 

Queries for Top Pages

get-google-search-console-detail-in-minutesCore Add-in, Google Search Connector
This free workbook is a companion to the Simple SEO Report Automation newsletter and video Get Google Search Contents in Minutes. It shows how easily Analytics Edge can automate a sequence of queries; in this case, getting a list of the top pages that appear in Google Search results, then for each of those pages, get the queries that were used to find them.

It includes the impressions, clicks, CTR and position data.

Download the workbook: GoogleSearch-QueriesForTopPages-1-0.xlsx

UPDATE: The functionality in this workbook can easily be accomplished with a single ‘query’ in the Google Search connector v4.0, and it works in the Basic Add-in:

GoogleSearch-QueriesForTopPages-4-0.xlsx

 

Moz Inbound Link Report

Core Add-in or Basic Add-in, Moz Connector
mz-inbound-links2See how much ‘link juice’ you are getting from your inbound links with this simple Analytics Edge report. It works with both free and paid Moz accounts, retrieving the Moz Page Authority and MozRank Passed metrics for inbound links to the web page you enter.

Use it for competitive analysis, or just to see what those inbound links to your own site are really worth to you.

Download the workbook: Moz-inbound-links-1-0.xlsx

This report can be refreshed with either the Analytics Core Add-in, or Analytics Edge Basic Add-in, in combination with the Analytics Edge Connector for Moz. 

Top Queries Trend

Core Add-in, Google Search Connector
google-webmaster-tools-top-queriesSee 10 weeks worth of Google Search Console data in one report. Analytics Edge makes it easy with this workbook and the Connector for Google Search.

It downloads the top queries for each week, and lines them up side-by-side so you can see the number of impressions shift over time, highlighted using Excel’s conditional formatting.

Download the workbook: GoogleSearch-TopQueries-3-0.xlsx [updated 2015-10-16]

 

UPDATE: similar functionality can now be obtained with the Basic Add-in and the Google Search connector v4.0 using a single query:

GoogleSearch-TopQueries-4-0.xlsx

SEO Results Tracker

Core Add-in, Google Search Connector
See how your content marketing or search optimization efforts have affected traffic to your site with this free Microsoft Excel report. Enter the target phrase and your account and website information, then let the Analytics Edge Core Add-in and Google Search Connector take care of the rest.

google-search-phrase-tracker

Continue reading

Top Pages And Queries This Week

Core Add-in, Google Search Connector
search-analytics-position-this-weekSee a day-by-day position changes for the top queries and pages for your website over the past week, direct from Google Search Console.

Just enter your website URL and click Refresh All; Analytics Edge takes care of the rest, downloading the data for each day, combining the results, pivoting by day, and sorting by the highest number of clicks and impressions for the week.

Download the workbook: SearchAnalytics-position-this-week-3-0.xlsx [updated 2015-10-16]

UPDATE: similar functionality can be obtained with the Basic Add-in and the Google Search Connector v4.0:

SearchAnalytics-position-this-week-3-0.xlsx

Weekly Ranking Report

Core Add-in, Google Search Connector
weekly-positionSee a week-by-week summary of the top queries and pages for your website, direct from Google Search Console. Quickly identify trends and changes in ranking of popular terms. It also shows the number of impressions and clicks for the most-recent week!

Just enter your website URL and click Refresh All; Analytics Edge takes care of the rest, downloading the data for each week, combining the results, pivoting and sorting by the to show your search engine rankings over a 7-week period.

Download the workbook: SearchAnalytics-weekly-position-3-01.xlsx [updated 2015-10-16]

Requires the Analytics Edge Core Add-in and the Analytics Edge Connector for Google Search.

UPDATE: similar functionality is now available from the Basic Add-in with the Google Search connector v4.0:

SearchAnalytics-position-this-week-4-0.xlsx

Long Tail Keyword Analysis

Core Add-in, Google Search Connector
long-tail-keyword-analysis (2)This free Analytics Edge report lets you see long-term trends in the individual words used in search queries that showed you site. Refresh weekly and the report maintains previous results, letting you see not just the current hot topics but also those that have fallen out of the rankings.

You don’t have to dig through hundreds of similar but unique query phrases, Analytics Edge splits each term apart and performs a Soundex grouping of word variants to give you a concise summary of the current topics of interest. A companion blog article describes how the report was created.

Download the workbook: GoogleSearch-Word-Frequency-2-0.xlsm

This report can be refreshed with the Analytics Core Add-in, in combination with the Analytics Edge Connector for Google Search.

Web vs Image Search Clicks

Basic Add-in, Google Search Connector
webmastertools-web-image-comparisonThis free workbook uses the Analytics Edge connector for Google Search to download your website search query performance for the past month, and compares the clicks coming from web search to those from image search.

Download the workbook: GoogleSearch-web-image-comparison-2-0.xlsx

UPDATE: Similar functionality is now available from the Google Search connector v4.0 with a single query:

GoogleSearch-web-image-comparison-4-0.xlsx

Keeping Google Search Analytics Data

Core Add-in, Google Search Connector
webmaster-tools-monthly-trackerGoogle Search Console provides some excellent insight into your website’s performance in search but it is limited to 90 days of history.

These two workbooks let you keep your weekly or monthly snapshots offline in an Excel workbook. Analytics Edge Core Add-in automation makes it easy to maintain — you can even schedule it to refresh automatically!

Available in weekly and monthly versions; download the workbooks:
SearchAnalytics-Weekly-Tracker-2-0 (1).xlsx
SearchAnalytics-monthly-tracker-2-0.xlsx

 

Search Queries by Country

Core Add-in, Google Search Connector
search-analytics-query-by-countryThis free Analytics Edge report gets Google Search Analytics data for your website and displays your top queries distributed across the countries they came from.

Use this data to better understand how topics and terminology differ between regions.

Download the workbook: SearchAnalytics-query-by-country-1-0 (2).xlsx

UPDATE: most of the functionality in this report can be recreated with a single query using the Google Search Connector v4.0:

SearchAnalytics-query-by-country-4-0.xlsx

Keywords for Top Landing Pages

Basic Add-in, Google Analytics Connector, Google Search Connector
keywords-for-top-landing-pagesYes, you can get the keywords for your top landing pages, but not from Google Analytics — they come from the Google Search Console.

This free workbook uses the Analytics Edge Connector for Google Analytics to grab your top landing pages, then the Connector for Google Search (Webmaster Tools) grabs the keywords used to see each page in search results; clicks, impressions and average position! All you need to do is Refresh!

Download the workbook: SearchAnalytics-KeywordsForTopLandingPages-1-0.xlsx

 

Google Search Top Queries Report

Core Add-in, Google Search Connector
google-search-last-month-queriesGet the top queries from Google Search Console for the past calendar month in this free workbook. Just enter your account and website information, then refresh with Analytics Edge and you’re done in seconds!

Download the workbook: GoogleSearch-Last-Month-Queries-1-0.xlsx

This report can be refreshed with the Analytics Core Add-in, in combination with the Analytics Edge Connector for Google Search (Webmaster Tools) v3.0 or higher. 

Campaign Overview Report

Core Add-in, MailChimp Connector
MailChimpCampaignOverviewReportReport on the most recent MailChimp campaign with this free workbook. You don’t have to struggle to recreate the online reports, we’ve done all the work for you! View the key campaign metrics along with list and industry averages. It also includes a  24-hour performance chart displaying opens and clicks.

Simple refresh in Excel is made possible by the Analytics Edge Core Add-inand the MailChimp Connector. Download your free trial today!

Download the workbook: MailChimpCampaignOverviewReport-1-31.xlsx

Recent Campaign Comparison

Core Add-in, MailChimp Connector
MailChimpRecentCampaignsComparisonThis free MailChimp report compares the performance of the last 3 campaigns, showing key metrics along with industry averages. It also includes a side-by-side chart displaying the 24-hour open and click performance of each campaign.

Simple refresh in Excel is made possible by the Analytics Edge Core Add-in and the MailChimp Connector. Download your free trial today!

Download the workbook: MailChimpRecentCampaignsComparison-1-31.xlsx

AdWords Campaign Report

Core Add-in, Google AdWords Connector
adwords-campaigns-reportDownload your Google AdWords campaign activity for the past 30 days directly into Microsoft Excel. Analytics Edge makes it easy with this report and the Connector for Google AdWords — just one click. No programming, no manual downloads. Change the date range and run again for specific periods of interest without ever leaving Excel.

Download the workbook: GoogleAdWordsCampaignSummary-2-0.xlsx

Facebook Insights Weekly Report

Basic Add-in, Facebook Connector
facebook-weekly-reportSee the latest week’s performance of your Facebook page with this free Excel report from Analytics Edge.

Using the Basic Add-in and Facebook connector, one simple refresh shows this week’s Likes, Reach and Engagement compared to the previous week, plus 12-week trend charts showing the types of posts you made and the user response.

Analytics Edge can deliver the custom Facebook Insights reporting the way you need it.

Download the workbook: Facebook-weekly-report-1-0.xlsx

 

Multi-Email Campaign Report

Core Add-in, Constant Contact Connector
constant-contact-multi-email-campaign-reportWhen you send your email campaign separately to multiple lists, maybe with small tweaks to the content, you tend to lose sight of the overall campaign. This free report from Analytics Edge lets you identify selected campaigns and produce a summary report combining and comparing their effectiveness.

The Analytics Edge Core Add-in, along with the Constant Contact Connector, make it easy to select the campaigns to include and populate the summary report with an aggregated total. Download your free trial today!

Download the workbook: ConstantContactMultiEmailCampaign-1-4.xlsx

Email Domain Analysis

Core Add-in, Constant Contact Connector
constant-contact-domain-analysisAnalytics Edge makes it easy to analyze the effectiveness of your Constant Contact email campaigns. This free report compares the key campaign metrics for each email domain in your list, and lets you identify possible delivery problems or compatibility with email interfaces.

Automatic refresh is made possible from inside Excel using the Analytics Edge Core Add-in with the Constant Contact Connector. Download your free trial today!

Download the workbook: ConstantContactDomainAnalysis-1-4.xlsx

First 3 Days of Opens

Core Add-in, Constant Contact Connector
constant-contact-first-3-days-opensSee the number of email opens by hour for the critical first 3 days of your campaigns. Select from any of the most recent 50 emails sent with a convenient drop-down selector. Analytics Edge does all the work, downloading the details and rearranging the data for easy charting.

Use the workbook as-is, or modify it to suit your specific needs; Analytics Edge makes it easy!

Automatic refresh is made possible in seconds from inside Excel using the Analytics Edge Core Add-in with the Constant Contact Connector. Download your free trial today!

Download the workbook: ConstantContact3DaysOpens-1-4.xlsx

Subscriber Analysis

Core Add-in, Constant Contact Connector
constant-contact-subscriber-analysisThis free Analytics Edge report shows the past 3 years of additions and removals to your Constant Contact subscriber base, It also shows a running total, allowing you to see visualize seasonal trends and the impact of campaigns over time.

Use the workbook as-is, or modify it to suit your specific needs; Analytics Edge makes it easy!

Automatic refresh is made possible in seconds from inside Excel using the Analytics Edge Core Add-in with the Constant Contact Connector. Download your free trial today!

Download the workbook: ConstantContactSubscriberAnalysis-1-4.xlsx

Detail Reports

Core Add-in, Constant Contact Connector
constantcontactdetailreportsGet the detailed opens, clicks by email, links clicked, forwards, bounces and opt-outs for a selected Constant Contact email campaign. Analytics Edge does all the work, downloading the details directly into Excel worksheets for you.

Use the workbook to feed your reports, or modify it to suit your specific needs; Analytics Edge makes it easy!

Automatic refresh is made possible in seconds from inside Excel using the Analytics Edge Core Add-in with the Constant Contact Connector. Download your free trial today!

Download the workbook: ConstantContactDetailReports-1-4.xlsx

Email Comparison Report

Core Add-in, Constant Contact Connector
cc-email-comparison-reportReport on your most recent Constant Contact email campaigns with this free workbook. You don’t have to struggle to recreate the online reports, we’ve done all the work for you! View the key campaign metrics and percentages for the past 4 campaigns in one simple report.

Customize it with your logo and colours, and impress your stakeholders.

Automatic refresh is made possible in seconds from inside Excel using the Analytics Edge Core Add-in with the Constant Contact Connector. Download your free trial today!

Download the workbook: ConstantContactEmailComparisonReport-1-4.lsx

Branded Agency Report

Core Add-in, Constant Contact Connector
branded-report-example (2)UPDATED! This free Analytics Edge report can be used by Constant Contact Solution Providers, email marketing agencies and small businesses to deliver branded reports to their clients.

The Analytics Edge add-in and connector for Constant Contact are used to refresh the data for specific client accounts in seconds, sending campaign reports as attachments to email addresses you specify. The repeating macros can process multiple accounts, and report on all campaigns sent in the past number of days. You can even schedule it to run overnight to completely free up your day!

A companion blog article describes how the report was created.

Download the workbook: ConstantContact-BrandedExample-2-0.xlsx

Download the original, single-campaign workbook: ConstantContact-BrandedExample-1-4.xlsx

Bing Webmaster Weekly Position

Core Add-in, Bing Webmaster Connector
bw-weeklyThis free Analytics Edge report shows the weekly search page positions for each of your top queries and top web pages. Instantly visualize hot new pages or queries, and see where you are losing ground.

Download the workbook: BingWebmaster-weekly-position-1-0.xlsx

This report can be refreshed with the Analytics Core Add-in in combination with the Analytics Edge Connector for Bing Webmaster. 

! Assistance with Custom Reporting !

Standard reports only touch the surface, so people use Microsoft Excel to build customized reporting to show the metrics and performance indicators important to them.

Analytics Edge products were designed to make custom reporting simple. The connectors can download current data, and the wizard-driven analysis functions can extract the key performance measures you need. The process is so fast and so easy, I openly offer to help you with your reporting challenges.

Don’t be afraid to contact me.

[email protected]

Collection of Top Reports

Basic Add-in, Google Analytics Connector
googleanalyticsoccamsrazorreportsThis free Analytics Edge workbook includes a set of reports inspired by an entry in the Google Analytics Solutions Gallery by Avinash Kaushik*. It can be refreshed with either the Analytics Edge Code add-in or the Basic add-in in combination with the Connector for Google Analytics.

The reports included:

  • All Traffic Sources Report
  • Content Efficiency – Business Analysis
  • Content Efficiency – Technical Analysis
  • Paid Search Report
  • Internal Site Search Analysis
  • Landing Pages Analysis
  • Mobile Performance Analysis

Inspired by: Occam’s Razor Awesomeness

Download the workbook: GoogleAnalyticsOccamsRazorReports-2-0.xlsx

Visits by Medium Trend

Core Add-in, Google Analytics Connector
google-analyt-cs-visits-by-mediumLet Analytics Edge do your work for you with this free report. Automatically download your Google Analytics data and transform that raw data into meaningful information. No formulas required; the workbook uses the wizard-driven Analytics Edge filter, replace, pivot and sort functions to do the work for you.

Download the workbook: GoogleAnalyticsVisitsByMediumReport.xlsx

Inspiration reference: annielytics.com

Google Analytics Summary

Basic Add-in, Google Analytics Connector
google-analytics-summaryThis free Google Analytics Summary Excel Report is refreshed in seconds using the Analytics Edge Connector for Google Analytics. It includes 4 trend charts for the past 30 days, providing great visual presentation of:

  • visits by continent
  • visits by medium
  • visits by social network
  • visits by device

Click the Refresh All button on the Analytics Edge ribbon and all the queries are updated. No fussing with dates. The report uses standard Excel pivot tables and charts, so after you refresh the queries, you will need to refresh the pivot tables as well (Data ribbon – Refresh All button). You can easily modify it to suit your website tracking challenges.

Download the workbook: Google-Analytics-Summary-1-3.xlsx

SEO Combination Report

Core Add-in, Google Analytics Connector, Google Search Connector, Moz Connector
ga-gwt-moz-reportThis free workbook uses the Analytics Edge Connectors for Google Analytics, Google Search, and Moz to combine key SEO metrics for your top 100 web pages. The included Analytics Edge Core Add-in macros make refreshes a snap.

The report lists your top 100 landing pages from Google Analytics, sorted by the number of Entrances. The macro then combines Google Search data and Moz data producing an all-in-one report in seconds!

The report includes:

  • Entrances and Unique Pageviews from Google Analytics
  • Avg. position, Impressions, and Clicks from Google Search Console
  • External Equity Links, Root Domains Linking, and Page Authority from Moz

Instructions: see blog article

Download the workbook: GoogleAnalytics-Search-Moz-report-3-0.xlsx  [updated 2014-09-21]

Google Analytics Audience Overview

Basic Add-in, Google Analytics Connector
google-analytics-audience-overviewThis free Excel workbook provides a quick summary of your website’s audience over the past 30 days, just like in Google’s web interface!

See the trends and totals for all the key metrics of Sessions, Users, Pageviews, Pages/Session, Avg. Sessions Duration, Bounce Rate and % New Sessions. Compare new and returning visitors day by day as well as a summary pie chart.

The bottom section is interactive! Click one of 9 dimensions and see the top 10 items: Language, Country, City, Browser, Operating System and Service Provider. You can even check out the Mobile (and tablet) Operating Systems, Service Providers and Screen Resolutions. Each listing includes a percentage of the total sessions (% of total mobile sessions for the mobile metrics).

Download the workbook: GoogleAnalytics-AudienceOverview-1-0.xlsx

Google Analytics Acquisition – All Traffic

Basic Add-in, Google Analytics Connector
google-analytics-acquisition-all-trafficBased on the standard Acquisition-All Traffic report, this free workbook gives you new perspective into where your website traffic is coming from. Refresh in seconds with Analytics Edge.

With interactive Excel features and conditional formatting, you can easily switch between 9 different dimensions and visualize the top key traffic source segments.

Interactive dimensions include: Source/Medium, Medium, Source, Referral Path, Campaign, Social Network, Landing Page, Visitor Type, and the Count of Sessions (visit frequency). Metrics are presented for easy reading, with rates in percent, and times in hours:minutes:seconds format. The main chart is based on an Excel pivot table, allowing you to filter which items are included.

Download the workbook: GoogleAnalytics-AquisitionAllTraffic-2-0.xlsx (Revenue metrics) or GoogleAnalytics-AquisitionAllTrafficGoals-2-0.xlsx (Goal metrics)

Desktop Screen Resolution/Browser Size

Core Add-in, Google Analytics Connector
DesktopScreenResolutionThis free report presents the Google Analytics screen resolution (or the new browser size) dimension the way it should be — showing the percentage of website users served by various combinations of screen widths and heights.

The report auto-adjusts to your site data, showing the most common size increments that your website visitors use.

The two-axis table and conditional formatting make it really easy to zero in on the target screen sizes that a specific percentage of users have. For example, in the sample image, 81% of visitors have screens 1280 wide x 768 high.

Download the workbooks:
GoogleAnalytics-DesktopScreenResolution-1-1.xlsx (desktop devices only)
GoogleAnalytics-BrowserSize-1-0.xlsx (all devices)

Frequency and Recency Report

Basic Add-in, Google Analytics Connector
FrequencyAndRecencyThis free Excel report includes all the formulas and conditional formatting needed to reproduce the Google Analytics Frequency and Recency reports. Use it as part of your dashboard project!

A quick refresh and your website data is presented in an easy-to-understand tabular format, complete with background bar chart-like conditional formatting providing a quick visual reinforcement of the larger numbers.

Download the workbook: GoogleAnalytics-FrequencyAndRecency-2.xlsx

Cohort Analysis for Blog Articles

Core Add-in, Google Analytics Connector
cohort-analysis-for-blog-articlesDo your blog articles peak in popularity as soon as they are published or do they gain attention over time? This free report shows the number of pageviews per month for your most popular blog articles versus the number of months since they were published.

Sometimes called “cohort analysis”, this report lets you compare how various articles perform from the day of the their introduction. Sorted by their peak performance over the past 12 months, the report compares the monthly pageview counts for each article. The included Analytics Edge macro leverages the Google Analytics connector’s ability to minimize data sampling.

The macro is designed to recognize blog articles with year and month numbers in their paths (…/2014/08/…), and is open for easy customization to suit your blog site specifics.

Download the workbook: GoogleAnalytics-BlogCohortAnalysis-2-0.xlsx

This report was inspired by an article from Jon Meck of LunaMetrics.

Interactive Behaviour Flow

Basic Add-in, Google Analytics Connector
behaviour-flowThis free interactive workbook lets you see the relationships between Sources and Landing Pages from your Google Analytics data. Simply refresh the queries and hover the mouse over any of the Top 10 Sources listed at the left or over any of the Top 10 Landing Pages listed at the right.

Inspired by an E90F50fx blog article.

Download the workbook: GoogleAnalytics-Source-to-LandingPage-Cosmograph-1-1.xlsm

Interactive Analytical Charts

Basic Add-in, Google Analytics Connector
interactive-analytical-chartsThis free workbook show how easy it is to mimic the alternating presentations of data as seen in the Google Analytics web interface. Simply click the top radio buttons to switch between table, pie chart (percentage), bar chart (performance) and relative to average (comparison) views.

Inspired by an article from Chandoo.org

Download the workbook: GoogleAnalytics-Analytic-Charts-1-0.xlsx

Time of Day, Day of Week, by Device Type

Basic Add-in, Google Analytics Connector
googleanalytics-timeofday-dayofweekThis free Excel report shows the most popular times of day, by day of week, for each device category tracked by Google Analytics: Desktop, Mobile or Tablet. It could also be easily adapted to display time-of-day vs day-of-week profiles for other dimensions such as Continent, Medium, of Social Network.

Inspired by a presentation from Gerry White of SiteVisibility

Download the workbook: GoogleAnalytics-TimeOfDay-DayOfWeek-1-0.xlsx

Can be refreshed with the Analytics Edge Basic Add-in and connectors.

Email-enabled Monthly PDF Report

Core Add-in, Google Analytics Connector
email-enabled-monthly-pdf-report[updated 2016-07-27] This free Analytics Edge report demonstrates the capabilities of the Analytics Edge Core Add-in v2.20 to fully automate monthly reporting. It supports multiple Google Analytics accounts, exports to Adobe PDF format and sends the file via email to named recipients.

Using a simple setup worksheet, you enter the Google Analytics login to use, the view ID, a descriptive name, and the recipient’s email address. If you enter more rows of values, Analytics Edge will process each row in turn, sending PDF versions of the report to the email addresses entered.

Download the workbook: GoogleAnalytics-MonthlyPDFReport-3-0.xlsx

Read the companion blog article : Advanced Techniques: the Monthly PDF Report 

Cohort Analysis by Source

Core Add-in, Google Analytics Connector
googleanalytics-gohort-analysis-by-sourceThis free report demonstrates how easy it is to use the Analytics Edge Core add-in and Google Analytics Connector to perform a dynamic cohort analysis in Excel.

Its shows the number of sessions (visits) by source for the date range, plus how many of those sessions came from visitors whose first session on your site was in each of the past 6 months. Quickly see which sources people are using to return  to your site again and again.

Easily modify the report to show traffic by Landing Pages, Countries, or Languages. Change the metric to see conversions, revenue or other measure.

The date range for the report can be entered directly on the report worksheet, with the individual cohort labels and date ranges defined on a supporting worksheet.

Download the workbook: GoogleAnalytics-Cohort-Analysis-by-Source-1-0.xlsx

This workbook requires the Analytics Edge Core Add-in v 1.4 or higher, and the Free or Pro version of the Google Analytics Connector v1.7.3 or higher.

Sampling-Free Annual Report

Core Add-in, Google Analytics Connector
google-analytics-annual-reportThis free report demonstrates how easy it is to use the Analytics Edge Core add-in and Google Analytics Connector to create an annual report that avoids Google Analytics data sampling errors.

The Analytics Edge automated refresh makes 24 monthly queries to virtually eliminate sampling errors and deliver accurate trend information, by channel, for the past year.

The report also displays top countries and top pages, as well as the top traffic source and landing page combinations.

Download the workbook: GoogleAnalytics-Annual-Report-1-1.xlsx
or for small sites that don’t need to worry about sampling, here is a faster version: GoogleAnalytics-Annual-Report-SmallSite-1-0.xlsx

This workbook requires the Analytics Edge Core Add-in and either the Free or Pro version of the Google Analytics Connector.

7 Day Cohort Analysis

Basic Add-in, Google Analytics Connector

7-day-cohort-analysisThis free Excel report from Analytics Edge works with the free Basic Add-in and Google Analytics connector to mimic the 7-day Cohort Analysis report provided in Google Analytics.

Using embedded queries with dynamic segments, the report shows how many of your new website visitors returned to your site over each of the past 7 days.

Use the report as-is to gauge short term campaign effectiveness, or use the technique in your own custom analysis.

Download the workbook: GoogleAnalytics-7DayCohortAnalysis-1-0.xlsx

A companion Help article shows how to make a 12-Month Cohort Analysis and includes a sample report.