Create reports with the Data Studio connector for Shopify

[Michael_Whitak1]

Hi there,

Could you give me an example of what modifying names would look like? I'm trying to see if this is something that can be done in Data Studio itself (eg through calculated fields). You can also reach out to me at info@analyticsbuddy.com.

[Leevi]

Hi - thanks for the connector! The report template link doesn't seem to work? Could you let me know how it would be possible to access the template? Thanks!

[Michael_Whitak1]

Sorry about that. Please try again. If you still have trouble please contact me at info@analyticsbuddy.com

Michael

[KevinW]

For those following this thread and looking for a high-end solution, I recommend checking out Panoply. Their cloud data warehouse solution is a little pricey, but they have tons of data integrations, including one that allows you to quickly and efficiently analyze Shopify data in Google Data Studio. I've tried accomplishing this several different ways over the last 6 months and Panoply is my favorite.

[CharlotteA]

Hi Michael

I understand you're the creator of the connector :) 

First thanks a lot for sharing it, it's a great start to get data out of Shopify. 

I do experience some issues though: since about 3m ago, all my time series charts do not display any data while the total metrics do. 

I tried to re-create them from scratch but it still doesn't work. 

Do you have any idea why?

[Michael_Whitak1]

Hi CharlotteA,

I tried the connector today and it was working fine for me. Would you
contact me directly at info@analyticsbuddy.com and I'll try to help.

Michael

[EugeniuS]

Hi, Michael_Whitak1

Tried today your connector and it seems it's working.

Can i ask you to add field of Product type to generate a report like Product Category (Enhanced Ecommerce) from GA?

Thank you!

[Michael_Whitak1]

Hi there,

The connector calls the Order API, so if the field Product Type is in the response I can add it. Can you confirm which field it is?

It may also be possible to use the Data Studio data blending feature. If the Product Type is not in the API response, you could add a second data source to Data Studio (say a Google Sheet) that has the Product SKU and the Product Type. Then you can blend the data from the connector to the Sheet based on the common SKU key. 

[EugeniuS]

Hi,

It seems OrderAPI, unfortunately doesn't contain Product Type, only Product API.  I can't use SKU, because i don't have it in my store. I'll try with product ID correlated to Product type.

Thx!

[EugeniuS]

Hello, Michael_Whitak1,
Today i observed a message:

Private apps need updating within 28 days
Your private apps may no longer work if they are not updated before April 1, 2020. This message is based on data from the last 30 days. Contact the developer of the following apps to update them before the deadline: Data Studio Connector

Can you help me to solve this issue?