How to add actual sales statistics from Mergado Orders to Google Sheets or Looker Studio#

Are you using Mergado Orders to automatically retrieve order data from your online store on the Eshop-rychle platform? In addition to advanced customer segmentation for retargeting, the extension also lets you eliminate repetitive work from manually processing statistics.

If you want a constant, up-to-date overview of your actual sales in real time, you can use the generated CSV feed and connect it to the analytics tools Google Sheets or Looker Studio. The following guide shows you how to turn data from Mergado Orders into automated reports that save you time and improve your marketing decisions.

Step 1: Preparing data in Mergado Orders#

To track sales statistics over time, you need to choose the correct data grouping type.

In the Mergado Orders interface, click New connection.
As the Aggregation type, select Day. This export type provides aggregated statistics on the online store’s performance by individual day.
Choose the Aggregation days — the period for which you want to analyse data retroactively (7, 30, 90, 180, or 360 days).
Enter the API URL, which you obtain from the Eshop-rychle admin.
Save by clicking Create.
In the Connections overview, copy the URL of the created export (by clicking the relevant icon next to the export).

Step 2: Importing data into Google Sheets#

Google Sheets allows dynamic connection to a CSV feed using a simple function.

Open a new spreadsheet in Google Sheets.
Into the first cell (A1), enter the formula: =importdata("YOUR_COPIED_URL_FROM_MERGADO_ORDERS")
The spreadsheet will automatically fill with data from Mergado Orders. Once the source feed updates (every day at 8:00 AM), the data in the spreadsheet will also update the next time it is opened or recalculated.

Step 3: Connecting to Looker Studio#

You can then easily insert and visualize the data from Google Sheets in Looker Studio.

In Looker Studio, open a blank report.
From the available sources, select Google Sheets.
Select the spreadsheet and sheet into which you imported data from Mergado Orders in the previous step.
Click Add.
You can now create charts and tables based on real orders.

What data will you find in the statistics from Mergado Orders?#

In the day-organized export, you will encounter these key elements:

DATE – Date of the order.
CONVERSIONS – Total number of orders for the given day.
CONVERSIONS_VALUE – Sum of all order values excluding VAT.
CONVERSIONS_VALUE_VAT – Sum of all order values including VAT.

FAQ#

How will connecting Mergado Orders with Looker Studio help me?#

Instead of manually downloading and processing order data, you’ll have an automatically updated overview and sales statistics directly in Looker Studio. Data refreshes every day without any manual work on your part.

Do I need to connect data from Mergado Orders with both Google Sheets and Looker Studio, or is one sufficient?#

It depends on your needs. Google Sheets is sufficient if you want the data in a spreadsheet and to work with it manually. Looker Studio is useful in addition when you want to visualize data as charts and clear reports.

Can I connect data from Mergado Orders directly to Looker Studio, without Google Sheets?#

Looker Studio does allow connections to other sources, but a direct connection to a CSV feed from Mergado Orders is not available by default. That’s why you need to get the data into Google Sheets first.

What aggregation type should I choose and why?#

For tracking sales statistics over time, choose the Day aggregation type. This type creates an export where each row corresponds to one day and contains aggregated order statistics for that day — how many orders were placed and what their total value was. The other aggregation types (Email, Product) are structured differently and are not suitable for this purpose.

How long a period (aggregation days) should I choose?#

It depends on how long a period you want to analyse. For tracking short-term trends, 30 days is sufficient; for seasonal analysis or longer-term overviews, choose 180 or 360 days.

Where do I find the export URL I’ll need in Google Sheets?#

On the Connections overview page, click the copy URL icon next to the relevant export. Paste this address into the function in Google Sheets.

How do I get data from Mergado Orders into Google Sheets?#

In Google Sheets, open a new spreadsheet and type =importdata("YOUR_COPIED_URL_FROM_MERGADO_ORDERS") into the first cell (A1). The spreadsheet will automatically fill with data from the feed.

How often does data in Google Sheets update?#

Data in the export from Mergado Orders updates every day at 8:00 AM. In Google Sheets, data refreshes when the spreadsheet is opened.

The `=importdata` function is returning an error. What should I do?#

The most common causes are an incorrectly copied URL (check for spaces or an incomplete address), or the feed has not been updated yet. Try manually refreshing the export in Mergado Orders by clicking the refresh icon, then reload the function in Google Sheets.

Why do I select Google Sheets as the data source in Looker Studio instead of Mergado Orders directly?#

Looker Studio cannot read CSV feeds directly. Google Sheets acts as an intermediary. Data from Mergado Orders is automatically updated there, and Looker Studio loads it from there.

What data will I find in the export and what do the individual values mean?#

The export contains four elements: DATE (date), CONVERSIONS (number of orders for the given day), CONVERSIONS_VALUE (total order value excluding VAT), and CONVERSIONS_VALUE_VAT (total order value including VAT).

Can I see details of individual orders or customers in Google Sheets or Looker Studio?#

No, the Day export type contains only aggregated daily statistics. For customer details, use the Email aggregation type export, which contains data at the individual customer level.