# 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.

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/how-to-create-a-scorecard-for-conversions-in-facebook-ads-1.png)

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/how-to-create-a-scorecard-for-conversions-in-facebook-ads-2.png)

## Solution

With your [sheets add-on](https://knowledge.powermyanalytics.com/application/reports/installing-the-power-my-analytics-add-on-for-google-sheets/), 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.

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/how-to-create-a-scorecard-for-conversions-in-facebook-ads-3.png)

Go to your Data Studio report. Click **Add Data.**

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/how-to-create-a-scorecard-for-conversions-in-facebook-ads-4.png)

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

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/how-to-create-a-scorecard-for-conversions-in-facebook-ads-5.png)

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

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/how-to-create-a-scorecard-for-conversions-in-facebook-ads-6.png)

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

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/how-to-create-a-scorecard-for-conversions-in-facebook-ads-7.png)

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

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/how-to-create-a-scorecard-for-conversions-in-facebook-ads-8.png)
