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 Google Data 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. Conversions - By first and last interactions.
  6. 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. Tips - Tips are not currently available in the API.
  3. Breakdowns by brand - Shopify's API does not provide us with brands. Product titles are available.
  4. Custom Fields - Custom fields are not available.


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 Data 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



Import COGS data from Google Sheets

Compare the performance of this store against others by combining the data in sheets and then importing it into Data Studio with the sheets connector.
Create a Sheet with the following information:
  1. COGS Per Item
  2. Variant SKU



Report refunds over time

Select Date from your available fields and drag it onto your report.



Select Returns (orders) for the dimension.


Backfilling Capabilities

  1. We automatically backfill 3 months of data when you first connect.
  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.

    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 ...
      • ShareASale Data Connector User Guide

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

        The following article provides the steps for setting up your Shopify store to allow PMA's connector to collect data. ​ Check your permissions Only the store owner and staff who have been given full permissions can connect to the Shopify store. Add a ...
      • 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 ...
      • GA4 Data Connector User Guide

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