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 Data Studio report.
Add a Calculated Result Rate Field in Data Studio
Before you begin, make sure you've:
- Connected your Facebook Ads account as a data source in your hub.
- Created your Data 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 Data 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.
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 ...Facebook Ads Data Connector Limitations
This article covers the limitations, considerations, and workarounds for working with Facebook Ads data in Power My Analytics. For instructions on connecting your Facebook Ads account and creating reports, see the Facebook Ads Data Connector User ...Facebook Insights Deprecated Legacy Reach and Video View Metrics (June 15, 2026)
Meta is removing a large group of legacy reach, impression, and video view metrics from its Graph API effective June 15, 2026. This change affects several fields in the Power My Analytics Facebook Insights data source. On June 15, 2026, Meta is ...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 Data Studio. If you're using custom conversions with your Facebook Ads ...A Facebook Ads Account Is Missing From The List When Trying To Create A Report
This article will help you to resolve the following problem: One or more Facebook accounts are missing from the list when trying to create a report. Cause When you connect to Facebook in the Hub, only accounts that are already added to your Business ...