@kapa.ai I don’t see any data in the

video_avg_time_watched_actions

fields on the Facebook Marketing source version 3.4.8 that has a breakdown on

hourly_stats_aggregated_by_advertiser_time_zone

. There should be data as per the AdsManager UI. Can you tell me why is that ?

The knowledge sources you provided don’t explicitly mention

video_avg_time_watched_actions

being missing when using the

hourly_stats_aggregated_by_advertiser_time_zone

breakdown, so I can’t give a definitive root cause specific to that field. What we do know from the docs and issues: • The Facebook Marketing custom insights config supports

hourly_stats_aggregated_by_advertiser_time_zone

as a valid breakdown, and

video_avg_time_watched_actions

is listed as a valid field in the connector’s schema for custom insights. [FB custom config] • There are several known problems and inconsistencies in the Facebook Marketing source around custom insights, breakdowns, and which fields actually appear in the output vs. the schema (for example, SKAN-related fields and

total_postbacks

being present in the raw

_airbyte_data

but not exposed properly). [SKAN breakdown issue] • Other breakdown-related issues show that some combinations of breakdowns and fields that are valid in the Meta API can behave incorrectly or fail in the Airbyte connector (e.g., SKAN breakdowns,

product_id

breakdown, and action breakdown defaults). [SKAN breakdown issue; product_id breakdown issue] Given this, the most likely explanations (based only on the available information) are: 1. Connector bug or schema mismatch for this field under hourly breakdowns – similar to the SKAN /

total_postbacks

behavior, where the field is supported by the API but not correctly surfaced by the connector. [SKAN breakdown issue] 2. Interaction between breakdowns and fields – some field/breakdown combinations that work in Ads Manager or direct API calls don’t behave correctly in the Airbyte connector’s custom insights implementation, as seen with other breakdowns. [SKAN breakdown issue; product_id breakdown issue] Because there is no explicit mention of

video_avg_time_watched_actions

+

hourly_stats_aggregated_by_advertiser_time_zone

in the knowledge sources, I can’t confirm exactly why you see data in Ads Manager but not via Airbyte 3.4.8. The safest conclusion from the available information is that you are likely hitting a connector limitation/bug in the custom insights implementation for that combination. If you need a definitive answer or fix, the next steps (outside what’s in the docs) would be: • Compare a direct Graph API insights call (with the same fields and breakdown) to the connector’s raw

_airbyte_data

to see if the field is present but not mapped, similar to the

total_postbacks

case. [SKAN breakdown issue] • Open or reference a GitHub issue against

source-facebook-marketing

describing this exact combination, since similar breakdown/field issues have been tracked and fixed via GitHub in the past. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.