Nutshell logo

CRM integration

Nutshell reporting & pipeline

Turn cRM accounts, contacts, leads, activities, products, pipelines, sources, owners, change history, and deletions into 86 governed metrics for dashboards, agent answers, and cross-channel reporting.

What you can do with Nutshell in Maven

Maven models Nutshell into 86 governed metrics from the semantic layer. Track Average CRM Activity Duration, CRM Activity-Contact Associations, CRM Activity Count, CRM Activity-Deal Associations and Cancelled CRM Activities, break results down by Account, Activity Name, Activity Type Name and Status, and report Nutshell alongside Google Ads, LinkedIn Ads and Google Analytics 4 without rebuilding exports or metric logic for every report.

What you can measure

86 Nutshell metrics you can use consistently

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

Average CRM Activity Duration

Average scheduled duration in minutes for CRM activities with valid start and end times

CRM Activity-Contact Associations

Contact associations carried by CRM activity records

CRM Activity Count

Scheduled, logged, and cancelled CRM activities at native activity grain

CRM Activity-Deal Associations

Deal associations carried by CRM activity records

Cancelled CRM Activities

CRM activities marked cancelled

Logged CRM Activities

CRM activities marked logged/completed by the provider

Overdue CRM Activities

CRM activities marked overdue

Average CRM Product Unit Price

Average provider unit price across CRM deal-product lines

CRM Product Line Count

Product lines attached to CRM deals

Show all 86 metrics

CRM Product Quantity

Quantity of products attached to CRM deals

CRM Product Revenue

Extended deal-product line amount calculated as quantity times provider unit price

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

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 Nutshell

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?

Connection and sync

What Maven pulls from Nutshell

You connect Nutshell with API credentials from the Nutshell account. Maven stores them encrypted. The first Nutshell sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 2 years in total. After that, each scheduled sync re-reads the last 3 days, so late changes are picked up.

Accounts

Fields: name, description, primary email, primary phone, website, domain, city, state, country, postal code, and 8 more

Contacts

Fields: full name, first name, last name, job title, primary email, primary phone, website, domain, description, city, and 8 more

Leads

Fields: lead number, name, description, status, confidence, priority, value amount, value currency, value formatted, is overdue, and 8 more

Pipelines

Fields: pipeline name, is default pipeline, pipeline status, can access pipeline, stage name, stage description, stage position, account name

Users

Fields: name, first name, last name, primary email, emails, is enabled, is admin, created at, updated at, account name

Sources

Fields: name, description, channel, source type, status, created at, updated at, deleted at, account name

Account types

Fields: name, description, status, created at, updated at, account name

Industries

Fields: name, description, status, created at, updated at, account name

Events

Fields: occurred at, actor type, payload type, action, changes, is deletion, account name

Outcomes

Fields: name, description, status, created at, updated at, account name

Activity types

Fields: name, is benchmarkable, updated at, account name

Activities

Fields: name, agenda, status, is all day, is cancelled, is flagged, is logged, is overdue, start at, end at, and 5 more

Products

Fields: name, description, sku, product type, unit price amount, unit price currency, prices, updated at, deleted at, account name

Product maps

Fields: name, unit, quantity, product type, price amount, price currency, relationship, account name

How it works

Connect Nutshell 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 Nutshell

In the client’s workspace, open Sources, add Nutshell 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 Nutshell data (14 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.

Works well with

Report Nutshell alongside the rest of your stack

FAQ

Nutshell reporting questions

What Nutshell metrics can I report on in Maven?

Maven exposes 86 governed Nutshell metrics, including Average CRM Activity Duration, CRM Activity-Contact Associations, CRM Activity Count, CRM Activity-Deal Associations, Cancelled CRM Activities and Logged CRM Activities — each defined once so it means the same thing in every report.

What can I break Nutshell performance down by?

You can break Nutshell metrics down by Account, Activity Name, Activity Type Name, Status, Is All Day, Is Flagged, Is Overdue and Deal Name, and more.

Can I combine Nutshell with other data sources?

Yes. Nutshell sits in the same client workspace as sources like Google Ads, LinkedIn Ads, Google Analytics 4, Klaviyo and Shopify, so one report or question can use them together.

What Nutshell data does Maven sync?

Maven syncs accounts, contacts, leads / opportunities, pipelines and stages, users / owners and lead sources, and more from Nutshell.

How often does Nutshell data sync to Maven?

Maven refreshes Nutshell on a schedule after the source is connected, and shows each source’s last sync time in the client’s workspace, so you can check the data is current before a report goes out.

Is my Nutshell data secure with Maven?

Yes. Maven encrypts integration credentials and tokens, scopes access to the workspace, and uses the connection only to sync the reporting data needed for governed analytics.

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.