I would like to find in Analytics the turnover by products, no matter what the variant is. I couldn't find yet how to do this.
For example, if I sell the bottle "Lion" in 3 colors : red, blue, black.
In Analytics I will see the turnover by variant like this :
- Lion / Red : 59$
- Lion / Black : 12$
- Lion : Blue : 0$
But I would like to have a way to retrieve the total turnover for the Lion bottle (71$) no matter the variant.
Is there a simple way to do this in Analytics ?
Hey there, @GOUSA!
That is a great question. Before I attempt to answer your question I'd need a bit more context so I know we are on the same page in regards to your needs. When you say "turnover by products" are you referring to the profit by product variant SKU report that shows your gross profit by variant? Ex. White T-Shirt - Large, White T-Shirt - Medium, and White T-Shirt - Small?
If that's the case and you are looking for the total profit for each product without breaking it down by variant, you can simply go into Analytics > Reports, and select the Profit by product report. This report shows your gross profit by product for the date range of your choice.
Let me know if that helps!
Hello @Dirk thanks for the help.
I was speaking of Google Analytics 🙂
However I tried to check what you said but I can't have this report. Probably because I don't input the info about how much a product cost me in the product details 😕
Do you know a way in Google Analytics to see this turnover by product without breaking it down by variants ?
Hello @GourdeMorning ,
I am John from Report Pundit, a reporting and analytics app for Shopify.
1) Google Analytics will provide only SKU level sales (turnover) reports. They do not provide product level sales figures. However, we have noticed that sales numbers in Google Analytics is different from what is reported in Shopify reports. It is better to take decisions based on sales figures in Shopify.
Google Analytics is best suited for visitor analytics (sessions, funnels, and checkout analysis). After the vistior is converted to a customer, it is better to use Shopify reports. Because you will receive cash into your bank account based on sales, taxes, shipping and transcations as calculated by Shopify.
2) As Dirk suggested, you can use Shopify's built-in sales (turnover) reports and profit margin reports. For profit margin reports, you will need to enter cost for each variant.
3) We have an app called Report Pundit that can report both sales at product or variant level. You can create thousands of custom reports to analyse marketing, sales and customer data generated each day from your store. For example, you can identify which marketing efforts are working and how often customers come to your website before placing an order.
Feel free to contact me if you have more questions at firstname.lastname@example.org
@GourdeMorning You can create a custom dimension and push the product (not variant) name through that, for purchases, This way you'll have a column of data to work with that provides what you're after.
Alternatively, I have not done this before, but you could search and replace the Ecommerce Item Name as a filter to consolidate the names. However, GA documentation says this functionality may not be available for ecomm dimensions.
Hello @Josh_Uebergang , thanks for stepping in 🙂
Could you detail a bit more the "custom dimension" you're talking about for solution 1 ?
I'm not sure to understand what you mean and how exactly.
@GourdeMorning Simo Ahava is a great guy to learn more. This isn't necessarily how to do exactly what you're asking, but someone with Google Analytics experience in custom dimensions would be able to combine what you're asking with a document of his on the topic.
Quick update : I managed to have these reports with the Shopify plan (79$/month... which is cheaper in terms of fees when you reach 5K$/month of turnover). And you have report per product, per variant etc...
Ah, yes. Shopify Analytics. Glad to hear you got it done.