Google Analytics

Google Analytics: Advanced Reporting Add-on

The Zoho Reports Advanced Reporting Add-on for Google Analytics enables you to easily analyze your Google Analytics data. Its intuitive drag-and-drop interface allows you to quickly create insightful reports and dashboards. SEO/SEM professionals, webmasters, and online marketers can 'slice and dice' their Google Analytics data the way they want, analyze key metrics, and take informed decisions to optimize their SEO/SEM operations.

General

  1. What is Zoho Reports?
  2. What is the Zoho Reports Advanced Reporting add-on for Google Analytics and how does it work?
  3. Who can setup/subscribe to this Zoho Reports add-on?
  4. What is the value that I get, when I subscribe to this add-on?
  5. How does the Zoho Reports add-on for Google Analytics work?
  6. What are the default reports & dashboards created by Zoho Reports, on setting up this add-on?
  7. How secure is Zoho Reports to store my Google Analytics Data?

Pricing

  1. How much does this add-on cost?
  2. What do you mean by 'Users' in the (add-on) pricing plan?
  3. What do you mean by 'Rows' and how is it calculated in the pricing plan?
  4. How do I purchase a paid plan in Zoho Reports?

Setup

  1. How do I setup the Zoho Reports Add-on for my Google Analytics account?
  2. How long should I wait for my Google Analytics data to initially appear in Zoho Reports?
  3. I got this email which said 'Setup Process Failed'/'Synchronization Process Failed'. What should I do?
  4. What data from Google Analytics will be synchronized in Zoho Reports reporting database?
  5. Can I add custom columns or new fields?
  6. Can I edit the Google Analytics-Zoho Reports synchronization setting?
  7. How do I access the reports created in Zoho Reports?
  8. How to create my own reports with this add-on?
  9. Who has access to the reports I create?
  10. What are the modules in Google Analytics on which I could create reports using this add-on?
  11. Will other modules in Google Analytics be supported, for report creation through this add-on & When?
  12. On whose account will the Zoho Reports add-on be setup?
  13. Can I transfer my Zoho Reports add-on to another admin account?
  14. How can I remove the setup?

Reporting Features

  1. What are the report types supported by Zoho Reports?
  2. What are the default reports & dashboards created by Zoho Reports, on setting up this add-on?
  3. Can I modify the default reports that have been created by the Zoho Reports add-on? If so, how?
  4. How do I create reports using Zoho Reports with this add-on? [or] What are the reports that I can possibly make using this add-on?
  5. What are 'Formulas' in reports?
  6. What are the default formulas added by Zoho Reports, on setting up this add-on?
  7. How do I create my own custom formulas in Zoho Reports?
  8. Can I add/modify Google Analytics data from within Zoho Reports?
  9. Can I add new columns to the Google Analytics tables data in Zoho Reports?
  10. Can I add new data tables in this reporting database to create reports & dashboards?
  11. Can I combine data from other sources with the data from Google Analytics to create reports and dashboards?
  12. What are Query Tables?
  13. Can I join data from multiple tables to create reports?

Users, Sharing & Collaboration

  1. How do I share the reports in Zoho Reports with my colleagues?
  2. Why are other members in my organization not able to access the reports created?
  3. How can other members in my organization create reports?
  4. What are the user roles available in Zoho Reports?
  5. Why can't other users edit the reports that I have shared to them?
  6. Can I share the same report created to multiple users with different criteria associated, so that they see different data?
  7. How can I print the reports & dashboards created in Zoho Reports?
  8. How can I email reports & dashboards created in Zoho Reports in a scheduled manner?
  9. Into what file formats can I export the reports & dashboards created in Zoho Reports and how?
  10. How do I embed my reports in my intranet, blog or presentation?

Cross-Functional Analytics with Popular Business Applications

  1. What are the popular business applications that I can integrate Google Analytics with?
  2. How can I analyze the data from the business applications along with Google Analytics
  3. Will a relationship (lookup) be created between Google Analytics and the third party applications that I integrate it with?

Help & Support

  1. How do I get technical support on Zoho Reports add-on?
  2. Can I have someone from Zoho do a demo of this add-on for me?

General

1. What is Zoho Reports?

