Shopify Fields
This page provides a comprehensive reference of all supported metrics and breakdowns available for Shopify data extraction through Adzviser.
Metrics
Sales Metrics
| Field Name | Description |
|---|---|
| Gross sales | Total gross sales |
| Discounts | Total discounts applied |
| Returns | Return amount |
| Net sales | Net sales after returns/discounts |
| Shipping | Shipping charges |
| Tax | Total tax amount |
| Duties | Duties applied |
| Total sales | Total sales amount |
Order Metrics
| Field Name | Description |
|---|---|
| Items | Total items ordered |
| Orders | Order count |
Inventory Metrics
| Field Name | Description |
|---|---|
| Inventory value | Total inventory value |
| Inventory quantity | Available inventory quantity |
Profitability Metrics
| Field Name | Description |
|---|---|
| Cost of goods sold | COGS total |
| Gross profit | Gross profit (Net Sales - COGS) |
Customer Metrics
| Field Name | Description |
|---|---|
| Customer count | Unique customer count |
Breakdowns
Product Breakdowns
| Field Name | Description |
|---|---|
| Shop Name | Store name |
| Product SKU | Product SKU |
| Product ID | Product identifier |
| Variant ID | Variant identifier |
| Product title | Product name |
| Variant title | Variant name |
| Product tags | Product tags |
| Product price | Product price |
| Product description | Product description |
| Product vendor | Vendor name |
| Product type | Product type |
| Product image URL | Featured image URL |
| Product created datetime | Creation datetime |
| Product cost per item | Unit cost |
| Is gift card | Gift card flag |
Order Breakdowns
| Field Name | Description |
|---|---|
| Order ID | Unique order identifier |
| Order name | Order name |
| Order note | Order notes |
| Order tags | Order tags |
| Order created datetime | Creation datetime |
| Order closed datetime | Closed datetime |
| Order cancelled datetime | Cancellation datetime |
Shipping Address
| Field Name | Description |
|---|---|
| Shipping address 1 | Address line 1 |
| Shipping address 2 | Address line 2 |
| Shipping phone | Phone number |
| Shipping post code | Postal code |
| Shipping city | City |
| Shipping province | Province/state |
| Shipping country | Country |
Billing Address
| Field Name | Description |
|---|---|
| Billing address 1 | Address line 1 |
| Billing address 2 | Address line 2 |
| Billing phone | Phone number |
| Billing post code | Postal code |
| Billing city | City |
| Billing province | Province/state |
| Billing country | Country |
Order Details
| Field Name | Description |
|---|---|
| Channel | Sales channel |
| Channel (App name) | App name |
| Order confirmed | Confirmation status |
| Currency | Currency code |
| Order email | Customer email |
| Fully paid | Payment status |
| Is returning customer | Returning customer flag |
| Fulfillment status | Fulfillment status |
Attribution Breakdowns
| Field Name | Description |
|---|---|
| Landing page URL | Landing page URL |
| Referral code | Referral code |
| Order referrer URL | Referrer URL |
| UTM content | UTM content parameter |
| UTM term | UTM term parameter |
| UTM medium | UTM medium parameter |
| UTM source | UTM source parameter |
| UTM campaign name | UTM campaign parameter |
| Referring channel | Referring channel |
| Traffic type | Traffic source type |
Customer Breakdowns
| Field Name | Description |
|---|---|
| Customer ID | Customer identifier |
| Customer first name | First name |
| Customer last name | Last name |
| Customer email | Email address |
| Customer last order created datetime | Last order date |
| Customer account created datetime | Account creation date |