BigCommerce Data Connector User Guide

BigCommerce Data Connector User Guide

Info
Are you looking to streamline your BigCommerce data analysis and reporting? Power My Analytics' BigCommerce connector automates the collection and integration of your e-commerce data, saving you time and providing deeper insights into your online store's performance. This guide will walk you through setting up the BigCommerce data source, creating reports, and understanding key metrics to help you make data-driven decisions for your business.



Prerequisites

Before you begin, ensure you have:
  1. An active BigCommerce store-level API account with read-only permissions for the following scopes:
    1. Customers
    2. Information & Settings
    3. Orders
    4. Order Transactions
    5. Products


  2. The API path for your account
  3. The access token for your account
For more information on creating a store-level API account and obtaining your API path and access token, please see How to Connect to BigCommerce.

Adding BigCommerce as a Data Source

  1. Log in to your Power My Analytics Hub.
  2. Navigate to Sources from the main menu.
  3. Click + Add New Source.
  4. Select BigCommerce from the gallery of available sources.
  5. Enter your API Path and Access Token when prompted.
  6. Click Connect to authenticate and link your BigCommerce account.

Creating a Data Studio Report

Follow these steps to create a Data Studio report using your BigCommerce data:
  1. In the Power My Analytics Hub, go to Reports > Data Studio
  2. Select BigCommerce under Create Data Studio Report (this will open the official Data Studio application in a new window)
  3. Google Data Studio Configuration:
    1. Step 1:
      1. Name your data source (e.g., "BigCommerce - Your Store 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 BigCommerce account (for real data) or "Sample Account" (for sample data)
      2. Click Next
    3. Step 3:
      1. Optional: Choose "Optional - Order Status Filter" for reports
      2. Optional: Allow "Optional - Order Status Filter" 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 BigCommerce demo template.

Key Reports and Fields

BigCommerce data in Power My Analytics offers a wide range of metrics and dimensions. Here are some popular metrics you can use in your reports:
  • Orders Metrics: Shipping Cost Ex Tax, Refunded Amount, Total Ex Tax, Total Inc Tax
  • Product Sales Metrics: Price, Reviews Count, Total Sold
  • Inventory Metrics: Stock Quantity, Total Sold
For a complete list of available BigCommerce fields, refer to the Schema Explorer.

Limitations and Important Considerations

  1. Cached Data Requests with Unique Metrics and Date Dimension: When a unique metric is paired with the date dimension, this will result in a request for cached data instead of a request for live data. For more information, please see Understanding Cached and Live Data Requests.
  2. Backfilling: Power My Analytics will backfill 24 months of data when you first connect your BigCommerce account as a data source.

Unavailable Data

  1. Line-item reports
  2. Images
  3. Web analytics data
  4. Realtime data
  5. Custom fields

Troubleshooting

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