Mercado Libre Report Looker Studio

This guide provides a complete overview of the Mercado Libre Report on Looker Studio 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.

🎥 Mercado Libre Report on Looker Studio

Watch the video below to explore all the features and capabilities of the Mercado Libre Report on Looker Studio:

Mercado Libre Report Looker Studio

This guide provides a complete overview of the Mercado Libre Report on Looker Studio 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.

Summary

• Accessing the Looker Studio Report
• 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 on Looker Studio 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 Looker Studio

• Once your Kondado account is created, just follow the first steps tutorial and add a data source for Mercado Libre.
• When your data 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 on Looker Studio 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 on Looker Studio?

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 in Kondado with Via Kondado destination to use the Report. Via Kondado is a Kondado solution that allows you to connect Looker Studio 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. Looker Studio 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:

1. Create your free account on Kondado

2. Add your Mercado Libre Source

3. Click "Create+" > Dashboards and select the Mercado Libre Report on Looker Studio template

4. 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 on Looker Studio, you have complete commercial control, ensuring more agile, strategic management based on precise data. For more detailed information, visit this link.