Connect PayPal
In the client’s workspace, open Sources, add PayPal 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.
Billing & revenue integration
Turn payments, refunds, payer history, fees, and transaction-level product detail into 109 governed metrics for dashboards, agent answers, and cross-channel reporting.
What you can do with PayPal in Maven
Maven models PayPal into 109 governed metrics from the semantic layer. Track Amount Applied, Cash Collected, Payment Amount, Payment Application Count and Payment Applied Amount, break results down by Account, Direction, Payment Row Type and Payment Number, and report PayPal alongside HubSpot CRM, Shopify and Google Analytics 4 without rebuilding exports or metric logic for every report.
What you can measure
Maven keeps PayPal numbers consistent across dashboards, reports, and answers so the team is not debating which spreadsheet is right.
Payment amount applied to linked invoices
QuickBooks-canonical cash collected from payments (payments union is QB-first)
Gross payment amount. Filter by direction: in is cash received from customers, out is cash paid to vendors.
Number of payment-to-document applications.
Amount of payments applied to invoices (direction in) or bills (direction out).
Number of payments.
Payment amount net of fees and refunds.
Amount refunded on payments.
Rows on the merged payments surface (payment and application rows). Canonical measure; filter by direction and payment_row_type.
Successful payment amount less refunds
Refunded amount on payment headers
Cash paid to vendors on QuickBooks bill-payment headers
Bill-payment amount allocated to linked QuickBooks bills
Count of current QuickBooks bill payments
Payment operational records
Signed gross amount on processor balance-ledger activity
Credit amount applied to invoices
Credits applied to invoices
Disputed amount
Dispute records
Failed charge and terminal attempt records
Processing fees on balance activity
Successful gross charge amount
Net balance activity after fees
Amount settled to external accounts
Payout records
Successful refund activity amount
Successful refund records
Successful charge records
Dispute records
Payment-processor activity records of every type (charge attempts, refunds, disputes, balance-ledger entries, payouts); filter activity_type for one lifecycle stage
Payout records
Point-in-time payment-processor balance available for use or withdrawal (PayPal today; group or filter by platform)
Point-in-time total payment-processor account balance (PayPal today; group or filter by platform). Snapshot: filter to one date before summing; not the balance-ledger activity in balance_ledger_amount
Payment-processor account-currency balance observations; group or filter by platform (PayPal today)
Point-in-time payment-processor balance held or unavailable (PayPal today; group or filter by platform)
Payment-dispute cases whose current state requires merchant action (PayPal today; group or filter by platform)
Amount originally disputed on current payment-dispute cases (PayPal today; group or filter by platform). Differs from dispute_amount, which sums dated dispute events on payment activity
Current payment-dispute case records, one per dispute in its latest state (PayPal today; group or filter by platform). Differs from dispute_count, which counts dated dispute events on payment activity
Payment-dispute cases not currently resolved (PayPal today; group or filter by platform)
Payment-dispute cases currently resolved (PayPal today; group or filter by platform)
Average order value from orders
Orders marked cancelled in the canonical order fact
Orders not marked cancelled in the canonical order fact
Discounts from orders
Gross revenue from orders
Net revenue from orders
Refunds from orders
Order subtotal before tax shipping discounts and refunds
Amount collected on source orders when the provider supplies a paid balance; currently populated by Keap.
Orders represented by the order-level ecommerce fact
Gross revenue at order grain
Net revenue at order grain
Amount still due on source orders when the provider supplies an outstanding balance; currently populated by Keap.
Refund amount at order grain
Shipping amount charged on order-level ecommerce rows.
Tax amount collected on order-level ecommerce rows.
Units sold at order grain
Count of orders
Platform-funded discounts on TikTok Shop orders
Seller-funded discounts on TikTok Shop orders
Shopify order value after returns, sourced from currentTotalPriceSet.
Distinct SKU counts reported on TikTok Shop orders
Order subtotal before tax shipping discounts and refunds
Items represented on TikTok Shop orders
Gross revenue on TikTok Shop orders
Line items represented across canonical orders
Units sold from orders
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
Amount collected on source orders when the provider supplies a paid balance; currently populated by Keap.
Orders represented by the order-level ecommerce fact
Amount still due on source orders when the provider supplies an outstanding balance; currently populated by Keap.
Units sold at order grain
Line-level product discounts.
Net product revenue after line-level discounts.
Product revenue after discounts and line-linked refunds; group or filter by currency
Distinct orders containing this product.
Gross product revenue across commerce and shopping product rows
Units sold for the product at daily grain.
Product-listing clicks reported by Google Merchant Center
Product-listing conversions reported by Google Merchant Center
Product-listing impressions reported by Google Merchant Center
Product-listing conversion revenue reported by Google Merchant Center
Fractional conversion credit under the first-touch model by conversion touchpoint
Fractional conversion credit under the last-touch model by conversion touchpoint
Fractional conversion credit under the linear model by conversion touchpoint
Fractional conversion credit under the data-driven Markov removal-effect model by conversion touchpoint
Fractional conversion credit under the position-based model by conversion touchpoint
Fractional conversion credit under the data-driven Shapley-value model by conversion touchpoint
Fractional conversion credit under the time-decay model by conversion touchpoint
Canonical conversion/lead events counted through normalized last-touch weights
Point-in-time PayPal balance available for use or withdrawal
PayPal account-currency balance observations
Point-in-time total PayPal balance
Point-in-time PayPal balance held or unavailable
Amount originally disputed in PayPal cases
Current PayPal dispute records
PayPal disputes not currently resolved
PayPal disputes currently resolved
PayPal disputes whose current state requires merchant action
Monthly QuickBooks-canonical cash collected for workspace profitability
Monthly delivery billable amount from time tracking
Monthly delivery cost from time tracking
As-of-today open AR snapshot attributed to the current month only (not historical month-end AR)
Monthly operating expenses for workspace profitability
Monthly canonical invoice revenue for workspace profitability
Questions you can ask
Maven’s agent answers in plain language with the right metric definitions applied automatically. These are real, verified questions it can run today.
How many ecommerce orders did we get per week over the last 12 weeks?
Show ecommerce refunds by platform
Show cancelled orders by financial status
Show order discounts by customer type
Compare linear attribution weights by channel
Connection and sync
You connect PayPal with client ID and client secret from the PayPal account. Maven stores them encrypted. The first PayPal sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 3 years in total. After that, each scheduled sync re-reads the last 3 days, so late changes are picked up.
Current PayPal reporting account identity, capability status, and sync metadata.
Fields: account name, default currency, timezone, livemode, transactions available, balances available, disputes status, transaction count, balance currency count, dispute count, and 1 more
PayPal per-currency total, available, and withheld balances at the requested reporting time.
Fields: account name, currency, is primary, total balance, available balance, withheld balance, as of at, last refreshed at
PayPal transaction ledger including completed, pending, denied, reversed, fee, transfer, and balance activity.
Fields: account name, payer email, payer given name, payer surname, payer country code, payer status, payer address status, reference ID type, event code, event group, and 38 more
Product details passed by the merchant to PayPal for each account-qualified transaction.
Fields: account name, event code, item index, item code, item name, item description, quantity, unit price, item amount, total item amount, and 12 more
Optional PayPal dispute summaries when the connected REST app has the Disputes feature.
Fields: account name, reason, status, dispute state, lifecycle stage, channel, amount, currency, outcome code, seller response due at, and 3 more
How it works
No SQL or warehouse setup. Connect the source, then build the client’s report by asking Claude or ChatGPT.
In the client’s workspace, open Sources, add PayPal 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.
Maven pulls the client’s PayPal data (5 objects) and models it into documented tables. No SQL, warehouse or pipeline setup.
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
FAQ
Maven exposes 109 governed PayPal metrics, including Amount Applied, Cash Collected, Payment Amount, Payment Application Count, Payment Applied Amount and Payment Count — each defined once so it means the same thing in every report.
You can break PayPal metrics down by Account, Direction, Payment Row Type, Payment Number, Line Index, Linked Txn Index, Linked Txn Type and Counterparty Role, and more.
Yes. PayPal sits in the same client workspace as sources like HubSpot, Shopify, Google Analytics 4 and Google Ads, so one report or question can use them together.
Maven syncs reporting account identity, currency, and capability status, per-currency total, available, and withheld balance snapshots, transaction lifecycle, payments, fees, refunds, disputes, and payer context, transaction product line items passed to PayPal and dispute lifecycle summaries when app access is enabled from PayPal.
Maven refreshes PayPal 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.
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.
Set up your first client, build their report by asking Claude or ChatGPT, and publish it to their portal.
Nothing is charged unless you subscribe.