Keap logo

CRM integration

Keap reporting & pipeline

Turn contacts, companies, opportunities, pipeline, tasks, orders, products, source attribution, owners, currency, and timezone from Keap into 125 governed metrics for dashboards, agent answers, and cross-channel reporting.

What you can do with Keap in Maven

Maven models Keap into 125 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 Keap alongside Google Ads, LinkedIn Ads and Google Analytics 4 without rebuilding exports or metric logic for every report.

What you can measure

125 Keap metrics you can use consistently

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

AOV

Average order value from orders

Cancelled Orders

Orders marked cancelled in the canonical order fact

Show all 125 metrics

Completed Orders

Orders not marked cancelled in the canonical order fact

Ecommerce Discounts

Discounts from orders

Gross Revenue

Gross revenue from orders

Net Revenue

Net revenue from orders

Ecommerce Refunds

Refunds from orders

Ecommerce Subtotal Revenue

Order subtotal before tax shipping discounts and refunds

Collected Order Revenue

Amount collected on source orders when the provider supplies a paid balance; currently populated by Keap.

Order Count

Orders represented by the order-level ecommerce fact

Order Gross Revenue

Gross revenue at order grain

Order Net Revenue

Net revenue at order grain

Outstanding Order Revenue

Amount still due on source orders when the provider supplies an outstanding balance; currently populated by Keap.

Order Refunds

Refund amount at order grain

Order Shipping

Shipping amount charged on order-level ecommerce rows.

Order Tax

Tax amount collected on order-level ecommerce rows.

Order Units

Units sold at order grain

Orders

Count of orders

Platform Discount

Platform-funded discounts on TikTok Shop orders

Seller Discount

Seller-funded discounts on TikTok Shop orders

Shopify Current Order Value

Shopify order value after returns, sourced from currentTotalPriceSet.

SKU Count

Distinct SKU counts reported on TikTok Shop orders

Subtotal Price

Order subtotal before tax shipping discounts and refunds

TikTok Shop Items

Items represented on TikTok Shop orders

TikTok Shop Revenue

Gross revenue on TikTok Shop orders

Total Line Items

Line items represented across canonical orders

Total Weight

Units Sold (Ecommerce)

Units sold from orders

Current Order Value

Order value after post-purchase edits and returns (Shopify currentTotalPriceSet). Only Shopify reports this value, so the formula is limited to Shopify orders; other platforms' order totals are in ecommerce_gross_revenue

Collected Order Revenue

Amount collected on source orders when the provider supplies a paid balance; currently populated by Keap.

Ecommerce Orders

Orders represented by the order-level ecommerce fact

Outstanding Order Revenue

Amount still due on source orders when the provider supplies an outstanding balance; currently populated by Keap.

Ecommerce Units Sold

Units sold at order grain

Ecommerce Product Discounts

Line-level product discounts.

Ecommerce Product Net Revenue

Net product revenue after line-level discounts.

Ecommerce Product Net Revenue After Refunds

Product revenue after discounts and line-linked refunds; group or filter by currency

Ecommerce Product Orders

Distinct orders containing this product.

Ecommerce Product Revenue

Gross product revenue across commerce and shopping product rows

Ecommerce Product Units Sold

Units sold for the product at daily grain.

Shopping Clicks

Product-listing clicks reported by Google Merchant Center

Shopping Conversions

Product-listing conversions reported by Google Merchant Center

Shopping Impressions

Product-listing impressions reported by Google Merchant Center

Shopping Revenue

Product-listing conversion revenue reported by Google Merchant Center

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 Keap

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 Keap

You connect Keap by signing in to it and approving access, so nobody shares a password. The first Keap sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 12 months in total. After that, each scheduled sync re-reads the last 30 days, so late changes are picked up.

Business profile

Keap tenant reporting context and business dimension.

Fields: business name, website, time zone, currency, language tag, business type, business goals, city, state, country, and 2 more

Contacts

Keap contacts with account-safe identity, company, consent, geography, attribution, tags, ownership, and governed custom fields.

Fields: email, email opt status, is email opt in, first name, last name, company, job title, phone, contact type, source type, and 24 more

Companies

Keap company/account dimension with contactable identity and governed custom fields.

Fields: company name, email, phone, website, city, state, country, postal code, custom fields, created at, and 2 more

Users

Keap users/owners including active and inactive states.

Fields: user name, first name, last name, email, title, status, is admin, is partner, created at, updated at, and 1 more

Lead sources

Keap acquisition source, vendor, medium, category, status, and active window.

Fields: name, description, vendor, medium, status, start at, end at, created at, updated at, account name

Opportunity stages

Current Keap opportunity-stage dimension with order, probability, target days, and checklist.

Fields: stage name, stage order, probability, target days, checklist items, created at, updated at, account name

Opportunities

Keap current opportunity/deal snapshot with owner, contact, stage, value range, forecast, and next action.

Fields: opportunity title, contact name, contact email, contact company name, stage name, stage order, stage probability, owner name, projected revenue low, projected revenue high, and 10 more

Tags

Keap tag dimension for contact and company segmentation.

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

Tasks

Keap CRM task activity linked to contacts, opportunities, and owners.

Fields: title, task type, priority, is completed, due at, completed at, created at, updated at, custom fields, account name

Orders

Keap order/invoice summary with collected, due, refunded, source, customer, currency, and geography context.

Fields: order title, status, order type, source type, contact email, currency, total amount, total paid, total due, refund total, and 15 more

Order items

Keap order line-item grain with product hierarchy, quantity, unit economics, discount, and revenue.

Fields: product name, sku, item type, quantity, price per unit, cost per unit, discount amount, gross revenue, net revenue, currency, and 1 more

Products

Keap product catalog with SKU, price, tax/shipping/subscription flags, categories, and plans.

Fields: product name, sku, description, price, currency, is active, is taxable, is shippable, is subscription only, subscription plans, and 2 more

How it works

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

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

FAQ

Keap reporting questions

What Keap metrics can I report on in Maven?

Maven exposes 125 governed Keap 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 Keap performance down by?

You can break Keap 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 Keap with other data sources?

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

Maven syncs tenant identity, currency, timezone, and reporting context, contacts, consent, geography, attribution, ownership, and custom fields, companies and CRM accounts, users and CRM owners, acquisition sources and opportunity stages and forecast probabilities, and more from Keap.

How often does Keap data sync to Maven?

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