Hi Team,

We have set up Microsoft Bing Ads for one of our high-priority businesses and require access to reports via the API endpoints that the business has provided. Currently, they are extracting data from these endpoints on their end.

There are four key datasets we aim to build using the data from these API endpoints. Given the critical nature of this business, ensuring accuracy is essential.

We attempted to use the existing reports available through Fivetran; however, the data does not align with the tables the business has generated using the API. Due to the importance of this data, we’re open to scheduling a call to discuss the discrepancies and requirements in detail.

Please find below the API endpoint details along with the relevant tables and column mappings.

1).  https://learn.microsoft.com/en-us/advertising/bulk-service/downloadentity?view=bingads-13&source=recommendations

Table 1 & 2 are coming from the above API endpoint

TABLE 1 - CAMPAIGN_INFO_RAW
customer_id
account_id
account
account_timezone
campaign_id
campaign
base_campaign_id
campaign_status
serving_status
campaign_type
currency
budget
budget_id
budget_name
budget_type
bid_type
target_roas_actual
bid_strategy_id
bid_strategy

TABLE 2 -CAMPAIGN_SNAPSHOTstatus
campaign_id
parent_id
campaign
modified_time
tracking_template
custom_parameter
time_zone
budget
budget_type
bid_strategy_id
bid_strategy_name
bid_strategy_type
bid_strategy_maxcpc
bid_strategy_targetroas
campaign_type
priority
start_date
end_date
localinventoryadsenabled
language
target_setting
bid_adjustment
store_id
experiment_id
ad_schedule_use_searcher_time_zone

2) https://learn.microsoft.com/en-us/advertising/reporting-service/campaignperformancereportrequest?view=bingads-13&tabs=xml

Table 3 & 4 are coming from the above API endpoint

TABLE 3 - CAMPAIGN_BY_DEVICE_REPORTaccountname
accountnumber
accountid
timeperiod
campaignstatus
campaignname
campaignid
currencycode
impressions
clicks
ctr
averagecpc
spend
conversions
conversionrate
costperconversion
devicetype
qualityscore
expectedctr
adrelevance
landingpageexperience
historicalqualityscore
historicalexpectedctr
historicaladrelevance
historicallandingpageexperience
assists
revenue
returnonadspend
costperassist
revenueperconversion
revenueperassist
trackingtemplate
customparameters
accountstatus
campaignlabels
customerid
customername
clicksharepercent
impressionsharepercent
topimpressionsharepercent
topimpressionsharelosttorankpercent
finalurlsuffix
campaigntype
basecampaignid
allconversions
allrevenue
allconversionrate
allcostperconversion
allreturnonadspend
allrevenueperconversion
viewthroughconversions
impressionlosttobudgetpercent
impressionlosttorankaggpercent
impressionslosttobudget
impressionslosttorank

TABLE 4 - CAMPAIGN_DEVICE_CLICK_COST_RAWdate
account_id
campaign_id
base_campaign_id
device
impression_count
click_count
spend
impression_share
impression_share_top
impression_share_absolute_top
click_share
currency