Sponsored Ads
Historical Availability
Historical availability of data refers to the pulling in of past data from Walmart Sponsored Ads in Intentwise Analytics. This refers to your data for the time period before you added a particular account as a data source under My Connections.
Report Type | Historical Availability |
---|---|
All Sponsored Ads reports | 90 days |
Account
Table Name: ad_account
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 |
budget_id | Integer | Budget id |
advertiser_id | Integer | Advertiser id |
budget | Integer | Budget |
budget_date | Date | Budget date |
Account Budget
Table Name: account_budget
Column Name | Data type | Description |
---|---|---|
platform_multiplier_id | Integer | Platform multiplier id |
campaign_id | Integer | Campaign id |
platform_type | String | Platform type |
multiplier | Numeric | Multiplier |
Adgroup
Table Name: ad_adgroup
Column Name | Data type | Description |
---|---|---|
account_id | Integer | Intentwise account id |
account_name | String | Intentwise account name |
currency_code | String | One single currency for all adgroup settings |
country_code | String | Countries associated with the account |
advertiser_id | Integer | Advertiser id |
ad_group_id | Integer | Ad group id |
campaign_id | Integer | Campaign id |
name | String | Name of the ad group |
status | String | Status of the ad group |
created_on | Timestamp | Created date and time of the ad group |
updated_on | Timestamp | Updated date and time of the ad group |
version | Integer | Version of the ad group |
Adgroup Report
Table name: ad_adgroup_report
Column Name | Data type | Description |
---|---|---|
account_id | Integer | Intentwise account id |
account_name | String | Intentwise account name |
currency_code | String | One single currency (code) for adgroup settings |
country_code | String | Countries associated with the account |
date | Date | Date for Adgroup |
campaign_id | Integer | Campaign id |
advertiser_id | Integer | Advertiser id |
ad_group_id | Integer | Ad group id |
ad_group | String | Ad group name |
ad_spend | Numeric | Amount spend for Adgroup |
num_ads_shown | Integer | Number of Ad's shown |
num_ads_clicks | Integer | Number of Ad clicks |
click_revenue_3_days | Numeric | Ad click revenue for 3 days |
click_revenue_14_days | Numeric | Ad click revenue for 14 days |
click_revenue_30_days | Numeric | Ad click revenue for 30 days |
units_sold_3_days | Numeric | Units sold for 3 days |
units_sold_14_days | Numeric | Units sold for 14 days |
units_sold_30_days | Numeric | Units sold for 30 days |
view_revenue_3_days | Numeric | View revenue for 3 days |
view_revenue_30_days | Numeric | View revenue for 30 days |
view_revenue_14_days | Numeric | View revenue for 14 days |
brand_click_revenue_3_days | Numeric | Brand click revenue for 3 days |
brand_click_revenue_14_days | Numeric | Brand click revenue for 14 days |
brand_click_revenue_30_days | Numeric | Brand click revenue for 30 days |
brand_view_revenue_3_days | Numeric | Brand view revenue for 3 days |
brand_view_revenue_14_days | Numeric | Brand view revenue for 14 days |
brand_view_revenue_30_days | Numeric | Brand view revenue for 30 days |
related_click_revenue_3_days | Numeric | Related ad click revenue for 3 days |
related_click_revenue_14_days | Numeric | Related ad click revenue for 14 days |
related_click_revenue_30_days | Numeric | Related click revenue for 30 days |
offline_click_revenue_3_days | Numeric | Offline click revenue for 3 days |
offline_click_revenue_14_days | Numeric | Offline click revenue for 14 days |
offline_click_revenue_30_days | Numeric | Offline click revenue for 30 days |
offline_view_revenue_3_days | Numeric | Offline view revenue for 3 days |
offline_view_revenue_14_days | Numeric | Offline view revenue for 14 days |
offline_view_revenue_30_days | Numeric | Offline view revenue for 30 days |
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 | The 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_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 |
Campaign
Table name: ad_campaign
Column Name | Data type | Description |
---|---|---|
account_id | Integer | Intentwise account id |
account_name | String | Intentwise account name |
currency_code | String | One single currency code for all campaign related settings |
country_code | String | Countries associated with the account |
advertiser_id | Integer | Advertiser id |
campaign_id | Integer | Campaign id |
name | String | Name of the campaign |
status | String | Status of the campaign |
campaign_type | String | Campaign type |
targeting_type | String | Targeting type |
budget_type | String | Budget type |
start_date | Date | Start date for the ad campaign |
end_date | Date | End date for the ad campaign |
total_budget | Numeric | Total budget for the campaign |
daily_budget | Numeric | Daily budget for the campaign |
rollover | Boolean | Rollover of the campaign |
channel | String | Channel of the campaign |
created_on | Timestamp | Created on date and time |
updated_on | Timestamp | Updated on date and time |
version | Integer | Version of the campaign |
is_search_ingrid | Boolean | Is_Search ingrid |
is_search_carousel | Boolean | Is_Search carousel |
is_item_buy_box | Boolean | Is_Item_Buy box |
is_item_carousel | Boolean | Is_Item carousel |
Campaign Placement Bid Multiplier
Table name: ad_campaign_placement_bid_multiplier
Column Name | Data type | Description |
---|---|---|
account_id | Integer | Intentwise account id |
account_name | String | Intentwise account name |
campaign_id | Integer | Campaign id |
country_code | String | Countries associated with the account |
currency_code | String | One single currency for campaign placement bid |
multiplier | Numeric | Multiplier |
placement_multiplier_id | Integer | Placement multiplier id |
placement_type | String | Placement type |
Campaign Platform Bid Multiplier
Table name: ad_campaign_platform_bid_multiplier
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 |
platform_multiplier_id | Integer | Platform multiplier id |
campaign_id | Integer | Campaign id |
platform_type | String | Platform type |
multiplier | Numeric | Platform bid multiplier |
Item
Table name: ad_item
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 |
advertiser_id | Integer | Advertiser id |
ad_group_id | Integer | Adgroup id |
campaign_id | Integer | Campaign id |
item_id | String | Item id |
ad_item_id | Integer | Ad_Item id |
bid | Numeric | Bid |
status | String | Status |
item_image_url | String | URL of item image |
review_status | String | Review status |
review_reason | String | Review reason |
item_page_url | String | URL of item page |
created_on | Timestamp | Created on |
updated_on | Timestamp | Updated on |
version | Integer | Version |
Item Master
Table name: ad_item_master
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 |
advertiser_id | Integer | Advertiser id |
item_id | String | Item id |
item_name | String | Item name |
item_image_url | String | URL of item image |
item_page_url | String | URL of item page |
suggested_bid | Numeric | Suggested bid |
Item Report
Table name: ad_item_report
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 |
report_date | Date | Report date |
advertiser_id | Integer | Advertiser id |
campaign_id | Integer | Campaign id |
ad_group_id | Integer | Ad_Group_Id of the ad item |
item_id | String | Item id |
name | String | Name of the ad item |
image | String | Image of the ad item |
ad_spend | Numeric | Amount spend for ad |
num_ads_shown | Integer | Number of ad's shown for the ad item |
num_ads_clicks | Integer | Number of ad clicks done for the item |
click_revenue_3_days | Numeric | Click revenue for 3 days |
click_revenue_14_days | Numeric | Click revenue for 14 days |
click_revenue_30_days | Numeric | Click revenue for 30 days |
units_sold_3_days | Numeric | Units sold for 3 days |
units_sold_14_days | Numeric | Units sold for 14 days |
units_sold_30_days | Numeric | Units sold for 30 days |
view_revenue_3_days | Numeric | View revenue for 3 days |
view_revenue_14_days | Numeric | View revenue for 14 days |
view_revenue_30_days | Numeric | View revenue for 30 days |
brand_click_revenue_3_days | Numeric | Brand click revenue for 3 days |
brand_click_revenue_14_days | Numeric | Brand click revenue for 14 days |
brand_click_revenue_30_days | Numeric | Brand click revenue for 30 days |
brand_view_revenue_3_days | Numeric | Brand view revenue for 3 days |
brand_view_revenue_14_days | Numeric | Brand view revenue for 14 days |
brand_view_revenue_30_days | Numeric | Brand view revenue for 30 days |
related_click_revenue_3_days | Numeric | Related ad click revenue for 3 days |
related_click_revenue_14_days | Numeric | Related ad click revenue for 14 days |
related_click_revenue_30_days | Numeric | Related ad click revenue for 30 days |
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 | The 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 |
Keyword
Table name: ad_keyword
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 |
advertiser_id | Integer | Advertiser id |
ad_group_id | Integer | Adgroup id |
campaign_id | Integer | Campaign id |
keyword_id | Integer | Keyword id |
state | String | State |
keyword_text | String | Text for ad keyword |
keyword_category | String | Category of ad keyword |
status | String | Status |
match_type | String | Match type |
bid | Numeric | Bid |
created_on | Timestamp | Created on |
updated_on | Timestamp | Updated on |
version | Integer | Version |
Keyword Report
Table name: ad_keyword_report
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 | Date |
advertiser_id | Integer | Advertiser_Id |
campaign_id | Integer | Campaign_Id |
ad_group_id | Integer | Adgroup_Id |
keyword_id | Integer | Keyword Id |
bidded_keywords | String | Bidded keywords |
match_type | String | Match type |
searched_keyword | String | Searched keyword |
ad_spend | Numeric | Amount spent for ad |
num_ads_shown | Integer | Number of ad's shwon |
num_ads_clicks | Integer | Number of ad clicks done |
click_revenue_3_days | Numeric | Ad click revenue for 3 days |
click_revenue_14_days | Numeric | Ad click revenue for 14 days |
click_revenue_30_days | Numeric | Ad click revenue for 30 days |
units_sold_3_days | Numeric | Units sold for 3 days |
units_sold_14_days | Numeric | Units sold for 14 days |
units_sold_30_days | Numeric | Units sold for 30 days |
view_revenue_3_days | Numeric | View revenue for 3 days |
view_revenue_14_days | Numeric | View revenue for 14 days |
view_revenue_30_days | Numeric | View revenue for 30 days |
brand_click_revenue_3_days | Numeric | Brand click revenue for 3 days |
brand_click_revenue_14_days | Numeric | Brand click revenue for 14 days |
brand_click_revenue_30_days | Numeric | Brand click revenue for 30 days |
brand_view_revenue_3_days | Numeric | Brand view revenue for 3 days |
brand_view_revenue_14_days | Numeric | Brand view revenue for 14 days |
brand_view_revenue_30_days | Numeric | Brand view revenue for 30 days |
related_click_revenue_3_days | Numeric | Related click revenue for 3 days |
related_click_revenue_14_days | Numeric | Related click revenue for 14 days |
related_click_revenue_30_days | Numeric | Related click revenue for 30 days |
offline_click_revenue_3_days | Numeric | Offline click revenue for 3 days |
offline_click_revenue_14_days | Numeric | Offline click revenue for 14 days |
offline_click_revenue_30_days | Numeric | Offline click revenue for 30 days |
offline_view_revenue_3_days | Numeric | Offline view revenue for 3 days |
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. |
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 |
ntb_orders_30_days | Integer | The number of first-time orders for products within the brand, over a one year look back window attributed over 30 days |
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. |
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 |
Placement Report
Table name: ad_placement_report
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 |
Platform Report
Table name: ad_platform_report
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 |
MarketPlace Order LineItem
Table name: marketplace_orderlineitem
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 |
MarketPlace Order LineItemCharge
Table name: marketplace_orderlineitemcharge
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 |
MarketPlace Order LineItemRefundCharge
Table name: marketplace_orderlineitemrefundcharge
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 |
MarketPlace Order LineItemStatus
Table name: marketplace_orderlineitemstatus
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 |
MarketPlace Order PickupPerson
Table name: marketplace_orderpickupperson
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 |
MarketPlace Order SubTotal
Table name: marketplace_ordersubtotal
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 |
Ad Searchterm Report
Table name: ad_search_term_report
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 |
Last updated