Welcome to Portal
The Zoho Analytics - Google Analytics integration comes with over 50+ domain specific reports and dashboards organized functionally as page tracking, traffic sources, demographics, geo, events, site speed, e-commerce, and AdWords. This will help you jump start your analysis. Not just that, you can also create your own reports and dashboards using custom modules.
Zoho Analytics is a self-service BI and data analytics software that lets you analyze your data, create stunning data visualizations, and discover hidden insights in minutes.
It offers the following important capabilities:
The Zoho Analytics Advanced Reporting for Google Analytics empowers your website data with advanced reporting and analytical capabilities. This integration enables you as a marketer to 'slice and dice' your Google Analytics data, analyze key metrics, and make informed decisions to optimize your SEO/SEM operations.
This brings in all the capabilities of Zoho Analytics described above to Google Analytics users.
Any Google Analytics user who wishes to implement advanced reporting and analytical capability to their website data can set up this integration.
The advantage of using Zoho Analytics advanced reporting for Google Analytics over the reporting module offered by Google Analytics is mentioned below:
Google Analytics Advanced Reporting is available for free in all the paid plans of Zoho Analytics. Click to learn more about Zoho Analytics Pricing.
Anyone to whom you privately share your Workspace, tables (data), reports and dashboards, created in Zoho Analytics, for collaboration is considered a 'User' in Zoho Analytics. A user is identified by his/her unique email address, with which their Zoho Analytics account was registered.
Suppose you subscribe to the Zoho Analytics Standard plan, you can privately share the data/reports in your account and collaborate with 4 other persons. Now your Zoho Analytics account is said to have 5 users (including yourself).
In Zoho Analytics, 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 "Invoices", each row would represent a single invoice record. The number of rows calculated for pricing is the sum of all rows/records stored across all your Workspace tables in your Zoho Analytics account.
Refer,
You can synchronize your data once every day.
Yes, you can edit the Google Analytics connector synchronization setting if you are the administrator of the Google Analytics Advanced Workspace in Zoho Analytics.
To do so,
Yes, you can synchronize your Google Analytics data instantly when needed.
To synchronize your data instantly:
Yes, you can setup the Google Analytics Advanced Reporting in any of the existing Workspaces or in any of the Advanced Analytics Workspace to analyze data together.
To do this,
Your Google Analytics data will be imported into your Workspace. Refer to this setup presentation.
No, you cannot add/modify data in the Google Analytics data tables. Data from Google Analytics application will automatically get synced into Zoho Analytics in the different tables. You cannot edit any of this data or add new data records from within Zoho Analytics.
However, you can add new tables and add/import data into that, to create reports combining it with the data from Google Analytics. To know more refer Question 12.
No, you cannot add new columns. But, you can add Custom and Aggregate Formulas (i.e., calculated fields) to these tables to derive your own business metrics. Refer Adding Formulas to know more on this.
Yes, you can add new data tables. Click New > New Table to add a new table in the existing Google Analytics Workspace.
With this feature, you can import data from other sources or add them manually into your Workspace to analyze and create reports combining this with your Google Analytics data. You can also import data from other business applications like Zoho CRM, Salesforce CRM etc.
Refer:
At present, we do not provide an option in the user interface. If you require this transfer, please do mail us to support@zohoanalytics.com and we will do this for you.
Once the transfer is done, the new administrator must log in to his Zoho Analytics account and follow the below steps.
You can create reports using the data from the following modules:
The modules in Google Analytics will not be linked by default. If you wish to create reports by combining data from the different modules in Google Analytics, you must first create a lookup relationship between them.
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 create a lookup relationship:
Post that, you can create reports by simply dragging and dropping the columns from the different modules into the respective shelves of the reports designer.
To learn in detail about creating a lookup refer to this help documentation.
Zoho Analytics supports a wide variety of reports.
Formulas, as the name indicates, are calculations that help you derive key business metrics that can be used for reporting and analysis. Zoho Analytics provides a powerful formula engine to create any type of calculations required, to enable creating the required reports. Refer Adding Formulas in Zoho Analytics to know more.
You can create a custom formula by clicking Add > Formula Column/Aggregate Formula in a Table. Refer to the Adding Formulas in Zoho Analytics help page.
The default formulas added by Zoho Analytics are listed below. You can view these formulas by opening the corresponding table and selecting Add > Edit Formulas from the toolbar.
The following are the default formulas in the Site Speed table
Formula Name | Formula | Formula Type | Description |
Avg. Page Download Time (sec) | Column | (" Page Download Time (ms )"/" Page Load Sample ")/1000 | Displays the average time (in seconds) it takes for the page to loading from initiation of the pageview (e.g. click on a page link) to load completely in the browser. |
Avg. Domain Lookup Time (sec) | Column | (" Domain Lookup Time (ms )" /" Page Load Sample ") /1000 | The average time spent to DNS lookup for the page in seconds |
Avg. Redirection Time (sec) | Column | (" Redirection Time (ms) "/" Page Load Sample ")/1000 | The average time spent in redirecting the page in seconds |
Avg. Page Load Time (sec) | Column | (" Page Load Time (ms) "/" Page Load Sample ")/1000 | The average time taken in seconds for the page to load |
Avg. Server Response Time (sec) | Column | (" Server Response Time (ms) "/" Page Load Sample ")/1000 | The average time taken in seconds for your server to respond to a user request. |
Avg. Server Connection Time (sec) | Column | (" Server Connection Time (ms) "/" Page Load Sample ")/1000 | The average time taken in seconds for the user to connect to the server |
Yes, you can combine data from your other sources with your Google Analytics application data for analysis.
To do this, you need to add/import a new data table into the Google Analytics Workspace as explained in the previous question and then define a look-up to join it with the 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.
Yes, you can join data from multiple tables to create the reports. Refer to the previous question for detailed help on this.
Query Table is a feature that enables you to prepare data for easy reporting and analysis. You can combine data from one or more tables in a Workspace and create specific data views using the standard SQL SELECT queries. These data views are similar to tables and you can perform operations such as report creation, sharing, and even create another Query Table over an existing Query Table.
Refer to this help document to know how to create Query Tables in Zoho Analytics.
You can import and analyze data from all the applications that Zoho Analytics offers integration with. Please refer to our Integrations page to know more.
To import data from the third party business apps,
This will import the data into the Workspace. You can combine it with your Google Analytics data by creating a lookup relationship. Refer to this question to learn about creating a lookup.
A lookup relationship will not be created automatically between the Google Analytics modules and the modules of the application that you are trying to import. You will have to manually link the tables using a lookup relationship.
To manually create a lookup relationship refer this help link - Click here
If you have selected the AdWords module while setting up the integration, your Google AdWords data will be imported into the Workspace. If not, you can select the module while editing the setup . We also offer an AdWords integration, please do check out this link.
You can easily share the reports that you create with the other users in your organization. Refer to Sharing and Collaboration help page for more details on this.
Once you privately share a report with your colleagues they will be able to access the reports as you do. Refer here to know how to access the reports.
When a Google Analytics Administrator configures the Google Analytics - Zoho Analytics, the tables, and reports will be available only to him/her, by default. The Administrator has to share the Workspace with other members of the company. Only then will the default reports be accessible by those members.
To know more, refer to Sharing and Collaboration help page.
The Google Analytics Administrator who has set up the should share the tables present in ' Google Analytics Advanced Reporting' Workspace with other members of the company. Once this is done, the shared users can create reports based on those tables.
To know more, refer to Sharing and Collaboration help page.
Zoho Analytics offers three user roles - Administrator, Workspace Administrator, and User. Click to know more about the Zoho Analytics Organization Model and User Roles.
This is the expected behavior. Only when the users to whom the reports are being shared is set as a Workspace Administrator, they will be able to edit the reports. If a normal user wants to edit the report, he/she will have to save the report with a new name using the Save As option toolbar. The User can edit this report. To know more about user roles, click here.
Yes, you can. Refer the topic Apply filter criteria .
Yes, you can export the report/dashboard in various file formats such as CSV, EXCEL, PDF, HTML, and Image. Click to know more.
In order to print the report/dashboard, you first need to export it. You can export the report in various file formats such as CSV, EXCEL, PDF, HTML and Image. Click to know more.
If you are the Administrator of the Zoho Analytics or a 'Workspace Administrator', you can schedule reports and dashboards to be emailed automatically. Refer to the email schedule section in this help documentation.
You can easily embed the reports & dashboards created in Zoho Analytics in your website, web application or blog. Refer Embedding in Web Pages/Blogs to know more about this.
Yes, Zoho Analytics supports various rebranding options such as Portal rebranding/white labeling and Logo Rebranding .
We offer 24x5 technical support (Monday to Friday). In case if you need our assistance kindly do mail us your questions to support@zohoanalytics.com .
You can also reach out to us on our toll-free numbers -
Yes, certainly. Register for a demo in this page .
Subscribe to receive notifications from this article.