Salesforce logo

CRM integration

Salesforce reporting & pipeline

Turn Salesforce opportunities, pipeline, and lead sources into governed revenue reporting your clients can trust.

What you can do with Salesforce in Maven

Maven connects Salesforce and models opportunities, deal stages, leads, and accounts into governed CRM metrics you can trust. Track pipeline value, weighted pipeline, win rate, average deal size, and average days to close alongside the full lead funnel — MQL rate, SQL rate, and lead conversion rate — then break every result down by stage, pipeline, owner, lead source, or lifecycle stage. Snapshot open, won, and lost pipeline over time, and tie closed revenue back to the Google Ads, LinkedIn, and Facebook campaigns that sourced it.

What you can measure

75 Salesforce metrics you can use consistently

Maven keeps Salesforce numbers consistent across dashboards, reports, and answers so the team is not debating which spreadsheet is right.

Average Days in Current Stage

Average number of days open deals have remained in their current pipeline stage

Avg Days to Close

Average days from creation to close

Avg Deal Size

Average CRM deal amount calculated from deal amount divided by deal count

Average Forecast Probability

Average CRM forecast probability across deals that provide a forecast probability

Avg Open Deal Age

Average age of currently-open deals in days (creation to today)

Average Stage Probability

Average pipeline-stage probability across represented CRM deals

Closed Deals

CRM deals whose stage outcome is won or lost

CRM Deal-Account Associations

CRM deal-to-account associations where native account IDs are available

CRM Deal Associations

CRM deal association rows or summary counts, summed per deal

Show all 75 metrics

CRM Deal-Contact Associations

CRM deal-to-contact associations where native contact IDs are available

Deal Amount

CRM deal amount for monetary CRM opportunities; FranConnect lead rows have no amount

Deal Count

CRM deals or franchise-sales leads at deal grain

Forecast Amount

Num Contacts

Stage Display Order

Weighted Pipeline

Pipeline amount weighted by stage probability

Win Rate

Closed-won deals divided by all closed deals

Won Deals

Deals marked closed-won at the CRM stage outcome

Deal-Account Associations

CRM deal-to-account associations where native account IDs are available

Deal Associations

CRM deal association rows or summary counts, summed per deal

Deal-Contact Associations

CRM deal-to-contact associations where native contact IDs are available

Average Lead Score

Average native lead score across CRM leads that provide a score

Converted Leads

CRM leads or contacts marked converted by native or inferred lifecycle evidence

Customer-Matched Leads

CRM leads or contacts that resolve to ecommerce customer identity

Lead Conversion Rate

Converted CRM leads divided by all CRM leads

Lead Count

CRM leads or contacts at lead/contact grain

Lead Customer Match Rate

CRM leads matched to ecommerce customers divided by all CRM leads

Lead Qualification Rate

Qualified CRM leads divided by all CRM leads

MQL Leads

CRM leads or contacts whose conformed lifecycle stage is marketing-qualified lead

MQL Rate

Marketing-qualified CRM leads divided by all CRM leads

Qualified Leads

CRM leads or contacts marked qualified by native or inferred lifecycle evidence

SQL Leads

CRM leads or contacts whose conformed lifecycle stage is sales-qualified lead

SQL Rate

Sales-qualified CRM leads divided by all CRM leads

CRM Current Stage Observations

Current-stage snapshot observations in the CRM stage history surface

CRM Stage Events

CRM stage/property history events plus current-stage observations

Snapshot Closed Amount

Cumulative closed deal amount as of the snapshot date.

Snapshot Deal Count

Deals in the stage as of the snapshot date.

Lost Deals (Snapshot)

Cumulative closed-lost deals as of each snapshot date

Open Pipeline Value

Open deal amount in the pipeline as of each snapshot date

Open Deals (Snapshot)

Open deals in the pipeline as of each snapshot date

Weighted Pipeline (Snapshot)

Probability-weighted open pipeline value as of each snapshot date

Won Deals (Snapshot)

Cumulative closed-won deals as of each snapshot date

Attributed Closed CRM Deals

Closed CRM deals with deterministic campaign attribution matched to paid delivery

Attributed CRM Deals

CRM deals with deterministic campaign attribution matched to paid delivery

Attributed Won CRM Deals

Won CRM deals with deterministic campaign attribution matched to paid delivery

Paid CRM Clicks

Paid-media clicks represented in the paid-to-CRM surface

Paid CRM Cost per Deal

Paid spend divided by attributed CRM deals

Paid CRM Cost per Won Deal

Paid spend divided by attributed won CRM deals

Deterministically Matched CRM Deals

Attributed deals backed by a deterministic identity match

Paid CRM Impressions

Paid-media impressions represented in the paid-to-CRM surface

Paid CRM Spend

Paid-media spend on campaign-day rows with CRM attribution coverage; group or filter by spend_currency

Attributed Closed Deals

Closed CRM deals with deterministic campaign attribution matched to paid delivery

Attributed Deals

CRM deals with deterministic campaign attribution matched to paid delivery

Attributed Won Deals

Won CRM deals with deterministic campaign attribution matched to paid delivery

Deterministically Matched Deals

Attributed deals backed by a deterministic identity match

Conversion Weight (First Touch)

Fractional conversion credit under the first-touch model by conversion touchpoint

Conversion Weight (Last Touch)

Fractional conversion credit under the last-touch model by conversion touchpoint

