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

Start a Business
, , ,

Topic summary

Peter from Datma is gauging interest in an analytics service that would capture comprehensive website events (product views, add-to-cart, checkouts) and combine them with Shopify database information (products, orders, customers). The proposed solution would automatically sync this data to warehouses like BigQuery, Snowflake, or Redshift with approximately 2-hour delays, enabling analysis through BI tools such as Looker, Power BI, and Tableau.

Key Features:

  • Full event tracking from user sessions
  • Integration with Shopify API for enriched data
  • Multi-brand shop data aggregation
  • Automatic syncing to preferred data warehouses

Current Status:
Peter indicates they’re considering building this as an extension to their existing Ecommerce analytics app, pending sufficient interest. One user expressed support, noting it could help merchants govern their data.

Differentiation:
Peter explains their app focuses on product/variant-level analytics (views, add-to-carts) with granular tracking that goes deeper than Shopify’s native analytics. They’re also developing automations based on metrics and offer funnel attribution tracking (e.g., conversions attributed to collection click paths). Unlike competitors relying solely on Shopify backend data, Datma tracks and stores every individual product/variant event.

Discussion remains open for feedback and interest validation.

Summarized with AI on October 29. AI used: claude-sonnet-4-5-20250929.
1

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
2

Hi @Peter_Datma

Have you found the solution?

3

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
4

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!!

5

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