Connector Improvement: Add Quality Ranking Columns Back to Facebook Ads Connector
Answered
Request: Add the following columns back to the Facebook Ads connector for use in ad-related reports.
- quality_ranking
- conversion_rate_ranking
- engagement_rate_ranking
These columns are business critical to our Facebook Ads analyses. They help us determine where we focus our efforts when optimizing ads.
They were removed from the Facebook Ads connector in March 2024 according to Fivetran's release notes.
According to Facebook API Documentation, these columns are still fully available and have not changed due to API upgrades.
I contacted Facebook Ads support and they also confirmed that there have been no changes to those fields between API versions, so they are still available for Ad Insight reports.
I can provide expected output data for the development team to use during testing, if needed.
-
Official comment
Hi Tracy,
Luke from the Product team here. Thanks for submitting this request.
We use this endpoint to get report data from Facebook Ads: https://developers.facebook.com/docs/marketing-api/reference/adgroup/insights#fields. These fields are no longer available in the latest version.
The documentation that you shared is for the Ad Report Run endpoint. I'm not sure why Facebook includes references to deprecated fields on that page. Per this documentation, that endpoint is used to check the status of an asynchronous job submitted via a request to the adgroup/insights endpoint I linked above. It can't be used to request reports.
So I don't think there is a way to retrieve these metrics from the Facebook Ads API anymore.
Cheers,
Luke
Please sign in to leave a comment.
Comments
1 comment