Supermetrics Support Forum

Setting up Facebook Ad data on Google Data Studio

How do you export a Google Sheet with all the necessary tabs, as seen here: https://supermetrics.com/blog/facebook-ads-data-studio


I can't find detailed instructions on the boxes I should be checking to retrieve all that information that's presented. 

  • Hi Rudys,


    I'm not clear where the issue is - can you describe which step or part of the blog post you are getting stuck at and what isn't working as described?


    -Thank you

    Supermetrics Team

  • Hi Rudys,

    None of the instructions reference an Excel document, so perhaps that is the issue? You need to use Google Sheets to perform the steps in the blog post - and it cannot be an Excel file type, but a Google Sheets file specifically.


    You can also avoid using the spreadsheet completely and use the Facebook Ads connector in Data studio to pull right from the source (the blog post may have been created before we had this option). See this article for instructions and an example video of how to do this:

    https://support.supermetrics.com/support/solutions/articles/19000065955-adding-and-authorizing-supermetrics-connectors-in-google-data-studio


    Please let me know if you need any further assistance.


    -Thank you

    Supermetrics Team

Login to post a comment