So you’ve been running your Facebook campaign for a while and now it’s time to make a simple dashboard in Google Sheets. The main question is: How can I download Facebook Ads data to Google Sheets? The answer is Supermetrics for Google Sheets.
First of all, you need to install Supermetrics for Google Sheets for your Google account. Just follow the link and click “Start Free Trial”. Don’t worry, you will not be charged anything. You will have 14 days to try the product.
The next step is to open a new Google Sheets document and check if your Supermetrics for Google Sheets add-on installed correctly. You should see something like this:
Click it and authenticate with Facebook – just fill in your login details. Once you are authenticated, you can start building your report. What you need to do now is to make sure “Facebook Ads” data source is selected in the Data source list in case it got deselected during the authentication. The selected items have blue border.
Now it’s time to select you dates so expand “Select dates” section. You can select from “Custom date range” or you can simply define a static period with start and end dates. I’m going for a custom date range:
Pay attention to the 5 “Last X …” options. Those are very useful and you can make your report change period dynamically to e. g. always show the last 12 months of data.
Similarly as with the account selection, you can select many metrics via the list of suggestions. I’m going small with Impressions, Clicks (All), and Amount spent (yea, not sure why it’s not simply called “Cost”).
The next step is to define the dimensions which you need for splitting the data. That’s done in the “Split by” section. You can Split to rows and you can Split to columns. I’m usually Splitting to rows only. I’m going for this selection:
You can also limit the number of rows downloaded as well as you can also define primary and secondary sorting in this section.
We are almost done.
The next step is optional and probably for more advanced users. It’s filtering. Navigate to the “Filter” section. You can use basic operators such as EQUALS, DOES NOT EQUAL, CONTAINS, and also MATCHES REGEX. Any filter you add behaves as AND. If you want to create very complex filters with AND and OR clauses, then you are out of luck – it will likely not be possible. I’m going with no filters.
Among all the options, you need to make sure you select the correct Conversion window and you also make the right choice in “Report time of action stats”. The both selections depend on your internal processes and on how you do your reporting. There is not a correct answer.
Ok, so now we are ready to run the query.
Running the query
That did not hurt, did it? Your Facebook Ads data now sits in Google Sheets.
Scheduling Your Supermetrics Queries
Okay, so running this once is helpful but what if you want to run your query regularly? Daily, Weekly, Monthly? Yes, you are guessing correctly – you can schedule the queries :). In order to enable scheduling, follow these steps: Add-ons > Supermetrics > Schedule refresh & emailing:
You have 2 options. You can only Refresh the sheet (Daily, Weekly, Monthly) or you can Refresh & Email the sheet (again Daily, Weekly, Monthly). If you buy the Super Pro license, you can setup even hourly refreshes (but not emails).
You can have an email sent to you in case the query fails – that’s helpful for spotting errors which sometimes happen.
You can select the format, exact time, sheet, you can tailor your subject, you can even have the email sent conditionally.
Supermetrics for Google Sheets looks like a simple tool but it can save you tons of hours in future. Especially when you learn all the little details, the tool becomes super powerful. Click the button below to try it out today!