Zoho Reports is an on-demand reporting and business intelligence solution that helps you get new insights on your business information through its powerful and flexible online business intelligence engine. You get powerful reports in minutes, with no IT help. It offers the following important capabilities.

  • Complete online reporting & business intelligence service accessible anytime and anywhere.
  • Easy to adopt 'spreadsheet-like' interface for data analysis and report creation.
  • Powerful drag & drop based reporting features for quick report creation and publishing.
  • Visual analysis capability for in-depth analysis and to slice & dice your data.
  • Supports dashboards, charts, pivot tables, summary and simple tabular reports.
  • Supports data import from variety of file formats including Excel, Open Office, CSV, TSV, HTML, XML and JSON. Data can also be imported from cloud storage/drives (Google Drive, Zoho Docs, Dropbox, Box and OneDrive) and web URLs. Also supports periodic scheduling of import.
  • Push data from traditional in-house applications, SQL  & NoSQL databases with batch tools or API (application programming interface).
  • Integrated with Google Analytics, to provide advanced reporting on data collected from Google Analytics. Similar integrations available for popular business applications like Zoho CRM, Salesforce, MangeEngine ServiceDesk Plus, Zoho Projects, Zoho Recruit, Zoho BugTracker etc.
  • Supports reports creation by joining data across related data sets.
  • SQL (Structured Query Language) driven querying is also supported for powerful report creation.
  • Real-time collaboration by sharing data, reports & dashboards in read or read-write modes with your colleagues. You could also notify reports via email.
  • Email, export and print reports in variety of formats. You can also setup scheduled emailing of reports.
  • Embed reports within your websites, web applications and blogs.
  • Highly secure through user login with support for HTTPS (SSL connection). All your data and reports are hosted in highly secure datacenters.
  • Web APIs (HTTP based & Zoho CloudSQL) to tightly integrate and interact with your business applications.
  • Zero maintenance cost & low cost.

2. What is the Zoho Reports advanced reporting add-on for Google Analytics and how does it work?

The Zoho Reports advanced reporting add-on for Google Analytics brings in all the capabilities of Zoho Reports described above, to Google Analytics. It comes with the following features/benefits.

  • A full-featured business intelligence (BI) and reporting tool that can slice & dice your Google Analytics data to create any report/dashboard you require.
  • Pre-packaged set of 50+ reports and dashboards that anyone using Google Analytics will find great value in.
  • Create your own reports and dashboards based on not only your Google Analytics data but also from any other data source (eg., Excel spreadsheets etc) that you would wish to combine with your Google Analytics data.
  • Drag & drop based reporting & analysis that could be used by any business user. No technical knowledge required. No scripting/querying required.
  • Collaboratively work with your colleagues when creating new reports/dashboards on your Google Analytics data. Easily share & embed the reports you create.
  • Schedule and email your reports whenever your want.
  • Export your reports as PDF, Excel, CSV, JPG etc files to your desktop and print them for offline consumption.

3. Who can setup/subscribe to the Zoho Reports add-on?

Any Google Analytics user can set up this add-on. You can choose any of the available plans in Zoho Reports, including the Free plan. For setting up the add-on, refer to the step-by-step instructions as described here.

4. What is the value that I get, when I set up/subscribe to this add-on?

As a Google Analytics user, subscribing to this add-on brings you immense benefits. You get to look at your Google Analytics data in ways you haven't looked at before. Using this Zoho Reports add-on enables you to do powerful analysis of your Google Analytics data and create insightful reports & dashboards. Like say, knowing your top/bottom performing landing pages, tracking various metrics (users, sessions, pageviews etc) across dimensions (landing page, geo location, operating system, browser etc), and do much more.

Zoho Reports' drag-and-drop based reporting is so easy to use that you could create any report or dashboard on your Google Analytics data, with basic technical knowledge and share them to your colleagues. No scripting or querying skills are required. 

5. How does the Zoho Reports add-on for Google Analytics work?

The Zoho Reports advanced reporting add-on Add-on for Google Analytics works as below.

  • Google Analytics user creates an account in Zoho Reports.
  • The user configures the Google Analytics account from within Zoho Reports, by authenticating with her Google Analytics username/password.
  • The user initializes the data sync process.
  • The data from Google Analytics will be imported into the configured Zoho Reports account automatically. Depending on the amount of data in Google Analytics, the initial import can take a few minutes to a few hours.
  • Then on, the data will be continuously synched between Google Analytics & Zoho Reports, at times that the user has configured.
  • Along with the data from Google Analytics, 50+ insightful & hand-picked reports and dashboards are provided by default.
  • The Google Analytics user who configured the add-on, can share the reports to his/her colleagues and clients.
  • New ad hoc reports can be created by the users of the add-on.
  • Refer to this slide show to know more about how to setup the Zoho Reports add-on.

6. What are the default reports & dashboards created by Zoho Reports, on setting up this add-on?

When you setup/configure the Zoho Reports add-on, 50+ default reports/dashboards are automatically created. These hand-picked reports will be pretty useful in analyzing your Google Analytics data effectively. For example, campaign reports, geo reports, platform/system reports etc.

