Use the Facebook Ads connector to stay up to date with your ad campaign performance. Collect ad reporting data from various sources on the same spreadsheet or dashboard to get the full picture.
Note
The Facebook Ads data source connector fetches Instagram ad data as well.
Before you begin
Before you build reports, you need to connect the data source to Supermetrics.
Connection instructions: See our Facebook Ads connection guide.
Available metrics and dimensions: Find the full list of fields in our Facebook Ads field documentation.
Popular queries
These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.
Track monthly ad spend year to date
See whether you're meeting your monthly ad budget goals throughout the year, with spend broken down by month for easy comparison.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Year to date |
Metrics | Amount spent |
Dimensions | Month |
Suggested visualization | Time series or bar chart |
Understanding the data
Amount spent: The total amount spent on your ad campaigns within the reporting period, in the currency used by your Facebook Ads data source.
Month: Splits results by month so you can compare spend across the year.
Note
You can convert the currency to other currencies in Google Sheets and Looker Studio. Learn more about currency conversion.
Review impressions and reach by campaign
See how many times your ads were shown and how many unique users saw them last month, broken down by campaign — useful for evaluating visibility and audience overlap.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last month |
Metrics | Impressions, Reach |
Dimensions | Campaign name |
Suggested visualization | Table |
Understanding the data
Impressions: The total number of times your ad was seen, including multiple views by the same person.
Reach: The number of unique individual users who saw your ad.
Campaign name: Splits results by campaign so you can compare visibility across campaigns.
Compare ad spend by campaign last month
See how much you spent on each campaign last month to identify where your budget is going and which campaigns may need adjusting.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last month |
Metrics | Amount spent |
Dimensions | Campaign name |
Suggested visualization | Bar chart |
Understanding the data
Amount spent: The total amount spent on your ad campaigns within the reporting period, in the currency used by your Facebook Ads data source.
Campaign name: Splits results by campaign for side-by-side spend comparison.
Break down impressions by platform and campaign
See how many times your ads were shown across Facebook and Instagram last week, split by platform and campaign, to understand where your ads are getting the most visibility.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last week |
Metrics | Impressions |
Dimensions | Publisher platform, Campaign name |
Suggested visualization | Bar chart |
Understanding the data
Impressions: The total number of times your ad was seen within the reporting period.
Publisher platform: The platform where the ad was shown, such as Facebook or Instagram.
Campaign name: Splits results further by campaign so you can see platform distribution per campaign.
Analyze conversion results by campaign
See how many website purchases your campaigns generated this month, so you can identify which campaigns are driving the most conversions.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | This month to date |
Metrics | Website purchases |
Dimensions | Campaign name |
Conversion window | Match to your ad campaign's attribution window. If campaigns have different attribution windows, select Default attribution. |
Suggested visualization | Table |
Understanding the data
Website purchases: The number of purchases completed on your website that are attributed to your ad campaigns.
Campaign name: Splits results by campaign so you can compare conversion performance.
Note
To change the conversion window, go to the Options section in the query settings. In Looker Studio, edit the connection details to change the settings. If you experience errors or data discrepancies, follow this guide to fix your queries.
See total website purchases across campaigns with multiple attributions
Get a single scorecard total for website purchases this month across campaigns that use different attribution windows, by using the Default attribution setting with unified attribution disabled.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | This month to date |
Metrics | Website purchases |
Conversion window | Default attribution |
Disable unified attribution setting | Enabled (check the checkbox in data source settings) |
Suggested visualization | Scorecard |
Understanding the data
Website purchases: The number of purchases completed on your website that are attributed to your ad campaigns.
Default attribution: Uses Facebook's default attribution window, allowing data from campaigns with different attribution settings to be aggregated without conflicts.
Disable unified attribution setting: When enabled, allows total purchase counts to be reported across campaigns with mixed attribution windows.
Note
To change the data source settings, go to the Options section in the query settings. In Looker Studio, edit the connection details to change the settings. If you experience errors or data discrepancies, follow this guide to fix your queries.
More resources
See the Supermetrics blog for tips for social media marketing funnel and other Facebook-related posts.
You might also be interested in: