event column is always NULL in facebook_ads.ad_conversion table
Which destination?: facebook_ads
Additional details: We are the engineering team at Udemy (udemy.com).
We're using the Fivetran Facebook Ads connector and we noticed that the event column in the ad_conversion table is consistently returning NULL values.
We can confirm that conversion events are actively being received on the Facebook side — our Facebook Pixel (ID: 1457291081167286) is receiving events such as PageView, isMember, and Purchase with significant volume (e.g. 150M+ PageViews, 982K Purchases in the last ~30 days).
Expected behavior: The event column should reflect the conversion event name (e.g. Purchase, PageView, etc.)
Actual behavior: The event column is always NULL
Could you clarify:
- Is the
eventcolumn populated from the Facebook Ads API, or from the Pixel/Conversions API separately? - Is there a known issue or a specific API endpoint/field that maps to this column?
- Do we need any additional permissions or API scopes enabled on our Facebook connection to populate this field?
Please sign in to leave a comment.
Comments
0 comments