Welcome to Analytics Canvas Support!

We want you to get the most out of Analytics Canvas, and we’re proud at nModal of the level of support we give our customers.

 

 

As well, we’ve made a series of online tutorial videos, which will help you get started with step-by-step examples of certain functionalities.

FAQ

Knowledge Base

Analytics Canvas (4)

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.

 


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 (4)

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.


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.


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.

 


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.


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