CRM and sales
Connect Salesforce to DataxLand
The Salesforce connector reads your Salesforce objects through the API - Opportunity, Account, Contact, Lead, User, Campaign and any custom objects you pick. Si maps Opportunity to the sales team's opportunity model and Lead to marketing leads, so you get new opportunities, won and lost deals, win rate, pipeline value, average deal size, sales cycle, target attainment and lead-to-customer rate, with one definition across dashboards, Si and MCP.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with Salesforce
- Track pipeline and win rate per owner without building separate reports in Salesforce.
- Set targets in Google Sheets and measure attainment against won opportunities.
- Combine with LinkedIn Ads or Google Ads for cost per lead by campaign.
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 |
|---|---|
| Opportunity | Opportunities with amount, stage, close date, owner and won or lost status. |
| Account | Customer companies, industry and region. |
| Lead | Leads, lead source and conversion status (personal columns hashed on load). |
| Contact | Contacts (personal columns hashed on load). |
| User | Salesforce users, used as deal owners. |
| Campaign | Marketing campaigns and the costs recorded in Salesforce. |
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, Refresh Token |
| Developer | Airbyte (certified), 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 |
|---|---|---|
| New opportunities | Sales opportunities created in the period (by creation date), including open, won and lost ones. | Count |
| Won opportunities | Number of opportunities won, by close date. | Count |
| Won amount | Total value of won opportunities, by close date. | Currency |
| Lost opportunities | Number of opportunities lost, 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 |
| Average sales cycle (days) | Average days from creation to win for opportunities won in the period.= won_cycle_days_total / Won opportunities | Number |
| Quota attainment | Won amount divided by sales target. Above 100% means the target is exceeded.= Won amount / Sales target | Ratio (%) |
| 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 Salesforce in 3 steps
- 1
Create a Connected App
In Salesforce Setup, create a Connected App with OAuth enabled and generate a refresh token for a user who can read the objects you need.
- 2
Add the source
In the workspace choose Add source, find Salesforce in the connector library, enter the client ID, client secret and refresh token, tick Sandbox if needed, filter the objects to read and click Test connection.
- 3
Choose streams and review
Pick Opportunity, Account, Lead and User (loaded incrementally by last-modified time); Si proposes which stages count as won or lost and how objects join, and you approve before the build.
Limits and caveats
- DataxLand does not run the Salesforce sign-in for you; you create the Connected App and refresh token yourself.
- Salesforce caps daily API calls by edition; read only the objects you need to save quota.
- Target attainment needs a targets table (Google Sheets or Excel). This is an Airbyte connector (ELv2) run inside DataxLand.
Frequently asked questions
Can it read custom objects?
Yes. Select them in the object filter and Si proposes how to interpret them when you review.
Does DataxLand change Salesforce data?
No. DataxLand only reads.
Does it work with a Sandbox?
Yes. Turn on the Sandbox option to try it out before connecting production.
Dashboard templates that use this source
Connect Salesforce and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes