Send Mercado Libre 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 Mercado Libre

Connect Mercado Livre Data to Your Analytics

Access comprehensive Mercado Livre data including your product catalog with attributes like brand and model, advertising performance showing total visits over 90 days, and complete order histories with buyer information. Kondado enables extraction of Mercado Pago payment statuses, shipment tracking numbers, and customer review ratings alongside complaint resolution data. You can monitor daily store performance metrics and analyze item variations by color and size to understand customer preferences and buying patterns.

Kondado provides 19 Mercado Livre pipelines containing 716 fields, covering Ads, Items, Orders, Payments, Shipments, Reviews, and Complaints for comprehensive data replication.

Marketing teams leverage this Mercado Livre data to optimize ad spend by correlating campaign performance with actual sales conversions. Operations managers track inventory levels and fulfillment efficiency through stock and shipment pipelines. Data analysts combine buyer email data with order context to build detailed customer segmentation models. Finance teams reconcile transaction totals from order invoices against Mercado Pago records for accurate revenue recognition and financial reporting.

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

The following Mercado Livre pipelines deliver granular insights into every aspect of your marketplace operations. Analyze the Items: daily performance pipeline to track sales velocity and interaction trends over time, while the Order Reviews pipeline captures customer ratings and comments for sentiment analysis. The Payments Mercado Pago pipeline provides transaction statuses and values for cash flow monitoring, and the Ads pipeline reveals which listings generate the most visits in the last 90 days. The Orders pipeline combined with Order Shipments data enables complete fulfillment tracking from purchase to delivery.

By joining these datasets, you can calculate true customer acquisition costs, identify top-performing product variations, and detect shipping delays before they impact seller ratings. Updates run on a configurable schedule from every 5 minutes to daily, ensuring your Mercado Livre analytics reflect current inventory levels, recent payments, and fresh customer feedback without manual data pulls.

Try out all the features for free for 14 days

Available Mercado Libre data

19
available pipelines
716
extractable fields

Available integrations

Integration Description
Ads Table presents published ads with fields such as id, title, price, and description, along with metrics like total_visits_last_90_days.
Items Table contains item details, including id, catalog_product_id, and attributes such as brand and model, along with pricing information.
Items: stock Table provides information on available stock, including user_product_id, item_id, and quantity, along with availability type.
Items: daily performance Table presents daily performance metrics of items, allowing analysis of sales and interactions over time.
Items: prices Table displays pricing information for items, including id, selling price, and sale conditions, essential for marketing strategies.
Items: selling prices Table provides details on the selling prices of items, including id and values, fundamental for market analysis.
Items: variations Table presents variations of items, including attributes such as color and size, allowing better customer segmentation.
Store: daily performance Table provides daily performance metrics of the store, including total sales and interactions, essential for evaluating results.
Payments Mercado Pago Table contains information on payments, including id, status, and values, fundamental for financial management.
Orders Table presents order details, including id, status, and information about buyers, essential for sales management.
Order Invoices Includes fields such as id, seller_id, and total_amount, allowing detailed analysis of transactions and billed amounts.
Order Reviews Contains information such as order_id, rating, and comment, facilitating the assessment of customer satisfaction and feedback on orders.
Order Buyers Presents data such as buyer_id, buyer_email, and buyer_name, allowing analysis of buyer profiles and their contact information.
Order Context Includes fields such as order_id, context_type, and context_value, providing insights into the conditions and circumstances of orders.
Order Shipments Contains information such as shipment_id, tracking_number, and shipping_status, allowing tracking and management of shipments made.
Order Items Includes data such as item_id, quantity, and price, facilitating the analysis of purchased products and their quantities.
Order Payments Presents fields such as payment_id, payment_method, and payment_status, allowing analysis of payment methods and statuses for orders.
Order Sellers Includes information such as seller_id, seller_name, and seller_rating, allowing analysis of seller performance and reputation.
Complaints Contains fields such as complaint_id, order_id, and resolution_status, facilitating tracking and management of customer complaints.
Ads
Table presents published ads with fields such as id, title, price, and description, along with metrics like total_visits_last_90_days.
Items
Table contains item details, including id, catalog_product_id, and attributes such as brand and model, along with pricing information.
Items: stock
Table provides information on available stock, including user_product_id, item_id, and quantity, along with availability type.
Items: daily performance
Table presents daily performance metrics of items, allowing analysis of sales and interactions over time.
Items: prices
Table displays pricing information for items, including id, selling price, and sale conditions, essential for marketing strategies.
Items: selling prices
Table provides details on the selling prices of items, including id and values, fundamental for market analysis.
Items: variations
Table presents variations of items, including attributes such as color and size, allowing better customer segmentation.
Store: daily performance
Table provides daily performance metrics of the store, including total sales and interactions, essential for evaluating results.
Payments Mercado Pago
Table contains information on payments, including id, status, and values, fundamental for financial management.
Orders
Table presents order details, including id, status, and information about buyers, essential for sales management.
Order Invoices
Includes fields such as id, seller_id, and total_amount, allowing detailed analysis of transactions and billed amounts.
Order Reviews
Contains information such as order_id, rating, and comment, facilitating the assessment of customer satisfaction and feedback on orders.
Order Buyers
Presents data such as buyer_id, buyer_email, and buyer_name, allowing analysis of buyer profiles and their contact information.
Order Context
Includes fields such as order_id, context_type, and context_value, providing insights into the conditions and circumstances of orders.
Order Shipments
Contains information such as shipment_id, tracking_number, and shipping_status, allowing tracking and management of shipments made.
Order Items
Includes data such as item_id, quantity, and price, facilitating the analysis of purchased products and their quantities.
Order Payments
Presents fields such as payment_id, payment_method, and payment_status, allowing analysis of payment methods and statuses for orders.
Order Sellers
Includes information such as seller_id, seller_name, and seller_rating, allowing analysis of seller performance and reputation.
Complaints
Contains fields such as complaint_id, order_id, and resolution_status, facilitating tracking and management of customer complaints.

