Welcome to Analytics Canvas Support!

We want you to get the most out of Analytics Canvas and we’re here to help you get up to speed with the tool and simplify your reporting and analysis processes. See what analysts like you have said about our support in the Google Analytics App Marketplace.

Check out our Getting Started page, and review our blog for helpful posts on analyzing multiple Google Analytics accounts, reducing and eliminating sampling, automating reports, and getting the most out of your Google Analytics Premium account.

Helpful Links

  

Video Gallery

We’ve made a series of tutorial videos designed to introduce you to Canvas and help you get started with step-by-step examples.
getting_started_videos

FAQ

Knowledge Base

We’ll continue to update this section as customers and trial users write in with questions.  If you can’t find the answer you’re looking for, write to us at support@analyticscanvas.com or contact us through the site.

Analytics Canvas (6)

Is Analytics Canvas available on a Mac?

Yes and no. Analytics Canvas requires Windows components to work.

We have employees and customers who are Mac users and have installed Parallels or VM Ware to run Analytics Canvas on their Macs.  Both offer free trials, can be had for less than $80 and are elegant solutions that allow you to run Windows programs seamlessly.

Alternatively, we offer services and can work with you to build and automate the reports you need. Contact us to learn more.

 


Please check your spam folders and if you’re using Gmail on the web, please check the Social, Promotions, Updates and Forums tabs as we’re finding that it will often end up in one of those.

If you can’t find it, please send an email to support @ analyticscanvas.com and we will get your key to you asap.

 


Absolutely not. Analytics Canvas establishes a connection between your desktop, laptop or server and various databases and file types, including the Google Analytics API. The data is sent from the source to your machine and is never captured or read by us. You can read more about our data usage policy here.


How do I export my Google Analytics data to Excel? 

Export blocks allow you to write your data into a number of different database and file types, including Microsoft Excel.

Whether you have a pre-existing template that you want to feed your data into or if you just want to get your data into Excel to create charts and tables, you can simply drop an Excel export block onto your canvas, connect it to your data source, and configure the block to write the data to the appropriate location.

The first three steps are the same whether you’re using an existing workbook / templates or a new workbook.

  • Right click on any open area of the canvas and choose "Add Export Block > Excel Workbook Export"
  • Connect it to the data block you want to export
  • Click on the center of the Excel block to bring up the block configuration menu in the lower third of the Canvas and choose "New Workbook"

Export to an Empty Excel Workbook

  • Choose "Add new workbook"
  • Give your workbook a name, choose your Excel version and if you’d like, add a date-stamp to the file
  • Choose "OK"

Export_to_Empty_Excel_Workbook

  • Under “Location to insert data set in Workbook”, name your worksheet and choose "Pick"
  • Point your mouse to the top left cell where you want your data to be written and click on it.
  • Choose OK.

That’s it!  When you run your canvas, the data will be written to your workbook.

Export to an Existing Template

Let’s say you’ve already created a dashboard like the one below but instead of recreating it each time, you want to grab the template and populate it with the most recent data.

beautiful_heat_map

 

In that case:

  • Choose "New Workbook" > "Start with a template".
  • Name your export and click "OK"

Export_to_a_Template

 

  • Choose "Pick" and you can navigate through the existing tabs and cells.  Cells that already have data being written to them are highlighted in yellow
  • Choose the top left cell where your data will be written.  Your selected area will be highlighted in green..
  • Click "OK".

That’s it!  Next time you run your canvas, a copy of your template will be made, renamed as specified, and your data will be written into it.

To see your results, choose either "Open last generated workbook" in the Excel export configuration menu or "Open Excel Outputs in the top menu bar.

 


Having trouble getting your Google Analytics data into an Excel file?

There are some limitations to the kinds of dashboards that Canvas can write directly into.  In cases where the Excel file has objects or properties that conflict with what Canvas needs to do, Canvas or the other object will fail.

For example, if the file contains:

  • Report Builder queries from Adobe’s Site Catalyst,
  • custom XML data,
  • other objects from 3rd party add-ins or native tools (which may or may not be on the same worksheets that Canvas is writing to)

the write may fail. Best to inspect properties of the Excel file and remove any hidden fields, XML, or other properties that may cause a conflict.

Excel version matters as well. Those on Office for Mac 2011 will have difficulty if the template or dashboard was built in a newer version of Microsoft Office Excel. Office 2013 is the most feature rich, older versions will not support features such as Slicers and Timelines.

