How to Transfer Daily Facebook Ads Data Using AWS AppFlow

It is possible to transfer records for a specific time range when using Facebook Ads connector for Amazon AppFlow.

Option-1: Flow trigger = Run on demand

This can be accomplished by using "Filters" in the Flow configuration.

Amazon AppFlow enables you to filter data fields by adding multiple filters and by adding criteria to a filter. Amazon AppFlow will transfer only records that meet the filter criteria.

Option-2: Flow trigger = Run flow on schedule

Amazon AppFlow runs schedule-triggered flows based on the schedule that you specify during flow setup.

When using schedule-triggered flow you can select incremental transfer, Amazon AppFlow transfers only the records that have been added or changed since the last successful flow run. You can also select a source timestamp field to specify how Amazon AppFlow identifies new or changed records. For example, if you have a Created Date timestamp field, choose this to instruct Amazon AppFlow to transfer only newly-created records (and not changed records) since the last successful flow run. The first schedule-triggered flow will pull 30 days of past records at the time of the first flow run.

Optionally, you can add a time offset (t) to the time range for the incremental transfer. The flow run will import records that were created or changed between the previous flow run and the specified offset prior to the current flow run.

https://docs.aws.amazon.com/appflow/latest/userguide/flow-triggers.html#flow-triggers-schedule

Use time_range, but it can't segregate by day. If you pick Oct 1st to Oct 2nd, it will produce data for Sep 30th to Oct 1st. There is a chance that timezone plays a role in this. I don't know.