How to validate Meta ad conversion metrics

Overview: 

This document provides guidance validating ADL 2.0 Meta standard ad conversion data source (facebookads_insights_adconversion) metrics against the UI.

This guideline applies exclusively to clients utilizing the Facebook platform.

Validation steps against UI:

• Use custom query builder to query facebookads_insights_adconversion data source using the Explorer in Alli for a client. (See Querying Data Library 2.0 in Data Explorer from step 7)

• select the specified date , campaign_id and conversion columns(action_offsite_conversion_fb_pixel_purchase,action_values_offsite_conversion_fb_pixel_purchase,action_offline_conversion_purchase,action_values_offline_conversion_purchase) to get the results

• Login to Facebook Ads Manager using { }_reporting credentials.

  • Up on login, select the specific client account under the dropdown provided at the top.

  • Go to the Campaign Report and choose the date and campaign to get the conversions and other metrics-related info.

  • Compare the total conversions from the query with the total displayed in the UI.

• If you notice discrepancies between the results of the data source and UI, it may be due to conversions being recorded at the ad and platform granularity levels. These conversions are also included in our Ad Conversions data source.

• Follow these steps for analysis:

  • Calculate the sum of conversions for each ad ID and publisher platform by adding a filter for campaign_id through SQL Query builder in Data Explorer.

    

  • Go to Ads Reporting in UI and create a new report by selecting the specific client account. Add the required columns such as campaign_id, ad_id, and publisher_platform from the breakdowns and conversions metrics option provided on the right end.

• Choose the date and campaign, ad and select an ungroup breakdowns option to ungroup the data by Ad ID and Publisher Platform in the UI to check conversions being recorded at the ad and platform granularity levels to compare the total results from the query with the UI's conversions for that combination displayed.