Skip to content

How to Import Data from the Microsoft Ads Source

Before you begin, please ensure that:

  • You have already obtained all required credentials, as described in CREDENTIALS.
  • You have set up OWOX Data Marts and created at least one storage in the Storages section.

Microsoft Ads Storage

  • Click New Data Mart.
  • Enter a title and select the Storage.
  • Click Create Data Mart.

Microsoft New Data Mart

  1. Select Connector as the input source type.
  2. Click Set up connector and choose Microsoft Ads.
  3. Fill in the required fields with the credentials you obtained in the CREDENTIALS guide.
    • Leave the other fields as default.
    • Proceed to the next step.

Microsoft Input Source

Microsoft Setup Connector

  1. Choose one of the available endpoints.
    • To import spend, clicks, and impressions from an ad account, select the Microsoft Ads Campaigns endpoint.
  2. Select the required fields.
  3. Specify the dataset where the data will be stored (or leave the default).
  4. Click Finish, then Save and Publish Data Mart.

Microsoft Publish Data Mart

You now have two options for importing data from Microsoft Ads:

Option 1: Import Current Day’s Data

Choose Manual run → Incremental load to load data for the current day.

Microsoft Manual Run

Microsoft Incremental Load

ℹ️ If you click Incremental load again after a successful initial load,
the connector will import: Current day’s data, plus Additional days, based on the value in the Reimport Lookback Window field.

Microsoft Reimport

Option 2: Manual Backfill for Specific Date Range

  • Choose Backfill (custom period) to load historical data.
  1. Select the Start Date and End Date.
  2. Click Run.

Microsoft Backfill

The process is complete when the Run history tab shows the message: “Success”

Microsoft Success

Once the run is complete, the data will be written to the dataset you specified earlier.

Microsoft Import Success

If you encounter any issues:

  1. Check the Run history 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