> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: Bing Ads Source

> Configure the Bing Ads source component to read Microsoft Advertising report data in your Integrate.io ETL pipeline. Supports campaign metrics.

## Connection Setup

## To create a Bing Ads connection In Integrate.io ETL

<Steps>
  <Step>
    Click the **Connections** icon (lightning bolt) on the top left menu.
  </Step>

  <Step>
    To create a connection, click **New connection.**

    <Frame>
      <img src="https://mintcdn.com/integrateio/XpeHmuMzUiEmfOEz/images/connectivity-and-security/image-136.webp?fit=max&auto=format&n=XpeHmuMzUiEmfOEz&q=85&s=80beaf45692f98f009a330cecb3c4cfd" alt="Connections page with New connection button" width="1200" height="829" data-path="images/connectivity-and-security/image-136.webp" />
    </Frame>
  </Step>

  <Step>
    Select Bing Ads.

    <Frame>
      <img src="https://mintcdn.com/integrateio/XpeHmuMzUiEmfOEz/images/connectivity-and-security/image-137.webp?fit=max&auto=format&n=XpeHmuMzUiEmfOEz&q=85&s=52639b50aafa6de519c742c349af65ad" alt="Selecting Bing Ads from the connection type list" width="1200" height="829" data-path="images/connectivity-and-security/image-137.webp" />
    </Frame>
  </Step>

  <Step>
    In the Bing network account window, sign in with your Bing account or click **Sign in with a different Microsoft account**.
  </Step>

  <Step>
    In the next Microsoft account page click **Yes** to let Integrate.io ETL access your information.
  </Step>

  <Step>
    In the new Bing Ads connection window, name the connection and click **Create bing ads connection.**

    <Frame>
      <img src="https://mintcdn.com/integrateio/XpeHmuMzUiEmfOEz/images/connectivity-and-security/image-138.webp?fit=max&auto=format&n=XpeHmuMzUiEmfOEz&q=85&s=1740ca476103545e7538412c2ec850cf" alt="Naming the Bing Ads connection" width="1200" height="829" data-path="images/connectivity-and-security/image-138.webp" />
    </Frame>

    <Frame>
      <img src="https://mintcdn.com/integrateio/XpeHmuMzUiEmfOEz/images/connectivity-and-security/image-139.webp?fit=max&auto=format&n=XpeHmuMzUiEmfOEz&q=85&s=3a19f1de09aca1dd355c48d2bac7364a" alt="Bing Ads connection created successfully" width="1200" height="829" data-path="images/connectivity-and-security/image-139.webp" />
    </Frame>

    <Frame>
      <img src="https://mintcdn.com/integrateio/XpeHmuMzUiEmfOEz/images/connectivity-and-security/image-140.webp?fit=max&auto=format&n=XpeHmuMzUiEmfOEz&q=85&s=fa2574798eb94fa400c6d3bb6362fe1d" alt="Bing Ads connection confirmation dialog" width="1200" height="829" data-path="images/connectivity-and-security/image-140.webp" />
    </Frame>
  </Step>
</Steps>

## To modify Bing Ads connections in Integrate.io ETL

<Steps>
  <Step>
    Click the Connections icon (lightning bolt) on the top left menu.
  </Step>

  <Step>
    Click a connection to open and modify it. Make any necessary changes, then click Reconnect, and Save changes. To exit the Bing Ads connection window without changes, click Back to connections (grey tab on the left side) on the Bing Ads connection window.
  </Step>

  <Step>
    To delete a Bing Ads connection, click on the three vertical dots on the far right of the connection listing and select the Delete connection option.

    <Frame>
      <img src="https://mintcdn.com/integrateio/XpeHmuMzUiEmfOEz/images/connectivity-and-security/image-141.webp?fit=max&auto=format&n=XpeHmuMzUiEmfOEz&q=85&s=4ff05f31c8c40fb38a9a5f7e5c580fb1" alt="Delete connection option for Bing Ads" width="1200" height="829" data-path="images/connectivity-and-security/image-141.webp" />
    </Frame>
  </Step>
</Steps>

***

<Frame>
  <img src="https://mintcdn.com/integrateio/2ttHYDu3EKov-VoY/images/creating-packages/using-components-bing-ads-source/image-1.png?fit=max&auto=format&n=2ttHYDu3EKov-VoY&q=85&s=5a815132bff3c6af36ea2016e53df270" alt="Bing Ads source component in the pipeline designer" width="1200" height="828" data-path="images/creating-packages/using-components-bing-ads-source/image-1.png" />
</Frame>

## Connection

Select an existing Bing Ads connection or create a new one.

## Source Properties

* **API Version** - Integrate.io ETL will use the selected Adwords API version when running the job. Microsoft releases a new API version every few months and sunsets older versions of the API. You should check and update the API versions periodically.
* **Report type** - Select a report type from the dropdown list of reports.
* **Unit of time** - Select date/time granularity for the report. Date and time fields will be added to the source schema depending on the selection.
* **Date range** - Select a date range from the dropdown list of ranges. If you select `custom date range...`, you will be prompted to enter From date and To date. Click on either inputs and select the dates from the calendar. You can also use variables as values for the custom date range in the format `yyyyMMdd`.
* **Accounts and campaigns** - Select accounts or specific campaigns to report on.

## Source Schema

After defining the Bing report, select the fields to use in the source.

<Note>
  **Note:**

  Some fields are not compatible with other fields in the same report.
</Note>