Skip to main content
All CollectionsData SourcesShopify
Shopify Analytics Reporting
Shopify Analytics Reporting

Shopify Store reports and dashboards

A
Written by Achou
Updated over 2 years ago

What is Shopify Analytics?

Shopify Analytics provides detailed analytics related to customers, products, orders and line items of the shopify store.

How do you link Shopify stores on ReportGarden?

In order to link your Shopify store to ReportGarden, you need to first enter the name of the shopify store.

  • Navigate to ReportGarden -> Accounts.

  • Click on Link Account

  • Select Shopify

  • Enter the store name and click on Submit.

If the Store URL is of the format https:{{mystorename}}.shopify.com, please enter mystorename in the text box shown.

Shopify Metrics and Dimensions

Shopify orders a wide variety of analytics. Here, we have only listed the top level metrics that are available for any shopify store.

We primarily work with orders, line items, products and product variants in shopify analytics.

Fetching user behaviour data into the dashboards is possible by integrating your google analytics accounts into ReportGarden and combining the data with shopify.

In case you do not find a dimension/metric that you are looking for, please do reach out to us at [email protected] with your query. 

Dimensions

The following dimensions are available for Shopify

Dimension

Description

Product

The name of the product.

Product Vendor

The name of the product's vendor.

Product Type

A categorization for the product used for filtering and searching products.

Product Handle

A unique human-friendly string for the product. Automatically generated from the product's title.

Product Status

The status of the product. Valid values:

active: The product is ready to sell and is available to customers on the online store, sales channels, and apps. By default, existing products are set to active.
archived: The product is no longer being sold and isn't available to customers on sales channels and apps.
draft: The product isn't ready to sell and is unavailable to customers on sales channels and apps. By default, duplicated and unarchived products are set to draft.

Product Published Scope

Whether the product is published to the Point of Sale channel. Valid values:

web: The product is published to the Online Store channel but not published to the Point of Sale channel.
global: The product is published to both the Online Store channel and the Point of Sale channel.

Product Variant

Variants are options of a product that comes in more than one option, such as size or color. Each combination of option values for a product can be a variant for that product.

Product Variant Bar Code

The barcode, UPC, or ISBN number for the product.

Fulfillment Service

The fulfillment service associated with the product variant. Valid values: manual or the handle of a fulfillment service.

Inventory Management

The fulfillment service that tracks the number of items in stock for the product variant. Valid values:

shopify: You are tracking inventory yourself using the admin.
null: You aren't tracking inventory on the variant.
the handle of a fulfillment service that has inventory management enabled: This must be the same fulfillment service referenced by the fulfillment_service property.

Product Variant SKU

A unique identifier for the product variant in the shop

Order

Order is a customer's request to purchase one or more products from a shop

Order Cancel Reason

The reason why the order was canceled. Valid values:

customer: The customer canceled the order.
fraud: The order was fraudulent.
inventory: Items in the order were not in inventory.
declined: The payment was declined.
other: A reason not in this list.

Landing Site

The URL for the page where the buyer landed when they entered the shop.

Referring Site

The website where the customer clicked a link to the shop.

Source

The source where the order originated.

UTM Campaign

The utm campaign, if any from where the order has been placed. It is obtained by parsing the query parameters of the referring site

UTM Content

The utm content, if any from where the order has been placed. It is obtained by parsing the query parameters of the referring site

UTM Medium

The utm medium, if any from where the order has been placed. It is obtained by parsing the query parameters of the referring site

UTM Source

The utm source, if any from where the order has been placed. It is obtained by parsing the query parameters of the referring site

UTM Term

The utm term, if any from where the order has been placed. It is obtained by parsing the query parameters of the referring site

Order Processing Method

How the payment was processed. It has the following valid values:

checkout: The order was processed using the Shopify checkout.
direct: The order was processed using a direct payment provider.
manual: The order was processed using a manual payment method.
offsite: The order was processed by an external payment provider to the Shopify checkout.
express: The order was processed using PayPal Express Checkout.
free: The order was processed as a free order using a discount code.

Order financial Status

The status of payments associated with the order.

pending: The payments are pending. Payment might fail in this state. Check again to confirm whether the payments have been paid successfully.
authorized: The payments have been authorized.
partially_paid: The order has been partially paid.
paid: The payments have been paid.
partially_refunded: The payments have been partially refunded.
refunded: The payments have been refunded.
voided: The payments have been voided.

Order Fulfillment Status

The order's status in terms of fulfilled line items. Valid values:

fulfilled: Every line item in the order has been fulfilled.
null: None of the line items in the order have been fulfilled.
partial: At least one line item in the order has been fulfilled.
restocked: Every line item in the order has been restocked and the order canceled.

Shipping Country

The country in the shipping address of the order

Shipping City

The city in the shipping address of the order

Shipping Province

The province in the shipping address of the order

Billing Country

The country in the billing address of the order

Billing City

The city in the billing address of the order

Billing Province

The province in the billing address of the order

Line Item

An entry containing the information about each item in an order, with product, product variant, quantity and price

Line Item Fulfillment Status

How far along an order is in terms line items fulfilled. Valid values: null, fulfilled, partial, and not_eligible.

Line Item Fulfillment Service

The service provider that's fulfilling the item. Valid values: manual, or the name of the provider, such as amazon or shipwire.

Customer

Contains shop's customers, such as their contact details, their order history, and whether they've agreed to receive email marketing.

Measures

The following measures are available for Klaviyo

Measure

Description

Orders

No of orders

Line Items

No of line items

Line Items / Order

Avg no of line items per order

Orders - current total discount

The current total discounts on the order in the shop currency. The value of this field reflects order edits, returns, and refunds

Orders - current sub total pirce

The current subtotal price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds.

Orders - current total price

The current subtotal price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds.

Orders - current total tax

The current total taxes charged on the order in the shop currency. The value of this field reflects order edits, returns, or refunds.

Orders - sub total price

The price of the order in the shop currency after discounts but before shipping, duties, taxes, and tips.

Orders - total discount

The total discounts applied to the price of the order in the shop currency.

Orders - total line item price

The sum of all line item prices in the shop currency.

Orders - total outstanding

The total outstanding amount of the order in the shop currency.

Orders - total price

The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive.

Orders - total tax

The sum of all the taxes applied to the order in the shop currency. Must be positive.

Orders - total tip received

The sum of all the tips in the order in the shop currency.

Orders - total weight shipped

The sum of all line item weights in grams. The sum is not adjusted as items are removed from the order.

Current Discount / Order

Avg current total discount per order. It is calculated as Orders - current total discount / No of orders

Current Sub total price / Order

Avg current sub total price per order. It is calculated as Orders - current sub total price / No of orders

Current Avg price / Order

Avg current price per order. It is calculated as Orders - current price / No of orders

Current avg tax / Order

Avg current total tax order. It is calculated as Orders - current total tax / No of orders

Current Sub total price / Order

Avg sub total price per order. It is calculated as Orders - sub total price / No of orders

Discount / Order

Avg total discount per order. It is calculated as Orders - total discount / No of orders

Line items price / Order

Avg total line items price per order. It is calculated as Orders - total line item price / No of orders

Outstanding / Order

Avg current outstanding price per order. It is calculated as Orders - total outstanding / No of orders

Price / Order

Avg total price per order. It is calculated as Orders - total price / No of orders

Tax / Order

Avg total tax per order. It is calculated as Orders - total tax / No of orders

Tip received / Order

Avg total tip received per order. It is calculated as Orders - total tip recieved / No of orders

Weight / Order

Avg total weight per order. It is calculated as Orders - total weight / No of orders

Line Items - total price

The price of the item before discounts have been applied in the shop currency.

Line Items - total quantity

The number of items that were purchased.

Line items - total discount

The total amount of the discount allocated to the line item in the shop currency.

Line Items - total weight

The weight of the item in grams.

Price / Line Item

Avg price per line item. It is calculated as Line Items - total price / No of line items

Quantity / Line Item

Avg quantity per line item. It is calculated as Line Items - total quantity / No of line items

Discount / Line Item

Avg discount per line item. It is calculated as Line Items - total discount / No of line items

Weight / Line Item

Avg weight per line item. It is calculated as Line Items - total weight / No of line items

