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) | year_of_week | dim | ||
| Year of week (Mon-Sun) | year_of_week_iso | dim | ||
| Year & month | year_month | dim | ||
| Month | month | dim | ||
| Year & week (Sun-Sat) | year_week | dim | ||
| Year & week (Mon-Sun) | year_week_iso | dim | ||
| Week (Sun-Sat) | week | dim | ||
| Week (Mon-Sun) | week_iso | dim | ||
| Day of month | day_of_month | dim | ||
| Day of week (Sun-Sat) | day_of_week_name | dim | ||
| Day of week (Mon-Sun) | day_of_week_name_iso | dim | ||
| Date | date | dim | ||
| Datetime | atom | dim | ||
| Seller | Seller ID | seller_id | dim | Amazon seller ID, it is unique to a given seller. |
| Marketplace | Marketplace ID | marketplace_id | dim | Amazon marketplace identifier. |
| Marketplace name | marketplace_name | dim | Amazon marketplace name. | |
| Order | Amazon order ID | amazon_order_id | dim | Unique identifier for the order assigned by Amazon. |
| Merchant order ID | merchant_order_id | dim | Merchant-defined identifier for the order. | |
| Purchase date | purchase_date | dim | Date the order was placed. | |
| Purchase datetime | purchase_datetime | dim | Date and time the order was placed. | |
| Last updated date | last_updated_date | dim | Date the order was last updated. | |
| Last updated datetime | last_updated_datetime | dim | Date and time the order was last updated. | |
| Order status | order_status | dim | Current status of the order (e.g., New, Pending, Shipped, Delivered, Closed). | |
| Order channel | order_channel | dim | Channel through which the order was initiated (e.g., website, mobile app, third-party marketplace). | |
| Sales channel | sales_channel | dim | Channel through which the order was placed (e.g., Amazon.com, Amazon App, Amazon Marketplace). | |
| Product | Product name | product_name | dim | Title of the product being ordered. |
| (Parent) ASIN | parent_asin | dim | Identifiers (ASINs) of the related items that are parents of this item. | |
| (Child) ASIN | child_asin | dim | Identifiers (ASINs) of the related items that are children of this item. | |
| SKU | sku | dim | Stock Keeping Unit, a seller-specified identifier for an Amazon listing. | |
| ASIN | asin | dim | ||
| Brand | brand | dim | Name of the brand associated with an Amazon catalog item. | |
| Title | title | dim | Name, or title, associated with an Amazon catalog item. | |
| Item status | item_status | dim | Status of the individual items in the order (e.g., Ordered, In Stock, Shipped, Delivered, Canceled). | |
| Currency | currency | dim | Currency in which the order was placed. | |
| Promotion IDs | promotion_ids | dim | IDs of any promotions applied to the order. | |
| Is business order | is_business_order | dim | Indicates whether the order is a business order. | |
| Purchase order number | purchase_order_number | dim | Purchase order number associated with the order, if applicable. | |
| Price designation | price_designation | dim | Indicates the method used to determine the price of the order (e.g., Standard Price, Configurable Price). | |
| Signature confirmation recommended | signature_confirmation_recommended | dim | Indicates whether signature confirmation is recommended for the shipping address. | |
| Item quantity | item_quantity | met | The quantity of the item ordered. | |
| Item price | item_price | met | Price of each individual item. | |
| Item tax | item_tax | met | Sales tax applicable to each item. | |
| Gift wrap price | gift_wrap_price | met | Cost of any gift wrapping selected by the customer. | |
| Gift wrap tax | gift_wrap_tax | met | Sales tax applicable to the gift wrapping cost. | |
| Item promotion discount | item_promotion_discount | met | Discount applied to the total price of the items. | |
| Sales | Ordered product sales | ordered_product_sales | met | Total revenue from products ordered, excluding taxes and shipping costs. |
| Ordered product sales - B2B | ordered_product_sales_b2b | met | Total revenue from products ordered by business-to-business B2B customers, excluding taxes and shipping costs. | |
| Units ordered | units_ordered | met | Total number of units ordered, regardless of whether they were fulfilled or refunded. | |
| Units ordered - B2B | units_ordered_b2b | met | Total number of units ordered by B2B customers. | |
| Total order items | total_order_items | met | Total number of items ordered, including multiple quantities of the same product. | |
| Total order items - B2B | total_order_items_b2b | met | Total number of items ordered by B2B customers. | |
| Average sales per order item | average_sales_per_order_item | met | Average revenue per order item, calculated by dividing orderedProductSales by totalOrderItems. | |
| Average sales per order item - B2B | average_sales_per_order_item_b2b | met | Average revenue per order item for B2B orders, calculated by dividing orderedProductSalesB2B by totalOrderItemsB2B. | |
| Average units per order item | average_units_per_order_item | met | Average number of units per order item, calculated by dividing unitsOrdered by totalOrderItems. | |
| Average units per order item - B2B | average_units_per_order_item_b2b | met | Average number of units per order item for B2B orders, calculated by dividing unitsOrderedB2B by totalOrderItemsB2B. | |
| Average selling price | average_selling_price | met | Average selling price per unit, calculated by dividing orderedProductSales by unitsOrdered. | |
| Average selling price - B2B | average_selling_price_b2b | met | Average selling price per unit for B2B orders, calculated by dividing orderedProductSalesB2B by unitsOrderedB2B. | |
| Average offer count | average_offer_count | met | The average number of offers listed for sale created on the particular day. | |
| Average parent items | average_parent_items | met | The average number of parent items listed for sale created on the particular day. | |
| Shipping | Fulfillment channel | fulfillment_channel | dim | Channel through which the order will be fulfilled (e.g., Seller Fulfilled Prime, Amazon Fulfilled). |
| Ship service level | ship_service_level | dim | Shipping service level chosen by the customer. | |
| Ship city | ship_city | dim | City where the order should be shipped. | |
| Ship state | ship_state | dim | State or province where the order should be shipped. | |
| Ship postal code | ship_postal_code | dim | Postal code where the order should be shipped. | |
| Ship country | ship_country | dim | Country where the order should be shipped. | |
| Shipped product sales | shipped_product_sales | met | Total revenue from products shipped, excluding taxes and shipping costs. | |
| Units shipped | units_shipped | met | Total number of units shipped. | |
| Orders shipped | orders_shipped | met | Total number of orders shipped. | |
| Shipping price | shipping_price | met | Total shipping cost for the order. | |
| Shipping tax | shipping_tax | met | Sales tax applicable to the shipping cost. | |
| Ship promotion discount | ship_promotion_discount | met | Discount applied to the shipping cost. | |
| Refunds | Units refunded | units_refunded | met | Total number of units refunded. |
| Refund rate | refund_rate | met | Percentage of units refunded, calculated by dividing unitsRefunded by unitsOrdered. | |
| A-to-z claims granted | claims_granted | met | Total number of claims granted. | |
| Claims amount | claims_amount | met | Total amount of money paid out in claims. | |
| Traffic | Page views - mobile app | mobile_app_page_views | met | Number of page views from mobile apps. |
| Page views - mobile app - B2B | mobile_app_page_views_b2b | met | Number of page views from mobile apps for B2B customers. | |
| Page views - browser | browser_page_views | met | Number of page views from desktop browsers. | |
| Page views - browser - B2B | browser_page_views_b2b | met | Number of page views from desktop browsers for B2B customers. | |
| Page views - total | page_views | met | Total number of page views. | |
| Page views - total - B2B | page_views_b2b | met | Total number of page views for B2B customers. | |
| Sessions - mobile app | mobile_app_sessions | met | Number of sessions from mobile apps. | |
| Sessions - mobile app - B2B | mobile_app_sessions_b2b | met | Number of sessions from mobile apps for B2B customers. | |
| Sessions - browser | browser_sessions | met | Number of sessions from desktop browsers. | |
| Sessions - browser - B2B | browser_sessions_b2b | met | Number of sessions from desktop browsers for B2B customers. | |
| Sessions - total | sessions | met | Total number of sessions. | |
| Sessions - total - B2B | sessions_b2b | met | Total number of sessions for B2B customers. | |
| Unit session percentage | unit_session_percentage | met | Percentage of sessions that resulted in a unit sale. | |
| Unit session percentage - B2B | unit_session_percentage_b2b | met | Percentage of sessions that resulted in a unit sale for B2B customers. | |
| Order item session percentage | order_item_session_percentage | met | Percentage of sessions that resulted in an order. | |
| Order item session percentage - B2B | order_item_session_percentage_b2b | met | Percentage of sessions that resulted in an order for B2B customers. | |
| Featured offer (buy box) percentage | buy_box_percentage | met | Percentage of time your products were displayed in the Buy Box. | |
| Featured offer (buy box) percentage - B2B | buy_box_percentage_b2b | met | Percentage of time your products were displayed in the Buy Box for B2B customers. | |
| Feedback | Feedback received | feedback_received | met | Total number of feedback ratings received. |
| Negative feedback received | negative_feedback_received | met | Total number of negative feedback ratings received. | |
| Received negative feedback rate | received_negative_feedback_rate | met | Percentage of feedback ratings that were negative, calculated by dividing negativeFeedbackReceived by feedbackReceived. |