Full tracking & shopify data captured and delivered to BigQuery or other Data warehouses?

Hi @All ,

I’m exploring the idea of an analytics service that would capture from a shop all website events (e.g., product views, add to cart, checkouts) combined with Shopify’s database (products, collections, orders, customers) and deliver them in the store operator’s preferred data backend/warehouse. The goal is to create a fully accessible data repository (that works even for multi-brand shops aggregating data across them) that a store owner can connect and sync automatically to their BigQuery (or other data warehouses) and access from BI tools like Looker, Power BI, Tableau, etc.

It would capture all on-site interactions from user sessions, enrich data through integration with Shopify API for capturing product detail updates, orders, customers etc.
Data would sync automatically, with lets say a 2 hours delay to BigQuery, Snowflake, Redshift, etc. From there teams from the shops can use advanced analytics in their preferred tool like Looker, Power BI, Tableau and such.
Would this be useful? I’d love to hear your thoughts!

If you’re interested, feel free to comment below or send me a PM.

Thanks!
Peter [email removed] Datma

1 Like

Hi @Peter_Datma

Have you found the solution?

We are planning to build it as an extension / option to our Ecommerce analytics app , if we find that there is enough interest for it…

1 Like

Thanks @Peter_Datma for the reply. Hope you will enough interest. Personally I think it can help the merchant to govern their data.
You have interesting E-commerce analytics app, I did explore the demo. Informative dashboards and reports!
Would like to know more about your value addition compared to Shopify Analytics. I see that Shopify has an advanced analytics features comes with Plus subscription. Can you help me to understand that how different is your anlaytics app from Shopify analytics? also How different is your solution compared to other solution out there in the market?
Thanks!!

Hello, we are focused on delivering product/variant level analytics - product views, add to carts - all measures made available on product granularity. As far as I know Shopify doesnt get so deep into analytics, we’ll see how this evolves. Also we are planning to build some automations (already started with tagging) based on reports and metrics in Datma. Funnel attribution is another aspect that differentiates our app, for example to be able to track add to carts/conversions attributed based on user click path to collections. Few other apps are built to track every single product/variant view, process and store all events and made them available for custom time ranges. There are some, but most of them rely only on data available from Shopify backend.

1 Like