Try out all the features for free for 14 days

How to visualize Mercado Libre data in 3 steps

Connect Mercado Libre to dashboards, spreadsheets, or databases — no code required.

1
Add Mercado Livre Data Source

Connect your Mercado Livre account by providing API credentials to establish the initial data source connection within Kondado.

2
Select Pipelines and Destinations

Choose from 19 available pipelines including Ads, Orders, and Payments, then select where to send your data such as Power BI, Looker Studio, Google Sheets, or BigQuery.

3
Visualize and Analyze Your Data

Build dashboards in your BI tools, explore metrics in spreadsheets, or query structured data in databases like PostgreSQL, MySQL, or Redshift to uncover actionable insights from your Mercado Livre operations.

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 Mercado Libre data

Choose a tool to visualize your Mercado Libre 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 Mercado Libre to dashboards, spreadsheets, and databases

What specific Mercado Livre data can I extract using Kondado?
You can replicate 19 different pipelines including Ads with visit metrics, Items with stock levels and price variations, Orders with buyer details and shipment tracking, Mercado Pago payment statuses, and customer Reviews with ratings. This covers everything from catalog attributes like brand and model to complaint resolution statuses for complete operational visibility.
How do I connect Mercado Livre to my existing analytics tools?
After adding Mercado Livre as a data source, select your desired pipelines and choose destinations like Power BI, Looker Studio, Google Sheets, or BigQuery. The connection requires your Mercado Livre API credentials to begin automated data replication.
What pre-built dashboards are available for Mercado Livre analytics?
Kondado offers ready-made report templates including the Mercado Libre Looker Studio Report and Mercado Libre Power BI Report. These templates provide immediate visualization of sales performance, payment trends, and customer satisfaction metrics without building visualizations from scratch.
How frequently does Kondado update my Mercado Livre data?
Data replication runs on a configurable schedule that you control, ranging from every 5 minutes to daily updates. This flexibility lets you monitor near-real-time order flows during peak sales periods or opt for daily batch updates for standard reporting needs.
Can I analyze Mercado Livre data in spreadsheets and databases simultaneously?
Yes, you can send the same pipelines to multiple destinations at once, such as Google Sheets for quick ad-hoc analysis and PostgreSQL or BigQuery for complex SQL querying and historical data warehousing. This enables both immediate business user access and deep technical analysis from the same source data.
What analyses can I run with Mercado Livre order and payment data?
You can calculate seller performance ratings by combining Order Sellers data with Reviews, reconcile Order Invoices against Mercado Pago Payments for financial accuracy, and analyze Order Context to understand which circumstances drive successful conversions or complaints. These insights help optimize both operational efficiency and customer satisfaction strategies.
Do I need technical skills to replicate Mercado Livre data?
No coding is required to set up these pipelines. The interface guides you through selecting specific Mercado Livre pipelines and connecting them to your preferred business intelligence tools or databases using a simple point-and-click configuration.

Try out all the features for free for 14 days