PayPal logo

Billing & revenue integration

PayPal reporting & revenue

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

109 PayPal metrics you can use consistently

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

Amount Applied

Payment amount applied to linked invoices

Cash Collected

QuickBooks-canonical cash collected from payments (payments union is QB-first)

Payment Amount

Gross payment amount. Filter by direction: in is cash received from customers, out is cash paid to vendors.

Payment Application Count

Number of payment-to-document applications.

Payment Applied Amount

Amount of payments applied to invoices (direction in) or bills (direction out).

Payment Count

Number of payments.

Payment Net Amount

Payment amount net of fees and refunds.

Payment Refunded Amount

Amount refunded on payments.

Finance Payment Row Count

Rows on the merged payments surface (payment and application rows). Canonical measure; filter by direction and payment_row_type.

Show all 109 metrics

Payment Net Amount

Successful payment amount less refunds

Payment Refunded Amount

Refunded amount on payment headers

Vendor Payment Amount

Cash paid to vendors on QuickBooks bill-payment headers

Vendor Payment Applied Amount

Bill-payment amount allocated to linked QuickBooks bills

Vendor Payment Count

Count of current QuickBooks bill payments

Payment Activity Count

Payment operational records

Balance Ledger Amount

Signed gross amount on processor balance-ledger activity

Credit Amount

Credit amount applied to invoices

Payment Credit Count

Credits applied to invoices

Dispute Amount

Disputed amount

Payment Dispute Count

Dispute records

Failed Payment Count

Failed charge and terminal attempt records

Payment Fee Amount

Processing fees on balance activity

Gross Payment Amount

Successful gross charge amount

Net Balance Amount

Net balance activity after fees

Payout Amount

Amount settled to external accounts

Payment Payout Count

Payout records

Refund Amount

Successful refund activity amount

Payment Refund Count

Successful refund records

Successful Payment Count

Successful charge records

Dispute Count

Dispute records

Payment Events

Payment-processor activity records of every type (charge attempts, refunds, disputes, balance-ledger entries, payouts); filter activity_type for one lifecycle stage

Payout Count

Payout records

Payment Available Balance

Point-in-time payment-processor balance available for use or withdrawal (PayPal today; group or filter by platform)

Payment Balance

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 Balance Snapshot Count

Payment-processor account-currency balance observations; group or filter by platform (PayPal today)

Payment Withheld Balance

Point-in-time payment-processor balance held or unavailable (PayPal today; group or filter by platform)

Dispute Cases Requiring Seller Action

Payment-dispute cases whose current state requires merchant action (PayPal today; group or filter by platform)

Dispute Case Amount

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

Dispute Cases

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

Open Dispute Cases

Payment-dispute cases not currently resolved (PayPal today; group or filter by platform)

Resolved Dispute Cases

Payment-dispute cases currently resolved (PayPal today; group or filter by platform)

AOV

Average order value from orders

Cancelled Orders

Orders marked cancelled in the canonical order fact

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

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

PayPal Available Balance

Point-in-time PayPal balance available for use or withdrawal

PayPal Balance Snapshot Count

PayPal account-currency balance observations

PayPal Total Balance

Point-in-time total PayPal balance

PayPal Withheld Balance

Point-in-time PayPal balance held or unavailable

PayPal Dispute Amount

Amount originally disputed in PayPal cases

PayPal Dispute Count

Current PayPal dispute records

Open PayPal Disputes

PayPal disputes not currently resolved

Resolved PayPal Disputes

PayPal disputes currently resolved

PayPal Disputes Requiring Seller Action

PayPal disputes whose current state requires merchant action

Workspace Cash Collected

Monthly QuickBooks-canonical cash collected for workspace profitability

Workspace Delivery Billable Amount

Monthly delivery billable amount from time tracking

Workspace Delivery Cost Amount

Monthly delivery cost from time tracking

Workspace Ending AR

As-of-today open AR snapshot attributed to the current month only (not historical month-end AR)

Workspace Opex Amount

Monthly operating expenses for workspace profitability

Workspace Profitability Billable Hours

Workspace Profitability Hours Logged

Workspace Revenue Issued

Monthly canonical invoice revenue for workspace profitability

Questions you can ask

Just ask Maven about PayPal

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

What Maven pulls from PayPal

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.

Accounts

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

Balances

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

Transactions

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

Transaction items

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

Disputes

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

Connect PayPal 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 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.

Step 2

Maven syncs and models the data

Maven pulls the client’s PayPal data (5 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 PayPal alongside the rest of your stack

FAQ

PayPal reporting questions

What PayPal metrics can I report on in Maven?

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.

What can I break PayPal performance down by?

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.

Can I combine PayPal with other data sources?

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.

What PayPal data does Maven sync?

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.

How often does PayPal data sync to Maven?

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.

Is my PayPal 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.