Summary
The user is experiencing an error while syncing Facebook Marketing data to Snowflake in Airbyte Cloud. The error message indicates missing fields in the summary parameter that were not present during the report creation. The specific issue seems to be with the ads_insights_age_and_gender stream failing to sync successfully.
Question
Hey,
this morning I started getting the following error:
Source: Facebook Marketing
Destination: Snowflake
Platform: Airbyte Cloud
(#100) Cannot include account_currency, account_id, account_name, action_values, actions, ad_click_actions, ad_id, ad_impression_actions, ad_name, adset_id, adset_name, attribution_setting, auction_bid, auction_competitiveness, auction_max_competitor_bid, buying_type, campaign_id, campaign_name, canvas_avg_view_percent, canvas_avg_view_time, catalog_segment_actions, catalog_segment_value, catalog_segment_value_mobile_purchase_roas, catalog_segment_value_omni_purchase_roas, catalog_segment_value_website_purchase_roas, clicks, conversion_lead_rate, conversion_rate_ranking, conversion_values, conversions, converted_product_quantity, converted_product_value, cost_per_ad_click, cost_per_conversion, cost_per_conversion_lead, cost_per_estimated_ad_recallers, cost_per_inline_link_click, cost_per_inline_post_engagement, cost_per_unique_click, cost_per_unique_inline_link_click, cpc, cpm, cpp, created_time, ctr, engagement_rate_ranking, estimated_ad_recallers, frequency, full_view_impressions, full_view_reach, impressions, inline_link_click_ctr, inline_link_clicks, inline_post_engagement, instant_experience_clicks_to_open, instant_experience_clicks_to_start, instant_experience_outbound_clicks, mobile_app_purchase_roas, objective, optimization_goal, outbound_clicks, purchase_roas, qualifying_question_qualify_answer_rate, quality_ranking, reach, spend, unique_actions, unique_clicks, unique_ctr, unique_inline_link_click_ctr, unique_inline_link_clicks, unique_link_clicks_ctr, unique_outbound_clicks, updated_time, video_15_sec_watched_actions, video_30_sec_watched_actions, video_avg_time_watched_actions, video_continuous_2_sec_watched_actions, video_p100_watched_actions, video_p25_watched_actions, video_p50_watched_actions, video_p75_watched_actions, video_p95_watched_actions, video_play_actions, video_play_curve_actions, video_play_retention_0_to_15s_actions, video_play_retention_20_to_60s_actions, video_play_retention_graph_actions, video_time_watched_actions, website_ctr, website_purchase_roas, wish_bid in summary param because they weren't there while creating the report run. All available values are:
I started using this connection last Thursday, it has been working fine for the last 6 days without errors. Anyone experiencing the same issue?
It seems the problem is with the ads_insights_age_and_gender stream.
During the sync, the following streams did not sync successfully: ads_insights_age_and_gender
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.