Sponsored Ads

Account

Table Name: ad_account

Column NameData typeDescription

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 NameData typeDescription

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 NameData typeDescription

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 NameData typeDescription

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 NameData typeDescription

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 NameData typeDescription

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 NameData typeDescription

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 NameData typeDescription

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 NameData typeDescription

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 NameData typeDescription

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 NameData typeDescription

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 NameData typeDescription

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 NameDataTypeDescription

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 NameData TypeDescription

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 NameData TypeDescription

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 NameData TypeDescription

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 NameData TypeDescription

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 NameData TypeDescription

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 NameData TypeDescription

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