Bing Ads provides a desktop tool to manage campaigns offline, called Microsoft Ads Editor. Using this editor you can make offline changes to your campaigns and later sync it online. Bing Ads also provides APIs that can be used to manage advertising campaigns.
This sync can be used to upload audience data from a user specified data warehouse to the Bing Ads platform.
Amazon Redshift to Bing Ads
1. Setup a Data Warehouse - Go to Data Warehouses Tab and add a Redshift Warehouse.
2. Setup a Data Model - Navigate to Data Models tab and click on Create New. Name your Data Model and select your data warehouse from the drop down. Write a SQL query to fetch data from your warehouse.
(Eg. Select * from Schema_Name.Table_Name)
*A simple “select” statement will work, although you can write complex SQL queries in the data model field itself or use our no-code segment builder to filter your data without writing complex SQL Queries.
*You can fetch data directly from any table / view existing in your warehouse if you don’t want to set up a data model. In that case you can skip this step and directly move to configuring your destination.
3. Configure your Data Destination - Navigate to Reverse ETL tab, click on "All Destinations" and select Bing Ads.
%20(1)%20(1).svg)
