Try our plataform
Microsoft Advertising (Bing)

Creating the data source

Requirements

  • A work or school account linked to the Microsoft Advertising account must be used to authenticate the connector

Instructions

  1. Log in to Kondado, click the 'CREATE +' button, then select 'Source' > ‘Microsoft Advertising’
  2. Click the 'Sign in with Microsoft' button
  3. Click Accept in the next page
    1. You must use a work or school account - personal accounts are not suported
  4. Back in Kondado, click the Save button

View the reference for reports, metrics and dimensions

Pipelines

Summary

Relationship chart

Click to expand

Custom report

To build a Microsoft Ads Custom Report pipeline, the following parameters are available:

  1. Accounts: Include one or multiple advertising accounts in the pipeline. If left blank, all ad accounts linked to your data source will be used. All pipelines include the following fields by default:
    1. _kdd_account_id: The account ID that represents the unique identifier of the account within the system
    2. _kdd_account_name: The name of the account as it is registered or displayed within the system.
  2. Report: Select a report to base your pipeline on. More details about available reports can be found in our reference
  3. Time Aggregation: Defines the date aggregation of the report. A metric_date field is automatically added, depending on the selected aggregation. Note that not all reports, metrics, and dimensions support every aggregation type:
    1. Daily: Uses the actual date. Sets replication type to incremental.
    2. Weekly: Uses the Sunday of the given week. Sets replication type to incremental.
    3. Monthly: Uses the first day of the month. Sets replication type to incremental.
    4. Hourly: Uses the actual date, adding a timeperiod column representing a timestamp with metric_date plus hour or plus hour and minute, depending on the report. Sets replication type to incremental.
    5. Summary: No date column is added; data represents the lifetime. Sets replication type to integral.
    6. Default: No date column is added; data represents the lifetime. Sets replication type to integral.
  4. Savepoint: Required for incremental replication. Defines the start date for data reading
  5. Update Window: Required for incremental replication. Defines how many days before the savepoint the data should be refreshed
  6. Dimensions: Specifies the report's dimensions. All available dimensions are listed in our reference. Note that not all dimensions, metrics, and time aggregations are compatible with one another. The user interface will adjust available options based on your selections.
  7. Metrics: Specifies the report's metrics. All available metrics are listed in our reference. Note that not all dimensions, metrics, and time aggregations are compatible with one another. The user interface will adjust available options based on your selections
Campo Tipo

_kdd_account_id

text

metric_date

date

dimension_z

text

metric_a

float

metric_b

float

metric_c

float

Notes

  1. Some metrics, dimensions and time aggregations cannot be combined, so during the process of creating the pipeline, the list of possible metrics and dimensions will constantly reload for a few seconds to reflect the possible selections
  2. The report might include results with “zero impressions”, depending on some criteria
  3. Data is reported in UTC timezone
  4. Incomplete data might be returned, that's why the update window is important
  5. The data retention period provided by the API may vary depending on the type of report and time aggregation. Generally, for the Hourly period, data is available for up to 6 months in the past, and for the other reports, data is available for 36 months. See more here