Facebook Marketing: expand time_increment config, add date_preset config

[darian-heede]

Tell us about the problem you're trying to solve

When fetching reach data, we oftentimes want monthly aggregations (calendar month) or even lifetime aggregations over campaigns or ads for example. With the current implementation of time_increment this is not possible. The insights API does allow for such specifications though, using the date_preset and time_increment parameters.

• To fetch lifetime data we would set date_preset = maximum and time_increment = all_days
• To fetch monthly data we would set date_preset = maximum and time_increment = monthly

The time_increment configuration currently only allows for values [1,89] in days and defaults to 1.

Describe the solution you’d like

Add options all_days and monthly to time_increment and allow for the configuration of date_preset.

Describe the alternative you’ve considered or used

Using another source for Facebook reach data.

Are you willing to submit a PR?

No.

[alafanechere]

Thank you for the suggestion @darian-heede . I triaged the issue to make sure it eventually reaches our team backlog.

[misteryeo]

Issue was linked to Harvestr Discovery: Source Facebook Marketing: Add options all_days and monthly to time_increment and allow for the configuration of date_preset

[darian-heede]

Hey @alafanechere, do you have an update when this feature will be available?

[misteryeo]

Hi @darian-heede - we haven't made any plans to implement this feature so far so no updates here. We will continue to monitor upvotes for this feature but you're also welcome to make a PR to implement this!

[sh4sh]

@YowanR same here, it looks like @scottleechua needs to leave a comment here before we can assign

[scottleechua]

Adding a comment!

[YowanR]

Great, this was finally assigned to you @scottleechua ! :D

[scottleechua]

Hi, this is on my radar! Just currently blocked on this as Meta temporarily disabled sandbox ad accounts about two weeks ago. Am staying on top of this.

[YowanR]

Any updates here, @scottleechua ?

[scottleechua]

@YowanR still blocked on this without access to a sandbox ad account. 😢

[octavia-squidington-iii]

At Airbyte, we seek to be clear about the project priorities and roadmap. This issue has not had any activity for 180 days, suggesting that it's not as critical as others. It's possible it has already been fixed. It is being marked as stale and will be closed in 20 days if there is no activity. To keep it open, please comment to let us know why it is important to you and if it is still reproducible on recent versions of Airbyte.

[andrii-porokhnavets]

I am interested in this feature, especially for the monthly option. I am also ready to contribute. @octavia-squidington-iii could you please highlight places that should be updated to support monthly time increment option?