Connector Improvement: Missing metrics for Facebook Pages connector tables
AnsweredFor most of the [LIFETIME/UNIQUE_LIFETIME/UNIQUE_DAILY]_POST_METRICS_BY_[CATEGORY] tables, there is only one metric (post_video_view_time_by_[Category]) being pulled. Can you please add more metrics to these tables? Impressions, views, clicks, shares, etc.
Two tables in particular: lifetime_post_metrics_by_country and lifetime_post_metrics_by_age_gender currently has the following fields: Country/Age_Gender, Date, Post_ID, Post_Video_Time_By_Country_ID/Age_Bucket_And_Gender. Can you please add more fields (metrics) to include at the very least: impressions and clicks.
I'm hoping this will be a quick win.
-
Official comment
Hi Nathan,
Luke from the Product team here! Thanks for submitting this feature request. We checked the API responses and documentation for these endpoints and unfortunately, Meta doesn't provide any additional metrics for these two tables.
In Meta's documentation,post_video_view_time_by_country_idis the only available field that returns values by Location (Country). In the API response we can see the values by country as it is written in the documentation:
This is why we have only one field,
post_video_view_time_by_country_id, besides the standard columns and country column in the lifetime_post_metrics_by_country table. It is the same for lifetime_post_metrics_by_age_gender. We have only thepost_video_view_time_by_age_bucket_and_gendermetric, that returns data by age and gender.
However, you can find the other impression metrics in ourpage_metrics_total,post_metrics_totalandreel_metrics_totaltablesLet me know if you have any follow-up questions. I'm going to mark this request as answered for now.
Cheers,
Luke
Please sign in to leave a comment.
Comments
1 comment