Before 2year back, we wrote a detailed guideline on how to extract data from Facebook not just in google sheet and excel but also in different marketing Datawarehouse like Bigquery, etc.
Let’s go inside into a updated and straight forward option using a single and simple google sheet and excel plugin called Supermetrics : (Website Link)
Steps we will go through in this process
- Things to know before setting up this in your sheet
- Installing and setting up Supermetrics in sheet
- Installing and setting up Supermetrics in Microsoft excel
- Few examples how you can use supermetrics with Google sheets
Things to know before setting up this in your sheet
- This reporting automation heavily suitable for marketing agencies who have multiple clients (thus multiple facebook accounts)
- It also suitable for companies who have data from multiple channels (FB, google, Twitter, Linkedin, DoubleClick (currently renamed as google 360), Criteo, App networks, etc)
- It might not be suitable for someone who has one ad account and spending less than 10K. Because it is a paid tool and it is better you identify some raw model of using google scripts to download data into Google sheet and Facebook native Excel plugin to download
- If you or your team is not serious about getting the data every day and not using for monitoring. Because you can just setup a report in Facebook, download and paste in a googlesheet/excel tab named as RAW and have another TAB as REPORT and use formulas.
Installing and setting up Supermetrics in Google sheet
Lets go through the steps to install Supermetrics
- Go to Addons > Get Add ons > Search for supermetrics
- When you click install > It will ask you whether you want to install domain level or One sheet level (Because Domain level will be applicable for all users who are corporate Google Apps business users). (Better to do from Sheet level everytime. Otherwise i THINK multiple email users will start using supermetrics and it may charge, do double check)
- Then Click continue and do email authorisation
- You should be able to get this add on like below screen and LAUNCH it
- You will find all the list of connectors (mostly marketing tool connectors). For this exercise, we will be taking Facebooks ads as example
- You have 5 components to fill based on the needs.
- The Data source you choose
- Ad accounts selection (When I used to handle one who client which are present in multiple countries, We have different ad accounts. This is for billing, currency, timezonee, etc reasons. So I just put all those accounts together
- Dates: A straight forward thing (The timezone are ad account timezone. Supermetrics or Google sheet doesn’t control that. But for Date format, remember to use same in Gsheet as FB ad account) . Recommend to select just 7days on the first fetch until you finish setting up the report(so it’s faster to push)
- Metrics are the numbers (like your results, conversions, etc) . You can get 7day or 28days based attribution . And also custom conversions as well but it will comes in ROW instead of column for you to differentiate. Most of the custom conversions you create will be under the ROWS, so select all conversions on the initial stage and get the results. Then identify what is needed and what’s not needed. Avoid doing one by one.
- Then select the dimensions you want. There is 100+ dimensions which facebook provide and especially if you have good analyst team and significant ads spent, you can do lot of interesting analysis.
- Click GET DATA to TABLE . Watch this quick video below https://youtu.be/xU4CtzIom2g
Few examples how you can use supermetrics with Google sheets
There are few ways I used + Other inspirations below
- Budget Monitoring (By country (removed the actual numbers)
- Cohort Analysis – 10 Type of analysis. Refer from there.
- Creative performance monitoring (which sync with designers as well)
- And other ad hoc like Page abandonment data and Content marketing stats.
Hope this informations are helpful.