If you’re new to Google Data Studio and would like to copy and paste our templates, this is your guide.
Here’s a video first, if you prefer:
Now, here’s the step-by-step guide.
All our Data Studio templates come with a button in the top right corner that says Use template. Click it.
Now, we will connect a data source. In this case, we will use the Porter Metrics Facebook Ads connector. You will get a 14-days free trial with all our features.
If you have used it before, you’ll see it as “Facebook Ads + Instagram Ads” connector in the dropdown list of connections.
Adding a data source
If it’s your first time, go to create a new data source.
Now choose the Facebook Ads connector by Porter Metrics.
Now, authorize Porter by signing in with Google. Make sure to sign in with the same Gmail account you’re currently using.
Otherwise, you’ll create a paradox in Google’s space-time, making it crash, and you would need to start over. We don’t want that.
If you’re wondering about your privacy, we only retrieve your email so you don’t need to fill a form, and this way we can assign a new account to such email. Now you should authorize your Facebook account so the connector can access your advertisement data.
Connect your Facebook profile
Click on Authorize.
Now you will connect to your Facebook account.
We will request you to give us permissions like managing your page and Ads.
We won’t manage them, actually, but this kind of permission is necessary to correctly retrieve your Facebook Ads data.
Setting up the connector
Once we finished the authentication steps, setting up the connector just takes a few clicks.
First, choose the Facebook Ads account you want to connect.
You should choose one Facebook Ad account at a time for each connector setup.
We restrict connecting multiple accounts at once as it may affect speed and performance; Facebook API and Google Data Studio have response time limitations.
If you want to connect other Facebook Ads accounts, you should set up the connector again, but the authentication process just needs to be done once per Gmail account.
Then, pick a conversion window.
By default, Facebook uses 28 Days Clic + 1 Day view, which means that a conversion will be attributed to an ad click that has happened within 28 days or one day after someone seeing an ad. Read more about attribution here.
We recommend you to keep the default option, though.
Finally, choose the report time action stats. 99% of times you will want “On impression date.”
Leave the checkbox that says “Use report template for new reports” checked by default.
It will let you use our template so you don’t need to start from scratch.
To finish, click on the blue button that says “Connect” in the top-right corner.
All the fields must be filled in order to proceed.
Just click on “Connect”, on the top right corner of the page.
Now you will see the metrics and dimensions our Facebook Ads connector brings.
Click on Add to report in the top-right corner.
Heads up, Facebook API response time may take longer depending on the number of queries and the amount of data you request.
Connect other data sources
Now you should connect the other data sources, if any. Some of our templates also connect to data sources like Google Ads, Analytics, Search Console, and more.
Their setup process is pretty similar. Remember that connections to Google products like Analytics, Google Ads, Search Console, and Youtube are free.
Finally, click on Copy Report, and you’ll be done.
Hope you enjoy our templates—and avoiding the excruciating pain of manual reports in sheets.