google analytics excel dashboard

If you’re having trouble writing into your Excel file that uses an underlying template, try disabling the advanced features.

In the Excel Export wizard, ensure that the option to disable sparklines and other features is selected, then try to write again.

If the option of writing to another version of Excel is not possible there is another trick that would work. It involves two files, one that Canvas will directly write data into and a second which is the dashboard file. The dashboard would link directly to the data file and would require a refresh after the data file was updated. To read more about how this is done, checkout Microsoft’s support post on the topic.

If you are still having difficulty getting your Google Analytics data into an Excel file using Analytics Canvas, send an email to support@analyticscanvas.com with a description of your issue.  If possible, send the Canvas file as well.  Remember, your data never travels with the Excel file, just the meta-data about the source you’re connecting to (Google Analytics query information, etc.) and the blocks you created.

 

 


Can I transfer my license to a co-worker or another PC that I own? 

Yes!

To use Canvas on another PC, follow these simple steps:

  1. Get your account key, found under Help > About.
  2. On the other PC, download the latest version of Canvas found here.
  3. Once you have Canvas installed go under Help > Activate Account Key and enter your existing license key.

You will have to authorize your GA accounts and if you have any Block Groups, Templates, queries saved to your Query Library or anything else you want to carry over, simply open the folder ~\Documents\My Analytics Canvas\ and delete the folder called “DMCache”, then copy the “My Analytics Canvas” folder to the same location on your new PC.

You’re all set!

It would be best to email support@analyticscanvas.com to advise us of the change.  As long as the old machine is deactivated when the new machine is activated, we will ensure that your account is not charged for having an additional user license.


Automation (1)

Analytics Canvas includes an automation wizard.  Here is a link to the blog post with detailed information about the automation wizard and a step-by-step guide can be found in the related documentation.


Bing ads and cost upload tutorials (2)

With Analytics Canvas it is possible to connect directly to the Bing Ads API.

This gives you all the power of Analytics Canvas to create great analysis, and excel based dashboards from data from all your Bing Ads accounts and campaigns. Read more


This tutorial will show you how to pull data directly from the Bing Ads API and upload it into Google Analytics using the new Cost upload capability. Read more


Google Analytics (3)

I can’t find a certain dimension or metric from Google Analytics in Analytics Canvas. Why is that?

There are two reasons why this might be the case.

  1. The dimension or metrics is not yet available in the Core Reporting API.
  2. The dimension or metric has a slightly different name in the API than it does on the web.

In the first case, there’s nothing we can do.  Generally it takes about 6 months for new dimensions and metrics that are released into the GA web version to make their way into the API.  Analytics Canvas has a strong track record of releasing on the same day as Google makes them available.

In the second case, Google has provided a reference guide to help you map the names.

 For example,

If you configure your query using the dimension and metrics reference guide, you’ll be able to get the results you’re after.


My results from Google Analytics Web are different than what I see through the API in Analytics Canvas.  Why is that?

Analytics Canvas uses the Google Analytics APIs to retrieve your data based on your query. We do not store, access or modify the results in any way before making them available to you in the application. Generally the results from the Web and the API should be the exact same.

On very rare occasions, there are bugs which may cause you to see different results. In order to determine whether the issue is with how the data is being reported through the API or if the issue is with Canvas, the best thing to do is to build your query in the API Explorer and see what is returned.

Most often we discover that there is a filter, segment, or some other variable that is in one query but not the other. However if the queries are the exact same and you’re still getting different results, please capture screenshots of your query in the Web, API Explorer and Analytics Canvas interfaces and send them to support @ analyticscanvas.com

We will dig into the issue with you and if there is a bug, we will take the necessary steps to squash it.


Absolutely! We’ve created a blog post to help you get started, and in Version 1.7 we’ve released a template that allows you to compare multiple Google Analytics accounts. Under “Example templates”, choose “Multi-Site Comparison Example” and you’ll get a Canvas that connects to multiple accounts and compares the number of visitors, average page views per visit, and average time on site. It even outputs into a nice bubble chart that’s ready for your dashboard or report.


Licensing and Account Info (1)

Can I transfer my license to a co-worker or another PC that I own? 

Yes!

To use Canvas on another PC, follow these simple steps:

  1. Get your account key, found under Help > About.
  2. On the other PC, download the latest version of Canvas found here.
  3. Once you have Canvas installed go under Help > Activate Account Key and enter your existing license key.

