Bing Ads walkthrough

info

Bing Ads API version 13 is currently supported.

This integration enables businesses to streamline the process of collecting, managing, and analyzing Bing Ads data alongside other marketing and business data sources. It provides a comprehensive view of advertising performance, audience insights, and campaign effectiveness.

Connection

To connect Bing Ads with your destination, follow our step-by-step tutorial. Choose a Source Connection after creating a connection.

Predefined reports

Data Integration provides an entry point and recommended approach to access a range of predefined reports. Each report includes a concise data description, a list of customizable fields (if applicable), and the schema mapping.

Since these reports follow a standardized format, specific fields are restricted and can be accessed only through Custom Reports.

Custom reports

Select a specific report to pull data from the "Klaviyo API v2024-02-15 API".

Pull data from Bing in Data Integration

Bing data is organized in reports. Data Integration Bing Ads data integration (ETL) tool lets you select a report and choose the list of columns that will compose the chosen report.

Select the Bing connection or create a new connection according to the instructions above. Click Test Connection to make sure the connection is valid.
Select the report to pull.

Available reports

Columns: Select the report from the list of reports. Click the input to show a list of all available fields in the report.

Accounts: Click to get the list of all available accounts in the Bing connection. Select any account to pull its data for the selected report.

Leave this input empty to pull the results for all the available accounts.

Time period: Select the type of time period of the report. It can be a custom date range or a defined time period (For example, Yesterday, last week)

(Instructions if selecting Date range:)

Select the start date and end date.
Leave the end date empty to pull data until the moment the river runs.
After each run of the river, the start date will be updated automatically with the end date, and the end date will be updated with the empty value. This enables the next run to pull data from the end of the previous run.
Select the time zone offset. It is relevant only if the end date is empty to find the moment of the river’s run according to the time zone.
Days back: Use that input to tell Data Integration to pull data from the given days before the given start date.

note

The Start Date will not be advanced if a River run is unsuccessful. If you do not want this default setting, click More Options and select the checkbox to advance the start date even if the River run is unsuccessful (Not recommended).

Select the timezone offset to send the correct dates that consider that offset.

Data aggregation: Select the report's time aggregation. The report contains results according to the selected aggregation. For example, selecting daily aggregation will store each record in the result as a day of data, while selecting weekly aggregation will store each record as a week.

Reporting data is available for specified periods of time. The Hourly, Daily, Weekly, Monthly, Yearly, and Summary values are in months and are listed here.
Not all column combinations are allowed. To learn more about column restrictions, refer to the column restrictions topic.

Bing Ads kits

Kits are pre-built data models to help data teams immediately create the right data pipelines to tackle common challenges and scenarios.

These readily available pieces of code can be changed or customized to fit your company's data needs. They are the best starting point to leverage existing data models that are proven effective in their specific use cases.

Here is the list of available Bing Ads Kits: