Shopify Data Connector User Guide

Shopify Data Connector User Guide

This guide will walk you through the process of setting up and using Shopify as a data source in Power My Analytics. By connecting your Shopify store, you'll be able to automate data collection, centralize your e-commerce metrics, and easily create customized reports. This guide covers prerequisites, adding Shopify as a data source, creating a Looker Studio report, key reports and fields, and important considerations.


Prerequisites

Before you begin, ensure you have:
  1. Store owner access or staff access with all permissions to set up the connection

Grant Permissions to a User in Shopify

  1. Add a staff member in the Users and permissions section of your Shopify settings.



  2. Make sure staff members who need access are given all permissions.

Adding Shopify as a Data Source

  1. Navigate to your PMA Hub and select Sources from the menu.
  2. Click + New Data Source and choose Shopify from the gallery.
  3. Install the Power My Analytics app from the Shopify app store.

Creating a Looker Studio Report

Follow these steps to create a Looker Studio report using your Shopify data:
  1. After adding Shopify as a data source in the PMA hub, navigate to Reports > Looker Studio
  2. Select Shopify under Create Looker Studio Report (this will open the official Looker Studio application in a new window)
  3. Google Looker Studio Configuration:
    1. Step 1:
      1. Name your data source (e.g., "Shopify - Organization Name")
      2. Choose your Power My Analytics hub from the dropdown
      3. Optional: Leave "Use report template for new reports" checked to use the PMA demo template
      4. Click Next
    2. Step 2:
      1. User Account: Select your Shopify account (for real data) or "Sample Account" (for sample data)
      2. Click Next
    3. Step 3:
      1. Choose "Clients" for reports
      2. Optional: Allow "Clients" modification in reports
      3. Click Connect (top right) to complete the data source configuration
    4. Step 4:
      1. Click Create Report (top right)
For a quick start, use our pre-built Shopify demo template.

Key Reports and Fields

Shopify data in Power My Analytics offers a wide range of metrics and dimensions. Here are some popular metrics you can use in your reports:
  • Performance Metrics: Total sales, Total orders, Items, Average order value, Returning customer rate, Customers
  • Sales Metrics: Total sales, Orders, Gross sales, Discounts, Returns, Net sales, Shipping, Tax, Total sales, Item Quantity, Total Sales (Line Items)
  • Order Metrics: Items, Gross sales, Discounts, Returns, Net sales, Tax, Shipping, Order total, Item quantity, Total Sales (Line Items)
  • Conversion Metrics: AOV, Orders, Total sales
  • Customer Metrics: Orders, Average order value, Total sales by Customer type
  • Inventory Metrics: Variants, Inventory by Product title, Product type, Product vendor, Product status
  • Return Metrics: Returns, Total sales
For a complete list of available Shopify fields in Power My Analytics, refer to the Schema Explorer.

Limitations and Important Considerations

  1. Backfilling: Up to 2 years, with an initial backfill of 3 months when you first connect your Shopify account as a data source.
  2. Data delay: Data may take 2 hours to appear after first connecting your Shopify account. Wait 2 hours after connecting to see all of your data.
  3. Inventory reporting: When reporting inventory data, the latest data available will always be shown regardless of the date range selected.
  4. VAT reporting discrepancy: The fields Gross Sales, Discounts, and Total Sales may differ from Shopify values by less than 1% when VAT is collected. This is due to limitations in the data provided by Shopify. We are currently awaiting a fix from Shopify for this issue.
  5. Sales Channel App Names: Shopify's API does not report all sales channel apps by name. When sales are placed using apps which the API does not report by name, these sales will appear under "Draft Orders".

Unavailable Data

  • Conversion funnel: Shopify’s API does not currently provide the fields necessary for a conversion funnel (Total Sessions, Added to Cart, Reached Checkout, Sessions Converted, Sessions over time, Session by location, Session by device, Conversion over time)
  • Brands
  • Live fields
  • Realtime data
  • Custom fields
  • Metafields (meta fields)

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


Troubleshooting

See our article Basic Troubleshooting for information on issues that may affect the Shopify connector.


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

      • Related Articles

      • Mailchimp Data Connector User Guide

        Are you looking to streamline your email marketing analytics and reporting? Power My Analytics' Mailchimp integration allows you to easily connect your Mailchimp account, automate data collection, and create powerful reports. This guide will walk you ...

      • Klaviyo Data Connector User Guide

        Are you looking to streamline your email and e-commerce marketing data analysis? This guide will walk you through setting up Klaviyo as a data source in Power My Analytics. By integrating Klaviyo with PMA, you'll be able to automate your data ...

      • 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 ...

      • Stripe Data Connector User Guide

        Stripe is a powerful payment processing platform that enables businesses to accept online payments, manage subscriptions, and handle invoicing. This guide will walk you through the process of connecting Stripe to Power My Analytics, creating reports, ...

      • Criteo Data Connector User Guide

        This guide will walk you through the process of connecting your Criteo account to Power My Analytics and creating reports using the data. Criteo is a powerful advertising platform specializing in retargeting, customer acquisition, and personalized ...