You will have to authorize your GA accounts and if you have any Block Groups, Templates, queries saved to your Query Library or anything else you want to carry over, simply open the folder ~\Documents\My Analytics Canvas\ and delete the folder called “DMCache”, then copy the “My Analytics Canvas” folder to the same location on your new PC.

You’re all set!

It would be best to email support@analyticscanvas.com to advise us of the change.  As long as the old machine is deactivated when the new machine is activated, we will ensure that your account is not charged for having an additional user license.


Writing to Excel (2)

How do I export my Google Analytics data to Excel? 

Export blocks allow you to write your data into a number of different database and file types, including Microsoft Excel.

Whether you have a pre-existing template that you want to feed your data into or if you just want to get your data into Excel to create charts and tables, you can simply drop an Excel export block onto your canvas, connect it to your data source, and configure the block to write the data to the appropriate location.

The first three steps are the same whether you’re using an existing workbook / templates or a new workbook.

  • Right click on any open area of the canvas and choose "Add Export Block > Excel Workbook Export"
  • Connect it to the data block you want to export
  • Click on the center of the Excel block to bring up the block configuration menu in the lower third of the Canvas and choose "New Workbook"

Export to an Empty Excel Workbook

  • Choose "Add new workbook"
  • Give your workbook a name, choose your Excel version and if you’d like, add a date-stamp to the file
  • Choose "OK"

Export_to_Empty_Excel_Workbook

  • Under “Location to insert data set in Workbook”, name your worksheet and choose "Pick"
  • Point your mouse to the top left cell where you want your data to be written and click on it.
  • Choose OK.

That’s it!  When you run your canvas, the data will be written to your workbook.

Export to an Existing Template

Let’s say you’ve already created a dashboard like the one below but instead of recreating it each time, you want to grab the template and populate it with the most recent data.

beautiful_heat_map

 

In that case:

  • Choose "New Workbook" > "Start with a template".
  • Name your export and click "OK"

Export_to_a_Template

 

  • Choose "Pick" and you can navigate through the existing tabs and cells.  Cells that already have data being written to them are highlighted in yellow
  • Choose the top left cell where your data will be written.  Your selected area will be highlighted in green..
  • Click "OK".

That’s it!  Next time you run your canvas, a copy of your template will be made, renamed as specified, and your data will be written into it.

To see your results, choose either "Open last generated workbook" in the Excel export configuration menu or "Open Excel Outputs in the top menu bar.

 


Having trouble getting your Google Analytics data into an Excel file?

There are some limitations to the kinds of dashboards that Canvas can write directly into.  In cases where the Excel file has objects or properties that conflict with what Canvas needs to do, Canvas or the other object will fail.

For example, if the file contains:

  • Report Builder queries from Adobe’s Site Catalyst,
  • custom XML data,
  • other objects from 3rd party add-ins or native tools (which may or may not be on the same worksheets that Canvas is writing to)

the write may fail. Best to inspect properties of the Excel file and remove any hidden fields, XML, or other properties that may cause a conflict.

Excel version matters as well. Those on Office for Mac 2011 will have difficulty if the template or dashboard was built in a newer version of Microsoft Office Excel. Office 2013 is the most feature rich, older versions will not support features such as Slicers and Timelines.

google analytics excel dashboard

If you’re having trouble writing into your Excel file that uses an underlying template, try disabling the advanced features.

In the Excel Export wizard, ensure that the option to disable sparklines and other features is selected, then try to write again.

If the option of writing to another version of Excel is not possible there is another trick that would work. It involves two files, one that Canvas will directly write data into and a second which is the dashboard file. The dashboard would link directly to the data file and would require a refresh after the data file was updated. To read more about how this is done, checkout Microsoft’s support post on the topic.

If you are still having difficulty getting your Google Analytics data into an Excel file using Analytics Canvas, send an email to support@analyticscanvas.com with a description of your issue.  If possible, send the Canvas file as well.  Remember, your data never travels with the Excel file, just the meta-data about the source you’re connecting to (Google Analytics query information, etc.) and the blocks you created.

 

 


If you’ve got questions, contact us at support@analyticscanvas.com.

Analytics Canvas standard support: email support, 9am to 5pm EST. We aim to respond within one business day at maximum, and our customers tell us they are very impressed with how quickly we respond. Give us a try.

Menu