Mercado Libre Report Power BI
This guide provides a complete overview of the Mercado Libre Report in Power BI by Kondado. If you need assistance integrating your data into the Report, follow the steps in this guide to configure the Mercado Libre Pipeline and take advantage of all the features of a customizable Report.
View Example Report Use Your Own Data
Summary
- How to Use Your Data in the Kondado Report Template
- Pipelines and Models
- Report Features
- Highlights
- Benefits of using this template
- Frequently Asked Questions (FAQ)
How to Use Your Data in the Kondado Report Template
Accessing Kondado
- The first step to using your own data in the Mercado Libre Report in Power BI is to create a free trial account at Kondado. To do this, simply visit https://app.kondado.com.br/signup and register with your email.
Connecting Your Data to the Mercado Libre Template in Power BI
- Once your Kondado account is created, just follow the first steps tutorial and add a Source for Mercado Libre.
- When your Source for Mercado Libre has been created, you will be presented with the option to follow the tutorial to create your Report.
- After choosing this option, the platform will create the Pipelines and at the end of all the steps, it will present the link to access the Report with your own data!
Pipelines and Models
Below are the Pipelines and models required to use the Report template. Incremental Pipelines may have their savepoint adjusted to fetch historical data.
Pipelines:
- Orders - incremental
- Orders: Items - incremental
- Orders: Shipments - incremental
- Orders: Payments - incremental
- Items - full (free)
- Ads (Campaigns) - incremental
- Ads (Ads) - incremental
- Items: Variations - full (free)
Models:
- modelo_ml_pedidos
- modelo_ml_geo
- modelo_ml_variacao
Report Features
The Mercado Libre Report in Power BI provides a comprehensive and detailed view of your store's performance on Mercado Libre, bringing together strategic data on Sales, Ads, Customers, Products, Inventory, and ABC Curve. With direct Pipeline to Mercado Libre via Kondado, it enables efficient tracking of key business indicators, facilitating decision-making based on consolidated and updated data.
With scorecards, charts, and interactive tables, the panel presents essential metrics such as:
- Total revenue and average ticket
- Investment in ads and commissions to Mercado Libre
- Organic vs. paid performance (sales via ads)
- Average ACOS and ROAS
- Product ranking by revenue
- Geographic sales analysis (states and cities)
- Inventory management with variations
- ABC Curve for strategic prioritization
Panel Highlights
Page: Overview – View the main indicators of your operation in one place. Track total revenue, commissions to Mercado Libre, shipping value, investment in ads, average ticket, number of orders, and products sold. Analyze revenue evolution over time with an adjustable time series chart by month, year, or specific date. View the distribution of orders by status and check the ranking of products that generated the most revenue.
Page: Ads (Campaigns) – Monitor the performance of your advertising campaigns. Track campaign investment, organic sales vs. sales via ads, products sold in each channel, revenue generated by sales type, direct and indirect sales. Analyze average ACOS and ROAS of the operation. View detailed performance of each campaign with metrics on cost, clicks, CPC, conversions, and profitability.
Page: Ads (Ads) – Granular analysis of each individual ad. Track ad cost, organic and ad sales, revenue by channel, direct and indirect sales, average ACOS, and ROAS. Check the complete ads performance table with product thumbnail, SKU, clicks, impressions, CTR, CVR, ACOS, and ROAS per ad.
Page: Customers – Understand the geographic profile of your customer base. Track the number of customers served, states and cities served. Analyze revenue distribution by state, by city, and identify top customers by generated value.
Page: Products – Consolidated view of product performance. Check the complete table with SKU, product name, generated revenue, number of orders, quantity of items sold, and commission paid to Mercado Libre.
Page: Inventory – Complete inventory management with variations. Monitor the inventory table with detailed information on SKU, product, category, color, size, full variation, and quantity in stock.
Page: ABC – Strategic prioritization analysis. Has 2 tabs:
- ABC Curve (By SKU) – Classification of products into Class A (green), Class B (blue), and Class C (red)
- ABC Curve (By Category) – Analysis by product category
Use the ABC Curve to identify which products or categories generate greater impact on revenue and deserve more attention in inventory management and ad investment.
Benefits of using the Report
Why choose the Kondado Mercado Libre Report?
- ✅ Consolidated view of sales and ads – All information about your Mercado Libre business in one place, with automatic updates
- ✅ Ads analysis – Track investment, performance, and profitability of campaigns and individual ads
- ✅ Organic vs. paid performance analysis – Compare results from natural sales with sales driven by ads
- ✅ Profitability tracking – Monitor commissions, shipping, ACOS, and ROAS to understand the financial health of the operation
- ✅ Inventory management – Complete control of products with variations (color, size)
- ✅ Geographic analysis – Understand where your best customers are by state and city
- ✅ ABC Curve for strategic decision-making – Prioritize products and categories based on revenue impact
- ✅ 100% customizable – Edit charts, colors, filters, and metrics according to your needs
- ✅ Free and easy to use – Just create the template and connect your data
- ✅ Automatic updates – Data always updated according to your Kondado plan frequency
- ✅ Shareable – Distribute the Report with your team and stakeholders
Frequently Asked Questions (FAQ)
1. What is the Mercado Libre Report in Power BI?
It is a free Report template created by Kondado that presents the main business indicators of Mercado Libre in a visual and interactive way. Includes analysis of sales, ads, customers, products, inventory, and ABC Curve. Requires the use of Via Kondado as a data source.
2. Do I need Via Kondado to use this template?
Yes! This template uses Via Kondado as a data source. Configure your Mercado Libre Source in Kondado with Via Kondado destination to use the Report. Via Kondado is a Kondado solution that allows you to connect Power BI directly to integrated data.
3. Can I customize the Report?
Yes! When making a copy of the template, you can edit charts, metrics, colors, and layout according to your needs. Power BI offers total flexibility for customization.
4. How frequently is the data updated?
The update frequency depends on your Kondado plan. It can be every 5 minutes, hourly, daily, or weekly. Data is automatically synchronized from Mercado Libre to Kondado and reflected in the Report.
5. How do I get started?
Follow these simple steps:
- Create your free account on Kondado
- Add your Mercado Libre Source
- Click "Create+" > Reports and select the Mercado Libre Report in Power BI template
- Done! Now just wait for the Pipelines to run and your data will be automatically available. You will receive an email notification on how to access the Report.
6. What is ACOS and ROAS?
ACOS (Advertising Cost of Sales): Percentage of ad investment relative to the revenue generated by them. The lower, the better. ROAS (Return on Ad Spend): Return on ad investment. Indicates how many dollars of revenue were generated for each dollar invested. The higher, the better.
With the Mercado Libre Report in Power BI, you have complete commercial control, ensuring more agile, strategic management based on precise data. For more detailed information, visit this link.
Set up the Mercado Libre Report in Power BI
Configure your Mercado Libre data pipeline and connect it to the Kondado Power BI Report template for complete business analytics.
Create your Kondado account
Start by creating a free trial account at Kondado's signup page. Register with your email to access the platform and begin integrating your Mercado Libre data.
Add Mercado Libre as a Source
Follow the first steps tutorial in Kondado to add Mercado Libre as a data source. This establishes the connection to pull your store's orders, items, ads, and inventory data.
Create the Report template
After your Source is configured, select the option to create the Mercado Libre Report in Power BI. The platform will automatically build the required Pipelines including Orders, Items, Ads, and Inventory with their respective data models.
Configure Via Kondado destination
Set up Via Kondado as your destination to enable direct connection from Power BI to your integrated data. This Kondado solution allows seamless access without manual exports.
Access and customize your Report
Once Pipelines complete, you'll receive a link to access your Report with live data. Explore pages like Overview, Ads, Customers, Products, Inventory, and ABC Curve—then customize charts, colors, and metrics to match your business needs.
