Skip to content
OWOX Docs

How to Import Data from the Bing Ads Source

To begin importing data from Bing Ads, start by making a copy of one of the following templates:

Fill in the required information:

  • Start Date
  • Account ID
  • Customer ID
  • Fields
  • Aggregation
  • Report Timezone
  • Destination Dataset ID (for Google BigQuery template)
  • Destination Location (for Google BigQuery template)

The import will begin from the selected Start Date.

⚠️ Note: Using a long date range may cause the import to fail due to the high volume of data.

Bing Start Date

Log in to your Bing Ads account at https://ads.microsoft.com/.
Your Account ID and Customer ID can be found in the account URL.

Bing Add Account

Copy and paste both values into the template.

Account ID

Go to the Fields tab and check the boxes next to the fields you want to include.

Bing Fields

Select the Report Aggregation value.
Refer to the Microsoft Ads documentation to learn more.

Bing Aggregation

Choose the Report Time Zone to define the timezone for the reporting date range.

Bing Time Zone

If you’re using the Google BigQuery template, also provide:

  • Destination Dataset ID in the format: projectid.datasetid
  • Destination Location

ℹ️ If the specified dataset doesn’t exist, it will be created automatically.

Bing Dataset

Open the menu: OWOX → Manage Credentials

Bing Credentials

Enter your credentials obtained by following this guide: How to obtain the credentials for the Bing Ads source

Bing Token

Once your credentials are saved, go to: OWOX → Import New Data

Bing Import Data

The import process is complete when the Log sheet displays:
“Import is finished”

Bing Finished

Access Your Data:

  • In the Google Sheets template, the data will appear in new tabs labeled with the corresponding data types.

Bing Result

  • In the Google BigQuery template, the data will be written to the dataset specified earlier.

Bing Result

To import more data:

  1. Select the additional fields you need in the Fields tab.
  2. Go to OWOX → Import New Data again.

If you encounter any issues:

  1. Check the “Logs” sheet for specific error messages
  2. Please visit Q&A first
  3. If you want to report a bug, please open an issue
  4. Join the discussion forum to ask questions or propose improvements