Skip to content

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
OpportunityOpportunities with amount, stage, close date, owner and won or lost status.
AccountCustomer companies, industry and region.
LeadLeads, lead source and conversion status (personal columns hashed on load).
ContactContacts (personal columns hashed on load).
UserSalesforce users, used as deal owners.
CampaignMarketing campaigns and the costs recorded in Salesforce.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Fields to fill inClient ID, Client Secret, Refresh Token
DeveloperAirbyte (certified), run inside DataxLand
LicenseELv2
Technical docsConnector 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.

MetricDefinitionUnit
New opportunitiesSales opportunities created in the period (by creation date), including open, won and lost ones.Count
Won opportunitiesNumber of opportunities won, by close date.Count
Won amountTotal value of won opportunities, by close date.Currency
Lost opportunitiesNumber of opportunities lost, by close date.Count
Win rateWon 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 valueTotal value of opportunities created in the period that are still open (neither won nor lost).Currency
Average deal sizeWon amount divided by the number of won opportunities.= Won amount / Won opportunitiesCurrency
Average sales cycle (days)Average days from creation to win for opportunities won in the period.= won_cycle_days_total / Won opportunitiesNumber
Quota attainmentWon amount divided by sales target. Above 100% means the target is exceeded.= Won amount / Sales targetRatio (%)
LeadsNumber of leads (prospects) created in the period, by creation date.Count
Lead-to-customer rateLeads created in the period that have become customers divided by leads created in the period.= mkt_converted_leads / LeadsRatio (%)

Connect Salesforce in 3 steps

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

Ask Si about your Salesforce data →Salesforce + LinkedIn Ads →All data sources →

Connect Salesforce and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes