Shopify Data Connector User Guide

Shopify Data Connector User Guide

The following article is a guide for automating reports with your Shopify connector. It includes metrics available and how to connect, and backfill your Shopify data. To create a Shopify report, you will need access to at least one or more Shopify store accounts as well as Google Sheets and/or Looker Studio.

Available Data

  1. Daily Inventory Reporting - We currently provide the previous day's inventory
  2. Nine different sales breakdowns - Breakdowns by time, channel, checkout currency, shipping location, traffic referrer,  discount, product vendor, product, and product variant SKU.
  3. Order and refund reports
  4. Marketing attribution
  5. Inventory - By product or location.
  6. Conversions - By first and last interactions.
  7. Complete List of Fields.

Currently Unavailable Data

  1. Conversion Funnel - Shopify's API currently does not provide us with the metrics required to make a conversion funnel (Total Sessions, Added to Cart, Reached Checkout, Sessions Converted, Sessions over time, Session by location, Session by device, or Conversion over time).
  2. Breakdowns by brand - Shopify's API does not provide us with brands. Product titles are available.
  3. Realtime data - Realtime data is not available.
  4. Custom Fields - Custom fields are not available.

Reporting Limitations

When VAT is collected, the following fields may differ from Shopify's actual values by less than 1%:
  1. Gross Sales
  2. Discounts
  3. Total Sales
This is due to limitations in the data provided by Shopify. We are currently awaiting a fix from Shopify for this issue.

Inventory Reporting

When reporting inventory data, the latest data available will always be shown regardless of the date range selected. For example, if your report contains data for today and you set the date range to the past 3 days, the report will still display today's data.


Connection Requirements

Connecting to Shopify is a very involved process. See our How to Connect to Shopify guide for assistance.

Get the Most Out of Your Shopify Reports

Blend with Google Analytics to get conversion funnel reports.

Apply Google Analytics trackers to your store. You can import that data with our Google Analytics connector and use Looker Studio's Blend Data tool to combine them on the same report. 



Report Sales by Brand using Google Sheets

Create a Google Sheets spreadsheet with the following information:
  1. Brand
  2. Variant SKU



Backfilling Capabilities

  1. We automatically backfill 3 months of data when you first create a report.
  2. Wait 2 hours after connecting to see all of your data.
  3. Backfill Connection Data to get up to 2 years of data. 

Troubleshooting

Follow the instructions in our Basic Troubleshooting guide to get your reports working again.

If you receive an Unauthorized Access error, please see:
  1. Unauthorized Access Error When Connecting to Shopify


    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • Mailchimp Data Connector User Guide

        The following article is a guide to automating reports with your Mailchimp connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Mailchimp reports. To begin creating ...
      • Taboola Data Connector User Guide

        The following article is a guide to automating reports with your Taboola connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Taboola reports. To begin creating reports ...
      • AdRoll Data Connector User Guide

        The following is a guide to automating reports with your AdRoll connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your AdRoll reports. To begin creating reports with your ...
      • Quickbooks Data Connector User Guide

        The following article is a guide for automating reports with your Quickbooks connector. It includes metrics available and things to know about the connector. To create a report, you will need access to at least one or more Quickbooks online accounts ...
      • eBay Data Connector User Guide

        The following is a guide to automating reports with your eBay Seller connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your eBay Seller reports. To begin creating reports ...