Conversion Weight (Linear)

Fractional conversion credit under the linear model by conversion touchpoint

Conversion Weight (Markov)

Fractional conversion credit under the data-driven Markov removal-effect model by conversion touchpoint

Conversion Weight (Position Based)

Fractional conversion credit under the position-based model by conversion touchpoint

Conversion Weight (Shapley)

Fractional conversion credit under the data-driven Shapley-value model by conversion touchpoint

Conversion Weight (Time Decay)

Fractional conversion credit under the time-decay model by conversion touchpoint

Conversion Events

Canonical conversion/lead events counted through normalized last-touch weights

Answered Interactions

Source-neutral interactions that were answered

Average Answered Interaction Duration

Average duration in seconds among answered interactions

Avg Session Duration (s)

Average session duration in seconds with each session counted once

First-Touch Events

Touchpoints that opened a session

Interaction Answer Rate

Share of represented interactions that were answered

Interactions

Source-neutral interactions represented as attribution touchpoints

Last-Touch Events

Touchpoints that closed a session

Missed Interactions

Phone interactions that were neither answered nor sent to voicemail

Total Interaction Duration

Total interaction duration in seconds

Touchpoints

Journey touchpoint events recorded before conversion credit allocation

Touchpoint Order

Voicemail Interactions

Source-neutral interactions that reached voicemail

Questions you can ask

Just ask Maven about Salesforce

Maven’s agent answers in plain language with the right metric definitions applied automatically. These are real, verified questions it can run today.

What is our deal pipeline value by stage for deals created in the last 90 days?

Show closed deals by stage

Show average days to close by owner

Show average open deal age by owner

Show open pipeline by stage

Show won and lost deals in the latest pipeline snapshot by stage

Show closed amount by pipeline in the latest pipeline snapshot

How many ServiceTitan bookings did we get in the last 30 days?

Report templates

Salesforce reports for the next client review

Use Salesforce reporting templates to see what needs attention, what can be trusted, and which optional fields need cleanup before the next review.

Maven report template

Account Influence Report

A client-ready LinkedIn account engagement report connected to CRM pipeline, revenue, journeys, and warm-account signals.

Account influenceLinkedIn + CRMLive data

Paid company delivery uses LinkedIn MEMBER_COMPANY. Organic engagement and firmographics require LinkedIn Company Intelligence provisioning.

Connection and sync

What Maven pulls from Salesforce

You connect Salesforce with client ID, client secret and instance URL from the Salesforce account. Maven stores them encrypted. Each Salesforce sync takes a fresh copy of the current records, so the workspace always reflects what is in Salesforce now.

How it works

Connect Salesforce to a client’s workspace

No SQL or warehouse setup. Connect the source, then build the client’s report by asking Claude or ChatGPT.

Step 1

Connect Salesforce

In the client’s workspace, open Sources, add Salesforce and choose the account to sync. If you don’t have access to the account, send the client a connect link where the platform supports one.

Step 2

Maven syncs and models the data

Maven pulls the client’s Salesforce data (7 objects) and models it into documented tables. No SQL, warehouse or pipeline setup.

Step 3

Report, ask and automate

Build the client’s report or deck by asking Claude or ChatGPT through the MCP, set alerts on what matters, and publish to the client’s portal once you approve it.

What Maven syncs from Salesforce

AccountsContactsOpportunitiesOpportunity stage historyOpportunity-contact rolesLeadsUsers and owners

Works well with

Report Salesforce alongside the rest of your stack

FAQ

Salesforce reporting questions

What Salesforce metrics can I report on in Maven?

Maven exposes 75 governed Salesforce metrics, including Average Days in Current Stage, Avg Days to Close, Avg Deal Size, Average Forecast Probability, Avg Open Deal Age and Average Stage Probability — each defined once so it means the same thing in every report.

What can I break Salesforce performance down by?

You can break Salesforce metrics down by Deal Name, Pipeline, Deal stage, Stage Probability, Stage outcome, Source Timezone, Close date and Forecast Probability, and more.

Can I combine Salesforce with other data sources?

Yes. Salesforce sits in the same client workspace as sources like Google Ads, LinkedIn Ads, Facebook Ads, Google Analytics 4 and Google Search Console, so one report or question can use them together.

How often does Salesforce data sync to Maven?

Maven syncs Salesforce automatically: a fast first source pull after connecting, then scheduled refreshes that keep reports current. The last successful sync time is always visible, so you know the source data is fresh before it feeds a trusted reporting workflow.

Can Maven report Salesforce pipeline and lead sources together?

Yes. Maven models Salesforce opportunities, deal stages, and the lead funnel alongside owner and lead source, so the same workspace can answer pipeline questions — value, weighted pipeline, win rate, and average days to close by stage or owner — and trace which acquisition sources produce the deals that close.

Is my Salesforce data secure with Maven?

Yes. Maven connects to Salesforce over its official OAuth flow — no password sharing — stores access tokens encrypted, and pulls read-only reporting data into a governed warehouse you control.

Start your 14-day trial

Set up your first client, build their report by asking Claude or ChatGPT, and publish it to their portal.

  • Free for 14 days, no credit card
  • Your first client workspace and portal
  • Every report template, ready to clone
Start a 14-day trial

Nothing is charged unless you subscribe.

Prefer a walkthrough? Book a demo on one of your own clients.