PayPal reports
and dashboards
Bring your PayPal data into Filament. Create dashboards, build reports and explore your questions in plain English.
Your PayPal data, connected.
PayPal shows you transaction volumes and invoice status, but understanding which customers generate recurring revenue or how payment behavior correlates with marketing campaigns means connecting to your CRM and analytics tools.
Filament links PayPal transactions, subscriptions, and invoices to your other platforms so you can analyze payment patterns, subscription health, and revenue attribution without manual exports.
Data we sync
BILLING_PLANExample fields: Plan id, Billing frequency
Track subscription plans and pricing tiers with plan_id, billing_frequency, pricing_model, payment_preferences, and setup_fees to analyze subscription revenue patterns and plan performance.
plan_idbilling_frequencypricing_modelpayment_preferencessetup_fees
SUBSCRIPTIONExample fields: Subscription id, Status
Monitor active and cancelled subscriptions with subscription_id, status, start_date, billing_cycle_sequence, and next_billing_time to understand churn patterns and recurring revenue health.
subscription_idstatusstart_datebilling_cycle_sequencenext_billing_time
INVOICEExample fields: Invoice id, Invoice date
Track invoice details and payment status with invoice_id, invoice_date, due_date, status, and amount to measure payment collection rates and outstanding receivables.
invoice_idinvoice_datedue_datestatusamount
Transaction HistoryExample fields: Transaction id, Transaction amount
Analyze payment flows with transaction_id, transaction_amount, transaction_status, payment_mode, and transaction_event_code to understand revenue patterns and payment method preferences.
transaction_idtransaction_amounttransaction_statuspayment_modetransaction_event_code
Refunds and TransfersExample fields: Refund id, Refund amount
Monitor refund patterns with refund_id, refund_amount, refund_status, reason_code, and create_time to identify product issues or customer satisfaction trends.
refund_idrefund_amountrefund_statusreason_codecreate_time
Payment MethodsExample fields: Payment source id, Type
Track payment sources with payment_source_id, type, brand, last_digits, and expiry_date to understand customer payment preferences and optimize checkout experiences.
payment_source_idtypebrandlast_digitsexpiry_date
PayPal works well with

Xero
Connect PayPal transaction data with Xero accounting records to reconcile payments automatically and see which invoice payment patterns affect cash flow forecasting.

Google Analytics 4
Connect PayPal transactions with GA4 session data to trace revenue back to specific traffic sources and see which marketing channels drive the highest transaction values.

HubSpot
Connect PayPal payment history with HubSpot contact records to identify which customer segments have the highest lifetime value and which sales campaigns generate recurring subscription revenue.
See the
whole picture.
Filament brings your apps together in a managed warehouse. Build dashboards, share reports and ask questions in plain English.
Explore the demo dashboard$118,050 of $245,000
194 of 250
Your questions, answered.
How do I connect PayPal?
This connection uses Fivetran.
You need a PayPal administrator account and access to its developer apps.
- Sign in to PayPal Developer. In Apps & Credentials → REST API apps, open the app for the environment you want to connect.
- Copy the Client ID and reveal and copy the Secret.
- For a Merchant app, enable Accept payments and Subscriptions, Invoicing, Customer Disputes and Transaction Search. Scope changes can take up to nine hours to become available.
- Open Apps in Filament and add PayPal. Use the production connection for live data; sandbox credentials require a separate sandbox connection.
- Enter the Client ID and Secret Key from that same environment.
- Select Save & Test, then return to Filament and complete setup.
How far back does Filament sync PayPal data?
Filament syncs your complete PayPal transaction history, including all invoices, subscriptions, and payment records from when you first started using PayPal. This lets you analyze year-over-year trends and long-term customer payment behavior.
Can I connect multiple PayPal accounts to Filament?
Yes. Agencies and businesses managing multiple PayPal accounts can connect each one separately to Filament. You can then analyze data across all accounts or filter to specific accounts when asking questions.
Does Filament track PayPal subscription churn in real-time?
Filament syncs PayPal subscription data regularly throughout the day, so you can track subscription cancellations, plan changes, and billing failures as they happen. Combine this with your CRM or support tools to see what drives churn.
Can I see which marketing channels drive PayPal transactions?
Yes. Connect PayPal with Google Analytics, Facebook Ads, or your CRM to trace transactions back to their original marketing source. Ask questions like which campaigns generate the most revenue or which channels have the highest transaction values.
Which PayPal KPIs can I track?
Payment volume: count and total completed payments, keeping currencies separate. Refunds: compare refunded amounts with the corresponding completed payments. Outstanding invoices: unpaid invoice balances grouped by due date. Exclude cancelled invoices.


