Salesforce Advanced Analytics

The Zoho Analytics Advanced Analytics Connector for Salesforce CRM allows you to easily analyze your CRM data in detail and derive useful insights on your sales data. Its intuitive drag-and-drop interface allows you to easily create reports and dashboards. Sales and Marketing personnel can 'slice and dice' their CRM data and take informed business decisions.

General

Setup

Reporting Features

Users, Sharing & Collaboration

Solutions

Help & Support

General

1. What is Zoho Analytics?

Zoho Analytics is an on-demand reporting and business intelligence solution that helps you derive insights on your business data through its powerful reporting and analytical capabilities. You can create dynamic 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 with powerful drag & drop based reporting features for quick report creation.
Visual Analysis capability for in-depth analysis and to slice & dice your data
Supports a wide range of reporting capabilities like Dashboards, Charts, Pivot Tables, Summary, and simple Tabular reports. Supports creation of KPI widgets in dashboards to analyze the performance.
Supports data import from a variety of file formats like Excel, JSON, HTML etc. Also supports data import from cloud storage and Web URLs. Supports periodic scheduling of import.
Integrated with Teamwork Desk to empower your helpdesk data with the powerful reporting capabilities in Zoho Analytics.
Zoho Analytics is integrated with popular business applications like Google Analytics, Salesforce CRM etc.
You can also integrate your own applications with Zoho Analytics using Zoho Analytics API.
Blend & merge data from across different sources to create meaningful business reports
With an advanced formula engine, you can derive key business metrics from your data. Also supports SQL (Structured Query Language) driven querying for powerful report creation.
Real-time collaboration by sharing data and reports in read or read-write modes with your colleagues & friends.
Export and Print reports in variety of formats. Notify reports via email.
Publish reports for wider consumption. 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. (Refer Security and Privacy)
Supports Logo Rebranding.

Also, check out our Getting Started Video

2. What is the Zoho Analytics Advanced Analytics connector for Salesforce and how does it work?

The Zoho Analytics Advanced Analytics connector for Salesforce brings in all the capabilities of Zoho Analytics described above for Salesforce data. It comes with the following features/benefits.

A full-featured business intelligence (BI) and reporting tool that can slice & dice your Salesforce CRM data to create any report/dashboard you require.
Pre-packaged set of 100+ reports and dashboards that anyone using Salesforce will find great value in
Create your own reports and dashboards based on not only your Salesforce CRM data but also from any other data source (eg., Excel spreadsheets, Google Adwords etc.,) that you would wish to combine with your CRM data.
Collaboratively work with your colleagues when creating new reports/dashboards on your Salesforce data
Schedule and email your reports whenever you want
Export your reports to PDF, Excel, CSV, JPG ... files to your desktop and print them for offline consumption

3. What do I get when I subscribe to this connector?

As a Salesforce users, subscribing to this connector brings you immense benefits. You get to look at your data in Salesforce in ways you haven't looked at before. Using this Zoho Analytics connector enables you to do powerful analysis of your CRM data and create insightful reports & dashboards. Like, say constructing sales funnels, knowing your sales win/loss rate, knowing your Top 5 / Bottom 5 sales persons, predicting how your sales in different regions is going to be in the following months and quarters, and do much more.

Zoho Analytics' drag-and-drop based reporting is so easy to use that you could create any report or dashboard on your CRM data with no IT help or technical knowledge and share them to your colleagues.

4. What are the default reports & dashboards created by Zoho Analytics, on setting up this connector?

When you setup/configure the Zoho Analytics connector, 100+ default reports/dashboards are automatically created. These hand-picked reports will be pretty useful in analyzing your sales performance effectively. For example, sales pipeline report, Top 5 / Bottom 5 sales persons report, Win/Loss % report, sales prediction report etc.

Setup

1. How do I setup the Zoho Analytics Connector in my Salesforce account?

Setting up the Zoho Analytics connector is easy. Please follow the step-by-step instructions in the below presentation.

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

After configuring your Salesforce account, wait for at least one day for all your Salesforce data to be imported into Zoho Analytics. 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 you make to your data in Salesforce (add, modify, delete records) will automatically be synchronized into Zoho Analytics every day at the scheduled time you have specified during setup.

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

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

Setup Process Failed mail will come when there is a failure during the initial Salesforce - Zoho Analytics connector setup.

Synchronization Failed mail will come if there is any failure during the data synchronization process, run daily, between Salesforce and Zoho Analytics, after the initial setup & import is completed successfully.

4. What are the tabs (modules) in Salesforce on which I could create reports using this connector?

The data from the following modules will be synchronized by default when setting up this integration.

Users
Accounts
Contacts
Opportunities

However, you can also synchronize data from the following modules.

Leads
Tasks
Events
Cases
Contracts
Orders
Quotes
Products
Price Books
Campaigns
Account Feed
Assets
Asset Feed
Attachments
Case Feed
Case Solution
Category Data
Group Feed
Group Records
Contact Feed
Contract Feed
Site
Documents
Event Feed
Feed Items
Ideas
Images
Macros
Notes
Lead Feed
List Emails
Order Feed
Partner
Solution Feed

Product Feed
Quick Text
Quote PDFs
Quote Feed
Solutions
Task Feed
Goals
Topic Feed
User Feed
Work Types
Report Feed
Order Products
Quote Line Items
Last Used App
Price Book Entries
Campaign Members
Account Clean Info
Asset Relationships
Campaign Feed
Case Comments
Announcements
Contact Requests
Content Folders
Dashboard Feed
Individuals
Data Use Purposes
Data.com Usage
Email Messages
Event Relations
ExpressionFilters
Feed Comments
D&B Companies
Work Orders

Feed Revisions
File Search Activity
Flow Interviews
Flow Record Relations
Installed Mobile Apps
Data Use Legal Bases
Lead Clean Info
Opportunity Feed
Process Instance Node
Recommendations
RecordActions
Streaming Channels
Opportunity Product
Topic Assignments
Work Order Feed
Work Order Line Items
Work Capacity Limits
Work Capacity Usages
Work Type Feed
Work Type Groups
User Provisioning Logs
Opportunity : Competitor
Account Contact Roles
Asset Relationship Feed
Background Operations
Case Contact Roles
Consumption Rates
Consumption Schedules
Contact Clean Info
Macro Instructions
Mail Merge Template
Order Product Feed
ExpressionFilterCriteria

Contact Point Type Consents
ContentDocument Feed
Contract Contact Role
Dashboard Component Feed
Data Assessment Field Metrics
Data Assessment Field Value Metrics
Data Assessment Metrics
Data.com Owned Entity
Duplicate Record Items
Duplicate Record Sets
Email Message Relations
Flow Interview Stage Relations
Forecasting Owner Adjustments
List Email Individual Recipients
List Email Recipient Sources
Org Delete Requests
Opportunity Contact Role
Product Consumption Schedules
Promoted Search Terms
UserAppMenuCustomizations
User Email Preferred People
User Provisioning Accounts
User Provisioning Account Stagings
User Provisioning Mock Targets
User Provisioning Requests
Work Capacity Limit Feed
Work Capacity Usage Feed
Work Order Line Item Feed
Work Type Group Members
Work Type Group Members Feed
App Analytics Query Requests
Additional Directory Numbers
Campaign Member Statuses

5. Will other tabs (modules) in Salesforce be supported, for report creation through this connector. When?

We plan to support synchronization from other Salesforce CRM tabs in the near future. Support for other tabs will also be prioritized based on user demand.

6. What are the default fields that will be synchronized from Salesforce into Zoho Analytics workspace?

Salesforce data from the following fields, for the tabs you have read permission, will be synchronized by default into Zoho Analytics. You can also include additional columns/fields to synchronize from Salesforce to Zoho Analytics as described in the question below.

The following are the fields that will be synchronized from the Salesforce into Zoho Analytics workspace by default.

Tabs/Modules	Fields
Account	ID
	Account Name
	Account Owner
	Account Type
	Industry
	Website
	Account Owner Id
	Tasks Involved
	Events Involved
	Activities Involved
Cases	Id
	Case Owner
	Case Owner Id
	Case Status
	Case Origin
	Created Date
	Last Modified Date
	Days to Closed
	Age in Days
	Age Tier
	Type
	Subject
	Email