You can quickly review the default reports that would be created from the sample reporting database listed below:

https://reports.zoho.com/ZDBDataSheetView.cc?DBID=779360000003326003

For more details about the reports supported for Zoho Reports Advanced Reporting Add-on for Google Analytics, refer to Reporting Features section.

7. How secure is Zoho Reports to store my Google Analytics Data?

In Zoho we give utmost importance to ensure our customers' data is both SAFE and SECURE. We have very stringent processes and systems in place to ensure the same. To know more about our security practices, we recommend you to go through the following policy documents:

Zoho Security Practices & Policies: https://www.zoho.com/security.html
Zoho Security Practices An Overview:http://blogs.zoho.com/general/security-practices
Zoho Privacy Policy:https://www.zoho.com/privacy.html
Zoho Terms of Service: https://www.zoho.com/terms.html

In case you have any further questions or concerns, please write to us at support@zohoreports.com.

Pricing & Trial

1. How much does this add-on cost?

To use the Zoho Reports advanced reporting add-on for Google Analytics, you can choose any of the available plans in Zoho Reports, including the Free Plan (Refer to the Zoho Reports pricing page). This add-on can be set up in both free and paid Google Analytics accounts.

You can subscribe to any of the paid plans in Zoho Reports as follows (after you set up the add-on):

  1. Log in to your Zoho Reports account.
  2. Click the Subscription link at the top right.
  3. In the Upgrade tab/page, choose the plan you want to subscribe to in Zoho Reports.
Note 1: Ensure that you subscribe to Zoho Reports, only from the account that was used to setup the Google Analytics - Zoho Reports Add-on.
Note 2: If you are a Google Analytics user who need to import data from multiple accounts/properties, you have to subscribe to at least the Professional plan of Zoho Reports.

2. What do you mean by 'Users' in the (add-on) pricing plan?

Anyone to whom you privately share your databases, tables (data), reports and dashboards, created in Zoho Reports, for collaboration is considered a "User" in Zoho Reports. A user is identified by his/her unique email address, with which their Zoho Reports account was created/registered.

Suppose you subscribe to the Zoho Reports Standard plan, you can privately share the data/reports in your account and collaborate with 4 other persons. Now your Zoho Reports account is said to have 5 users (including yourself).

3. What do you mean by 'Rows' and how is it calculated in the pricing plan?

In Zoho Reports, a row or record is defined in the same context as in a database (or spreadsheet). In simple terms, a table consists of rows (records) and columns (fields). Each row in a table represents a set of related data and has the same structure. For example, in a table that represents "Geo", each row would represent a record of metrics pertaining to a date/time, sub-continent, country, city etc. The number of rows calculated for pricing, is the sum of all rows/records stored across all your database tables in your Zoho Reports account.

4. How do I purchase a paid plan in Zoho Reports?

This add-on can be setup in all editions of Zoho Reports including the Free plan. In case you would like to subscribe to any of the paid plans in Zoho Reports, please follow the below steps:

  1. Login to Zoho Reports.
  2. Click the Subscription link at the top right.
  3. In the Upgrade tab/page, choose Standard Edition or above and subscribe.
Note 1: Ensure that you subscribe to the Zoho Reports paid plan only from the Zoho Reports account from where you set up the Google Analytics Add-on.
Note 2: If you are a Google Analytics user who need to import data from multiple accounts/properties, you have to subscribe to at least the Professional plan of Zoho Reports.

Setup

1. How do I setup the Zoho Reports Add-on in my Google Analytics account?

Setting up the Zoho Reports add-on is easy. Please follow the below steps:

  • Sign up for a Zoho Reports account using the 'Sign Up' link provided. This will setup a free 15-day trial account in Zoho Reports Standard edition.
  • Confirm your Zoho account by clicking the confirmation link received via email from Zoho.
  • Configure the Zoho Reports add-on trial by following the step by step instructions as provided in the below slide show.

You will be configured for a 15-day free trial of Zoho Reports Standard edition. You will receive an email after the first batch of data from Google Analytics gets imported into Zoho Reports. Once this initial data from Google Analytics gets imported into Zoho Reports, subsequent changes made in Google Analytics will automatically get synchronized into Zoho Reports at the scheduled synchronization time.

Refer to the below slide show for setting up the add-on, with step-by-step instructions.

Note: If you are a Google Analytics user who need to import data from multiple accounts/properties, you have to subscribe to at least the Professional plan of Zoho Reports.

2. How long should I wait for my Google Analytics data to initially appear in Zoho Reports?

