Connect to Data Sources
BigCommerce
BigCommerce Supported Metrics and Breakdowns

BigCommerce Metrics and Breakdowns

This page provides a comprehensive reference of all supported metrics and breakdowns available for BigCommerce data extraction through Adzviser.

Metrics

Order Counts

Field NameDescription
OrdersTotal order count
Order items totalTotal items ordered
Order items shippedItems shipped

Order Totals

Field NameDescription
Order subtotalSubtotal including tax
Order discountDiscount amount
Order shippingShipping cost including tax
Order handlingHandling cost including tax
Order wrappingWrapping cost including tax
Order totalTotal including tax
Order subtotal (ex tax)Subtotal excluding tax
Order shipping (ex tax)Shipping excluding tax
Order handling (ex tax)Handling excluding tax
Order wrapping (ex tax)Wrapping excluding tax
Order total (ex tax)Total excluding tax

Tax Metrics

Field NameDescription
Shipping taxShipping tax amount
Handling taxHandling tax amount
Wrapping taxWrapping tax amount
Subtotal taxSubtotal tax amount
Total taxTotal tax amount

Discounts & Refunds

Field NameDescription
Store creditStore credit applied
Gift certificateGift certificate amount
CouponCoupon discount
Refunded amountRefund amount

Averages

Field NameDescription
Avg. order valueAverage order value
Avg. items per orderAverage items per order

Product Metrics

Field NameDescription
Product ordersNumber of orders containing the product
Product quantityTotal units ordered
Product quantity refundedTotal units refunded
Product refund amountTotal refund amount for products
Product price (inc tax)Product price including tax
Product price (ex tax)Product price excluding tax
Product total (inc tax)Product line total including tax
Product total (ex tax)Product line total excluding tax
Product cost priceProduct cost/COGS price
Product avg priceAverage product price including tax

Breakdowns

Order Breakdowns

Field NameDescription
Order IDUnique order identifier
Order customer IDCustomer identifier
Order status IDStatus identifier
Order statusOrder status
Order custom statusCustom status
Order customer messageCustomer message
Order is digitalDigital order flag
Order IP addressCustomer IP (v4)
Order IP address v6Customer IP (v6)
Order GeoIP countryGeoIP country
Order GeoIP country (ISO2)Country ISO code
Order sourceOrder source
Order channel IDChannel identifier
Order external IDExternal identifier
Order created dateCreation date
Order created datetimeCreation datetime
Order modified dateModification date
Order modified datetimeModification datetime
Order shipped dateShip date
Order shipped datetimeShip datetime

Billing Breakdowns

Field NameDescription
Billing first nameFirst name
Billing last nameLast name
Billing companyCompany name
Billing street 1Street address 1
Billing street 2Street address 2
Billing cityCity
Billing stateState/province
Billing zipZip/postal code
Billing countryCountry
Billing country (ISO2)Country ISO code
Billing phonePhone number
Billing emailEmail address

Payment Breakdowns

Field NameDescription
Order payment methodPayment method
Order payment provider IDPayment provider
Order payment statusPayment status
Order currency IDCurrency ID
Order currency codeCurrency code

Store Breakdowns

Field NameDescription
Store hashStore identifier

Product Breakdowns

Field NameDescription
Product nameProduct name
Product SKUStock keeping unit
Product IDProduct identifier
Product variant IDVariant identifier
Product typeProduct type
Product UPCUniversal product code
Product brandProduct brand
Product option set nameCustomer-facing option name
Product bin picking numberBin picking number
Product order IDOrder containing this product
Product is refundedWhether the product was refunded
Product is bundled productWhether the product is bundled
Product parent order product IDParent order product ID
Product fixed shipping costFixed shipping cost
Product event nameEvent name