pulling from ad tables(ads, ads_insights, campaigns, adsets etc... ) getting "Cannot include video_p100_watched_actions....."
Full error below, but we get a variety of errors showing different columns that is 'cannot include'. This is just started to happen recently.
400 Message: (#100) Cannot include video_p100_watched_actions, unique_inline_link_clicks, account_name, clicks, ad_id, reach, website_ctr, video_p50_watched_actions , cost_per_unique_click, canvas_avg_view_percent, engagement_rate_ranking, adset_name, quality_ranking, campaign_name, ctr, unique_link_clicks_ctr , cpm, outbound_clicks, video_30_sec_watched_actions, account_id, frequency, cpp, spend, inline_post_engagement, action_values, cost_per_unique_inline_link_click , impressions, unique_clicks, objective, unique_ctr, video_p25_watched_actions, ad_name, campaign_id, canvas_avg_view_time, conversion_rate_ranking , unique_inline_link_click_ctr, unique_actions, actions, cost_per_inline_link_click, cost_per_inline_post_engagement, unique_outbound_clicks , video_play_curve_actions, inline_link_click_ctr, inline_link_clicks, adset_id, cpc, video_p75_watched_actions in summary param because they weren't there while creating the report run. All available values are: ".
I just got a random error for the first time that is similar to this. The values were definitely there when the report was started. It seems like this might be an intermittent error. (#100) Cannot include account_id, campaign_id, adset_id, ad_id, actions in summary param because they weren't there while creating the report run. All available values are:
So do you think the error has any impact on the data we are pulling, ie are we getting all the rows and fields that we want, or are we missing some?
same here it happens at random
Status: 400 Response: { "error": { "message": "(#100) Cannot include ad_id, ad_name, adset_id, adset_name, buying_type, campaign_id, campaign_name, account_id, account_name, canvas_avg_view_percent, canvas_avg_view_time, action_values, actions, clicks, ctr, frequency, impressions, inline_link_clicks, inline_post_engagement, objective, outbound_clicks, quality_ranking, reach, spend, unique_actions, unique_clicks, unique_inline_link_clicks, unique_outbound_clicks in summary param because they weren't there while creating the report run. All available values are: ", "type": "OAuthException", "code": 100, "fbtrace_id": "AlUKSVkv9sIhL39oj4U1zAj" } }
Status: 400 Response: { "error": { "message": "(#100) Cannot include adset_id, adset_name, buying_type, campaign_id, campaign_name, account_id, account_name, canvas_avg_view_percent, canvas_avg_view_time, action_values, actions, clicks, ctr, frequency, impressions, inline_link_clicks, inline_post_engagement, objective, outbound_clicks, quality_ranking, reach, spend, unique_actions, unique_clicks, unique_inline_link_clicks, unique_outbound_clicks in summary param because they weren't there while creating the report run. All available values are: ", "type": "OAuthException", "code": 100, "fbtrace_id": "ALMkANRlc352OFhhijFeMiR" } }
for different accounts from time to time