How to Get Facebook Ads Data to Google Sheets?

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.

The Process

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 the Launch button. After a little while, you will see the Supermetrics extension in the right hand pane. Expand the “Data source” section and locate “Facebook Ads”:

GO TO SUPERMETRICS

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.

The next step is to scroll down t0 the “Select accounts” section. Expand it and you will see this:

Click into the “Select” area and select your accounts. You can select more than 1 account! Just repeat the process again and again.

I’m interested in 2 accounts and this is how it looks after I’m done with selections:

GO TO SUPERMETRICS

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.

The next step is to select your metrics. Expand the “Select metrics” section:

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:

GO TO SUPERMETRICS

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.

And the last step is the “Options” section:

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

Before you press “Get Data to Table”, you need to select the cell where the Facebook Ads data should be loaded. For me it’s A1:

GO TO SUPERMETRICS

I press “Get Data to Table” and after a while, the data is loaded into the sheet:

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).

These are options for your “Refresh” setup:

You can have an email sent to you in case the query fails – that’s helpful for spotting errors which sometimes happen.

And these are your options for “Refresh and email” setup:

You can select the format, exact time, sheet, you can tailor your subject, you can even have the email sent conditionally.

Conclusion

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!

GO TO SUPERMETRICS

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *