Sponsored Ads

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

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

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

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