Question

You need to understand the daily lookback window defined for Microsoft Advertising (formerly known as Bing Ads) connector.

Environment

Connector: Microsoft Advertising

Answer

Once a day around 3 am, Fivetran will have a 29 day look back window. For every other incremental sync we will have a 3 day look back window.

Note: the 3 am timezone is based off the timezone settings on the Fivetran destination dashboard page.