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

Connect Shopify to Data Studio (ex Looker Studio)

Connect Shopify 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 Shopify reporting in Data Studio (Looker Studio)?

Catchr lets media buyers and agencies stop rebuilding Shopify 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 Shopify every time a client report, spreadsheet, or dashboard needs fresh numbers.

Connected in minutes

Your first Shopify report can be live in a few minutes. Authorize your Shopify 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.

Shopify 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 Shopify to Data Studio with Catchr?

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

1. Open the Catchr Shopify 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 Shopify data source.

3. Connect your Shopify account

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

4. Select your Shopify 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 Shopify metrics and dimensions.

6. Customize your dashboard

Use Total sales, Total net sales, Gross sales, Discount, Refund, Total New Customer, Total Returning Customer, Date, Marketing Source, UTM source, UTM medium, UTM name, Sales Channel, Product Title, Product Type, Customer Country, Customer returning and many more.

Shopify metrics and dimensions available in Data Studio

Access 21 metrics and 89 dimensions from Shopify connectors including Total sales, Total net sales, Gross sales, Discount, Refund, Total New Customer, Total Returning Customer, Date, Marketing Source, UTM source, UTM medium, UTM name, Sales Channel, Product Title, Product Type, Customer Country, Customer returning and more.

21

Available metrics

89

Available dimensions

Build better Shopify 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 Total sales, Total net sales, Gross sales, Discount, Refund, Total New Customer, Total Returning Customer 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 Shopify performance

Track Shopify Total sales, Total net sales, Gross sales, Discount, Refund, Total New Customer, Total Returning Customer 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

Shopify 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 Shopify to Looker Studio?

Connect your Shopify store to Catchr, authorize access to the store data, and select the store in the Catchr Looker Studio connector. Create a report with an order summary and a product table. Use order identifiers when checking a sample against Shopify so you can confirm that the report covers the intended orders.

Why is my Shopify revenue different in Looker Studio?

Check the exact measure before comparing: gross sales, net sales and total sales are different. Discounts, returns, taxes and shipping can change the result. Also align the reporting period and order filters. Compare a few individual orders first; matching a label alone does not prove that two reports use the same calculation.

How should I report refunds and returns?

Show refunds separately from gross sales so a change in net revenue is easier to explain. Shopify sales reports can place returns on the date they are processed, while an order-based dataset may attach a refund to its original order. Check that date treatment before reconciling daily figures or comparing a month with Shopify Analytics.

Can I see which products generate the most sales?

Yes. Catchr includes product identifiers, titles, variants and SKU information, together with line-level sales fields. Build a product table using line-level values. Do not sum a whole order's value for every product in that order, or a multi-product basket will inflate the total.

How do I avoid counting a Shopify order more than once?

Keep the reporting level clear. One order can contain several line items, so an order count based on product rows can be too high. Use distinct order IDs for the number of orders and line-level values for product analysis. Validate the totals before combining order and product charts.

Can I compare Shopify sales with Facebook Ads spend?

Yes. Add Facebook Ads to compare store sales with advertising spend. Shopify records store transactions, while Meta reports purchases attributed to ads. Use both views to assess performance, but do not expect attributed revenue to equal total store revenue or represent a deduplicated view across every channel.

Can I combine multiple Shopify stores in one report?

Yes. Connect the stores you manage and retain a store identifier in the dashboard. Standardize currencies and the sales definition before producing a combined total. Keep separate store views available so an agency or brand team can trace a change back to the store responsible.

Is Shopify order data enough to report conversion rate?

Orders alone do not provide the number of store visits needed for a session conversion rate. Add a traffic source such as GA4 if that is the denominator you want to use, and label the calculation accordingly. A ratio built from Shopify orders and GA4 sessions may differ from Shopify's own conversion-rate report.

Still have a question?

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