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 | ||
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" | |
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-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 | |
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 | |
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 | |
Total sales | total_sales | met | The total sales for line | |
ORDER | Items | items | met | The amount of the line item |
Orders | sm_order_count | met | The amount of orders | |
Avg. order value | avg_total_sales | met | The average total sales | |
Avg. number of items | avg_items | met | The average number of sold items. Order adjustments and shipping is not calculated towards this metric | |
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 |