Reporting Templates' Updates and Troubleshooting Tips (From Google Sheets to Data Studio)

Facebook Ads Google Data Studio Template (GSheet ver.) is Now Fixed 

We have fixed both the Google Sheets file and the Data Studio file for our Facebook Ads reporting template, which was originally featured in this blog post. The problem with some charts not showing data occurred because some of the metrics' names have changed after a Facebook API's update, and those changes were not implemented in the template. 

In case you are using the template, and some of the metrics are not reported/charts are broken, please follow these steps:

  1. Populate the updated version of the Google Sheets' file with your data with the help of Supermetrics' Add-on

  2. Copy the new version of the Data Studio file and connect your Google Sheet as a data source

  3. Set up the calculated metrics 

If you are struggling with these above mentioned steps, please follow the instructions from the original post.  

You will get to the new files by clicking active links in this article. Also the links on the original blog post are now updated. Don't forget to get both the new GSheet and DS files, otherwise the template will not work properly. 

We have created a Facebook Ads template, which works with our native Facebook Ads connector and does not require Google Sheets to get data. Feel free to try it out!

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.