Facebook Ads
The Facebook Ads connector gets your Facebook Ads data into Google Sheets and Google Data Studio. Use it to track your key metrics in a spreadsheet or a Google Data Studio report.
What you can report on
- Campaign, ad set, and ad-level performance metrics
- Reach, impressions, clicks, and CTR
- Cost per click (CPC), cost per result, and ROAS
- Audience demographics and placement breakdowns
- Video views, engagement, and conversion tracking
Prerequisites
- A Facebook Business Manager account
- Employee access with View Performance enabled, or Ad Account Analyst access on the ad accounts you want to report on
- All the permissions that Facebook asks for when you authorize, including Business management. Two Minute Reports uses this permission to find the ad accounts of a Business Manager. These are the ad accounts that the Business Manager owns and the client ad accounts that are shared with it. Without this permission, you see only the ad accounts on which you have a direct role.
New Pages experience: If your Business Manager uses Meta's new Pages experience, your account also needs partial access to the linked Facebook Page. This is required because Meta separates personal profiles from page management.
Agencies and connections made before 25 August 2026: You do not need a direct role on each ad account. Two Minute Reports also shows the client ad accounts of a Business Manager that you have access to. On 25 August 2026, Two Minute Reports started to ask for the Business management permission. If you authorized your connection before this date, its Facebook token does not have this permission. Because of this, you do not see Business Manager ad accounts in the Hub or through the API until you reconnect. See An ad account is missing from the list.
How to create a connection
- In the Hub, open Connections & accounts.
- Select Create connection.
- Select Facebook Ads in the connector list.
- Select Next.
- In Name the connection, enter a name.
- Sign in with Facebook. Then allow Two Minute Reports access.
- Enable the accounts you want to report on.
- Select Done.
How to get Facebook Ads data into Google Sheets or Google Data Studio
To get Facebook Ads data into Google Sheets:
- In the Two Minute Reports sidebar, open Data Queries.
- Select Add.
- Select the accounts you want to report on. You can select more than one.
- Select your metrics and dimensions.
- Select the date range.
- Set sorting and filters if you need them.
- Select Run query. Two Minute Reports adds the data to your sheet.
To get Facebook Ads data into Google Data Studio:
- In the Hub, open Google Data Studio › Facebook Ads.
- Select Create report.
- Select or create a query config:
- To use a query config you have: select it in Choose your query config. Then select Save.
- To create a query config: if you already have one, first select Create new query config in the list. Enter a name in Name your query config, and select the accounts in Select your accounts. Select Save.
- Select Create from scratch. If templates show under Quick start from a template, you can select one instead.
- Looker Studio (formerly Google Data Studio) opens in a new tab, with the Two Minute Reports connector. If you are in more than one team, select your team in Select your Team.
- In Select Query Config, select your query config.
- Select Connect in the top-right corner.
- In your new report, add Facebook Ads metrics and dimensions to the canvas.
Troubleshooting
An ad account is missing from the list
First, reconnect the connection. Usually, the cause is that the Facebook token does not have the Business management permission. This occurs when:
- You authorized the connection before 25 August 2026. On this date, Two Minute Reports started to ask for this permission.
- You turned off this permission in the Facebook authorization dialog.
Without this permission, Two Minute Reports cannot get the ad accounts that you can access only through a Business Manager. This applies to the Hub and to the API.
When you reconnect, Facebook asks for this permission again, also if you turned it off before.
- In the Hub, open Connections & accounts.
- Find the Facebook Ads connection and select its edit icon (the pencil). If the connection is listed under Needs reconnecting, select Reconnect instead.
- Do the Facebook authorization steps again.
- Keep all the permissions on. Make sure that Business management is on.
- In the Hub, enable the accounts that you want to report on.
If the new accounts do not show after you reconnect, wait a few minutes and refresh the account list.
If the account is still missing:
- Make sure that you have Employee access with View Performance or Ad Account Analyst access on the ad account. See Prerequisites.
- Make sure that a Business Manager that you are a member of owns the ad account, or that the ad account is shared with this Business Manager as a client account.
- Sign in to Facebook and make sure that the ad account is active and not restricted.
Video URL is blank for some ads
Video URL and Video Permalink URL come from the video, not from the ad. Facebook gives these links only to a Facebook account that can access the owner of the video. The owner of the video changes with how the ad was made:
| How the ad was made | Owner of the video | Video URL and Video Permalink URL |
|---|---|---|
| A video was uploaded to the ad account, for example in Ads Manager | The ad account | Filled. Access to the ad account is sufficient. |
| The ad uses a video from a Facebook Page | The Facebook Page | Filled only if the connected Facebook account has a role on that Page. |
| The ad promotes an existing Page post (a boosted post) | The Facebook Page | Blank. The ad does not contain the video ID, so Video ID is also blank. |
Which role on the Page is necessary
The connected Facebook account does not need to be an admin of the Page. Any role on the Page is sufficient. The lowest role is Insights access, which only lets the account view the Page. Two Minute Reports does not publish or change anything on the Page.
To fill Video URL for ads that use a video from a Page:
- Ask an admin of the Page to give the Facebook account that is connected to Two Minute Reports a role on the Page. In Meta Business Suite, go to Settings → People, add the account, and give it partial access with Insights turned on.
- Reconnect Facebook Ads. In the Hub, open Connections & accounts. Find the Facebook Ads connection and select its edit icon (the pencil). Then do the Facebook authorization steps again.
- When Facebook asks which Pages to share, select the Pages that own the videos.
- Refresh your query.
A query fails because the start date is too old
Facebook gives Facebook Ads data for approximately the last 36 months only. If the date range of a query starts before this limit, the query fails with a message like this:
Facebook only keeps about 36 months of data. Choose a date range that starts on or after September 30, 2023 and try again.
The date in the message is the earliest start date that Facebook accepts on that day. This date moves forward one day each day. Because of this, a query with a fixed start date can work for some time, and then fail with no change to the query. The Long time date range starts on 1 January 2015, so it also starts before the limit.
To fix it:
- Change the date range of the query or report, so that it starts on or after the date in the message.
- In Google Sheets, for a query that you refresh regularly, select Last N months in the Date list, and enter 36 or less. Then the start date moves forward with the limit.
Data stops loading and the connection shows an error
The Facebook token is expired or not valid. Usually, this occurs after a password change, a change to security settings, or when a person removes access. Reconnect it in Connections & accounts: the connection is listed under Needs reconnecting, with a Reconnect button. For the full procedure, see Token expiration and authentication.
If you need help, contact [email protected].