How to Create a Scorecard for Conversions in Facebook Ads

How to Create a Scorecard for Conversions in Facebook Ads


Scorecards with total conversions do not work in Data Studio because Meta does not send this data. However, with our sheets add-on solution, you can create this information and import it to Data Studio for a seamless blend into your report.


This article will address the following issue:

Facebook Ads cannot sum conversions with multiple attribution settings. Conversion scorecards created in Data Studio will show zeroes.




Solution

With your sheets add-on, create a report using Conversions as the metric and Campaign Name as the dimension. Make sure the date range matches the date range in your Data Studio report.




Go to your Data Studio report. Click Add Data.



Select Google Sheets. This is a free connector provided by Google.



Select the spreadsheet and worksheet that contain the relevant report. Click Add.



Click Add a chart to add a scorecard and select the connected sheet as a data source.



For the metric, select Conversions. The resulting scorecard will display a sum of conversions from each campaign.


    • Related Articles

    • Troubleshooting Facebook Ads

      Meta's Facebook Ads API is complex and often difficult to work with due to continuous changes and little documentation or support. Here you will find the most up-to-date information we have to troubleshoot issues that arise while making Facebook Ads ...
    • 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 ...
    • 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 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 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 ...