Beginning today (30 April, 2019) we are "deprecating" 17 fields from the Facebook Ads connector. This is due to Facebook deprecating version 3.1 of their Facebook API and these fields no longer being available (officially deprecated in v3.2). These are not used in the Ad Manager UI (and have been non-functional in our tool) and have been replaced by other fields some time ago.
The fields will be moved to the group "Deprecated" with the text "(deprecated)" appended to a field's name. The fields will work as before until the 13th of May, 2019. After that the fields will return empty (NULL) values for all queries. Please check and update your queries if you are using any of these.
Here's a list of field names to be deprecated and their replacement fields:
|Deprecated Field Name||Replacement to Use Instead|
|Mobile app actions||Replaced by specific metrics for each action - see "App Actions" here for full list of options|
|Cost per mobile app action||Replaced by specific metrics for each action - see "App Actions Cost" here for full list of options|
|Other website conversions||No replacement - see section below for alternative method that may help|
|Cost per other website conversion||No replacement - see section below for alternative method that may help|
|Website adds to cart (conversion tracking pixel)||Website adds to cart|
|Cost per website add to cart (conversion tracking pixel)||Cost per website add to cart|
|Website checkouts initiated (conversion tracking pixel)||Website checkouts initiated|
|Cost per website checkouts initiated (conversion tracking pixel)||Pending feature request to add metric|
|Website conversions||We were able to recreate this field from the available data! Please use the new version (will have the same naming)|
|Cost per website conversion||We were able to recreate this field from the available data! Please use the new version (will have the same naming)|
|Website conversion rate (%)||We were able to recreate this field from the available data! Please use the new version (will have the same naming)|
|Website key page views (conversion tracking pixel)||No exact replacement - likely: Landing page views or Website content views|
|Cost per website key page views (conversion tracking pixel)||No exact replacement - likely: Cost per landing page view or Cost per website content view|
|Website leads (conversion tracking pixel)||Website leads [or Leads (form) if using internal forms]|
|Cost per website lead (conversion tracking pixel)||Cost per website lead|
|Website registrations (conversion tracking pixel)||Website registrations completed|
|Cost per website registration (conversion tracking pixel)||Cost per website registrations completed|
Also see this article for additional deprecations due to changes in the Ad Manager UI happening in April.
Special Instructions to Replace Other Metrics With No Direct Replacement
It is still may be possible to recreate some metrics using the same technique used to get custom conversions, which is to query the "Action" and "Action type" fields.
Here's an example of the query in the Supermetrics for Google Sheets, with an arrow pointing to the field that gives the same results that "Website conversions" used to:
You will also see the other conversion types and the custom conversion as well, so this can be used to fetch other actions (aka conversion) metrics we currently don't have fields for.
Then if you need to get the cost field, you will need to create two queries (as "Action type" can ONLY be fetched with "Actions" and no other metrics). One will be the Campaign ID and action type data, the other will be the Campaign ID and your other metrics like cost. Campaign ID (or other ID for Ad Set or Ad) will be used as the join key.
For Sheets (Excel is basically the same), then using vlookups (or similar formulas) you can add the conversion metric from the Action type query to the other and then use that math to generate the Cost per action field.
For Data Studio, this is far more complex as you need to first set up a blend and then create the custom calculated fields for this. See the example for Data Studio here for How to Query for Facebook Ads Custom Conversions, but instead of using the Custom Conversion ID, filter/look for the action type name. Then see this article about how to set up the cost calculated field: How to Get Cost Per Conversion for Facebook Custom Conversions (Data Studio)
If you have additional issues with the Action/Action Type method of getting conversion data, please submit a support request for further assistance.
If you aren't getting the right results for the replacement fields or the suggested replacement does not work, please submit a support request and give us a screenshot of the conversion you want to get data from the Ad manager directly (please get the actual metric value for the conversion, not the "Results", by adding the column to your table).