Home > Destinations > Data Studio (ex Looker Studio) > Magento

Connect Magento to Data Studio (ex Looker Studio)

Connect Magento to Data Studio (ex Looker Studio) and and build automated dashboards without CSV exports, spreadsheets, or manual API setup.

Looker Studio
Power BI
Google Sheets
BigQuery
Snowflake

Used by the world's leading companies

Why do agencies use Catchr for Magento reporting in Data Studio (Looker Studio)?

Catchr lets media buyers and agencies stop rebuilding Magento reports by hand: the data lands in Data Studio ready to chart, for every ad account you manage.

No manual csv export
‍

Stop downloading files from Magento every time a client report, spreadsheet, or dashboard needs fresh numbers.

Connected in minutes

Your first Magento report can be live in a few minutes. Authorize your Magento account, pick your ad accounts, and your data source is ready.

Built for agencies with many Ecommerce accounts

Pull several Ecommerce accounts into one data source, then filter by account to build a report per client or brand in the same Data Studio file.

Magento to Looker Studio pricing

Choose your plan by the number of platforms and accounts you report on.

Starter

For freelancers and small teams.

$ 24 /mo

Billed monthly · cancel anytime

Platforms3
Accounts10
Start free trial

Growth

For agencies managing more clients.

$ 239 /mo

Billed monthly · cancel anytime

Platforms10
Accounts100
Start free trial

Scale

For teams reporting at scale.

$ 599 /mo

Billed monthly · cancel anytime

Platforms25
Accounts500
Start free trial

How to connect Magento to Data Studio with Catchr?

To connect Magento to Looker Studio (Data Studio), open the Catchr connector, authorize your Magento account, select the ad accounts you want to report on, then create your report.

1. Open the Catchr Magento connector in Looker Studio

Click the connector link to open it inside Looker Studio. You will be asked to authorize the connector before creating your data source.

2. Authorize Looker Studio (Data Studio) and Catchr

Choose the Google account you use for Looker Studio and authorize Catchr to create a secure Magento data source.

3. Connect your Magento account

Sign in with your Magento account that has access to the accounts you want to report on. Make sure your user has the right Magento permissions.

4. Select your Magento accounts

Choose one or several Ecommerce accounts, depending on the report you want to build.

5. Create your Data Studio report

Click Create report, then add charts, scorecards, tables, filters, and date controls using your Magento metrics and dimensions.

6. Customize your dashboard

Use , Date, Order Item Sku, Order Item Name, Order Item Product Type, Order Shipping Country Code, Order Base Currency Code and many more.

Magento metrics and dimensions available in Data Studio

Access 0 metrics and 144 dimensions from Magento connectors including , Date, Order Item Sku, Order Item Name, Order Item Product Type, Order Shipping Country Code, Order Base Currency Code and more.

0

Available metrics

144

Available dimensions

Build better Magento dashboards in Data Studio (ex Looker Studio)

Use Catchr to create dashboards that show what is working, what is wasting budget, and where performance is changing.

Client reporting for agencies

Create clean Looker Studio dashboards for each client with with always up to date.

Budget pacing

Compare daily spend with the monthly budget of each campaign, so overspend shows up mid-month instead of on the invoice.

Review what drives results across

Compare to see where budget, traffic, or revenue is improving and where performance is dropping.

Compare with your other channels

Combine with your others marketing to understand performance across your full acquisition journey.

Keep an eye on Magento performance

Track Magento in refreshable Data Studio dashboards so you can spot changes before they become reporting problems.

Customer testimonials

What our customers say about us.

85 %
Faster
Reporting time

After three years of use, Catchr has become essential for both our teams and our clients. So far, it has been our best solution for compiling and analyzing data from different advertising platforms. It’s easy to set up, and the customer service is responsive and excellent.

Valentin Keravel
CEO, Laio – Agency

With Catchr’s automated API, we can finally collect and centralize all advertising data, connect it with booking information, and calculate the real ROAS for our restaurant clients. It gives them full visibility, more autonomy, and the ability to optimize campaigns to maximize ROI.

Corentin Largeron
Freelance
30
hours saved

The solution is a real game changer, providing optimal time savings for our data reporting. The major strength of the solution is their highly responsive and professional support.

Corentin Largeron
CEO at The Browz – Agency

Magento to Data Studio (ex Looker Studio): FAQ

Answers to common questions about connecting data to spreadsheets, dashboards, AI assistants, and reporting tools with Catchr.

How do I connect Magento to Looker Studio?

Connect your Magento store to Catchr using the store URL and integration credentials requested during setup: Consumer Key, Consumer Secret, Access Token, and Access Token Secret. Then open the Catchr Magento connector in Looker Studio, authorize Google, select the store, and create your report.

Which Magento sales data is available in Catchr?

The connector exposes orders and order items, including order IDs, statuses, store information, customer-group fields, totals, taxes, shipping, discounts, paid amounts, and refunds. Product-level fields include SKU, product type, prices, and quantities ordered, invoiced, shipped, cancelled, or refunded. Choose fields that match the stage of the sale you want to measure.

What is the difference between Magento order total, paid total, and invoiced total?

These describe different stages of the order lifecycle. An order can exist before it has been fully invoiced or paid, and later cancellations or refunds can change the amounts involved. Keep those totals as separate measures and align order status filters with your reporting goal rather than labeling every order total as collected revenue.

Should I use base currency or order currency for Magento reporting?

Magento exposes base-currency and order-currency fields, along with their currency codes and exchange-rate information. Choose one consistent basis for financial comparisons. If orders use several currencies, do not add their unconverted grand totals; group by currency or use a validated common-currency measure.

Can I report on Magento refunds and product fulfillment?

Yes. Order-item fields distinguish quantities ordered, invoiced, shipped, cancelled, and refunded, while order fields include refund totals. These can help identify changes in fulfillment and returns. Keep order-level and item-level amounts separate, and do not interpret an order’s current refund total as the amount refunded on its creation date.

Why do Magento sales increase when I add product details?

Adding item details can repeat order-level values for each product row. Use distinct order IDs to count orders and the corresponding item totals for product analysis. Check product type and row structure for configurable or bundled products before summing quantities, so that related rows are not counted as separate customer orders.

Can I compare Magento sales with website analytics?

Yes. Add Google Analytics 4 to compare store orders with tracked website activity. Validate transaction IDs and align store scope, currencies, and dates before joining purchase data. Magento records commerce operations, while GA4 depends on event tracking, so their order and revenue figures can differ.

Still have a question?

Our team is always here to answer any questions you may have about our data connector.