After configuring the Advanced Analytics in your Google Analytics account, wait for at least a couple of hours for all your Google Analytics data to be imported into Zoho Reports. You will receive an email when the import/sync is complete and is ready for creating reports over the same.

Once the initial data synchronization is done, subsequent changes to your data in Google Analytics will automatically be synchronized into Zoho Reports at the scheduled times you have specified during setup.

3. I got this email which said 'Setup Process Failed'/'Synchronization Process Failed'. What should I do?

The import/sync process of your Google Analytics data can fail sometimes, due to a variety of reasons. Hence you may receive such mails occasionally. The Zoho Reports team will look into it immediately and get back to you, after taking the required corrective action.

Case 1: You will receive the Setup Process Failed mail when there is a failure during the initial fetch. In this case we request you to:

  • Open the database in which you have setup the add-on. 
  • Click the Google Analytics button (or Data Sources button - in the case where the database contains multiple tables) in the Explorer tab.
  • In the Data Sources tab that appears click the Retry Now link. 
  • If the issue persists please do write to support@zohoreports.com. We will look into it and get back to you immediately.

Case 2: You will receive the Synchronization Failed mail if there is any failure during the data synchronization process between Google Analytics and Zoho Reports, after the initial setup & import of data. This might be a momentary failure due to any internal issues. This import schedule will get suspended if there are five successive failures. 

4. What data from Google Analytics will be synchronized from Google Analytics into Zoho Reports Reporting Database?

The below Google Analytics data will be synchronized by default into Zoho Reports.

Zoho Report TableFields (Columns)
AdWordsDimensions: Date, Destination URL, Distribution Network, Campaign, Ad Group, Ad Content, Keyword

Metrics: Sessions, Bounces, Impressions, Clicks, Cost, Transactions, RPC

Event TrackingDimensions: Date, Page, Landing Page, Event Category, Event Action

Metrics: Total Events, Unique Events, Event Value, Sessions With Event

GeoDimensions: Date, Landing Page, Sub Continent, Country, Region, City

Metrics: Users, Sessions, Session Duration, Organic Searches, Bounces, Pageviews, Unique Pageviews, Entrances, Exits, Time on Page

GoalDimension: Date, Completion Location, Previous step 1, Previous step 2, Previous step 3

Metrics : Starts, Completions, Value, Sessions are the metrics

NetworkDimensions: Date, Landing Page, Network Domain, Service Provider

Metrics: Users, Sessions, Session Duration, Organic Searches, Bounces, Pageviews, Unique Pageviews, Entrances, Exits, Time On Page

Page TrackingDimensions: Date, Page, Page Title, Landing Page, Next Page, Previous Page, Exit Page

Metrics: Users, Sessions, New Users, Organic Searches, Bounces, Pageviews, Unique Pageviews, Entrances, Exits, Time On Page

Platform or DeviceDimensions: Date, Landing Page, Browser, Browser Version, Language

Metrics: Users, Sessions, Session Duration, Organic Searches, Bounces, Pageviews, Unique Pageviews, Entrances, Exits, Time On Page

SystemDimensions: Date, Landing Page, Device Category, Operating System, Operating System Version, Screen Resolution

Metrics: Users, Sessions, Session Duration, Organic Searches, Bounces, Pageviews, Unique Pageviews, Entrances, Exits, Time On Page

Traffic SourcesDimensions: Date, Traffic Page, Campaign, Referral Path, Source, Medium, Keyword

Metrics: Users, Sessions, Session Duration, Organic Searches, Bounces, Pageviews, Unique Pageviews, Entrances, Exits, Time On Page

UsersDimensions: Page, Landing Page, User Type, Session Count, Days Since Last Session, Session Duration Bucket

Metrics: Users, Sessions, Session Duration, Organic Searches, Bounces, Pageviews, Unique Pageviews, Entrances, Exits, Time On Page

5. Can I add custom columns or new fields?

No, you can't add custom columns or new fields to the Google Analytics database tables in Zoho Reports, as of now. We plan to support custom fields/columns in a future update.

6. Can I edit the Google Analytics - Zoho Reports setup?

Yes, you can edit the setup by following the steps below:

  • Login to your Zoho Reports account (the administrator account in which Google Analytics was set up).
  • Open the Google Analytics database for which the settings has to be modified.
  • Click on Google Analytics button in the Explorer tab.

  • In the Data Sources tab, click Edit Setup.
  • Modify the setup settings and click Save

7. How do I access the reports created in Zoho Reports?

