Why Is the First Sync of the Day Longer Than Other Syncs?

Question

Why is the first sync of the day longer than other incremental syncs for the Google Campaign Manager 360 connector?

Answer

The first sync of the day is a rollback sync for dates within the rollback window, which is hard coded for the Google Campaign Manager 360 connector to be 15 days.

According to Google's Documentation, Google Campaign Manager 360 continues to add data within seven days to ensure that data is included in reports as accurately as possible.

As a result, Fivetran requests a report for the last 15 days during each first sync in a day. The following syncs request a report only for the current day.