@kapa.ai can I set up a facebook marketing connector that allows ads_insights to be broken down by hour instead of date? Time increment minimum value is 1 and it corresponds to a 1-day increment.

Based on the available knowledge sources, hourly breakdowns are not supported by the Airbyte Facebook Marketing connector's

ads_insights

streams. The connector's

time_increment

field has a minimum value of 1 (day) and a maximum of 89 (days), meaning the finest granularity available is daily. [InsightConfig spec] The supported options for time-based aggregation are: • Integer values (1–89): N-day rolling windows (e.g.,

time_increment=1

for daily) •

time_increment_period: daily

— equivalent to

time_increment=1

•

time_increment_period: weekly

— Monday-aligned calendar weeks •

time_increment_period: monthly

— calendar month boundaries (passes

"monthly"

to the Facebook API) There is no hourly option available in the connector configuration. The knowledge sources do not mention any support for sub-daily (hourly) breakdowns in the Airbyte Facebook Marketing connector, even though the Facebook Marketing API itself does offer hourly breakdown options (e.g.,

hourly_stats_aggregated_by_advertiser_time_zone

) as a breakdown dimension — not as a

time_increment

value. If you need hourly data, you would need to check whether the Facebook API's hourly breakdown can be added as a custom

breakdown

field in a Custom Insight stream, but the knowledge sources do not confirm this is currently supported or tested in the connector. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

I have added hourly_stats_aggregated_by_advertiser_time_zone as a breakdown dimension. I what premade table will that show? Do I need to refresh the data to make it appear? @kapa.ai

When you add

hourly_stats_aggregated_by_advertiser_time_zone

as a breakdown dimension in a Custom Insight stream, the data will appear in a custom stream named according to the

name

you gave that custom insight configuration (prefixed with

Custom

internally). It does not appear in any pre-built/default table — it is only available through the custom insights stream you configured. [source.py] Regarding whether you need to refresh data: the knowledge sources do not explicitly address this specific scenario. However, based on general Airbyte guidance for schema changes, if you've added a new breakdown dimension to an existing custom insight stream, you should: 1. Go to Connections → select the affected connection. 2. Go to the Schema tab → click Refresh source schema → click OK. 3. Review any detected schema changes and Save changes. 4. Ensure the Clear affected streams option is checked, then save the connection to trigger a fresh sync. [Facebook Marketing Migration Guide] This is especially important because adding a breakdown changes the stream's schema (the breakdown field is added to the schema properties) and also affects the primary key (breakdown fields are included in the primary key). [base_insight_streams.py] 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.