BigCommerce Data Connector User Guide

BigCommerce Data Connector User Guide

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 API account with the following permission 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 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 + New Data 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 Looker Studio Report

Follow these steps to create a Looker Studio report using your BigCommerce data:
  1. In the Power My Analytics Hub, go to Reports > Looker Studio
  2. Select BigCommerce 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., "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. Backfilling: Historical data is available for up to 2 years. Power My Analytics will backfill 13 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.

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

      • How to Connect to BigCommerce

        This guide will walk you through the process of getting the credentials you need to connect to BigCommerce with Power My Analytics. You will need to create an API Account and get an Access Token. Before Getting Started You'll Need A BigCommerce ...

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

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

      • PayPal Data Connector User Guide

        PayPal is a widely used payment processing platform, and integrating its data into your analytics workflow can provide valuable insights into your business performance. This guide will walk you through the process of setting up PayPal as a data ...