How to Report Result Rate in Facebook Ads
Many of our customers are looking for a way to report result rate data in their Facebook Ads reports. This article will show you how to use Power My Analytics' flexible options for reporting different result rate metrics.
The Facebook Ads field Result Rate is frequently requested by our customers. Unfortunately, this field depends on the Results value, which is not provided through Facebook's API. For this reason, Power My Analytics is unable to provide the total Result Rate field across all result KPIs in our Facebook Ads connector. This is a limitation of Meta's API for Facebook.
Alternatively, we offer the option to report specific fields for numerous different kinds of results in Facebook Ads, such as:
- Conversions
- Leads
- Link Clicks
- Post Engagement
- Website Conversions
By combining these fields with the Impressions field, you can create a calculated field for each result rate you want to report, such as Link Clicks Result Rate, Post Engagement Result Rate, or Website Conversions Result Rate. In this article, we'll show you how to create these result rate fields and use them in your Looker Studio report.
Add a Calculated Result Rate Field in Looker Studio
Before you begin, make sure you've:
- Connected your Facebook Ads account as a data source in your hub.
- Created your Looker Studio report.
For help setting up your report, please see the instructions in our Facebook Ads Data Connector User Guide.
Add a Calculated Field in One Chart
If you'd like to use a result rate field in only one chart in your report, add it as a metric in the chart:
- Open your report and select the chart you want to modify. In this example, our table is already reporting Link Clicks and Impressions by Campaign Name, and we'll create Link Clicks Result Rate as a new calculated field in the table. In the Chart sidebar under Metric, click Add metric.
- Click Add calculated field.
- Under Name, enter a name for the calculated field, such as "Link Clicks Result Rate".
- For the Data Type, select Numeric > Percent, and for Display Format, choose Percent(2).
- In Formula, enter: SUM(Link Clicks)/SUM(Impressions). In place of Link Clicks, you can use the metric needed for the desired result rate. Click Apply.
- The calculated metric Link Clicks Result Rate will appear in the chart.
Add a Reusable Field in the Looker Studio Data Source
If you'd like to use a result rate field in multiple charts in your report, add it as a calculated field in the report's Facebook Ads data source:
- Open your report. In this example, we'll create Link Clicks Result Rate as a new calculated field in the report's data source. In the Data sidebar, click Add a field.
- Click Add calculated field.
- Under Field Name, enter a name for the calculated field, such as "Link Clicks Result Rate".
- In Formula, enter: SUM(Link Clicks)/SUM(Impressions). In place of Link Clicks, you can use the metric needed for the desired result rate. Click Save.
- Click Done.
- You can now add the field Link Clicks Result Rate into charts in your report.
- To format the Link Clicks Result Rate field correctly, click the pencil icon to the left of the field.
- Set the Data Type to Numeric > Percent and the Display Format to Percent(2). The percentages will be displayed for the Link Clicks Result Rate.
Still having issues?
Send us a ticket and we will get back to you.
Related Articles
Facebook Ads Data Connector User Guide
Facebook Ads is a powerful advertising platform that allows businesses to reach their target audience on Facebook, Instagram, and across the web. This guide will walk you through how to connect your Facebook Ads account to Power My Analytics, create ...How to Report Custom Conversions in Facebook Ads
Power My Analytics offers an easy way to include your custom conversions data in your Facebook Ads reports. Follow these steps to get started with reporting custom conversions in Looker Studio. If you're using custom conversions with your Facebook ...Understanding Changes to Facebook and Instagram Ads Attribution with iOS14 and Above.
New privacy regulations have presented challenges for attribution tracking. In response, Facebook has made a lot of changes to keep pace with Apple's iOS14 and above. This article will help you understand what you need to know to get the most out of ...Missing Sums on Facebook or Instagram Ads Campaign Reports
Facebook's attribution reporting has undergone some changes that may affect your reports. This article will help you understand how to compensate for new challenges with their API. This article will help you to resolve the following problem: You may ...Why Can't I Create Breakdowns by Objective in Facebook or Instagram Ads?
This article will help you learn to make breakdowns by Objective in Facebook and Instagram Ads. Problem Breakdowns by Objective are available in Facebook Ad Manager, but they are not available in the API. Attempts to create a breakdown by objective ...