Once the initial data import/synchronization between Google Analytics and Zoho Reports is completed successfully, you can start accessing the reports created in Zoho Reports, and also create your own reports & dashboards, as described below.

  • If you are the Google Analytics user who configured the Zoho Reports add-on (the administrator of the account), login to your Zoho Reports account, and open the required Google Analytics database directly.
  • For the other Google Analytics users of the organization, the administrator has to enable sharing to your account in the Zoho Reports add-on. Refer How to Share Reports & Dashboards in Zoho Reports to know about how to share reports and dashboards to other users in this add-on.

8. How do I create my own reports with this add-on?

Also refer to the following video demos:

Note: For creating your own reports using this add-on, you can do it only if your administrator who has setup this add-on, has shared the tables (that contains the Google Analytics data) in Zoho Reports to your account. Refer How to Share Reports & Dashboards question.

9. Who has access to the reports I create?

By default, the reports you create are accessible only to you. However, you can share the reports with your colleagues using the Sharing options available in Zoho Reports. Refer to the How to Share Reports & Dashboards question.

10. What are the profiles (modules) on which I could create reports using this add-on?

You can choose data from the following profiles of Google Analytics to be synced with Zoho Reports.

  • AdWords
  • Event Tracking
  • Geo
  • Goal
  • Network
  • Page Tracking
  • Platforn or Device
  • System
  • Traffic Sources
  • Users

Each of the above profile's data is stored as a 'Table' in Zoho Reports. Default reports are based out of the above profiles (tables). You can create your own reports & dashboards over the above profiles.

We plan to enhance the synchronization options of Google Analytics data in the near future.

11. Will other data from Google Analytics be supported, for report creation through this add-on. When?

We plan to support synchronization of more Google Analytics data (like e-commerce etc) in the near future. Support for other data will also be prioritized based on user demand.

12. On whose account will the Zoho Reports add-on be setup?

It will be setup in the Zoho Reports account that the Google Analytics user creates, and uses as part of the setup process of this add-on. It is this account which will serve as the master admin account of Zoho Reports.

13. Can I transfer my Zoho Reports Advanced Analytics setup to another admin account?

At present, we do not provide this option. Please do mail to support@zohoreports.com. We will assist you on this.

14. How can I remove the setup?

To remove the setup,

  • Login to your Zoho Reports account.
  • Open the corresponding reporting database.
  • In the Explorer tab, click Google Analytics button (or Data Sources button - in the case where the database contains multiple connector setups).
  • In the Data Sources tab that opens click the Settings icon and select Remove Data Source. 

Reporting Features

1. What are the report types supported by Zoho Reports?

Zoho Reports supports a wide variety of reports.

  • Charts
    • Pie
    • Bar
    • Stacked bar
    • Line
    • Scatter
    • Area
    • Stacked Area
    • Web
    • Funnel
    • Doughnut
    • Combination Chart
  • Pivot tables (Matrix Views)
  • Summary view
  • Tabular view
  • Dashboards (multiple reports arranged in the same page)

2. What are the default reports & dashboards created by Zoho Reports, on setting up this add-on?

When you setup/configure the Zoho Reports add-on, 50+ default reports/dashboards are automatically created. These hand-picked reports will be pretty useful in analyzing your analytics data. 

You can quickly review the default reports that would be created, from the sample database listed below:
https://reports.zoho.com/ZDBDataSheetView.cc?DBID=779360000003326003

For more details about the reports supported for Zoho Reports Advanced Reporting Add-on for Google Analytics, refer to Reporting Features section.

3. Can I modify the default reports that have been created by the Zoho Reports add-on? If so, how?

Yes, you can modify the default reports. If you are the Google Analytics administrator who set up the Zoho Reports add-on, or a 'Database Owner' (Refer Managing Users in Zoho Reports), click the 'Edit Design' button in a report's toolbar and you will be able to make the changes.

If you are just a user who's been shared the report, click Save > Save As and save the report as a new report. You can edit this copied report now.

4. How do I create reports using Zoho Reports with this add-on? [or] What are the reports that I can possibly make using this add-on?

You can create any type of report with this Zoho Reports add-on. All you have to do is open the appropriate module table(s) over which a report is to be created, click 'New' and choose any type of report you would want to create.

Use the intuitive drag-and-drop based designer of Zoho Reports to create the report required. To know more, view this slide show on "How to Create Reports?". You can also quickly view the type of reports & dashboards that are created by default, from the sample given below.

https://reports.zoho.com/ZDBDataSheetView.cc?DBID=779360000003326003

5. What are Formulas in Zoho Reports?

