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

Shopify Analytics FAQ

Twitter Analytics Reporting

Mailchimp Reporting

CallRail Reporting

Google Analytics Reporting