BigCommerce Fields
This page provides a comprehensive reference of all supported metrics and breakdowns available for BigCommerce data extraction through Adzviser.
Metrics
Order Counts
| Field Name | Description |
|---|---|
| Orders | Total order count |
| Order items total | Total items ordered |
| Order items shipped | Items shipped |
Order Totals
| Field Name | Description |
|---|---|
| Order subtotal | Subtotal including tax |
| Order discount | Discount amount |
| Order shipping | Shipping cost including tax |
| Order handling | Handling cost including tax |
| Order wrapping | Wrapping cost including tax |
| Order total | Total 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 Name | Description |
|---|---|
| Shipping tax | Shipping tax amount |
| Handling tax | Handling tax amount |
| Wrapping tax | Wrapping tax amount |
| Subtotal tax | Subtotal tax amount |
| Total tax | Total tax amount |
Discounts & Refunds
| Field Name | Description |
|---|---|
| Store credit | Store credit applied |
| Gift certificate | Gift certificate amount |
| Coupon | Coupon discount |
| Refunded amount | Refund amount |
Averages
| Field Name | Description |
|---|---|
| Avg. order value | Average order value |
| Avg. items per order | Average items per order |
Breakdowns
Order Breakdowns
| Field Name | Description |
|---|---|
| Order ID | Unique order identifier |
| Order customer ID | Customer identifier |
| Order status ID | Status identifier |
| Order status | Order status |
| Order custom status | Custom status |
| Order customer message | Customer message |
| Order is digital | Digital order flag |
| Order IP address | Customer IP (v4) |
| Order IP address v6 | Customer IP (v6) |
| Order GeoIP country | GeoIP country |
| Order GeoIP country (ISO2) | Country ISO code |
| Order source | Order source |
| Order channel ID | Channel identifier |
| Order external ID | External identifier |
| Order created date | Creation date |
| Order created datetime | Creation datetime |
| Order modified date | Modification date |
| Order modified datetime | Modification datetime |
| Order shipped date | Ship date |
| Order shipped datetime | Ship datetime |
Billing Breakdowns
| Field Name | Description |
|---|---|
| Billing first name | First name |
| Billing last name | Last name |
| Billing company | Company name |
| Billing street 1 | Street address 1 |
| Billing street 2 | Street address 2 |
| Billing city | City |
| Billing state | State/province |
| Billing zip | Zip/postal code |
| Billing country | Country |
| Billing country (ISO2) | Country ISO code |
| Billing phone | Phone number |
| Billing email | Email address |
Payment Breakdowns
| Field Name | Description |
|---|---|
| Order payment method | Payment method |
| Order payment provider ID | Payment provider |
| Order payment status | Payment status |
| Order currency ID | Currency ID |
| Order currency code | Currency code |
Store Breakdowns
| Field Name | Description |
|---|---|
| Store hash | Store identifier |