BigCommerce Data Connector User Guide

BigCommerce Data Connector User Guide

The following article is a guide to automating reports with your BigCommerce connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your BigCommerce reports. To begin creating reports with your BigCommerce connector, you will need at least one BigCommerce account as well as access to Looker Studio or Google Sheets.


Available Data

  1. Orders - Key performance indicators: number of orders, average order value, and total including tax. Shipping cost excluding tax, total excluding tax, total including tax, and refunded amount by date, order ID, date shipped, payment status, and customer message.
  2. Product Sales - Price, reviews count, and total sold by SKU, product name, and condition.
  3. Inventory Report - SKU, product name, condition, stock quantity, and total sold.
  4. Complete List of Fields.

API Limitations

  1. Line-Item reports unavailable - The BigCommerce API only provides high-level reports of products and orders.
  2. Images are not available.
  3. Web analytics data - This data is not available through the API and must be acquired through Google Analytics. Use our GA4 connector to incorporate this data into your reports.
  4. Custom Fields - Custom fields are not available.

Connection Requirements

Follow the instructions in our How to Connect to BigCommerce guide to get started.

Backfilling

Power My Analytics will initially backfill 13 months of non-lifetime data when you first create a report. Run a manual backfill from your Hub 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 ...
      • 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 ...
      • 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 ...
      • 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 ...
      • Campaign Monitor Data Connector User Guide

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