Data Studio templates

Shopify report template for Data Studio

Get a complete view of your store with this Shopify template for Data Studio. Follow gross sales, discounts, returns, net sales, shipping, taxes and total sales in a dynamic dashboard whose numbers reconcile with the finances summary of Shopify Analytics. Break down revenue by product, variant, SKU, vendor, discount code, sales channel, country and currency, compare first-time and returning customers, see which referrers and campaigns bring in orders, and check your stock by product and location - all next to the rest of your marketing data.

View template

Connectors used in this template:

Shopify

No items found.

How the template can help

Questions you can answer with this template

Sales performance

What are my gross, net and total sales for the period?
How much am I giving away in discounts, and how much comes back as returns?
How do shipping, taxes, duties and tips add up to my total sales?
How does this month compare with the previous one, or with last year?

Orders and average order value

How many orders did my store receive, and how many items were sold?
What is my average order value, and how does it evolve over time?
How many units does an average order contain?
Which orders were refunded, and for how much?

Products and variants

Which products bring in the most revenue?
Which variants and SKUs sell best?
Which products get returned the most?
What is the average selling price by product and by vendor?

Discounts

Which discount codes are used the most?
How much revenue comes from discounted orders?
What share of my sales is going to discounts?

Customers

How many orders come from first-time customers versus returning ones?
Where are my customers located?
Which shipping destinations generate the most revenue?
In which currencies do my customers check out?

Channels and marketing attribution

Which sales channels bring in the most revenue?
Which traffic referrers drive orders to my store?
Which campaigns and sources convert, by first visit and by last interaction?
How does my store revenue compare with the ad spend behind it?

Inventory

How many units are available, committed, incoming and on hand?
Which products are about to run out of stock?
How is my stock distributed across locations?

Done in a snap

How to use the template

Connect your Shopify store in your Reporting Ninja account.
Start creating a Data Studio data source by clicking on the button ‘Get the template’ below.
Authenticate your account by clicking on ‘Authorize’.
Enter the token you can find in the Data Studio area of your Reporting Ninja account.
Choose an account. The account and the blue check mark next to ‘Use report template for new reports’ must be selected. Other parameters are optional.
Once you’re happy, click on ‘Connect’ in the top-right.
The next page will display all available dimensions and metrics.
Click 'Create report'. After this, the template will fetch all your data in the report, ready for you to derive insights!

Get the template

Related templates

Browse all templates