Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | year | dim | |
| Year of week (Sun-Sat) | yearOfWeek | dim | ||
| Year of week (Mon-Sun) | yearOfWeekIso | dim | ||
| Year & month | yearMonth | dim | ||
| Month | month | dim | ||
| Year & week (Sun-Sat) | yearWeek | dim | ||
| Year & week (Mon-Sun) | yearWeekIso | dim | ||
| Week (Sun-Sat) | week | dim | ||
| Week (Mon-Sun) | weekIso | dim | ||
| Day of month | dayOfMonth | dim | ||
| Day of week (Sun-Sat) | dayOfWeekName | dim | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | ||
| Date | date | dim | ||
| Hour | hour | dim | Hour in a 24-hour clock, e.g. 18 | |
| STORE | Store ID | shop_id | dim | The unique identifier of the store |
| Store name | shop_name | dim | The name of the store | |
| PRODUCT | SKU | sku | dim | Variant SKU number |
| Product ID | product_id | dim | The unique identifier of the product | |
| Variant ID | variant_id | dim | The unique identifier of the product variant | |
| Product title | title | dim | The title of the product | |
| Variant title | variant_title | dim | The title of the product variant | |
| Product tags | product_tags | dim | Tags attached to the product | |
| Price | price | dim | The price of the product | |
| Description | description | dim | Description of the product | |
| Vendor | vendor | dim | The vendor of the product | |
| Type | type | dim | The type of the product | |
| Image URL | image_src | dim | The image URL of the product | |
| Product created datetime | product_created_at | dim | The date and time the product was created | |
| Product created date | product_created_at_date | dim | The date the product was created | |
| INVENTORY ITEM | Cost per item | inventory_item_cost_per_item | dim | Cost of the inventory item |
| LINE ITEM | Line item ID | line_item_id | dim | ID of the line item row |
| Line item type | line_item_type | dim | Type classification by Supermetrics. Possible values are "Product", "Refund", "Order adjustment", and "Shipping" | |
| Line item fulfillment date | line_item_fulfillment_date | dim | The date that the specific line item fulfillment was completed | |
| Is gift card | line_item_is_gift_card | dim | Whether or not the line item is a gift card | |
| ORDER | Order ID | order_id | dim | The unique identifier of the order |
| Order name | order_name | dim | The name of the order | |
| Order note | order_note | dim | The note on the order | |
| Order tags | order_tags | dim | Tags attached to the order | |
| Order created datetime | order_created_at | dim | The date and time the order was created | |
| Order created date | order_created_at_date | dim | The date the order was created | |
| Order closed datetime | order_closed_at | dim | The date and time the order was closed | |
| Order closed date | order_closed_at_date | dim | The date the order was closed | |
| Order cancelled datetime | order_cancelled_at | dim | The date and time of the order cancellation | |
| Order cancelled date | order_cancelled_at_date | dim | The date of the order cancellation | |
| Shipping address 1 | order_shipping_address1 | dim | The street address of the shipping address | |
| Shipping address 2 | order_shipping_address2 | dim | An optional additional field for the street address of the shipping address | |
| Shipping phone | order_shipping_phone | dim | The phone number at the shipping address | |
| Shipping post code | order_shipping_post_code | dim | The postal code (zip, postcode, Eircode, …) of the shipping address | |
| Shipping city | order_shipping_city | dim | The city, town, or village of the shipping address | |
| Shipping province | order_shipping_province | dim | The name of the region (province, state, prefecture, …) of the shipping address | |
| Shipping country | order_shipping_country | dim | The name of the country of the shipping address | |
| Billing address 1 | order_billing_address1 | dim | The street address of the billing address | |
| Billing address 2 | order_billing_address2 | dim | An optional additional field for the street address of the billing address | |
| Billing phone | order_billing_phone | dim | The phone number at the billing address | |
| Billing post code | order_billing_post_code | dim | The postal code (for example, zip, postcode, or Eircode) of the billing address | |
| Billing city | order_billing_city | dim | The city, town, or village of the billing address | |
| Billing province | order_billing_province | dim | The name of the region (for example, province, state, or prefecture) of the billing address | |
| Billing country | order_billing_country | dim | The name of the country of the billing address | |
| Channel | order_channel | dim | The sales channel of the order | |
| Channel (App name) | order_channel_app_name | dim | The sales channel's app name of the order | |
| Order confirmed | order_confirmed | dim | Whether inventory has been reserved for the order | |
| Currency | order_currency_code | dim | The currency code of the order | |
| Order email | order_email | dim | The email associated with the order | |
| Fully paid | order_fully_paid | dim | Whether the order is fully paid or not | |
| Discount reason | order_discount_code | dim | The reason for the applied order's item-level discount | |
| Location name | order_location | dim | The location name | |
| Shipping description | order_shipping_description | dim | Description of the shipping selected for the order | |
| Is returning customer | order_is_returning_customer | dim | Whether the customer is returning or not | |
| Fulfillment status | order_display_fulfillment_status | dim | Represents the order's current fulfillment status. Valid values are: unfulfilled, partial, fulfilled, restocked | |
| Fulfillment date | order_fulfillment_date | dim | The date that the order fulfillment was completed | |
| TRAFFIC SOURCE | Landing page URL | order_landing_page_url | dim | The URL of the landing page |
| Referral code | order_referral_code | dim | Referral code that led the customer making the order to the store. However this is set when a customer first enters the store. So if they have been to the store previously without a referral, then the referral code will stay empty even if they would later visit the store via a referral link | |
| Order referrer URL | order_referrer_url | dim | The web page the customer clicked a link on that sent them to the online store that led to the order | |
| UTM content | order_utm_content | dim | A/B testing and content-targeted ads to differentiate ads or links that point to the same URL | |
| UTM term | order_utm_term | dim | The keywords associated with an ad | |
| UTM medium | order_utm_medium | dim | The ad medium, such as email or cost-per-click (cpc) | |
| UTM source | order_utm_source | dim | Identifies a search engine, a newsletter name, or other source | |
| UTM campaign name | order_utm_name | dim | The name that you give a promotion or campaign to identify it | |
| CUSTOMER GEO | Country | customer_country | dim | The country of the customer |
| Country code | customer_country_code | dim | The country code of the customer | |
| City | customer_city | dim | The city of the customer | |
| CUSTOMER DETAILS | Customer ID | customer_id | dim | The unique identifier of the customer |
| First name | customer_first_name | dim | The first name of the customer | |
| Last name | customer_last_name | dim | The last name of the customer | |
| customer_email | dim | The email of the customer | ||
| Last order created datetime | customer_last_order_created_at | dim | The date and time the last order of the customer was created | |
| Last order created date | customer_last_order_created_at_date | dim | The date the last order of the customer was created | |
| Account age in days | customer_lifetime_duration | dim | The amount of days since the customer was first added to the online store | |
| Account created datetime | customer_created_at | dim | The date and time the customer was added to the online store | |
| Account created date | customer_created_at_date | dim | The date the customer was added to the online store | |
| Customer notes | customer_notes | dim | Note about the customer | |
| SALES | Gross sales | gross_sales | met | The total price for the line item without any discounts applied |
| Discounts | discounts | met | The total amount of discounts applied on the order | |
| Returns | returns | met | The total amount refunded for the order | |
| Net sales | net_sales | met | The net sales of the line | |
| Shipping | shipping | met | The total shipping amount including returns | |
| Tax | tax | met | The total amount of tax for the line. Takes returns into account | |
| Duties | duties | met | The total amount of duties based on the order | |
| Total sales | total_sales | met | The total sales for line | |
| ORDER | Ordered quantity | ordered_quantity | met | Total number of items ordered. Calculated by Net quantity + Returned quantity |
| Returned quantity | returned_quantity | met | Total number of items returned | |
| Net quantity | net_quantity | met | Net quantity of line items ordered. It shows number of sold items minus the number of returned items | |
| Units per transaction | units_per_transaction | met | Average number of items per transaction. Calculated by Net quantity / Orders | |
| Orders | sm_order_count | met | The amount of orders | |
| Avg. order value | avg_total_sales | met | The average total sales | |
| PRODUCT | Inventory value | product_inventory_value | met | The sell value of the product inventory |
| Inventory quantity | product_inventory_quantity | met | The product quantity in inventory | |
| INVENTORY ITEM | Cost of goods sold | cost_of_goods_sold | met | The total cost of all the units of goods sold |
| Gross profit | gross_profit | met | The total profit made calculated by subtracting the cost from net sales | |
| CUSTOMER | Customer count | customer_count | met | The total count of the customers |
| DEPRECATED | Items | items | met | The amount of the line item. Please note that this field will be removed on 2025-01-30 |
| Avg. number of items | avg_items | met | The average number of sold items. Order adjustments and shipping is not calculated towards this metric. Please note that this field will be removed on 2025-01-30 | |
| Query | Start date | system_metadata.query_date_range_start | dim | The start date of the requested query |
| End date | system_metadata.query_date_range_end | dim | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | dim | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | dim | All filters used in the query | |
| Start | system_metadata.query_date_start | dim | When the query was started | |
| End | system_metadata.query_date_end | dim | When the query completed | |
| Duration | system_metadata.query_duration | dim | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | dim | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | dim | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | dim | The Supermetrics users that created the data source login connections |