How to get data in the admin report page?

I’m developing a data reporting feature for our app, which requires daily user access data. I use WebPixel to report events and count the number of different ClientIDs each day. However, there is a significant difference between this data and the data in the Report of the Shopify Admin page. Are there any interfaces available to obtain the data in the Report of the Admin page, such as the number of Sessions per day, the number of orders placed each day, and so on?

Is ShopifyQL for analytics feasible for you?

Hey folks :waving_hand: - @Eric_Han - is on point - ShopifyQL is a decent avenue to look into, but I did just want to note that the ShopifyQL API is expected to be sunset this July and will no longer be available to use after that time.

For pulling session data, the WebPixel API is usually the best method for grabbing that through our APIs, but for tracking Orders and customer journey analytics, the GraphQL API might be a good bet if you wanted to look into that as an alternative, since it does show specific customer session-related data like the landing page, referral URL, etc: CustomerJourneySummary - GraphQL Admin

In terms of the discrepancies you mentioned there though, would you be able to share an example of what you’re seeing between the WebPixel data being returned and the analytics reports? I can take a look to see if we can confirm if that’s expected behaviour on our end if you’re able to share an example - happy to take a look!

Thanks Alan for remind that

1 Like

Hello, thank you for your reply. We are currently using WebPixel to record user behavior. The issue we’re facing is that some metrics we calculate don’t align with those in the admin dashboard. For example:

  1. There’s an official metric called “average_session_duration”, but when using WebPixel, we can only access the shopify_y_id and not the shopify_s_id, which makes it impossible for us to determine session duration.

This discrepancy makes it challenging to reconcile our internal analytics with the official reports. Are there alternative methods or APIs available to retrieve session-related data like shopify_s_id or calculate session duration accurately?