How to export shopify report data by API

Is it possible to export Analytics data with Shopify API ?

hi @wzc

You can export certain analytics data through the Shopify API, but there are limited options. Shopify does not offer direct access to detailed Analytics reports through its API. You can, however, get some metrics through the Shopify REST Admin API or GraphQL API, including:

Orders API – For sales and revenue
Transactions API – For payment
Customers API – For customer insights
Reports API (Shopify Plus) – For producing custom reports
ShopifyQL API (Shopify Plus) – For querying business data in a structured manner

In case you require more advanced analytics, you might have to pull data from Shopify and process it outside or employ third-party analytics tools such as Google Analytics, Data Studio, or a BI platform.

@wzc , Yes it is possible. Please check the Shopify API link for more information

Hi, @Dotsquares

Thank you for your reply, it helps a lot!

We would like to export session level data, such add add-to-cart ratio, checkout-ratio, is this possible with ShopifyQL API ? As I know, according to shopify’s document, the ShopifyQL would be deprecated soon.

Hi, @Report-Pundit

Thank you for your reply! It seems the graphQL can only export order/customer/transaction data, what we need is session level data, such as add-to-cart ratio, checkout-ratio, purchase-ratio. Is it possible to export these kinds of data?