Total Customers

Total no of customers that have placed orders during the period

Products Ordered

Total no of products ordered

Unique Products Ordered

Unique no of products ordered

Product Variants Ordered

Total no of product variants ordered

Unique Product Variants Ordered

Unique no of product variants ordered

Data Freshness and reporting durations

  • Shopify Analytics is a storage connector. The data is refreshed every 1 hour.

  • Order data can only be fetched for the last 60 days from the day the account is linked. In case you need to import older data, please contact [email protected] and we will get in touch with you to import older order data.

FAQ

Q: I am unable to link the Shopify Analytics, as I do not have the requisite permissions. What do I do?

A: In order to link your Shopify Store account with ReportGarden, you need to be a store administrator, which gives you the permissions to add new apps. In addition to the ability to connect new apps to your store, you will be needing the following permisisons

  • read_content

  • read_products

  • read_product_listings

  • read_customers

  • read_orders

  • read_draft_orders

  • read_inventory

  • read_locations

  • read_fulfillments

  • read_assigned_fulfillment_orders

  • read_merchant_managed_fulfillment_orders

  • read_third_party_fulfillment_orders

  • read_shipping

  • read_gift_cards

  • read_checkouts

  • read_price_rules

  • read_discounts

  • read_marketing_events

  • read_resource_feedbacks

  • read_shopify_payments_payouts

  • read_shopify_payments_disputes

  • read_translations

  • read_locales

Q: Can ReportGarden update/edit/delete/modify any data in the Shopify Store?

A: No, ReportGarden requests only read-access to your stores, and cannot modify/edit/update/delete any records in your Shopify Store. We explicitly request read-only access so that we are in no way able to edit or delete anything in the Shopify Store.

Q: Can I revoke access to the application and delete all data of my Shopify Store in ReportGarden?

A: Yes. ReportGarden is fully GDPR complaint. You can delete all data pertaining to your store with ReportGarden and also uninstall the ReportGarden app from your shopify store at anytime.

Q: I cannot get the read_customers scope as my Shopify store owner is concerned about GDPR. Is there a way to get reporting without customer data?

A: Yes, It is possible to connect to the shopify store witout read_customers scope. Please reach out to [email protected] for the same.

Note: You cannot use customer dimension if customer data is not imported.

Q: How long does it take to import the data into ReportGarden after I link my account?

A: It takes around 15 minutes to 1 hour to sync the data completely into ReportGarden. It is based on the number of products, orders and customers that are present in the shopify store. In case you are facing troubles with 0 data coming in your reports and dashboards, please reach out to [email protected] and we will be able to help you out in case you have trouble importing the data

Q: I need order data for my reporting beyond a period of 60 days from the day I have linked my account. How can I get that?

A: Please reach out to [email protected]. We will help you with the importing of the data

Q: How often is the data synced with the Shopify Store?

A: Data is refreshed every day from the shopify store.

Q: The data that I see in ReportGarden is different from the data in my Shopify dashboard

A: The data is calculated based on the timezone for the selected dates. By default, we assign the timezone from the shop details set in Shopify account.

If you are located in a different region than the timezone set in the shopify account, then you can always go to the sub account and edit the shopify account's timezone to reflect the data according to your timezone.

Q: I can't get UTM parameters in my reports. What am I missing?

A: UTM parameters are parsed from the landing site field in the shopify store. You need to ensure that the utm parameters are set correctly on the landing url. If not, please refer to the documentation in google/facebook to ensure that the landing page url is correctly configured.

Q: How can I view and filter the data based on where an order is placed from?

A: You can filter the data based on the APP ID filter.

The codes for App Id to be used to filter the orders that have been assigned through

Online store is 580111

Q: Can I import new user / returning user and visitor data using Shopify Analytics connector?

A: All visitor data is available through the google analytics view that is configured on the shopify store. Shopify Store connector only deals with orders and products.

Q: How can i calculate the ROAS of my Shopify Store based on my ppc campaign spend?

A: For this, you need to create a calculated metric. Create a calculated metric as follows

Ensure that the type is set to currency.

You can now use it as a calculated metric in KPI widgets

Did this answer your question?