Hello, I'm have a question regarding the Conversion Window for the GoogleAds source. From my understanding, this would fetch duplicate data when using the Incremental Append sync. Is there a column value we can use to query only the latest data? For example, Stitch provides a specific column to allow this -

_sdc_report_datetime

(https://www.stitchdata.com/docs/integrations/saas/google-ads#query-for-the-latest-data) Is this something we would have to do with a custom transformation? I noticed only the

_airbyte_emitted_at

column, but this is record specific, not batch specific.

Hey, Ross conversion window is in place to pull the last x days as they would have got updated. You can use Incremental dedup in the stream setting with correct primary keys you will have all duplicate merged into 1 and with latest data.