| Column Name | Data type | Description |
|---|---|---|
| account_id | Integer | Intentwise account id |
| account_name | String | Intentwise account name |
| currency_code | String | One single currency for billing, budgeting, bid settings & campaign performance metrics |
| country_code | String | Country code of account |
| Date | Date | Report Date |
| campaign_id | Integer | Campaign Identifier |
| advertiser_id | Integer | Advertising Id |
| ad_group_id | Integer | Adgroup id |
| placement | String | The location or placement to serve ads for keyword campaigns. Possible values are: Search In-grid, Browse In-grid, Search Carousel, Browse Carousel, Item Carousel, Buy Box, Home Page, Stock Up |
| ad_spend | Numeric | The amount of budget spent in dollars |
| num_ads_shown | Integer | Number of ads shown |
| num_ads_clicks | Integer | Number of ads clicked |
| direct_attributed_sales_3_days | Numeric | Attributed sales revenue based off the direct click of the advertised item in dollars, over 3 day click. |
| direct_attributed_sales_14_days | Numeric | Attributed sales revenue based off the direct click of the advertised item in dollars, over 14 day click |
| direct_attributed_sales_30_days | Numeric | Attributed sales revenue based off the direct click of the advertised item in dollars, over 30 day click |
| attributed_units_3_days | Numeric | Total attributed units sold over 3 day click. This is for online sales only. |
| attributed_units_14_days | Numeric | Total attributed units sold over 14 day click. This is for online sales only. |
| attributed_units_30_days | Numeric | Total attributed units sold over 30 day click. This is for online sales only. |
| brand_attributed_sales_3_days | Numeric | Attributed sales based off the direct click of the same brand as the advertised item in dollars, over 3 day click. |
| brand_attributed_sales_14_days | Numeric | Attributed sales based off the direct click of the same brand as the advertised item in dollars, over 14 day click. |
| brand_attributed_sales_30_days | Numeric | Attributed sales based off the direct click of the same brand as the advertised item in dollars, over 30 day click |
| related_attributed_sales_3_days | Numeric | Attributed sales revenue based off the direct click of the same brand and category as the advertised item in dollars, over 3 day click. |
| related_attributed_sales_14_days | Numeric | Attributed sales revenue based off the direct click of the same brand and category as the advertised item in dollars, over 14 day click |
| related_attributed_sales_30_days | Numeric | Attributed sales revenue based off the direct click of the same brand and category as the advertised item in dollars, over 30 day click |
| download_Date | Date | Date of Download |
| ntb_orders_3_days | Integer | The number of first-time orders for products within the brand, over a one year look back window attributed over 3 days |
| ntb_orders_14_days | Integer | The number of first-time orders for products within the brand, over a one year look back window attributed over 14 days. This metric includes all placement types. |
| ntb_orders_30_days | Integer | he number of first-time orders for products within the brand, over a one year look back window attributed over 30 days. This metric includes all placement types. |
| ntb_revenue_3_days | Numeric | The total sales of new-to-brand orders for products within the brand, over a one year look back window attributed over 3 days. This metric includes all placement types |
| ntb_revenue_14_days | Numeric | The total sales of new-to-brand orders for products within the brand, over a one year look back window attributed over 14 days. This metric includes all placement types |
| ntb_revenue_30_days | Numeric | The total sales of new-to-brand orders for products within the brand, over a one year look back window attributed over 30 days. This metric includes all placement types |
| ntb_units_3_days | Integer | The number of units purchased from new-to-brand orders for products within the brand, over a one year look back window attributed over 3 days. This metric includes all placement types. |
| ntb_units_14_days | Integer | The number of units purchased from new-to-brand orders for products within the brand, over a one year look back window attributed over 14 days. This metric includes all placement types. |
| ntb_units_30_days | Integer | The number of units purchased from new-to-brand orders for products within the brand, over a one year look back window attributed over 30 days. This metric includes all placement types. |
| attributed_orders_3_days | Integer | Total attributed orders placed over 3 day click. This is for online sales only. |
| attributed_orders_14_days | Integer | Total attributed orders placed over 14 day click. This is for online sales only. |
| attributed_orders_30_days | Integer | Total attributed orders placed over 30 day click. This is for online sales only. |
| other_sku_sales_3_days | Numeric | Attributed sales based off the direct click of the same brand as the advertised item in dollars, over 3 day click. This is for online sales only |
| other_sku_sales_14_days | Numeric | Attributed sales based off the direct click of the same brand as the advertised item in dollars, over 14 day click. This is for online sales only |
| other_sku_sales_30_days | Numeric | Attributed sales based off the direct click of the same brand as the advertised item in dollars, over 30 day click. This is for online sales only |
| in_store_advertised_sales_3_days | Numeric | In-store attributed sales revenue based off the direct click of the advertised item, over 3 day click |
| in_store_advertised_sales_14_days | Numeric | In-store attributed sales revenue based off the direct click of the advertised item, over 14 day click |
| in_store_advertised_sales_30_days | Numeric | In-store attributed sales revenue based off the direct click of the advertised item, over 30 day click |
| in_store_attributed_sales_3_days | Numeric | In-store total attributed sales revenue made from units sold, over 3 day click |
| in_store_attributed_sales_14_days | Numeric | In-store total attributed sales revenue made from units sold, over 14 day click |
| in_store_attributed_sales_30_days | Numeric | In-store total attributed sales revenue made from units sold, over 30 day click |
| in_store_orders_3_days | Integer | In-store total attributed orders over 3 day click |
| in_store_orders_14_days | Integer | In-store total attributed orders over 14 day click |
| in_store_orders_30_days | Integer | In-store total attributed orders over 30 day click |
| in_store_other_sales_3_days | Numeric | In-store attributed sales based off the direct click of the same brand as the advertised item, over 3 day click |
| in_store_other_sales_14_days | Numeric | In-store attributed sales based off the direct click of the same brand as the advertised item, over 14 day click |
| in_store_other_sales_30_days | Numeric | In-store attributed sales based off the direct click of the same brand as the advertised item, over 30 day click |
| in_store_units_sold_3_days | Integer | In-store total attributed units, over 3 day click |
| in_store_units_sold_14_days | Integer | In-store total attributed units, over 14 day click |
| in_store_units_sold_30_days | Integer | In-store total attributed units, over 30 day click |
| Column Name | Data type | Description |
|---|---|---|
| account_id | Integer | Intentwise account id |
| account_name | String | Intentwise account name |
| currency_code | String | One single currency for billing, budgeting, bid settings & campaign performance metrics |
| country_code | String | Country code of account |
| Date | Date | Report Date |
| campaign_id | Integer | Campaign Identifier |
| advertiser_id | Integer | Advertising Id |
| ad_group_id | Integer | Adgroup id |
| platform | String | The platform where the campaign is running. The values for platform: mobile, desktop, app, others |
| ad_spend | Numeric | The amount of budget spent in dollars |
| num_ads_shown | Integer | Number of ads shown |
| num_ads_clicks | Integer | Number of ads clicked |
| direct_attributed_sales_3_days | Numeric | Attributed sales revenue based off the direct click of the advertised item in dollars, over 3 day click. |
| direct_attributed_sales_14_days | Numeric | Attributed sales revenue based off the direct click of the advertised item in dollars, over 14 day click |
| direct_attributed_sales_30_days | Numeric | Attributed sales revenue based off the direct click of the advertised item in dollars, over 30 day click |
| attributed_units_3_days | Numeric | Total attributed units sold over 3 day click. This is for online sales only. |
| attributed_units_14_days | Numeric | Total attributed units sold over 14 day click. This is for online sales only. |
| attributed_units_30_days | Numeric | Total attributed units sold over 30 day click. This is for online sales only. |
| brand_attributed_sales_3_days | Numeric | Attributed sales based off the direct click of the same brand as the advertised item in dollars, over 3 day click. |
| brand_attributed_sales_14_days | Numeric | Attributed sales based off the direct click of the same brand as the advertised item in dollars, over 14 day click. |
| brand_attributed_sales_30_days | Numeric | Attributed sales based off the direct click of the same brand as the advertised item in dollars, over 30 day click |
| related_attributed_sales_3_days | Numeric | Attributed sales revenue based off the direct click of the same brand and category as the advertised item in dollars, over 3 day click. |
| related_attributed_sales_14_days | Numeric | Attributed sales revenue based off the direct click of the same brand and category as the advertised item in dollars, over 14 day click |
| related_attributed_sales_30_days | Numeric | Attributed sales revenue based off the direct click of the same brand and category as the advertised item in dollars, over 30 day click |
| download_Date | Date | Date of Download |
| ntb_orders_3_days | Integer | The number of first-time orders for products within the brand, over a one year look back window attributed over 3 days |
| ntb_orders_14_days | Integer | The number of first-time orders for products within the brand, over a one year look back window attributed over 14 days. This metric includes all placement types. |
| ntb_orders_30_days | Integer | he number of first-time orders for products within the brand, over a one year look back window attributed over 30 days. This metric includes all placement types. |
| ntb_revenue_3_days | Numeric | The total sales of new-to-brand orders for products within the brand, over a one year look back window attributed over 3 days. This metric includes all placement types |
| ntb_revenue_14_days | Numeric | The total sales of new-to-brand orders for products within the brand, over a one year look back window attributed over 14 days. This metric includes all placement types |
| ntb_revenue_30_days | Numeric | The total sales of new-to-brand orders for products within the brand, over a one year look back window attributed over 30 days. This metric includes all placement types |
| ntb_units_3_days | Integer | The number of units purchased from new-to-brand orders for products within the brand, over a one year look back window attributed over 3 days. This metric includes all placement types. |
| ntb_units_14_days | Integer | The number of units purchased from new-to-brand orders for products within the brand, over a one year look back window attributed over 14 days. This metric includes all placement types. |
| ntb_units_30_days | Integer | The number of units purchased from new-to-brand orders for products within the brand, over a one year look back window attributed over 30 days. This metric includes all placement types. |
| attributed_orders_3_days | Integer | Total attributed orders placed over 3 day click. This is for online sales only. |
| attributed_orders_14_days | Integer | Total attributed orders placed over 14 day click. This is for online sales only. |
| attributed_orders_30_days | Integer | Total attributed orders placed over 30 day click. This is for online sales only. |
| other_sku_sales_3_days | Numeric | Attributed sales based off the direct click of the same brand as the advertised item in dollars, over 3 day click. This is for online sales only |
| other_sku_sales_14_days | Numeric | Attributed sales based off the direct click of the same brand as the advertised item in dollars, over 14 day click. This is for online sales only |
| other_sku_sales_30_days | Numeric | Attributed sales based off the direct click of the same brand as the advertised item in dollars, over 30 day click. This is for online sales only |
| in_store_advertised_sales_3_days | Numeric | In-store attributed sales revenue based off the direct click of the advertised item, over 3 day click |
| in_store_advertised_sales_14_days | Numeric | In-store attributed sales revenue based off the direct click of the advertised item, over 14 day click |
| in_store_advertised_sales_30_days | Numeric | In-store attributed sales revenue based off the direct click of the advertised item, over 30 day click |
| in_store_attributed_sales_3_days | Numeric | In-store total attributed sales revenue made from units sold, over 3 day click |
| in_store_attributed_sales_14_days | Numeric | In-store total attributed sales revenue made from units sold, over 14 day click |
| in_store_attributed_sales_30_days | Numeric | In-store total attributed sales revenue made from units sold, over 30 day click |
| in_store_orders_3_days | Integer | In-store total attributed orders over 3 day click |
| in_store_orders_14_days | Integer | In-store total attributed orders over 14 day click |
| in_store_orders_30_days | Integer | In-store total attributed orders over 30 day click |
| in_store_other_sales_3_days | Numeric | In-store attributed sales based off the direct click of the same brand as the advertised item, over 3 day click |
| in_store_other_sales_14_days | Numeric | In-store attributed sales based off the direct click of the same brand as the advertised item, over 14 day click |
| in_store_other_sales_30_days | Numeric | In-store attributed sales based off the direct click of the same brand as the advertised item, over 30 day click |
| in_store_units_sold_3_days | Integer | In-store total attributed units, over 3 day click |
| in_store_units_sold_14_days | Integer | In-store total attributed units, over 14 day click |
| in_store_units_sold_30_days | Integer | In-store total attributed units, over 30 day click |
| Column Name | DataType | Description |
|---|---|---|
| account_id | Integer | Intentwise account id |
| account_name | String | Intentwise account name |
| currency_code | String | One single currency for billing, budgeting, bid settings & campaign performance metrics |
| country_code | String | Countries associated with the account |
| purchase_order_id | String | |
| customer_order_id | String | |
| sku | String | |
| order_date | Timestamp | |
| quantity_unit_measurement | String | |
| quantity_amount | Integer | |
| product_name | String | |
| line_item_status | String | |
| last_status_modified_date | Timestamp | |
| order_type | String | |
| customer_email_id | String | |
| original_customer_order_id | Integer | |
| shipping_phone | String | |
| shipping_estimated_delivery_date | Timestamp | |
| shipping_estimated_ship_date | Timestamp | |
| shipping_method_code | String | |
| shipping_postaladdress_name | String | |
| shipping_postaladdress_address1 | String | |
| shipping_postaladdress_address2 | String | |
| shipping_postaladdress_city | String | |
| shipping_postaladdress_state | String | |
| shipping_postaladdress_postal_code | String | |
| shipping_postaladdress_country | String | |
| shipping_postaladdress_address_type | String | |
| line_number | String | |
| fulfillment_option | String | |
| fulfillment_ship_method | String | |
| fulfillment_pickup_datetime | String | |
| seller_id | Integer | |
| shipnode_type | String | |
| buyer_id | String | |
| mart | String | |
| is_guest | String | |
| payment_types | String | |
| shipnode_name | String | |
| shipnode_id | String | |
| item_condition | String | |
| item_image_url | String | |
| item_weight_value | String | |
| item_weight_unit | String | |
| return_order_id | String | |
| original_carrier_method | String | |
| reference_line_id | String | |
| serial_numbers | String | |
| intent_to_cancel | String | |
| config_id | String | |
| seller_order_id | String | |
| total_amount | Integer | |
| currency | String | |
| refund_id | String | |
| refund_comments | String | |
| fulfillment_store_id | String | |
| fulfillment_pickup_by | String | |
| fulfillment_shipping_program_type | String | |
| download_date | Timestamp | Download Date |
| Column Name | Data Type | Description |
|---|---|---|
| account_id | integer | Intentwise account id |
| account_name | string | Intentwise account name |
| currency_code | string | One single currency for billing, budgeting, bid settings & campaign performance metrics |
| country_code | string | Countries associated with the account |
| purchase_order_id | string | |
| customer_order_id | string | |
| sku | string | |
| currency | string | |
| charge_type | string | |
| charge_name | string | |
| amount | integer | |
| tax_name | string | |
| tax_amount | integer | |
| seller_id | integer | |
| line_number | string | |
| download_date | timestamp |
| Column Name | Data Type | Description |
|---|---|---|
| account_id | integer | Intentwise account id |
| account_name | string | Intentwise account name |
| currency_code | string | One single currency for billing, budgeting, bid settings & campaign performance metrics |
| country_code | string | Countries associated with the account |
| purchase_order_id | string | |
| customer_order_id | string | |
| line_number | string | |
| refund_id | string | |
| refund_reason | string | |
| charge_type | string | |
| charge_name | string | |
| charge_amount | integer | |
| tax_name | string | |
| tax_amount | integer | |
| currency | string | |
| download_date | timestamp | |
| seller_id | integer |
| Column Name | Data Type | Description |
|---|---|---|
| account_id | integer | Intentwise account id |
| account_name | string | Intentwise account name |
| currency_code | string | One single currency for billing, budgeting, bid settings & campaign performance metrics |
| country_code | string | Countries associated with the account |
| purchase_order_id | string | |
| customer_order_id | string | |
| line_number | string | |
| status | string | |
| statusquantity_amount | integer | |
| statusquantity_unit_of_measurement | string | |
| cancellation_reason | string | |
| trackinginfo_ship_date_time | timestamp | |
| trackinginfo_method_code | string | |
| trackinginfo_tracking_number | string | |
| trackinginfo_tracking_url | string | |
| carriername_other_carrier | string | |
| carriername_carrier | string | |
| returncenteraddress_name | string | |
| returncenteraddress_address1 | string | |
| returncenteraddress_address2 | string | |
| returncenteraddress_city | string | |
| returncenteraddress_state | string | |
| returncenteraddress_postal_code | string | |
| returncenteraddress_country | string | |
| returncenteraddress_day_phone | string | |
| returncenteraddress_email_id | string | |
| download_date | timestamp | |
| seller_id | integer |
| Column Name | Data Type | Description |
|---|---|---|
| account_id | integer | Intentwise account id |
| account_name | string | Intentwise account name |
| currency_code | string | One single currency for billing, budgeting, bid settings & campaign performance metrics |
| country_code | string | Countries associated with the account |
| purchase_order_id | string | |
| customer_order_id | string | |
| complete_name | string | |
| first_name | string | |
| middle_name | string | |
| last_name | string | |
| general_suffix | string | |
| maturity_suffix | string | |
| title_of_respect | string | |
| empty | string | |
| phone_id | string | |
| phone_area_code | string | |
| phone_extension | string | |
| phone_complete_number | string | |
| phone_type | string | |
| phone_subscriber_number | string | |
| phone_country_code | string | |
| phonevalidity_validation_type | string | |
| phonevalidity_validation_status | string | |
| phonevalidity_validated_date | timestamp | |
| phonevalidity_validated_by | string | |
| download_date | timestamp | |
| seller_id | integer |
| Column Name | Data Type | Description |
|---|---|---|
| account_id | integer | Intentwise account id |
| account_name | string | Intentwise account name |
| currency_code | string | One single currency for billing, budgeting, bid settings & campaign performance metrics |
| country_code | string | Countries associated with the account |
| purchase_order_id | string | |
| customer_order_id | string | |
| sub_total_type | string | |
| currency | string | |
| subtotal_amount | integer | |
| download_date | timestamp | |
| seller_id | integer |
| Column Name | Data Type | Description |
|---|---|---|
| account_id | Integer | Intentwise account id |
| account_name | String | Intentwise account name |
| currency_code | String | One single currency for billing, budgeting, bid settings & campaign performance metrics |
| country_code | String | Countries associated with the account |
| date | Date | Report Date |
| advertiser_id | String | Advertiser ID |
| campaign_id | String | Campaign ID |
| ad_group_id | String | Adgroup ID |
| item_id | String | Item ID |
| keyword_id | String | Keyword ID |
| bidded_keyword | String | |
| match_type | String | |
| searched_keyword | String | |
| ad_spend | Integer | |
| num_ads_shown | Integer | |
| num_ads_clicks | Integer | |
| click_revenue_3_days | Integer | |
| click_revenue_14_days | Integer | |
| click_revenue_30_days | Integer | |
| unit_sold_3_days | Integer | |
| unit_sold_14_days | Integer | |
| unit_sold_30_days | Integer | |
| view_revenue_3_days | Integer | |
| view_revenue_14_days | Integer | |
| view_revenue_30_days | Integer | |
| brand_click_revenue_3_days | Integer | |
| brand_click_revenue_14_days | Integer | |
| brand_click_revenue_30_days | Integer | |
| brand_view_revenue_3_days | Integer | |
| brand_view_revenue_14_days | Integer | |
| brand_view_revenue_30_days | Integer | |
| related_click_revenue_3_days | Integer | |
| related_click_revenue_14_days | Integer | |
| related_click_revenue_30_days | Integer | |
| download_date | Date | Download Date |
| Column Name | Data type | Description |
|---|---|---|
| account_id | Integer | Intentwise account id |
| account_name | String | Intentwise account name |
| currency_code | String | One single currency for billing, budgeting, bid settings & campaign performance metrics |
| country_code | String | Countries associated with the account |
| keyword_id | String | Unique Identifier for Keyword |
| keyword_status | String | Keyword Status |
| search_keyword | String | Keyword for which search results are captured |
| product_id | String | Unique Identifier for Product |
| listing_position | Integer | Position in the search results |
| organic_rank | Integer | Organic Rank of search results |
| page_number | Integer | Page number of search results |
| ad_rank | Integer | Ad Rank of search results |
| title | String | Title of the ASIN |
| price | Numeric | Price |
| actual_price | Numeric | Actual Price |
| sale_price | Numeric | Sale Price |
| saved_price | Numeric | Saved Price |
| rating | Numeric | Star rating |
| review_count | Integer | Review Count |
| ad_type | String | Ex: Sponsored |
| wm_plus | Boolean | Walmart Plus Eligibility |
| pickup | String | Pickup Time Estimate |
| delivery_by | String | Delivery Time Estimate |
| shipping | String | Shipping Time Estimate |
| url | String | URL of the Product |
| image_url | String | URL of the Image |
| badges | String | Ex: Best Seller, Popular pick, Clearance |
| about_item | String | Description of the Item |
| return_details | String | Return Details |
| gift_eligible | Boolean | Gift Eligibility |
| brand_name | String | Brand Name |
| number_of_images | Integer | Number of Images |
| requested_timestamp | Timestamp | Time at which results were captured |
| download_timestamp | Timestamp | Download Time |
| Column Name | Data type | Description |
|---|---|---|
| account_id | bigint | Intentwise account id |
| account_name | varchar | Intentwise account name |
| currency_code | varchar | One single currency for billing, budgeting, bid settings & campaign performance metrics |
| country_code | varchar | Countries associated with the account |
| report_date | date | Snapshot Date of the Report |
| advertiser_id | integer | Advertiser id |
| availability_status | varchar | Indicates whether item can be added to cart |
| average_rating | numeric | This is the average rating this item has received from customers on Walmart.com |
| base_item_id | varchar | Base item ID for Catalog Item ID |
| base_variant_identifier | varchar | Indicates whether item is set up as base or variant |
| brand_name | varchar | Brand associated with item |
| buybox_winner_price | numeric | The item price of the winning Buy Box listing for this item at the time the report was generated |
| catalog_item_id | varchar | Unique item identifier |
| catalog_item_name | varchar | Item name |
| category | varchar | The navigation path a customer would follow to find the item on Walmart.com by browsing |
| gtin | varchar | Global Trade Item Number |
| inventory_count | integer | Total number of items available to sell to customers |
| item_creation_date | date | The date the item was created on Walmart.com |
| item_image_url | varchar | URL for the item’s main image |
| item_last_updated_date | date | The date the item was most recently updated on Walmart.com |
| item_page_url | varchar | URL for item page on Walmart.com |
| page_view_based_availability_rate | numeric | Percentage (%) of page views where items are available for transactions |
| page_view_based_buybox_win_rate | numeric | Percentage (%) of page views where the buy box is won |
| price | numeric | The price that is currently being charged for this item. This is the amount the Walmart customer sees |
| published_status | varchar | Indicates that the item is published and currently live (active) on Walmart.com |
| replenishment_status | varchar | A flag to provide info on continuous inventory flow for the Walmart Supplier |
| review_count | integer | Total count of customer reviews for the item |
| upc | varchar | Universal Product Code |
| walmart_item_number | varchar | Item number from the primary vendor |
| walmart_product_id | varchar | Walmart’s unique identifier for the item. This is used internally to track items |
| download_date | date | Download Date |