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.
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?
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.
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?