Formulas, as the name indicates are calculations (metrics) that you could define in Zoho Reports to help you create the required reports. Zoho Reports provides a powerful formula engine to create any type of calculations required, to enable creating the required reports. You can create formulas as easy as you would create a formula in a Spreadsheet like Excel.  Refer Adding Formulas in Zoho Reports to know more.

6. What are the default formulas added in the 'Google Analytics' database, on setting up this add-on?

The below table lists all the default formulas that will be created in the 'Google Analytics' database by default. You will find these formulas pretty useful, in creating reports & dashboards in Zoho Reports. Also these formulas are used in the reports created by default in your database. You can view them by selecting the corresponding table and click "Add -> Edit Formulas" in the toolbar.

The below table lists all the default formulas that are created in the AdWords table:

Formula NameFormula TypeFormulaDescription
CPCCustomsum("AdWords"."Cost")/
sum("AdWords"."Clicks")
Cost Per Click
CTRCustom100*sum("AdWords"."Clicks")/
sum("AdWords"."Impressions")
Click Through Rate
CPTCustomsum("AdWords"."Cost")/
sum("AdWords"."Transactions")
Cost Per Transaction

The below table lists all the default formulas that are created in the Event Tracking table:

Formula NameFormula TypeFormulaDescription
Events per Sessions with EventAggregatesum("Event Tracking"."Total Events")/sum("Event Tracking"."Sessions With Event")Sums up the events and divides by the sum of sessions with event

The below table lists all the default formulas that are created in the Geo table:

Formula NameFormula TypeFormulaDescription
% ExitsAggregatesum("Geo Network"."Exits")/sum("Geo Network"."Pageviews")Sums up the exits and divides by total pageviews, and expresses as percentage

The below table lists all the default formulas that are created in the Goal table:

Formula NameFormula TypeFormulaDescription
AbandonsCustom "Starts" - "Completions"Proivdes the number of visits abadoned after starting the goal.
% Goal CompletionsCustom("Goals"."Completions"/"Goals"."Starts")*10Calculats the percentage of goal
completion.
Converstion RateAggregatesum("Goals"."Completions")/
sum("Goals"."Sessions")*
100
Calculates the conversion rate.
Abandon RateAggregatesum("Goals"."Abandons")/
sum("Goals"."Starts")
Calculates the abandon rate.

The below table lists all the default formulas that are created in the Page Tracking table:

Formula NameFormula TypeFormulaDescription
Bounce RateAggregate100*sum("Page Tracking"."Bounces")/sum("Page Tracking"."Sessions")Sums up the bounces and divides by the sum of sessions, and expresses as percentage

The below table lists all the default formulas that are created in the Platform or Device  table:

Formula NameFormula TypeFormulaDescription
Browser with VersionCustomconcat_ws( ' ',"Browser","Browser Version")Joins (concatenates) the browser name and version strings, and presents as a single string

The below table lists all the default formulas that are created in the System table:

Formula NameFormula TypeFormulaDescription
OS with VersionCustomconcat_ws(' ',"Operating System","Operating System Version")Joins (concatenates) the OS name and version strings, and presents as a single string.

The below table lists all the default formulas that are created in the Traffic Sources table:

Formula NameFormula TypeFormulaDescription
Sessions Per UserAggregatesum("Traffic Sources"."Sessions")/sum("Traffic Sources"."Users")Sums up the sessions and divides by the sum of users

The below table lists all the default formulas that are created in the Users table:

Formula NameFormula TypeFormulaDescription
Bounce RateAggregate100*sum("Users"."Bounces")/sum("Users"."Sessions")Sums up the bounces and divides by the sum of sessions
Avg Session DurationAggregatesum("Users"."Session Duration")/sum("Users"."Sessions")Sums up the session duration values (in seconds) and divides by the sum of sessions
Pages per SessionAggregatesum("Users"."Pageviews")/sum("Users"."Sessions")Sums up the pageviews and divides by the sum of sessions
Sessions per UserAggregatesum("Users"."Sessions")/sum("Users"."Users")Sums up the sessions and divides by the sum of users

7. How do I create my own custom formulas in Zoho Reports?

Refer to the Adding Formulas in Zoho Reports help page. 

8. Can I add/modify data to the Google Analytics tables from within Zoho Reports?

No, you cannot. Data from Google Analytics gets automatically synched into Zoho Reports tables. You cannot edit any of this data or add new data records from within Zoho Reports.

9. Can I add new columns to the Google Analytics tables from within Zoho Reports?

No, you cannot add new columns. But you can add Formula Columns and Aggregate Formulas (i.e., calculated fields) to these tables to help you create powerful reports. Refer Adding Formulas in Zoho Reports to know more.

10. Can I add new data tables in this reporting database to create reports & dashboards?

