Connect Mercado Libre to Pentaho: Dashboards in Minutes
Get started for free
No credit card required | 14 days | 10 million records | 30 pipelines
or sign up with your email
By signing up, you agree to Kondado’s Terms of service and Privacy policy
How to Visualize Mercado Livre Data in Pentaho
You can visualize Mercado Livre data in Pentaho by using Kondado to replicate your marketplace information directly into your analytics environment. Simply connect Mercado Livre as a data source, select Pentaho as your destination, and choose from nineteen available pipelines spanning over seven hundred fields to populate your business reports. Kondado handles the data preparation behind the scenes, so marketing and operations teams can build insightful dashboards without writing any code or managing technical infrastructure.
With automated updates running on your preferred timetable, your Pentaho reports always reflect the latest marketplace activity. This means you can track product performance, advertising results, and customer behavior as your business evolves, turning raw marketplace data into clear visualizations that support daily decisions.
Kondado offers a direct Via Kondado connection that sends Mercado Livre data to Pentaho with no intermediate databases and no complex setup, allowing business teams to monitor sales, ads, and orders with automated updates on a configurable schedule.
Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required
Combining Mercado Livre with Pentaho gives business teams a complete view of their e-commerce operation through rich visual reports. For example, you can merge the Items: daily performance pipeline with the Ads pipeline to understand how published listings and advertising spend translate into actual sales trends over time. Adding the Orders pipeline and Order Payments data lets operations and finance teams track transaction volumes, payment methods, buyer behavior, and revenue patterns in one centralized place. These combined insights help you adjust pricing, optimize campaigns, and manage inventory with confidence.
Try out all the features for free for 14 days
Mercado Libre data available in Pentaho
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. |
Try out all the features for free for 14 days
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)