Before few years, it is about how we can manually export the data from Facebook ads manager and paste in Excel or Google sheet for reporting and analysis. Now there are multiple tools and approaches to automate this facebook ad transferespecially to bigquery, tableau, Google sheet,etc.

Why do we need this Facebook ads Data automation?

The reason why i choose Facebook to start with this series of data automation post is that Google products have been made easier to transfer(ready-made connectors) as Google has it own data warehouse like Bigquery. and Facebook is one of the second marketing channel providers where our money is spent and we need those data as well.

Also, Each one of us works in different technology stack, so am going to share short snippets of every possible way and so you can explore further on this. This information provided here are only a awareness of different approaches and not a in depth explanation as each company mentioned below has more expert posts than I can provide.

Transferring to Google Sheet only Stack:

You may just want to transfer the data directly into google sheet in a automated(hourly/daily) fetch for simple reporting like budget monitoring, creative report, or simple analysis from multiple facebook ad accounts data. For this case, the best and affordable ways are

Transferring directly to BigQuery

Usages like the advanced analysis from 100+ accounts with terabytes of data, building a marketing data warehouse for business intelligence (BI) or for any machine learning analysis where analyst wanted to pull numbers into their R Studio or Python environment, it is efficient to fetch data from Bigquery or any storage solutions. There are multiple ways to do from Manually writing api to automate, so I would recommend considering ready-made solutions as it is easy to start faster

Transferring to Google Sheet and then to Bigquery

Cases like where you want to clean these data before it gets passed to Bigquery, you need some environment, Google has it’s beta solution of data prep to do this but not everyone can afford to expertise to achieve this or even you can do SQL queries to clean and merge data directly in Bigquery interface but you want the simplest solution where everyone can play a part in cleaning. Anyway, it’s up to your requirements. So you can

Transferring into Tableau directly

What If you are already using business intelligence tool like tableau and your company is not in google environment and Microsoft product. simple..

Transferring to Google sheet and then to Tableau

A case you are not a SQL expert 🙂 but you are expert at Excel formula and a big believer in coding is for losers 😀 or your requirement itself has something to do with Google sheet. Similar to Bigquery, Tableau also has a free inbuilt google sheet connector that makes our job easier to connect to Google sheet which means

Transferring into Bigquery > R Studio/Python Environment > then to Tableau

What if you are a data scientist and expert analyst you want to get the terabytes of data into Bigquery as Google sheet cannot accompany your requirement of more than 2million cells? Or you want to pull data into Bigquery , then push to Rstudio/python environment for further data modeling or prediction algorithms and then push to Tableau.

Transferring to Microsoft Excel

You may say “My company is not in Google apps environment” or “Google sheet is for kids :D” or “Google sheet has lot of limitation and can be very slow sometimes”. No worries, free tool and paid tools available

Transferring to Google Data Studio directly

Ooh! Finally, the free visualization tool is available 🙂 And for budget users, the perfect love comes from Google.

For direct transfer:

In simple, list of the tools available for transfer to Bigquery, Google Sheet, Snowflake, Microsoft Excel

  1. singer.io
  2. Facebook official connector for excel
  3. Supermetrics
  4. Blockspring
  5. Stitchdata
  6. Alooma
  7. Owox BI
  8. Blendo
  9. Fivetran

Conclusion

If you ask me what you want to start first, I would recommend you to start with supermetrics which i have been using for 3+ years and worth of paying $39 basic package. if it is more for visualization just go ahead with Data Studio as its free and can still use all google products, if you want more, then you can use supermetrics connectors. Do you still have data? Ask me private doubts on https://sgdigitalnerds.slack.com which i just created to help fellow buddies!

2 Responses

Leave your comments