This website uses cookies to ensure you get the best possible experience. See our Cookies Policy.

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

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.

Insights meet inbox

Sign up for weekly articles & resources.

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.


Posted by Aaron Elkins

Related Content

Get Informed

Facebook Details Approach to Mobile Industry Changes

4 MINUTES READ | August 31, 2020

Get Informed

Social eCommerce is The Darling of Cyber Weekend

4 MINUTES READ | December 2, 2019

thumbnail image

Get Informed

Facebook Pixel Adds First-Party Cookie Option

3 MINUTES READ | November 1, 2018

Get Informed

PMG Wins Five Honors at Digital Trading Awards

3 MINUTES READ | September 22, 2017

Get Informed

PMG Shortlisted for Two UK-Based Awards

1 MINUTE READ | September 13, 2017

thumbnail image

Get Informed

Snapchat Releases New Measurement Tools

2 MINUTES READ | August 3, 2017

thumbnail image

Get Informed

Acquiring Placed: Snapchat’s Segue Into Location Measurement

2 MINUTES READ | June 12, 2017

Get Informed

Be Prepared

5 MINUTES READ | January 20, 2017

All POST