Collect Shopify data in Google Sheets with Supermetrics connector

Do you struggle with collecting Shopify data? I work with Shopify a lot, so I will explain to you how to collect Shopify data in Google Sheets easily!

Before reading, check out this video-tutorial:

Setting up Supermetrics add-on for Shopify

To collect Shopify data, I use Supermetrics add-on for Google Sheets. I use this connector to run cohort analysis in my template.

First of all, you need to select your Shopify account for data source and, actually, account. About date ranges. The variety is pretty wide here, you can even set up your custom date range. If you need, you can compare one date range to another one. 

Followingly, you need to select metrics and split data by dimensions you need. What dimensions can we use?

• Date and time related: in my case, I’ve chosen
• Store related: namely, Store ID and Store name. This may be very useful if you want to present data from several Shopify accounts. 
• Product related: what is interesting about it is that Shopify’s APIs are a bit different from the titles you see in the interface. I’ve selected 
• Item-related like Line Item, Inventory Item
• Order related, for example, order name, order ID 
• Traffic source related 
• Customer details

Some metrics and dimensions can’t be matched, so pay attention to composing your table correctly. 

You can also set up filters, but for me it’s not the case. 

There are also additional settings like “Add refresh button”, “Replace blank metrics with zero”, “Format Results for Looker Studio”, “Keep previous results on refresh error”. These are the settings I usually use. 

Attention to the reporting timezone. Your reporting timezone has to be the same as in your online store – this is the most important thing to pay attention to. Otherwise the data in your report will not be accurate. 

Working with the table

Here is the table we’ve got. I would like to draw your attention to product tags – they are written in one line and separated by commas. If you want to split your data by tag, I recommend you to transform this column and work a bit on organizing the tags. 

Basic settings for cohort analysis

Usually, in Cohort Analysis report I use such metrics as Gross Sales, Total Sales, Orders and Items. As dimensions I use Date, Order ID, Customer ID and Channel.

A table with such settings looks just like this. 

After you finish setting up the query, you can set up a trigger that will update your report with some frequency. 

Advantages of Shopify

Shopify offers numerous advantages for ecommerce owners, making it one of the most popular platforms for online businesses. Here are some of the key advantages:

• Shopify supports various payment gateways, including Shopify Payments, which allows seamless integration with major payment providers like PayPal, Stripe, and others, making it easier for customers to make payments.

• Shopify’s built-in analytics tools provide valuable insights into your store’s performance, including sales data, customer behavior, and more. This data can help you make informed decisions to grow your business

• Shopify provides built-in SEO features and customizable meta tags, allowing you to optimize your store for search engines and improve your visibility in search results.

• Shopify takes care of hosting, security, and maintenance, ensuring that your online store remains secure and available to customers at all times. It also complies with PCI DSS (Payment Card Industry Data Security Standard) requirements, providing secure payment processing.

Taking into account all the advantages of Shopify and its ease in usage, I recommend you to start using this platform. You can explore more features of it using the Supermetrics add-on to Google Sheets.  

In addition, while working with Shopify, I frequently use a Windsor.ai connector that really comes in handy for pulling up data from any ad platfrom. Using my promocode gaillereports you can get 10% off any subscription plan and enjoy the perks of Windsor.ai .

If you are an e-commerce owner, check out e-commerce report templates from Gaille Reports template store. 

Hope you enjoyed this article!