Setting up a Facebook Ads report

Intro

Founded in 2004, Facebook has been the pioneer of the social media revolution. Starting out at Havard University as a student platform, it has expanded globally reaching over 2.8B monthly active users, and holding highly granular data points about our life habits and preferences. Facebook acquired Instagram in 2012 and is now among the most used platforms to reach and engage with your target audience.

In this short guide, we’ll walk you through everything you need to build a dynamic Facebook Ads report, that pulls data directly from Facebook into your spreadsheet.

Here’s a sneak peek at what you will get:

What is Facebook Ads

Facebook offers a wide range of options to set up your campaign through its Ad manager: you can choose among different types of ads (such as image, video, poll, carousel), goals (e.g. brand awareness, reach, traffic, engagement…), copy, budget and schedule, and so on.

To handle our FACEBOOK_ADS() functions proficiently, let's go through some definitions. Any Facebook Ad is structured in three parts:

• A campaign. Think of the campaign as the foundation of your advertising on Facebook. At this level, you choose the goal of the campaign, i.e. Promote your page
• An Ad set. A the Ad set level, you go more granular, defining the specs of your target audience: gender, countries, and age. You also set up your budget and bid.
• The single Ad. When creating the Ad, you choose the images, videos, text, and CTAs your target

That said, when the campaign is over, a report is provided on the Facebook Ads dashboard. But every time you need to analyze, compare or consolidate your data, you need to export it as .csv and import it on a spreadsheet.

Creating a summary campaigns report

To understand how we’re going to build it, let’s go step by step:

To start, you need to enable the Facebook Ads integration. Click on the Connect button and follow the instructions. The Facebook Auth page will open: enter your credentials and authorize Rows to retrieve your data.

Now you are ready to build your report. Click on the Create spreadsheet button at the top of your dashboard.

Once you land on your spreadsheet, first of all, rename it: click on its title in the top left corner and type the new name. Use it also as a title for the first page, by pasting it on the page title. It'll be easier to find it later on.

Rows allows you to have multiple tables on the same page, giving you a neat view of your data. Select cell A1, click on the Actions icon in the toolbar, and look for our FACEBOOK_ADS() functions: many are available, depending on which level you want to retrieve data from, for example: GET_CAMPAIGN_INSIGHTS_FACEBOOK_ADS(), GET_AD_SET_INSIGHTS_FACEBOOK_ADS() or GET_AD_INSIGHTS_FACEBOOK_ADS()

For the purpose of this guide, we will choose to retrieve data from campaigns. On the right-hand side of your display, the function wizard will show up. At the top, you can see the name of the integration you turned on in the first steps of this guide.

Let's go through the wizard together:

• Account name. Pick here your account name from the drop down list
• Filter for campaign. Use this field to filter results for a specific campaign. We will use it later on in the guide
• Set fields. These are the metrics you want to display in your report, for each campaign. E.g. ad_type, campaign_id, country, Impressions, CTR, Spend, CPC, CPM…
• Set breakdowns. These are the dimensions across which your campaign metric will be evaluated and broken down. For example, if you choose “device_platform”, you will get a breakdown of the user OS - mobile, desktop
• Set date range. Use it to filter your data within the specified time frame.
• Finally, the Aggregation_period. Choose how you want data to be aggregated, daily, weekly or monthly. We will use it later on when building a daily focus. You can choose 'month' or just leave it blank for now.

Clicking on the button Next step, Rows will guides you through the creation of the output table, to display all data retrieved from the integration. Choose the table headers from the first drop down, and hit Create Data Table.

You can rename the table's columns by simply double-clicking on the column label and following the instructions in the popup. In case you need to reorder the table's column, just click on the ... icon in the table's top right corner and drag and drop the headers

Creating a daily campaign report

If you followed all the above points, you have now a summary table showing aggregated metrics for each campaign run in the selected time frame. You might also be interested in having a daily focus on a single campaign: let's build it together!

Select cell A2 in the first table and click again on the Actions menu in the toolbar. Use the same function as before GET_CAMPAIGN_INSIGHTS_FACEBOOK_ADS(), filtering the view for a specific campaign and breaking down per day in the right-end panel, as follows:

Click on the button Next step, then choose the output table headers and hit Create a table.

To make your report shine, add a chart to display the daily trend of the main metrics. Select the whole daily table, then use the Insert menu and hit Chart. A chart will be displayed below the last table: using the usual ... menu, you can customize it - adding or removing series, titles, and colors

Embed into documents

Finally, if you are using Notion or any other internal tools that support iframes to build a report, you can embed any table or chart of this spreadsheet in your document. Just click on the ... icon in the top right corner of the table and pick Embed. A modal will open, as follows:

Before embedding any table or chart of a spreadsheet, you need to grant access to it. Follow the yellow message, and toggle on the Share privately option in the Share tab, as follows:

Once the spreadsheet's sharing option has been enabled, you just need to hit Copy URL from the Embed tab and paste the link into your document.

This is how Rows embed looks on Notion:

You might also like