Bing Ads Walkthrough

Bing Ads API version 13 is currently supported

This provides a general description of Bing Ads and its capabilities.

Pull data from Bing in Rivery

Bing data is organized in reports. Rivery's Bing Ads data integration (ETL) tool allows users to select a report and then select the list of columns that will compose the chosen report.

1. Select the Bing connection or create a new connection according to the instructions above. Click on “Test connection” in order to make sure the connection is valid.
2. Report - Select which report to pull:



3. Columns* - Select the report in the list of reports. Click on the input in order to show a list of all available fields in the report.



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

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



5. Time period

Select the type of time period of the report. It can be a custom date range (as described in the picture above) or a defined time period shown in the pop up list (for example: Yesterday, last week etc.)

Instructions if selecting ‘Date Range’:

1. Select the start date and end date.
2. Leave the end date empty in order to pull data until the moment the river runs.
3. 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.
4. Select the time zone offset. It will be relevant only if the end date is empty in order to find the moment of the river’s run according to the time zone.
5. Days back - use that input in order to tell Rivery to pull data from the given days back before the given start date.

   Please Note:
   The Start Date won't be advanced if a River run is unsuccessful.
   If you don't want this default setting, click More Options and check the box to advance the start date even if the River run is unsuccessful (Not recommended).
   

Instructions if selecting any other value:



1. Select the timezone offset in order to send the correct dates that consider that offset.
2. Data aggregation -  select the time aggregation of the report. The report will contain results according to the selected aggregation. For example, selecting daily aggregation will have each record in the result store a day of data, while selecting weekly aggregation will have each record store a week

• Reporting data is kept for specified periods of time. The Hourly, Daily, Weekly, Monthly, Yearly and Summary values are in months and are listed here .
• Not all columns combinations are allowed. Please check the link below for more information on  columns restrictions:  columns restrictions

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 ready-made pieces of code can be changed or customized to fit your company’s data needs, but they are the best starting point to leverage existing data models that are proven to be effective in their specific use cases.

Here is the list of available Bing Ads Kits:

• Bing Ads - BigQuery
• Bing Ads - Snowflake