Checklist: 19 Custom Ad Report Tasks for Advanced Facebook Advertisers

Facebook Ad Reports Checklist

[AUDIO VERSION: I also recorded an audio version of this blog post. Click below to listen. Let me know if this is something you find helpful!]

One tool that not nearly enough Facebook advertisers are using is the custom ad reports. No, not the default campaign reporting Facebook gives you. And simply clicking on the “Reports” link doesn’t cut it either.

In fact, once you click on that link within Ads Manager, you’ll get a default report that is pretty darn worthless…

Facebook Ad Reports Default

It’s a single report for every campaign you’ve been running for the past seven days, consisting of 17 columns worth of data. It’s not helpful.

But once you dig in — and I mean truly dig in — you’ll find gold. This is the information that will help you learn about what actually works and doesn’t work. And it will allow you to optimize your advertising for success.

I’m obsessed with Facebook ad reports, and I’m determined to make sure that other advanced advertisers use it. It’s why I made it one of the focuses of my FB Mastery Workshops.

If you haven’t used these custom ad reports yet, use this checklist to get started. Even if you have, it’s likely you haven’t done each of these 19 things…

[Tweet “Are you using Facebook custom ad reports to their full potential? Use this checklist of 19 tasks to try!”]

1. Edit Columns

To unlock the gold found within Facebook’s custom ad reports, click the “Edit Columns” button on the left…

Facebook Ad Reports Edit Columns

Then you’ll see a dialog that looks like this…

Facebook Ad Reports Edit Columns

2. Use Filters

Chances are good that when you run your reports — especially if it’s for more than a few days — they will include data for campaigns that you don’t want to see at that time. For example, if you create a report for website conversions, you won’t want to see results for campaigns that used the Page Likes objective.

This kind of stuff can be cleaned up by using filters. Click the “Add Filters” button next to the “Edit Columns” button…

Facebook Ad Reports Add Filters

You can create filters based on the following:

  • Campaign Name
  • Ad Set Name
  • Ad Name

Your filter can be that your campaign name, ad set name or ad name…

  • Contains
  • Does Not Contain
  • Is
  • Is Not

In other words, you are entering a name that is or isn’t in the campaign, ad set or ad name so that you can include only specific campaigns within your reports.

For example, I only want to see results for the Jon Loomer Digital page. So I add a filter for contains “Jon Loomer Digital” in the campaign name…

Facebook Ad Reports Add Filters

Or maybe I only want to see campaigns that were run for page likes, and I include the objective within my campaign titles (as you should!). I’d add a filter for contains “Page Likes” in the campaign name…

Facebook Ad Reports Add Filters

But what if I didn’t want results for any of my ad sets when targeting lookalikes? Well, I include the name of the target audience within the ad set name, so that’s easy. I’d add a filter for does not contain “Lookalikes” in the ad set name…

Facebook Ad Reports Add Filters

For any of these filters to work appropriately, you need to have a good naming convention for your campaigns, ad sets and ads. Be descriptive — and be consistent!

3. Save a Report

What can be annoying about Facebook’s ad reports is that you’ll customize a great report, but as soon as you leave that page you’ll lose everything. If you want that information again, you’ll need to completely recreate it.

That is, assuming you didn’t save it!

Once you’ve created a report that you think you’ll need later, click the “Save” button…

Facebook Ad Reports Save

Then name it something descriptive so you’ll remember what it is later…

Facebook Ad Reports Save

Then when you want to access it, simply click on the down arrow by “Reports” at the top to get a menu of saved reports (including some default reports that Facebook generates for you)…

Facebook Ad Reports Save

4. Share a Report

Now that you’ve saved a report, you can share it with a co-worker or client. Simply click the “Share” button at the top…

Facebook Ad Reports Share

You’ll then be given a link that you can copy and share with your colleagues.

Facebook Ad Reports Share

5. Schedule a Report

Maybe there is a report that you want emailed to you and your team on an ongoing basis. Click the “Schedule” button on the right…

Facebook Ad Reports Schedule

You can have your report emailed on a daily, weekly or monthly basis, starting on a date you determine.

Facebook Ad Reports Schedule

Enter everyone’s email address, and your entire team will receive this report when they need it!

6. View 2 Days Per Row

By default, Facebook will show you results for the past seven days. Each row will show all results by campaign, ad set or ad for that period.

Facebook Ad Reports Dates

An obscure little option here, though, is to view results by the following:

  • 1 day per row
  • 2 days per row
  • 7 days per row
  • All days

By default, Facebook is showing you all days. Click the “All Days” drop-down, though, and you’ll get the other options.

Facebook Ad Reports Dates

Let’s say that you’re only viewing the results for one campaign (no ad sets or ads) during the past 14 days. By default, you’d see only one row showing you all selected columns of data for that campaign during those 14 days.

But if you select “2 days per row,” each row will cover a different two-day period. You’ll get seven rows in all, helping you spot trends in performance!

7. Add Column for Ad Objective

I typically include the objective (page likes, clicks to website, website conversions, etc.) within the campaign name, but not everyone does that. What if you wanted to see this information within your report?

After clicking the “Edit Columns” button, check the “Ad Objective” box within Data Aggregation.

Facebook Ad Reports Objective

A column will then be added for your Ad Objective…

Facebook Ad Reports Objective

8. View Performance by Age

After clicking the “Edit Columns” button, go to Data Breakdowns. This is my favorite information found within Facebook ad reports!

By default, “None” is selected. But instead, select “Age.”

Facebook Ad Reports Data Aggregation Age

Facebook will now show a column for age so that you will be able to view results based on age group…

Facebook Ad Reports Data Aggregation Age

Facebook will then give you results for the following age groups (assuming they were reached with your advertising):

  • 13-17
  • 18-24
  • 25-34
  • 35-44
  • 45-54
  • 55-64
  • 65+

This can be very useful when determining your cost per conversion, for example, depending on the age of your audience. I know many advertisers will create different ad sets by age to split test, but thanks to Facebook ad reports this isn’t always necessary.

9. View Performance by Gender

You can also have Facebook generate a column for gender…

Facebook Ad Reports Gender

Facebook will then generate a column for gender…

Facebook Ad Reports Gender

Your results will now be split up, giving you rows for Male, Female and Other. This can be very useful when determining whether men or women respond more or less favorably to your advertising.

10. View Performance by Age and Gender

Sure, maybe you already determined that women respond best to your ads. And maybe you know that the 25-34 age group is your sweet spot. But that age group also includes men. You can split that out!

Have Facebook generate columns for age and gender…

Facebook Ad Reports Age and Gender

You’ll then get two new columns, one for age and one for gender…

Facebook Ad Reports Age and Gender

Your results will now be split up even further, giving you a row for each age group mentioned earlier for each gender (including Other).

11. View Performance by Country

Does performance of your ads differ by country? It’s very likely!

Have Facebook generate a column for country…

Facebook Ad Reports Country

In addition to getting a column indicating the country targeted, you will now get a separate row for each country to keep those results separate.

Facebook Ad Reports Country

Do you create different ad sets by country? You may not need to!

12. View Performance by Placement

If you don’t manually change your placement within ad sets, Facebook will show your ads across desktop news feed, mobile and right column. But do you ever wonder how your ads performed in each placement?

Some people will create separate ad sets to figure this out. But you don’t need to.

Have Facebook generate a column for placement…

Facebook Ad Reports Placement

Facebook will then break apart performance depending on where it was shown — one column per placement…

Facebook Ad Reports Placement

Placements include the following:

  • News Feed on Desktop Computers
  • News Feed on Mobile Devices
  • Right Column Ads on Desktop Computers
  • Right Column Ads on Home Page for Desktop Computers

As you can see, Facebook splits apart right column ads to differentiate between when your ads are shown on the home page (next to the news feed) and on all other pages.

13. View Cross-Device Performance

A nice addition that Facebook made recently was for cross-device reporting. Have Facebook add a column for cross-device…

Facebook Ad Reports Cross-Device

Note that this is mainly for conversion reporting. Some data will not be available for cross-device reports.

Facebook will then generate three new columns for cross-device reporting…

Facebook Ad Reports Cross-Device

What does this mean? Facebook is helping answer the following questions for you:

  1. On what device were users when they saw your ad?
  2. On what device were users when they converted?
  3. Are these results the same?

It’s quite possible that users are seeing your ad on a mobile device, but later converting from their desktop. This will help you see if that change is being made.

14. View Performance by Destination

You may want to break down performance based on destination. For example, maybe you split tested sending users to different landing pages within the same campaign. For example, maybe one ad went to a Facebook tab and another to your website.

Have Facebook add a column for destination…

Facebook Ad Reports Destination

Facebook will then show you results based on where users went after clicking your ad…

Facebook Ad Reports Destination

If they went to a page on your website, Facebook will pull the title from that page. Otherwise, it may be the name of your Facebook page or application.

15. Change the Attribution Window

Most advertisers don’t realize this, but Facebook reports actions (including conversions) as follows:

  • 1 day after viewing ad
  • 7 days after clicking on ad (previously 28)

So if you are running a campaign that tracks conversions, for example, Facebook will — by default — tell you how many people converted based on those settings. The definition of a “conversion” includes far more than users who clicked and immediately converted.

