Send Pagar.me data to reports, spreadsheets and ETL

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

shape Pagar.me

Connect Pagar.me Data to Your Analytics

Access comprehensive Pagar.me data through Kondado’s direct integration, including detailed customer profiles from the Customers pipeline with contact information and addresses, complete transaction histories via Charges and Orders pipelines, and financial movement tracking through Balance Operations and Receivables. Replicate card details and billing addresses to understand payment preferences, or analyze recipient data for complex split payment scenarios. This data source provides granular visibility into every stage of your payment funnel, from initial customer creation through final settlement, enabling deep analysis of conversion patterns and revenue recognition.

Kondado’s Pagar.me data source includes 8 pipelines with 344 total fields, covering Customers, Customers: Cards, Customers: Addresses, Charges, Balance Operations, Orders, Recipients, and Receivables endpoints.

The Kondado platform takes care of refreshing Pagar.me data, allowing you to stop wasting time with manual work and complex workflows, and focus on analyzing Pagar.me data in your report, spreadsheet, data warehouse, data lake, or database

Marketing teams leverage customer and order data to optimize acquisition campaigns and calculate lifetime value, while finance teams use Balance Operations and Receivables pipelines to forecast cash flow and reconcile settlements. Operations managers monitor transaction success rates and charge patterns to identify fraud trends or payment method preferences. Data analysts combine these pipelines to build unified dashboards showing customer journey from first contact through repeat purchases, enabling strategic decisions about payment optimization and customer retention strategies.

Available Pagar.me Pipelines

The following pipelines deliver specific Pagar.me datasets directly to your preferred analytics environment. The Customers pipeline provides comprehensive demographic and contact data essential for segmentation analysis and retention studies, while the Charges pipeline captures transaction amounts, dates, and processing statuses for detailed revenue tracking. Analyze the Orders pipeline to understand purchase patterns, cart values, and completion rates across different time periods, or use the Receivables pipeline to monitor pending settlements, expected cash flow timing, and payment anticipation strategies. The Balance Operations pipeline records every financial movement including fees, chargebacks, and adjustments necessary for accurate accounting reconciliation, while Customers: Addresses enables geographic analysis of your customer base and regional sales performance. Combining the Customers: Cards pipeline with Charges data reveals payment method preferences and authorization success rates by card brand, while linking Recipients to Orders clarifies complex marketplace commission structures and split payment distributions. With automated updates on a configurable schedule ranging from every 5 minutes to daily intervals, your payment KPIs and financial metrics remain current without requiring manual data refreshes.

Try out all the features for free for 14 days

Available Pagar.me data

8
available pipelines
344
extractable fields

Available integrations

Integration Description
Customers Includes information such as customer name, email, and status, along with address and phone data like area code and number.
Customers: Cards Records card details including brand, expiration date, and status, along with cardholder name and card digits.
Customers: Addresses Contains address data such as city, state, and country, along with creation date and address status.
Charges Includes information on charges made, such as amount, date, and status, along with details of the associated customer.
Balance Operations Records operations related to balance, including operation type, amount, and transaction date.
Orders Contains details of orders placed, such as total amount, status, and creation date, along with customer information.
Recipients Includes information about recipients, such as name, document, and status, along with creation and update data.
Receivables Contains information about receivables, including amount, due date, and status, along with details of the associated customer.
Customers
Includes information such as customer name, email, and status, along with address and phone data like area code and number.
Customers: Cards
Records card details including brand, expiration date, and status, along with cardholder name and card digits.
Customers: Addresses
Contains address data such as city, state, and country, along with creation date and address status.
Charges
Includes information on charges made, such as amount, date, and status, along with details of the associated customer.
Balance Operations
Records operations related to balance, including operation type, amount, and transaction date.
Orders
Contains details of orders placed, such as total amount, status, and creation date, along with customer information.
Recipients
Includes information about recipients, such as name, document, and status, along with creation and update data.
Receivables
Contains information about receivables, including amount, due date, and status, along with details of the associated customer.

Try out all the features for free for 14 days

How to visualize Pagar.me data in 3 steps

Connect Pagar.me to dashboards, spreadsheets, or databases — no code required.

1
Add Pagar.me Data Source

Connect your Pagar.me account to Kondado by entering your API credentials in the platform interface, establishing a direct link to your payment data.

2
Select Pipelines and Destination

Choose from the 8 available pipelines including Customers, Charges, and Orders, then replicate your data to Power BI, Google Sheets, BigQuery, PostgreSQL, or MySQL.

3
Visualize and Analyze Your Data

Build custom dashboards in Power BI or Looker Studio, explore metrics in Google Sheets or Excel, and run SQL queries on database tables in BigQuery, PostgreSQL, Redshift, or SQL Server.

Try out all the features for free for 14 days

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Pick a Spreadsheet, Database, Data Warehouse or Data Lake to receive Pagar.me data

Choose a tool to visualize your Pagar.me data

If the software you need is not listed, drop us a messagem. You can use almost every tool

Frequently Asked Questions (FAQ)

Find answers to common questions about connecting Pagar.me to dashboards, spreadsheets, and databases

What specific customer information can I extract from Pagar.me using Kondado?
You can access detailed customer profiles through the Customers pipeline, including names, email addresses, phone numbers with area codes, and status indicators. The Customers: Cards pipeline provides card brand, expiration dates, and holder information, while Customers: Addresses contains city, state, country, and geographic data for location-based analysis.
How do I connect my Pagar.me account to Kondado?
Set up your Pagar.me data source by entering your API credentials in the Kondado platform interface, establishing a direct connection without coding requirements. The authentication process links your payment data directly to your selected destinations such as Power BI or BigQuery.
What Pagar.me financial data is available for cash flow analysis?
The Receivables pipeline delivers amounts, due dates, and settlement statuses for forecasting incoming funds, while Balance Operations records all financial movements including fees, chargebacks, and adjustments. Together, these pipelines provide complete visibility into your cash position and transaction economics for accurate financial planning.
Can I analyze Pagar.me transaction data by payment method?
Yes, by combining the Customers: Cards pipeline with the Charges pipeline, you can analyze transaction success rates and authorization patterns by card brand. This cross-analysis reveals which payment methods convert best and helps identify potential issues with specific card types or issuing banks.
How often does Kondado update my Pagar.me data?
Kondado updates your Pagar.me data on a configurable schedule that you control, ranging from every 5 minutes to daily intervals. This flexibility allows you to maintain near-real-time monitoring for high-volume operations or choose less frequent updates for periodic reporting needs.
Which BI tools and databases work with Pagar.me data from Kondado?
You can send your Pagar.me data to business intelligence tools like Power BI and Looker Studio, spreadsheets including Google Sheets and Excel, or databases such as BigQuery, PostgreSQL, MySQL, and Redshift for comprehensive analytics across your preferred platforms.
How can I track split payments and marketplace commissions in Pagar.me?
The Recipients pipeline contains recipient names, documents, and status information for split payment scenarios, which you can link to the Orders pipeline to calculate commissions and revenue shares. This combination enables marketplace operators to reconcile payments between multiple sellers and track platform economics accurately.
What insights can I gain from the Pagar.me Orders pipeline?
The Orders pipeline provides total amounts, creation dates, current statuses, and linked customer information for analyzing purchase patterns and completion rates. Use this data to identify cart abandonment trends, average order values, and seasonal purchasing behaviors to optimize your checkout process and inventory planning.

Try out all the features for free for 14 days