For the complete list of modules and fields available for synchronization, please refer
here.
Accessing Advanced Analytics
Once the synchronization is complete, you can access the advanced analytics powered by Zoho Analytics directly from Vertical Studio:
From Vertical Studio: Go to Set Up > Marketplace > Zoho > Advanced Analytics > Manage.
From Zoho Analytics: Log in to Zoho Analytics, open the Vertical Studio workspace created during integration.
Sync Status and History
Once the integration is active, users can easily monitor the synchronization status of their Vertical Studio data with Zoho Analytics. Information about the most recent sync, upcoming scheduled syncs, and historical sync logs is available in both the Vertical Studio application and Zoho Analytics interface.
In Vertical Studio:
- Navigate to Setup > Marketplace > Zoho > Advanced Analytics.
- The integration page displays:
- Last Sync Time – When the most recent data sync was completed.
- Next Scheduled Sync – Shows the date and time of the upcoming scheduled sync.
- Sync Status – Whether a sync is in progress or complete.
In Zoho Analytics:
- Log in to your Zoho Analytics account.
- Open the Vertical Studio Reports workspace
- Click on Data Sources > select your Vertical Studio data source.
- You will see the following sync metadata:
- Last Data Sync Status (e.g., Success, Failed, Sync in Progress)
- Last Data Sync Time
- Next Scheduled Sync Time
- Schedule Timezone
- Synchronizations Done
- Click the Sync History tab to view logs of all sync activities performed in the last 45 days.
Reports and Dashboards
The integration provides over 70 pre-built reports and dashboards. You can also create custom reports using Zoho Analytics' drag-and-drop builder. Refer to Zoho Analytics help for
Creating Ad-hoc Reports using Zoho Analytics.Sharing Reports and Dashboards with Other Users
By default, the reports and dashboards generated in Zoho Analytics using Vertical Studio data are initially accessible only to the administrator who configured the integration. However, to foster collaboration and promote data-driven decision-making across the organization, these valuable insights can be easily shared with other Vertical Studio application users, or even outside the application.
To share reports and dashboards:
- Log in to Zoho Analytics.
- Open the Vertical Studio Reports workspace (the workspace created during the integration process).
- On the Vertical Studio Reports page, select the report or dashboard you wish to share.
- Click the Share option.
- Choose the desired sharing method (e.g., sharing with specific users, user groups, or publicly via a permalink, if applicable).
Managing Your Vertical Studio - Zoho Analytics Integration
Editing Integration Settings
The Vertical Studio - Zoho Analytics integration settings can be modified at any time. This includes updating the selected modules or fields for synchronization, or altering the data synchronization schedule.
From Vertical Studio:
- Navigate to Setup > Marketplace > Zoho > Advanced Analytics.
- Click on Settings
- Make the necessary modifications to the settings
- Click Save.
From Zoho Analytics:
- Log in to Zoho Analytics
- Open the Vertical Studio advanced analytics Workspace.
- Click on Data Sources > Edit Setup
- Make the necessary modifications to the settings
- Click Save.
If you attempt to remove the synchronization of modules or fields from Advanced Analytics that are linked to any existing components, a warning pop-up will prompt you to first disassociate them in Analytics before proceeding with the removal in the CRM. However, if the modules or fields you remove from the CRM are not used in any Analytics components, the change will take effect immediately. The related data in Analytics will be automatically deleted during the next scheduled sync.
Any updates made to records in the Vertical Studio application will be automatically synced with Zoho Analytics during the scheduled synchronization period.
Deactivating the Integration
If you no longer require Advanced Analytics for Vertical Studio, the integration can be deactivated. If you deactivate the integration, re-activation requires a fresh setup. The previous workspace in Zoho Analytics remains but is not re-linked upon re-enabling the integration.
Important: Deactivating the Zoho Analytics account connected to Vertical Studio will result in the permanent deletion of all associated Vertical Studio data, reports, and dashboards within that specific Zoho Analytics workspace. This action is irreversible. Ensure that any critical reports or data have been backed up or exported before proceeding with deactivation.
To deactivate Advanced Vertical Studio Analytics:
From Vertical Studio:
- Log in to Vertical Studio with Administrator profile privileges.
- Navigate to the integration settings, under Setup > Marketplace > Zoho
- On the Advanced Analytics for Vertical Studio page, click Manage > Deactivate
- On the Deactivation of Zoho Analytics page, carefully review the warning message, and then click Deactivate to confirm the action.
From Zoho Analytics:
- Log in to Zoho Analytics.
- Open the Vertical Studio advanced analytics Workspace.
- Click Data Sources (or the Vertical Studio data source name).
- Click the Setup icon on the data source you want to delete.
- Click Remove Data Source.
- Confirm deactivation.
Synchronized Modules & Fields
You can synchronize standard modules, custom modules, subforms, linking modules, and picklist history trackers. Up to 95 fields can be synced per module. If you attempt to select more than 95 fields in a module, you will receive an UI warning. Default fields are pre-selected when a module is chosen.
Here is a complete list of modules that can be synchronised with Zoho Analytics.
Please note that the final list for your application depends on the modules you have selected while creating the application.
Standard Modules
- Accounts
- Events, Calls, and Tasks
- Cases
- Campaign
- Campaign Lead Status
- Contacts
- Invoices
- Invoice Line Items
- Leads
- Deals
- Deal Stage History
- Price Books
- Products
- Purchase Orders
- Purchase Order Line Items
- Quotes
- Quote Lines Items
- Sales Orders
- Sales Order Line Items
- Vendors
- Custom Modules
- Subforms
- Linking Module
- Picklist History Tracker
There are a set of default fields, that will be marked selected, when you select a module for synchronization. Apart from that, you can also include additional fields by selecting the required ones during the initial setup, or later.
Here is a list of default fields that will be synchronized during Vertical Studio - Zoho Analytics integration:
- Accounts - Account ID, Account Name, Account Owner, Account Type, Created Time, Industry, Website
- Calls - Call Start Time, Call Duration (in seconds), Call Owner, Subject, Call Type, Call Purpose, Billable, Created Time, Modified Time
- Campaign - Campaign ID, Campaign Name, Type, Status, Created Time, Modified Time, Start Date, End Date, Expected Revenue, Budgeted Cost, Actual Cost,
- Campaign Lead Status - Campaign ID, Lead ID, Campaign Name, Lead First Name, Lead Last Name, Status, Last Modified Time, Is Lead Active?
- Contacts - Contact ID, Last Name, Contact Owner, Email, Lead Source, Mobile, Created Time
- Cases - Case ID, Case Owner, Status, Case Origin, Created Time, Modified Time, Days to Closed, Age in Days, Age Tier, Type, Subject, Email
- Events - Event Owner, Subject, Start Date and Time, End Date and Time, Created Time, Modified Time
- Invoice - Invoice ID, Invoice Number, Sales Order Id, Invoice Owner Id, Invoice Owner, Invoice Status, Created Date, Modified Date, Account Id, Contact Id, Subject, Sub Total, Discount, Tax
- Invoice Line Items - Inventory Field, Inventory Id, Product Id, ListPrice, Quantity, Total, Discount, Total After Discount, Tax, Net Total, Product Name
- Leads - ID, Last Name, Company, Lead Owner, Email, Mobile, Website, Industry, Lead Source, Lead Status, Created Time, Converted
- Deals - ID, Potential Name, Potential Owner, Created Time, Amount, Expected Revenue, Closing Date, Stage, Type, Lead Source, Probability
- Potential Stage History - Deal Stage History ID, ID, Modified Time, Stage, Stage Duration, Stage Velocity
- Products - Product ID, Product Owner Id, Product Owner, Product Name, Product Code, Product Active, Product Manufacturer, Product Category, Cost, Taxable, Commission Rate, Quantity Ordered, Quantity In Stock, Reorder Level, Quantity In Demand, Sales Start Date, Sales End Date, Support Start Date, Support End Date, Created Time, Modified Time, Vendor ID, Cost of Stocks in hand, Need Replenishment
- Purchase Orders - Purchase Order ID, Purchase Order Owner Id, Purchase Order Owner, PO Number, Created Date, Modified Date, PO Date, Vendor Id, Contact Id, Status, Excise Duty, Sales Commission, Due Date, Sub Total, Discount, Tax, Gross Total, Adjustments
- Purchase Order Line Item - Inventory rel ID, Purchase Order Id, Product Id, List Price, Quantity, Total, Discount, Total after Discount, Tax, Net Total, Product Name, Book ID
- Quotes - Quote ID, Quote Owner Id, Quote Owner, Quote Stage, Created Date, Modified Date, Valid Till, Account Id, Contact Id, Potential Id, Subject, Sub Total, Discount, Grand Total, Tax, Adjustments
- Quotes Lines Items - Inventory Rel ID, Inventory Id, Product Id, Quantity, Total, Discount, Total After Discount, Tax, Net Total, Product Name, List Price, Sales Orders, Quote ID
- Sales Order - Owner Id, Sales Order Owner, Created Date, Modified Date, Due Date, Account Id, Contact Id, Potential Id, SALESORDERID, Status, Subject, Sub Total, Discount, Tax, Adjustments, Grand Total
- Sales Orders Line Items - INVENTORYRELID, Inventory Id, Product Id, Quantity, Total, Discount, Total After Discount, Tax, Net Total, Product Name, List Price,
- Vendors - Inventory Rel ID, Inventory Id, Product Id, Quantity, Total, Discount, Total After Discount, Tax, Net Total, Product Name, List Price
- Tasks - Task Owner, Subject, Created Time, Due Date, Status
- Users - User ID, First Name, Last Name, Email