Contacts	ID
	Account ID
	Contact Owner
	Email
	Full Name
	Lead Source
	Mobile
	Contact Owner ID
	Created Time
	Tasks Involved
	Events Involved
	Activities Involved
	Account Name
Events	ID
	LEADID
	CONTACTID
	OPPORTUNITYID
	Event Owner
	Event Owner ID
	Subject
	Start Date Time
	End Date Time
	Created Time
	Modified Time
	ACCOUNTID
	Who Id
	WhatId
Leads	ID
	Company
	Email
	Full Name
	Mobile
	Website
	Industry
	Lead Owner
	Lead Source
	Lead Status
	Lead Owner ID
	Created Time
	Converted
	Converted Opportunity ID
	Tasks Involved
	Events Involved
	Events Involved
	Activities Involved
Tasks	ID
	LEADID
	CONTACTID
	OPPORTUNITYID
	Task Owner
	Task Owner Id
	Subject
	Created Time
	Due Date
	Status
	Modified Time
	Who Id
	What Id
	ACCOUNTID
	Call Type
	Call Duration (in Seconds)
	Call Duration (in minutes)
Users	ID
	First Name
	Last Name
	Alias
	User Name
	Full Name
Opportunities	ID
	Account ID
	Amount
	Closing Date
	Expected Revenue
	Lead Source
	Opportunity Name
	Opportunity Owner
	Stage
	Created Time
	Opportunity Owner ID
	Age in Days
	Age Tier
	Amount Tier
	Probability
	Type
	Tasks Involved
	Events Involved
	Activities Involved
	Tasks Only
	Events Only
	Account Name

7. Can I add custom fields or new fields?

Yes, you can add custom columns or new fields. Follow the steps given below to synchronize your custom columns into the Advanced Analytics Connector for Salesforce:

Follow the steps given below to add new fields.

Open the corresponding Salesforce workspace in Zoho Analytics.
In the Explorer tab, click Salesforce CRM> Edit Setup. The Edit Salesforce CRM Setup dialog will open.
Select/unselect the check box adjacent to the required fields. You cannot unselect the check box for default fields.
Click Save. New fields will be added in the next import.

Data will be synced and the new fields will be imported into Zoho Analytics during the subsequent scheduled synchronization. In case you have already set up the Zoho Analytics Connector in your Salesforce account, then you can edit the Zoho Analytics Configuration setup as given in the following question to add the custom fields.

8. Can I edit the Salesforce-Reports Synchronization setting?

Yes, you can edit the Salesforce-Reports Synchronization setting by following the steps below:

Follow the steps given below to edit the setup from Zoho Analytics.

Open the corresponding Salesforce workspace in Zoho Analytics.
In the Explorer tab, click Salesforce CRM > Edit Setup. The Edit Salesforce CRM Setup dialog will open.
Select/unselect the check box adjacent to the required fields. You cannot unselect the check box for default fields.
In the Repeat drop-down, select Every Day and modify the synchronizing time to import data periodically.
Click Save. The synchronization setting will be modified.

9. Can I synchronize the Salesforce-Reports data instantly?

Yes, you can synchronize the Salesforce-Reports data instantly when needed. You can do this as follow. Login to your Zoho Analytics account.

Open the corresponding Salesforce workspace in Zoho Analytics.
In the Explorer tab, click Salesforce CRM
In the Data Sources tab that opens, Sync Now. Data will be synced instantly.

10. How do I access the reports created in Zoho Analytics?

Once the initial data fetch is successfully completed you will be able to access the tables and default reports in Salesforce workspace. To access this log into your Zoho Analytics account and open the corresponding workspace.

If you are another user of your Salesforce account, but not the one who setup the reports connector, you will see the Salesforce CRM Analytics workspace, only when the workspace is explicitly shared to you.

Refer How to Share Reports & Dashboards

11. How do I create my own reports with this connector?

You can easily create your own reports using the drag & drop designer of Zoho Analytics. You can refer to the below presentation to know how to create your own reports & dashboards using Zoho Analytics.

Also, Refer to the Following Video Demos:

Note:

For creating your own reports using this connector, Only user who have setup the connector or who has been added as a shared user can create reports over the Salesforce data. Refer How to Share Reports & Dashboards question.

12. 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 Analytics. Refer to the How to Share Reports & Dashboards question.

13. On whose account will the Zoho Analytics connector be setup?

Salesforce user who has read permission for the required table can configure/set up the Zoho Analytics connector. The Zoho Analytics account in which this integration is setup with Salesforce will serve as the master admin account of Zoho Analytics.

14. Can I setup the Connector in an account other than the trialed account where this is configured?

Yes, you can do this. If the account in which the trial was configured/setup is not upgraded after trial expiry (i.e. the Salesforce connector was not purchased), then the account will be downgraded automatically to free plan and eventually, the synchronization between Salesforce and Zoho Analytics will also be deleted. In this case you will be able to set up the synchronization in another Zoho Analytics account you need, by purchasing the Connector.

However, you will not be able to trial the Salesforce integration in Zoho Analytics again for the same organization.

15. Can I change the Salesforce user account, from which data need to be synced into Zoho Analytics?

Yes, you can change the Salesforce user, from which you want to pull data within your organization.

Follow the steps below to do this:

Open the Salesforce workspace in Zoho Analytics.
Click Salesforce CRM > Re-Authenticate.
In the dialog that opens, click Re-Authenticate Salesforce CRM.
You will be prompt to login to Salesforce for authenticating. Provide the credentials of the new user.

Note

The new Admin should be a user of the same Salesforce Organization.

16. Can I transfer my Zoho Analytics connector to another admin account?

At present, we do not provide an option in the user interface. If you require this transfer, please do mail us to onprem-support@zohoanalytics.com. We will get your requirements and handle this.

17. How can I remove the setup?

To remove the setup,

Login to your Zoho Analytics account.
Open the corresponding workspace.
In the Explorer tab, click Salesforce CRM button.
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 Analytics?

Zoho Analytics supports a wide variety of reports.

Charts
- Pie
- Bullet
- Bar
- Stacked bar
- Bubble
- Packed Bubble
- Line
- Scatter
- Area
- Web
- Funnel
- Doughnut
- Dial
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 Analytics, on setting up the Salesforce Integration?

3. Can I modify the default reports that have been created by the Zoho Analytics connector? If so, how?

Yes, you can modify the default reports. If you are a Workspace Admin or the person who set up the Zoho Analytics connector, 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 the Save As icon and save the report as a new report, and then edit the report as needed.

4. How do I create reports using Zoho Analytics with this connector?

You can create report of any supported report types with this Zoho Analytics connector. All you have to do is open the appropriate table(s)/tab(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 Analytics to create the report required. To know more, view slide show on How to Create Reports? You can also quick view the type of reports & dashboard that are created by default, from the sample given below, to get know the possibilities.

5. How to create reports using fields/columns across different tabs?

Columns from across different tables can be dragged and dropped to create a report. Refer this slide show on How to Create Reports?

6. What are Formulas in Zoho Analytics?

Formulas, as the name indicates are calculations that you could define in Zoho Analytics to help you create the required reports. 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.

7. What are the default formulas added in the 'Salesforce Reports' workspace, on setting up this connector?

The below table lists all the default formulas that will be created in the 'Salesforce Reports' workspace by default. You will find these formulas pretty useful, in creating reports & dashboards in Zoho Analytics. Also these formulas are used in the reports created by default in your workspace.

The below table lists all the default formulas that will be created in the Leads table:

Formula Name	Formula Type	Formula	Description
Activities count	Aggregate	countif(("Lead"."Activities Involved"=1))	Provides the count of Leads which have one or more Activities involved.
Converted Lead Count	Aggregate	count(if(("Lead"."Converted"=1),'1',NULL))	Provides the count of Leads converted into Potentials.

The below table lists all the default formulas that will be created in the Cases table:

Formula Name	Formula Type	Formula	Description
Age Tier	Custom	if( "Age in Days" >= 0, if( "Age in Days" <= 60, '1. 0 - 60 days', if( "Age in Days" <= 120, '2. 61 - 120 days', if( "Age in Days" <= 180, '3. 121 - 180 days', if( "Age in Days" <= 360, '4. 181 - 360 days','5. Above 360 days')))), '6. Negative - Not Valid')	Classifies the time spent on a potential/opportunity to close it, into different time period baskets, e.g., within 60 months, within 120 days etc.,
Age in Days	Custom	datediff(if("Case Status" = 'Closed',"Last Modified Date",now()),"Created Date")	Number of days it took for a potential to be closed. If the Closing Date is not available (null), we calculate the days till today from the potential created time. Used for calculating 'Age Tier' and 'Sales Cycle'.
Days to Closed	Custom	if("Case Status" = 'Closed',datediff("Last Modified Date","Created Date"),null)	Displays the days taken to close a case.
No. of Closed Cases	Aggregate	countif("Case"."Case Status"='Closed')	Displays the number of closed cases.
% of Closed Cases	Aggregate	("No. of Closed Cases"/count("Case"."Id"))*100	displays the percentage of closed cases.

The below table lists all the default formulas that will be created in the Tasks table:

Formula Name	Formula Type	Formula	Description
Call Duration (in minutes)	Custom	round(("CallDurationInSeconds"/60))	Provides the duration of the calls in seconds.
Overdue Tasks	Aggregate	countif(("Task"."Due Date"<now()) and ("Task"."Status"!='Completed'))	Provides the count of Tasks which are not completed.
Overdue Days	Aggregate	sumif(("Task"."Due Date"<now() and "Task"."Status"!='Completed'),datediff(now(),"Task"."Due Date"),0)	Provides the number of overdue days of the overdue tasks.
Avg Overdue Days	Aggregate	avgif(("Task"."Due Date"<now() and "Task"."Status"!='Completed'),datediff(now(),"Task"."Due Date"),0)	Provides the average overdue days.
Overdue %	Aggregate	("Overdue Tasks"/count("Task"."Id"))*100	Provides the percentage of Overdue Tasks.
Completed Tasks	Aggregate	countif("Task"."Status"='Completed')	Provides the count of Tasks which are completed.

The below table lists all the default formulas that will be created in the Opportunities table:

Formula Name	Formula Type	Formula	Description
Age in Days	Custom	datediff(ifnull("Closing Date",now()),"Created Time")	Number of days it took for a potential to be closed. If the Closing Date is not available (null), we calculate the days till today from the potential created time. Used for calculating 'Age Tier' and 'Sales Cycle'.
Age Tier	Custom	if( "Age in Days" >= 0, if( "Age in Days" <= 60, '1. 0 - 60 days', if( "Age in Days" <= 120, '2. 61 - 120 days', if( "Age in Days" <= 180, '3. 121 - 180 days', if( "Age in Days" <= 360, '4. 181 - 360 days','5. Above 360 days')))), '6. Negative - Not Valid')	Classifies the time spent on a potential/opportunity to close it, into different time period baskets, e.g., within 60 months, within 120 days etc.,
Amount Tier	Custom	if( "Amount" >= 0, if( "Amount" <= 10000, '1. 0 - $10K', if( "Amount" <= 20000, '2. $10,001 - $20K', i f( "Amount" <= 30000, '3. $20,001 - $30K', if( "Amount" <= 40000, '4. $30,001 - $40K','5. Above 40K')))), '6. Negative - Not Valid')	Classifying sales based on $ value (amount of sale made), e.g., upto 10,000, 10,001to 20,000, 20,001-30,000 etc.,
Tasks Only	Custom	if(("Tasks Involved"=1) & ("Events Involved"=0) ,1,0)	Provides the list of Potentials which has only associated Tasks and does not contain any Events or Calls.
Events Only	Custom	if(("Tasks Involved"=0) & ("Events Involved"=1) ,1,0)	Provides the list of Potentials which has only associated Events and does not contain any Tasks or Calls.
Forecast Type	Custom	if("Stage" in ('Closed Won'),'Won',i f("Stage" in ('Closed Lost'),'Lost','Open'))	Provides the forecast of the potential.
Won Vs Expected Revenue %	Aggregate	sumif("Opportunity"."Forecast Type"='Won',"Opportunity"."Amount")*100/sum ("Opportunity"."Expected Revenue")	Ratio of sum of sales won and sum of revenue expected.
Lost Deals Count	Aggregate	count(if("Opportunity"."Forecast Type"='Lost',"Opportunity"."Id",NULL))	Total number of deals lost
Won Deals Count	Aggregate	count(if("Opportunity"."Forecast Type"='Won',"Opportunity"."Id",NULL))	Total number of deals won
Win Rate %	Aggregate	count(if("Opportunity"."Forecast Type"='Won',"Opportunity"."Id",NULL))*100 /count(if("Opportunity"."Forecast Type" in ('Won','Lost'),"Opportunity"."Id",NULL))	Provides the Win Rate (in %) of sales. This is calculated as a Ratio between number of deals won and total number (won + lost) of deals
Won Amount	Aggregate	sumif("Opportunity"."Forecast Type"='Won',"Opportunity"."Amount")	Total amount of sales won (made)
Avg Deal Size Won	Aggregate	avgif("Opportunity"."Forecast Type"='Won',"Opportunity"."Amount",NULL)	Average size of sales made
Avg Sales Cycle	Aggregate	avgif("Opportunity"."Forecast Type" IN('Won','Lost'),"Opportunity"."Age in Days")	The average number of days it takes to close a potential sale (the sale can either be won or lost, but the potential sale shouldn't be in an open state).
Lost Amount	Aggregate	sumif("Opportunity"."Forecast Type"='Lost',"Opportunity"."Amount")	Predicts the amount lost
Open Deals Count	Aggregate	count(if("Opportunity"."Forecast Type"='Open',"Opportunity"."Id",NULL))	gives the count of open deals
Predicted Pipeline Revenue	Aggregate	"Predicted New Deals Count Next 90 Days"*"Avg Deal Size Last 365 Days"	Predicts the Sales expected in future, based on current pipeline and past trends.
Predicted New Business - Next 3 Months	Aggregate	("Win Rate Percentage Last 365 Days"/100)("Avg Deal Size Last 365 Days")(("Opportunities Created Last 365 Days"*90)/365)	Predicts the sales that could come from new business (new pipeline), calculated based on past trends.
Loss Rate %	Aggregate	count(if("Opportunity"."Forecast Type"='Lost',1,NULL))*100/count(if("Opportunity"."Forecast Type" in ('Won','Lost'),1,NULL))	provides the percentage of loss
Won Deals Count Last 365 Days	Aggregate	count(if("Opportunity"."Forecast Type"='Won' AND "Opportunity"."Closing Date">subdate(currentdate(),'365'),1,NULL))	Provides the count of deals won in last 365 days.
Lost Deals Count Last 365 Days	Aggregate	count(if("Opportunity"."Forecast Type"='Lost' AND "Opportunity"."Closing Date">subdate(currentdate(),'365'),1,NULL))	Provides the count of deals lost in last 365 days.
Open Deals Count Next 90 Days	Aggregate	count(if("Opportunity"."Forecast Type"='Open' AND "Opportunity"."Closing Date">=currentdate() AND "Opportunity"."Closing Date"<adddate(currentdate(),90),1,NULL))	Provides the count of open deals (not closed) whose closing date lies within next 90 days.
Win Rate Percentage Last 365 Days	Aggregate	("Won Deals Count Last 365 Days"*100)/("Won Deals Count Last 365 Days"+"Lost Deals Count Last 365 Days")	Provides the percentage of deals won in last 365 days.
Avg Deal Size Last 365 Days	Aggregate	avgif("Opportunity"."Forecast Type"='Won' AND "Opportunity"."Closing Date">subdate(currentdate(),'365'),"Opportunity"."Amount")	Provides the average of deals won in last 365 days.
Predicted New Deals Count Next 90 Days	Aggregate	("Win Rate Percentage Last 365 Days"/100)*"Open Deals Count Next 90 Days"	Predicts the count of Deals expected to be Won in the next 90 days. It is calculated based on Deals Won in the past 365 days.
Opportunities Created Last 365 Days	Aggregate	count(if("Created Time">subdate(currentdate(),365),1,NULL))	Provides the count of opportunities created in the last 365 days.
Activities count	Aggregate	countif(("Opportunity"."Activities Involved"=1))	Provides the count of Leads with any Activity involved.
Activities done % for Opportunities	Aggregate	(countif(("Opportunity"."Activities Involved"=1))/count("Opportunity"."Id"))*100	Provides the percentage of Opportunities which has some activity associated with it.
Opportunities without Activities	Aggregate	countif(("Opportunity"."Activities Involved"=0),"Opportunity"."Id",0)	Provides the count of Potentials without any Activities involved.
Tasks Only %	Aggregate	(countif(("Opportunity"."Tasks Only"=1)&("Opportunity"."Forecast Type"='Won'))/countif("Opportunity"."Tasks Only"=1))*100	Provides the percentage of Won Deals which has only Tasks involved/associated.
Events Only %	Aggregate	(countif(("Opportunity"."Events Only"=1)&("Opportunity"."Forecast Type"='Won'))/countif(("Opportunity"."Events Only"=1)))*100	Provides the percentage of Won Deals which are only associated Events.
Combined Activities %	Aggregate	(countif(("Opportunity"."Activities Involved"=1)&("Opportunity"."Tasks Only"=0)&("Opportunity"."Events Only"=0)&("Opportunity"."Forecast Type"='Won'))/countif(("Opportunity"."Activities Involved"=1)&("Opportunity"."Tasks Only"=0)&("Opportunity"."Events Only"=0)))*100	Provides the percentage of Won Deals which have one or more associated Activities.
No Activities %	Aggregate	((countif(("Opportunity"."Activities Involved"=0)&("Opportunity"."Forecast Type"='Won'))/countif(("Opportunity"."Activities Involved"=0)))*100	Provides the percentage of Won Deals which does not have any activities involved.

8. How do I create my own custom formulas in Zoho Analytics?

Refer to the Adding Formulas in Zoho Analytics help page.

9. Can I add/modify data in the Salesforce tabs (tables) from within Zoho Analytics?

No, you cannot. Data from Salesforce tabs gets automatically synchronized into Zoho Analytics in the 7 different tables (one table for one tab). You cannot edit any of this data or add new data records from within Zoho Analytics.

10. Can I add new columns to the Salesforce tabs (tables) from within Zoho Analytics?

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 Analytics to know more.

11. Can I add new data tables in this workspace to create reports & dashboards?

Yes, you can add new data tables. Click New > New Table and you can add new tables to the existing Salesforce workspace.

With this feature, you can import new data or add them manually into your workspace to analyze and create reports combining this with the Salesforce data. You can import data from files like Excel, HTML and CSV. You can also import data from local databases like Oracle, SQL Server, DB2, MySQL, PostgreSQL and MS Access.

Refer:

12.Can I combine data from other sources with the data from Salesforce CRM to create reports and dashboards?

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

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 Salesforce CRM 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.

13. What are Query Tables?

Zoho Analytics allows you to pull the data required by writing standard SQL SELET Queries. This feature is called Query Tables. With Query Tables, you can also combine data from different tables and create reports from the same.

14. 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 Analytics for detailed help on this.

Users, Sharing & Collaboration

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

You can share the default reports provided in the Zoho Analytics connector and also the reports you created, with your organization co-employees/colleagues. Refer to Sharing and Collaboration

Once you privately share a report to your colleagues, they will be able to access the same from Shared Workspaces tab.

Note:

1. If you share the data tables in the Salesforce workspace to users, they will be able to create their own reports over the same.

2. If you add a user as a Workspace Admin in the Salesforce workspace created in Zoho Analytics, the user will be able access all the data & reports, create new reports and do any operation that you could do on the workspace, except deleting the workspace & editing the Salesforce integration setup.

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

The tables and reports will be available only to the users who configures the Zoho Analytics connector, by default. The other members of the organization will be able to access it only when the 'Salesforce Reports' workspace shared. Let's say the Administrator has shared the workspace with other members in the organization. And a 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?

Other menbers in the organization can create reports when the user who setup the connector share the tables present in 'Salesforce Reports' workspace with them. 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 Workspace Admin in the Salesforce workspace created in Zoho Analytics, the user will be able access all the data & reports, create new reports and do any operation that you could do on the workspace, except deleting the workspace & editing the Salesforce integration setup.

4. 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 workspace admin, 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.

5. 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.

6. How can I print the reports & dashboards created in Zoho Analytics?

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

Open the table or report that you want to print.
Click the Export > Export as PDF.
Print the Exported PDF file.

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.

7. How can I email reports & dashboards created in Zoho Analytics in a scheduled manner?

If you are the Administrator of the Zoho Analytics connector or a Workspace Admin, you can schedule reports and dashboards to be emailed automatically. You can do this is as follows:

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

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

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

Charts
- CSV/XLS
- PDF
- HTML
- PNG/JPEG
Pivot/Tabular views
- CSV/XLS
- PDF
- HTML
Summary View
- CSV/XLS
- PDF
- HTML
Tabular View
- CSV/XLS
- PDF
- HTML
Dashboards
PDF
HTML

You can export a report/dashboard in Zoho Analytics as follows

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

9. Can I embed reports/dashboards as a Web Tab in Salesforce CRM? If yes how?

Yes, you can embed reports or dashboards as Web Tab in Salesforce CRM using the URL/Permalink for this view option available in Zoho Analytics.

Login to Salesforce CRM using your Salesforce credentials
Click Setup option in the top right corner
Select Create --> Tabs from the left pane
In the Custom Tabs window, click New in the Web Tabs box
In the New Web Tab, choose the tab layout and click Next
In the Display Properties box, fill in the information and click Next
In the Button or Link URL box, copy/paste the URL of the associated report/dashboard from the URL/Permalink for this view dialog

Note

In order to get the URL of the associated report/dashboard , Login to Zoho Analytics and open the Salesforce CRM workspace.
Open the report/dashboard that you wish to embed
Click the Publish icon in the top right corner of the report/dashboard and select URL/Permalink for this view
You can select the Access Permissions and also Specify the Filter Criteria in this Access URL dialog (to know more, refer URL/Permalink for this view)
Copy this code and paste it in the Button or Link URL box as discussed above

In the Add to Profiles window, you can either set a default visibility to all profiles or apply a different tab visibility to each profile. click Next
In the Add to Custom Apps window, you can customize the apps for which the new custom tab will be available. Also you can examine or alter the visibility of these tabs
Click Save
Now, this Web Tab name would be listed as one of the modules in your Salesforce CRM as shown in the snapshot below .

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

You can easily embed the reports & dashboards created in Zoho Analytics in your website, web application or blog. Follow the steps below to achieve the same:

Select the report or dashboard that you would like to embed into your website or blog.
Select the Publish > Embed in Website/Blog... option.

By default, when you embed the report into your website, web application or blog, it would prompt for users to login with Zoho Analytics login details to view the embedded view. Also, users to whom you have shared the view (using the 'Share' option) would only be able to access the view embedded, on successful login.

If you would like the embedded view to be accessible by anyone without login, then click on the link To access this view/table without login,

Copy and paste the code snippet provided in the text area below into your webpage or blog html content to embed this view.

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.

Solutions

1. Can I calculate sales Win Rate % and Loss Rate % from potentials/opportunities?

Yes, you can. Refer to the steps described in the embedded slideshow below.

2. Can I create Year-over-Year or Quarter-over-Quarter or Month-over-Month growth reports?

Yes, you can. Refer to the steps described in the embedded slide show below.

3. Can I create a Sales Pipeline Funnel Chart?

Yes, you can. Refer to the steps described in the embedded slide show below.

4. Can I create reports to view Average Sales cycle?

Yes, you can. Refer to the steps described in the embedded slide show below.

5. Can I create Top 5 or Bottom 5 sales person report?

Yes, you can. Refer to the steps described in the embedded slide show below.

6. How do I create Target (Quota) based reports in Zoho Analytics?

7. Can I calculate the percentage of potentials won out of the total leads?

Yes, you can. The following slide shows illustrates how to do this.

8. How can I create a cohort to analyze customer retention?

9. How is a sales cohort useful in keeping track of the team`s performance?

10. How do I measure the conversion rate of my leads to potentials using cohorts?

11. How can I create a cohort to calculate win rate?

Help & Support

1. How do I get technical support on Zoho Analytics connector?

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

You can also reach us on our toll-free numbers:

United States: +1 408 454 4202
India: +91-44-46447058 Extn: 6222

2. Can I have someone from Zoho do a Demo of this connector to me?

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