PMG Digital Made for Humans

Becoming FAMEous: Streamline Reporting with Facebook Ads Manager for Excel

3 MINUTE READ | May 10, 2017

Becoming FAMEous: Streamline Reporting with Facebook Ads Manager for Excel

Author's headshot

Aaron Elkins

Aaron Elkins has written this article. More details coming soon.

Earlier this spring, Facebook announced the launch of Facebook Ads Manager for Excel, or FAME. So far, I haven’t seen a lot of conversation about this tool, which is a shame, as the tool itself has a lot to offer almost any social marketing team. FAME is a great starting point for automating routine reports, although it’s not without its flaws.

Compared to Facebook Ads Manager, FAME is quicker to set up, easier to templatize your reports, and simpler to add to existing excel tables. Setting up your Excel 2016 to use FAME is as easy as downloading it (You can download it from the Office Store), and connecting it to your Facebook account. It can be a little surreal seeing your Facebook profile picture in Excel however.

The ability to pull down one report across several business accounts is the most apparent advantage at this stage. If you have a client or company that separates out their Facebook accounts such as one account for Facebook posts and another for Instagram, all these different accounts can appear on one output.

Social Media, Twitter, Facebook, Iphone

From there, a user can take the raw data that FAME gives returns and cut-and-paste it into Excel. To save time, one you know what your output looks like, you can build a table that takes advantage of Excel’s Calculated Columns so fields like CTR and ROAS can be updated dynamically. This is also great if your table is connected to a pivot table.

As I said though, FAME is not without its flaws. It is possible that it won’t be an adequate long-term solution for some teams. One problem is that the data comes into excel as a raw data range, and loses its formatting whenever the data is refreshed. This means you can’t simply build FAME data like you would a table that’s connected to a data source, like Redshift or Oracle. Nor will your “Refresh All” button help you. The data pull must be manually refreshed, and then placed somewhere before it can be manipulated.

Stay in touch

Bringing news to you

Subscribe to our newsletter

By clicking and subscribing, you agree to our Terms of Service and Privacy Policy

Furthermore, there is limited data aggregation support. The fields available to you are the same fields available through the normal Ads Manager. Data aggregation and manipulation is still best done through downloading raw data at the ad or campaign level and building up-wards, and raw data must be saved somewhere, meaning users risk file sizes which can become quite crash prone if you’re working with years of data, nevermind the time it takes to download such large queries. Instead, most users will be better served taking advantage of Facebooks Insights API at that point, working with their developers to pull data in automatically and working with it in more traditional ways. Nonetheless, FAME still works as an excellent stop-gap while the API connections are built out.

Related Content

thumbnail image

Consumer TrendsSocial MediaPlatforms & MediaDigital Marketing

What You Need to Know About Facebook’s Latest Content Transparency Reports

4 MINUTES READ | August 30, 2021

thumbnail image

Social eCommerce is The Darling of Cyber Weekend

4 MINUTES READ | December 2, 2019

thumbnail image

Facebook Pixel Adds First-Party Cookie Option

3 MINUTES READ | November 1, 2018

thumbnail image

PMG Wins Five Honors at Digital Trading Awards

3 MINUTES READ | September 22, 2017

thumbnail image

PMG Shortlisted for Two UK-Based Awards

1 MINUTE READ | September 13, 2017

thumbnail image

Snapchat Releases New Measurement Tools

2 MINUTES READ | August 3, 2017

thumbnail image

Be Prepared

5 MINUTES READ | January 20, 2017