Yes, you can add new data tables. Click New > New Table and you can add new tables to the existing Google Analytics reporting database.

With this feature, you can import new data or add them manually into your reporting database to analyze and create reports combining this with the Google Analytics data. You can import data from files & feeds like Excel, HTML, CSV, JSON, XML, Google Drive, Zoho Docs, Dropbox, Box and Web URLs. You can also import data from Local SQL & NoSQL databases like Oracle, SQL Server, DB2, MySQL, PostgreSQL, MS Access, Hadoop, Cassandra etc,. The databases can also be in the cloud.

Refer:

11. Can I combine data from other sources with the data from Google Analytics to create reports and dashboards?

Yes, you can combine data from your other sources with your Google Analytics data for analysis. 
To do this, you need to add/import a new data table into the Google Analytics reporting database and then define a look-up to join it with the synchronized table from Google Analytics.

To define a lookup relationship between two tables, it is essential that the tables have at least one column which is common between them. Follow the below steps to look up a column from Google Analytics along with the data from any other source.

  • Open the corresponding table, right click the column header and select Change to Lookup Column.
  • In the Change to Lookup Column dialog that opens, select the column to look up.
  • Click Ok

Please do note that you can create Lookup only to columns in the tables that are not from the same data source.

12. What are Query Tables?

Zoho Reports allow you to pull the data required by writing standard SQL SELECT queries. This feature is called Query Tables. With Query Tables you can also combine data from different tables and create reports from the same. View this demo video to know about how to create Query Tables in Zoho Report.

If you are just looking to join tables to create reports, you can use easy to use auto-join feature in Zoho Reports, instead of Query Tables. Refer to  Joining Tables in Zoho Reports for detailed help on this.

 13. Can I join data from multiple tables to create reports?

Yes, you can join data from multiple tables to create the reports. Refer to Joining Tables in Zoho Reports for detailed help on this.

Users, Sharing & Collaboration

1. How do I share the reports in Zoho Reports with my colleagues?

You can share the default reports provided in the Zoho Reports add-on and also the reports you create, with your organization employees/colleagues. Refer to Sharing and Collaboration help page for more.

Once you privately share a report to your colleagues they will be able to access the same as you do, following the steps below:

  1. User (each of your colleagues who you have shared the Google Analytics database with) creates a free Zoho Reports account at https://www.zoho.com/reports (using the same email address that you shared reports with)
  2. Once logged in, user clicks the Shared to Me tab.
  3. The Google Analytics reporting database that you shared is listed there.
  4. Clicking it, the user will be able access the reports & data shared to them.
Note:

1. If you share the data tables in the Google Analytics reporting database to users, they will be able to create their own reports over the same.

2. If you add a user as a Database Owner in the Google Analytics reporting database created in Zoho Reports (Refer Managing Users in Zoho Reports, to know how to add Database Owners), the user will be able access all the data & reports, create new reports and do any operation that you could do on the reporting database.

2. Why are other members in my organization not able to access the reports created?

When you configure the Google Analytics - Zoho Reports add-on, the tables and reports will be available only to you, by default. You have to share the 'Google Analytics' database with other members of the organization. Only then will the default reports be accessible by those members.

There could be a another case where you shared the database with other members in the organization. And the member creates his/her own reports. Those reports will be available only to him/her alone, unless he/she shares them with others.

To know more, refer to Sharing and Collaboration help page.

3. How can other members in my organization create reports?

The Google Analytics user who set up the add-on should share the tables present in Google Analytics  database with other members of the organization. Once this is done, the shared users can create reports based on those tables.

To know more, refer to Sharing and Collaboration help page.

Note: If you add a user as a Database Owner in the Google Analytics reporting database created in Zoho Reports (Refer Managing Users in Zoho Reports, to know how to add Database Owners), the user will be able access all the data & reports, create new reports and do any operation that you could do on the reporting database.

4. What are the user roles available in Zoho Reports?

Zoho Reports supports fine-grained access control. The following are are user roles that are supported in Zoho Reports:

1. Administrator (Master Admin): The User account in Zoho Reports who had setup the add-on will be the administrator of the Zoho Reports account.

2. Database Owner: The Administrator can designate one or more users as Database Owners. A Database Owner has all permissions to add, delete, modify reports, table rows and even tables. A Database Owner can share the database tables/reports with other users. A Database Owner cannot delete or rename a database.

