CRM and sales
Connect ZohoCRM to DataxLand
The Zoho CRM connector reads CRM modules such as Leads, Deals, Contacts and Accounts. Si maps Deals to sales opportunities and Leads to leads in the standard model, so you can see won amount, win rate, pipeline value and lead-to-customer rate by owner and by month, then ask Si about those numbers in plain language.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with ZohoCRM
- Track pipeline and win rate for a sales team on Zoho CRM.
- Measure lead-to-customer rate by lead source once ad spend is joined in.
- Set an alert when open pipeline value drops sharply from the previous week.
What data you get
Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.
| Stream (table) | Contents |
|---|---|
| Deals | Deals with value, stage, expected close date and owner. |
| Leads | Leads with lead source, status and created date; names, emails and phone numbers are hashed on load. |
| Contacts | Customer contacts; personal data is hashed. |
| Accounts | Customer companies, used as an analysis dimension. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | Client ID, Client Secret, Data Center Location, Environment, Refresh Token |
| Developer | Airbyte (community), run inside DataxLand |
| License | ELv2 |
| Technical docs | Connector documentation ↗ |
Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.
Metrics computed from this source
Real definitions from the analytics packs; dashboards and Si share them.
| Metric | Definition | Unit |
|---|---|---|
| Won amount | Total value of won opportunities, by close date. | Currency |
| Won opportunities | Number of opportunities won, by close date. | Count |
| Win rate | Won opportunities divided by all closed opportunities (won plus lost) in the period. Open opportunities are excluded.= Won opportunities / (Won opportunities + Lost opportunities) | Ratio (%) |
| Open pipeline value | Total value of opportunities created in the period that are still open (neither won nor lost). | Currency |
| Average deal size | Won amount divided by the number of won opportunities.= Won amount / Won opportunities | Currency |
| New opportunities | Sales opportunities created in the period (by creation date), including open, won and lost ones. | Count |
| Leads | Number of leads (prospects) created in the period, by creation date. | Count |
| Lead-to-customer rate | Leads created in the period that have become customers divided by leads created in the period.= mkt_converted_leads / Leads | Ratio (%) |
Connect ZohoCRM in 4 steps
- 1
Create a Zoho app
In the Zoho API Console, create a client (Self Client), get the Client ID and Client Secret, and generate a refresh token that can read the modules you need.
- 2
Add the Zoho CRM source
In the workspace choose Add source, find Zoho CRM, and enter the Client ID, Client Secret, Refresh Token, data region (Data Center Location) and environment; keys are encrypted when saved.
- 3
Test and choose streams
Click Test connection, then select the Deals, Leads, Contacts and Accounts modules.
- 4
Review and build
Si proposes a mapping from modules to opportunities and leads; you approve, then build the sales dashboard.
Limits and caveats
- DataxLand does not run the Zoho OAuth sign-in; you create the client and refresh token yourself in the Zoho API Console.
- Stream names are the module names in your CRM; custom modules also appear if the account can read them.
- Requires the Starter plan or above; Zoho limits API calls per day according to your CRM plan.
- A community Airbyte connector (ELv2 license) run inside DataxLand.
Frequently asked questions
Which data region should I choose?
The region where your Zoho account was created, for example US, EU, IN or AU; with the wrong region, the connection test reports an error.
Do I need Zoho admin rights?
Not necessarily, but the refresh token can only read the modules its creator is allowed to see.
Does customer personal data reach Si?
No. Name, email and phone number columns are hashed on load and masked before they reach Si.
Dashboard templates that use this source
Connect ZohoCRM and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes