FranConnect logo

CRM integration

FranConnect reporting & pipeline

Turn franchise CRM leads, opportunities, source attribution, franchise units, and tenant-defined custom fields into 75 governed metrics for dashboards, agent answers, and cross-channel reporting.

What you can do with FranConnect in Maven

Maven models FranConnect into 75 governed metrics from the semantic layer. Track Average Days in Current Stage, Avg Days to Close, Avg Deal Size, Average Forecast Probability and Avg Open Deal Age, break results down by Deal Name, Pipeline, Deal stage and Stage Probability, and report FranConnect alongside Google Ads, LinkedIn Ads and Google Analytics 4 without rebuilding exports or metric logic for every report.

What you can measure

75 FranConnect metrics you can use consistently

Maven keeps FranConnect 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 FranConnect

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 FranConnect

You connect FranConnect with API credentials from the FranConnect account. Maven stores them encrypted. Each FranConnect sync takes a fresh copy of the current records, so the workspace always reflects what is in FranConnect now.

Leads

Fields: account name, title, lead first name, lead last name, company name, alternate email, phone numbers, mobile numbers, fax numbers, extn, and 94 more

Fields

Fields: account name, system name, label, data type, is custom, is required

Franchisees

Fields: account name, franchisee no, center name, franchisee name, legal name, owner name, phone numbers, address, city, state, and 88 more

How it works

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

In the client’s workspace, open Sources, add FranConnect 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 FranConnect data (3 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 FranConnect alongside the rest of your stack

FAQ

FranConnect reporting questions

What FranConnect metrics can I report on in Maven?

Maven exposes 75 governed FranConnect 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 FranConnect performance down by?

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

Can I combine FranConnect with other data sources?

Yes. FranConnect 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 FranConnect data does Maven sync?

Maven syncs franchise-sales leads, lead field metadata and franchisee/unit master data from FranConnect.

How often does FranConnect data sync to Maven?

Maven refreshes FranConnect 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 FranConnect 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.