3. User: A user has the least privilege in the hierarchy. He/She can access the reports, dashboards & tables which are shared to them by the Administrator/Database Owner. Users can access the shared information only by log-in into his/her account in Zoho Reports. Unless the Administrator or a Database Owner shares a table with a User, the user cannot create any reports on his/her own. Also, an Administrator/Database Owner can decide to set specific permissions when sharing a report (Read Only, Export Data, View Underlying Data, Share with Others) or a table (Read Data, Export Data, Add/Delete/Modify Rows, Share View / Child Reports).

Refer to Managing Users in Zoho Reports, to know more about different user roles in Zoho Reports. Also refer to Sharing and Collaboration help page.

5. Why can't other users edit the reports that I have shared to them?

This is the expected behavior. If the user being shared to is a database owner, he/she can edit the reports. If a normal user wants to edit report, what he/she can do is to use Save As to save the report in a different name in his account. This report can then be edited.

6. Can I share the same report created, to multiple users with different criteria associated so that they see different data?

Yes, you can. Refer to this help documentation section to know how this can be done.

7. How can I print the reports & dashboards created in Zoho Reports?

To print a report/dashboard, please follow the below steps.

  1. Open the report or dashboard that you want to print.
  2. Click the 'Export' button.
  3. You will see options to save the report/dashboard in a variety of file formats like PDF, Excel, CSV, JPG etc.
  4. Choose the format you want and save the file to your desktop. For printing PDF is the recommended format.
  5. Open the file and print it.
Note: If you are a user to whom a report has been shared and you want to take a print, ensure you have been provided the Export permission by the Administrator to the report, only then you will be able to print the report.

8. How can I email reports & dashboards created in Zoho Reports in a scheduled manner?

If you are the Administrator of the Zoho Reports add-on or a 'Database Owner', you can schedule reports and dashboards to be emailed automatically. You can do this is as follows:

  1. Select the Report/Dashboard to be emailed in Zoho Reports.
  2. Select "Export -> Email this View" from the toolbar.
  3. Follow the instructions in the screen and provide the required input to setup a email schedule.

9. Into what file formats can I export the reports & dashboards created in Zoho Reports and how?

Reports and dashboards can be exported in a variety of file formats.

  • Charts
    • CSV/Excel
    • PDF
    • HTML
    • PNG/JPEG
  • Pivot/Tabular views
    • CSV/Excel
    • PDF
    • HTML
  • Dashboards
    • PDF
    • HTML

You can export a report/dashboard in Zoho Reports as follows.

  1. Select the Report/Dashboard to be exported in Zoho Reports.
  2. Select "Export -> Export this View" from the toolbar.
  3. Follow the instructions in the screen and provide the required input to export the report(s) selected.

10. How do I embed my reports in my website, intranet, blog or presentation?

To Embed your report/dashboard in a Website/Blog, follow the below steps:

  • Open the report/dashboard that you wish to embed.
  • Click on the publish icon and select Embed in a Website/Blog
  • In the Embed snippet for dialog, select the necessary options for customization..
  • You may also specify a filter criteria if needed
  • Access with login, prompts the user to enter his login credentials to view the report/dashboard. Also, the database owner/administrator should have shared the report with the user
  • Access without login does not require the user to login, the report would be publicly accessible to anyone.
  • Once you select the necessary options copy the embed snippet and paste it in your website/blog, wherever you wish to embed the report.

On embedding, you will see the corresponding report within your web page, application or blog. Refer Embedding in Web Pages/Blogs to know more about this.

Cross Functional Analytics with Popular Business Applications

1. What are the popular business applications that I can integrate this connector with?

You can integrate and perform cross-functional analytics with almost all the business applications that Zoho Reports offers integration with. 

2. How can I analyze the data from the other business applications along with Google Analytics?

To import data from business apps,

  • Open the reporting database in which you have setup the connector
  • Click the Import Data button
  • In the Create New Table tab that opens, select the application that you wish to import.
  • Provide the necessary authentications
  • Select the necessary modules and fields
  • Select the schedule import options
  • Click Create

3. Will the related modules from Google Analytics and other third-party application be created automatically?

No, a lookup relationship will not be created between the Google Analytics modules and the modules of the application that you are trying to import automatically. 

To manually create a lookup relationship refer this help link - https://www.zoho.com/reports/help/table/joining-tables.html

Help & Support

1. How do I get technical support on Zoho Reports add-on?

We offer 24x5 technical support (Monday to Friday). In case if you need our assistance kindly do mail us your questions to support@zohoreports.com.

You can also reach out to us on our toll free number 

United States:  +1 (888) 900 9646

United Kingdom:  +44 (20) 35647890

Australia:  +61-2-80662898

India:  +91-44-67447000

2. Can I have someone from Zoho do a demo of this add-on to me?

Yes, certainly. Register for a demo in this page.