Home / Connectors / Salesforce
Connector

Salesforce connector: datasets and metric definitionsBeta

Bring in leads, opportunities, stage history, accounts and campaigns. Updates daily. Needs Salesforce Enterprise edition or above; your Salesforce admin installs the Quiriz package once.

7 datasets17 metric definitionsRead-onlyRefreshes daily

When you connect Salesforce, Quiriz imports the datasets below and adds the metric definitions to Company Context, the one place your company’s definitions live. Every answer that uses one of these metrics uses the same definition, in the app, in Slack and in the Excel, Sheets, PowerPoint, Slides, Word and Docs add-ins. An admin can edit any of them.

DatasetsMetric definitionsQuestionsFAQ

Datasets

DatasetWhat it holds
[Salesforce] LeadsLeads
19 columnslead_id, created_date, status, status_order, is_converted, converted_date, days_to_convert, converted_opportunity_id, converted_account_id, lead_source, owner, company, industry, country, state, rating, record_type, fiscal_year, fiscal_quarter
[Salesforce] Lead status historyLead status history
7 columnslead_id, status, status_order, entered_date, left_date, days_in_status, is_converted_status
[Salesforce] OpportunitiesOpportunities
28 columnsopportunity_id, name, account_id, account_name, owner, pipeline, record_type, type, stage, stage_order, is_closed, is_won, probability, forecast_category, amount, currency, amount_corporate, expected_revenue_corporate, weighted_amount_corporate, created_date, close_date, days_to_close, days_since_stage_change, lead_source, primary_campaign, is_from_lead, fiscal_year, fiscal_quarter
[Salesforce] Opportunity stage historyStage history
13 columnsopportunity_id, pipeline, stage, stage_order, is_closed, is_won, entered_date, left_date, days_in_stage, amount_corporate_at_entry, close_date_at_entry, probability_at_entry, forecast_category_at_entry
[Salesforce] Pipeline snapshotsPipeline snapshots
9 columnssnapshot_date, opportunity_id, pipeline, stage, stage_order, amount_corporate, close_date, forecast_category, owner
[Salesforce] AccountsAccounts
10 columnsaccount_id, name, type, industry, billing_country, billing_state, employees, annual_revenue_corporate, owner, created_date
[Salesforce] CampaignsCampaigns
16 columnscampaign_id, name, type, status, parent_campaign, start_date, end_date, is_active, budgeted_cost, actual_cost, leads, converted_leads, opportunities, won_opportunities, amount_all_opportunities, amount_won_opportunities

Metric definitions

Each metric is a total over the period you ask about. A metric built from other metrics, such as a rate, divides the totals for the whole period; it does not average daily rates. Dated by is the date column that decides which period a row belongs to.

[Salesforce] Leads

MetricHow it is calculatedDated byNotes
Salesforce leads createdCount of distinct lead_idcreated_dateLeads created, by create date. Group by lead_source for where they came from.
Salesforce lead conversion rateShare of rows where is_converted is 1created_dateConverted leads divided by leads created, by create date. Shown as a decimal (0.25 = 25%).
Salesforce days to convertAverage of days_to_convert, where is_converted = 1converted_dateMean days from lead creation to conversion, by convert date.

[Salesforce] Opportunities

MetricHow it is calculatedDated byNotes
Salesforce pipeline valueSum of amount_corporate, where is_closed = 0created_dateOpen opportunity amount in the corporate currency, by create date. Group by pipeline when the dataset has a pipeline column (the org has more than one sales process).
Salesforce weighted pipelineSum of weighted_amount_corporate, where is_closed = 0created_dateOpen opportunity amount times probability, in the corporate currency, by create date. Group by pipeline when the dataset has a pipeline column (the org has more than one sales process).
Salesforce win rateShare of rows where is_won is 1, where is_closed = 1close_dateWon opportunities divided by closed ones, by close date. Shown as a decimal (0.25 = 25%). Group by pipeline when the dataset has a pipeline column (the org has more than one sales process).
Salesforce average deal sizeAverage of amount_corporate, where is_won = 1close_dateMean amount of won opportunities in the corporate currency, by close date.
Salesforce closed won revenueSum of amount_corporate, where is_won = 1close_dateAmount of won opportunities in the corporate currency, by close date.
Salesforce sales cycle daysAverage of days_to_close, where is_won = 1close_dateMean days from create to close for won opportunities, by close date.
Salesforce lost dealsCount of distinct opportunity_id, where is_closed = 1 AND is_won = 0close_dateOpportunities closed and not won, by close date.
Salesforce stalled dealsCount of distinct opportunity_id, where is_closed = 0 AND days_since_stage_change > 30Today’s snapshotOpen opportunities with no stage change in over 30 days. Group by stage. Group by pipeline when the dataset has a pipeline column (the org has more than one sales process).

[Salesforce] Opportunity stage history

MetricHow it is calculatedDated byNotes
Salesforce average days in stageAverage of days_in_stageentered_dateMean days an opportunity spent in a stage, by the date it entered. Group by stage. Group by pipeline when the dataset has a pipeline column (the org has more than one sales process).
Salesforce deals entering stageCount of distinct opportunity_identered_dateOpportunities that entered a stage, by entry date. Next stage divided by this stage is the stage conversion rate. Group by pipeline when the dataset has a pipeline column (the org has more than one sales process).

[Salesforce] Pipeline snapshots

MetricHow it is calculatedDated byNotes
Salesforce open pipeline as ofSum of amount_corporatesnapshot_dateOpen pipeline in the corporate currency on a snapshot date. Filter to one snapshot_date (or compare two); summing across dates double-counts. Group by pipeline when the dataset has a pipeline column (the org has more than one sales process).

[Salesforce] Campaigns

MetricHow it is calculatedDated byNotes
Salesforce campaign costSum of actual_coststart_dateActual campaign cost, by campaign start date.
Salesforce campaign won dealsSum of won_opportunitiesstart_dateWon opportunities credited to the campaign (Salesforce's all-time roll-up), by campaign start date.
Salesforce campaign cost per won dealSalesforce campaign cost ÷ Salesforce campaign won dealsstart_dateActual campaign cost divided by the won opportunities credited to the campaign.

Questions to ask

Ask Salesforce in plain words

Try the questions on sample data with no signup, then connect Salesforce read-only and ask your own.

Try Quiriz free →

Frequently asked questions

Does Quiriz change anything in Salesforce?
No. The Salesforce connector is read-only. Quiriz reads the data into datasets and never writes back to Salesforce.
How often does the Salesforce data refresh?
Once a day. Each dataset shows when it was last updated, and answers use the latest refresh.
Can I change how a metric is calculated?
Yes. The definitions are added to Company Context, where an admin can edit the formula, the filter or the date it uses. A daily refresh never overwrites a definition someone has changed.
Can I combine Salesforce with other sources?
Yes. An admin can also define a metric from metrics on different datasets. See cross-source metrics.

All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.