Connect the power of Excel to your Facebook ad accounts with FAME
Facebook Ads Manager for Excel automates your campaign reporting by downloading your ads performance data directly into Excel sheets.
Facebook advertisers frequently rely on the power of Excel to manage their ads accounts and evaluate performance, but exporting multiple Facebook accounts to an Excel worksheet takes time. With Facebook Ads Manager for Excel (FAME) you can quickly run a single report to download data from multiple ad accounts, helping you save time and work faster.
Downloading XLS or CSVs from multiple ads accounts and organizing metrics for custom reports takes a good deal of manual effort. And reports to evaluate ads data are requested with increasing regularity. While it is possible to develop customized reporting solutions using the Facebook Marketing API, these App based tools rarely provide the familiarity or flexibility of Excel.
Facebook Ads Manager for Excel, or FAME, allows advertisers to build their report templates in Excel and dynamically download rich performance data directly into sheets. Data can be combined from multiple Facebook ads accounts without manual integration . And information can be refreshed weekly, or as often as every 15 minutes, to ensure your data is always up-to-date.
FAME is available for free in the Microsoft Office Store. The FAME add-in seamlessly integrates with Excel 2016 to provide reporting capabilities.
Sign in with your Facebook account, and you’ll be able to create and download reports. Pre-designed templates help you quickly pull down common metrics, or customize your reports to deliver exactly what you need to know.
Facebook Ads Manager for Excel requires Microsoft Excel 2016. To download FAME from the Office Store complete the following steps:
Open Excel 2016 on your computer.
Click the [Insert] tab.
Click [Store] to go to the Office Store.
In the [Search] box, type “Facebook Ads Manager” and then click <MAGNIFYING GLASS ICON>. You should now see Facebook Ads Manager for Excel in the list.
Next to Facebook Ads Manager for Excel, click [Add].
How to AutoFit Cell Width and Height to Cell Data in Excel
Many times, our text doesn’t fit perfectly in Excel cells. To adjust the size without having to drag and find the ideal fit, a double-click can take care of it for you. With a quick click, you can AutoFit your cells so that your text fits comfortably within your spreadsheet, and doesn’t trail off into the next cell.
See the video demonstration above and steps below.
•In your spreadsheet, find the cells where the text doesn’t fit.
•Say for instance your text in cell C3 is cut off by the text in D3.
•Go to the column title bar. •Hover over the space between columns C and D.
•There is a thin grey line between the columns.
•A new icon should appear.
•While the icon is present, double click and your column will AutoFit the text in column C. It will jump and readjust.
To AutoFit your text in row, follow these same steps.
An Overview on how to Create Advanced Microsoft Dynamics CRM Online Reports using Microsoft Excel, Power Query and OData endpoint
By Ben Ward, Applications Analyst, MCTS, MCP, MS
Due to the cloud based nature of Microsoft Dynamics CRM Online, end users are not granted access to the backend SQL database (for a good reason which I will not go into now. Trust me, it’s long and pretty boring). This restriction to the SQL database makes pulling extensive reports a little more difficult than first thought. However, the good folks at Microsoft have provided an OData endpoint to be used with other products to allow extensive reports to be created. An OData endpoint is basically a URL for users to reference to access their data without permissions to manipulate the data with the SQL database. This ensures the data remains untouched inside the SQL database but users can download and access the data for other uses such as reporting.
Here is the high-level overview of how OData endpoints can be used:
The following example can be used to access your Microsoft Dynamics CRM Online OData endpoint:
[Your Organization Root URL]/XRMServices/2011/OrganizationData.svc
Once the OData endpoint has been referenced in Power Query, select the entities where the desire data resides and start editing the tables to fit your business needs. If you are familiar with SQL databases, Power Query editor will be very easy to use.
Note: Microsoft Visual Studio can also be used to access OData endpoints and create tables, which will be covered in another post.
About the author:
Ben has worked at Managed Solution for over two years and is currently working on CRM customization and administration, Microsoft SharePoint integration and customization as well as Business Intelligence analytics including SQL reporting. Ben is a Microsoft Certified Technology Specialist, Microsoft Certified Professional, Microsoft Specialist and has six Dynamic CRM certifications.
VIDEO: David McCandless, renowned data journalist and speaker, uses the world’s data to create powerful and provocative data visualizations and stories with Office.
Contact Us Today!
Chat with an expert about your business’s technology needs.
.png)