But this also includes things like page likes and website clicks. I’m fine with this for conversions in particular, but you can change this.

While viewing Actions within Edit Columns, you’ll see at the top that the attribution window is set as described above.

Facebook Ad Reports Change Attribution Window

Click the “Change Attribution Window” link.

Facebook Ad Reports Change Attribution Window

You’ll now have the following options (image created before removal of 28-day click attribution):

  • 1 day after viewing ad
  • 7 days after viewing ad
  • 28 days after viewing ad
  • 1 day after clicking on ad
  • 7 days after clicking on ad
  • 28 days after clicking on ad

Your results will then be split out depending on how many of the actions were performed within those attribution windows.

Facebook Ad Reports Change Attribution Window

One of my page like campaigns broke down as follows:

  • 1 day after viewing ad: 5
  • 7 days after viewing ad: 5
  • 28 days after viewing ad: 5
  • 1 day after clicking on ad: 310
  • 7 days after clicking on ad: 311
  • 28 days after clicking on ad: 311

To help you understand this, note that this campaign generated 316 total page likes. So while 310 people liked my page within 1 day of clicking my ad, 311 did within 7 and 28 days. That just means that one more person liked my page within a day or more following that first click.

[adrotate banner=”43″]

16. Create a Page Likes Report

You should know your way around these ad reports now, so it’s time that you create some saved reports that you can put to good use.

Use the following base settings for a Page Likes report:

  • Add Filter: Campaign Name Contains “Page Likes”
  • Delivery & Spend: Amount Spent
  • Actions: Page Likes
  • Cost Per Action: Cost Per Page Like

In order for the filter to work, of course, you’ll need to use a naming convention that includes the objective within the campaign name.

Note that this is a base report — it is as basic as can be so that you aren’t distracted unnecessarily by metrics that may not matter.

Of course, you may want to add on data aggregation columns and a few others later. But I like to start with the base and then edit my saved report later.

Some other columns you may need:

  • Data Aggregation: Ad Set Name
  • Data Aggregation: Ad Name
  • Delivery & Spend: Frequency
  • Delivery & Spend: Cost Per 1,000 Impressions

17. Create a Clicks to Website Report

Use the following base settings for a Clicks to Website report:

  • Add Filter: Campaign Name Contains “Clicks to Website”
  • Delivery & Spend: Amount Spent
  • Actions: Website Clicks
  • Cost Per Action: Cost Per Website Click

Once again, this is very basic to start and the filter will only work if you include the objective within the campaign name. Some other columns you may need:

  • Data Aggregation: Ad Set Name
  • Data Aggregation: Ad Name
  • Delivery & Spend: Frequency
  • Delivery & Spend: Cost Per 1,000 Impressions
  • Actions: Website Conversions

Even though these ads weren’t run with the objective of a website conversion, I often track them anyway.

18. Create a Video Views Report

Use the following base settings for a Video Views report:

  • Add Filter: Campaign Name Contains “Video Views”
  • Delivery & Spend: Amount Spent
  • Actions: Clicks to Play Video
  • Cost Per Action: Cost Per Clicks to Play Video

Once again, this is very basic to start and the filter will only work if you include the objective within the campaign name. Some other columns you may need:

  • Data Aggregation: Ad Set Name
  • Data Aggregation: Ad Name
  • Delivery & Spend: Frequency
  • Actions: Video Views
  • Actions: Average Duration of Video Viewed
  • Actions: Average Percentage of Video Viewed
  • Actions: Website Clicks
  • Actions: Website Conversions

When running Facebook video ads, you may be using a CTA button that drives users to a website to perform a conversion. In that case, you may need more columns.

19. Create a Website Conversion Report

Use the following base settings for a Website Conversions report:

  • Add Filter: Campaign Name Contains “Website Conversions”
  • Delivery & Spend: Amount Spent
  • Actions: Website Conversions
  • Cost Per Action: Cost Per Website Conversion
  • Revenue: Website Conversion Value

Once again, this is very basic to start and the filter will only work if you include the objective within the campaign name. Some other columns you may need:

  • Data Aggregation: Ad Set Name
  • Data Aggregation: Ad Name
  • Delivery & Spend: Frequency
  • Delivery & Spend: Cost Per 1,000 Impressions
  • Clicks: Click-Through Rate (CTR)
  • Actions: Website Clicks

I’ll occasionally include CTR and Website Clicks to help me determine if there’s a disconnect between my ad and the landing page.

Your Turn

Note that I’m focusing on the core uses for Facebook ad reports. If you have a mobile app, desktop app, Facebook offer or event, the types of reports will vary.

Any other tasks you’d add to this checklist? Let me know in the comments below!