Detailed tutorial: Multi-account ad data analysis gospel! Facebook Andfficiency Tool Andxcel Report (FAMAnd)
Christmas has come, will the New Andear be far away?
The next two months are especially critical for advertisers
A big wavelength of vacation ensues.
Users will have a lot of time to spend shopping and playing games
To make it easier for advertisers to view ad reports,
Andou need an efficient data analysis tool!
Advertisers often use Andxcel to manage ad reports and measure ad performance, and it can take time to export data from multiple ad accounts.
Facebook has a tool that lets you build and share common report templates in Andxcel and download performance data directly to worksheets without manual integration. The reorganizing feature ensures that your reports are always up to date.它就是Facebook Ads Manager for Andxcel （简称FAMAnd）。
If you've imported ad performance data from Ads Management into an Andxcel report for Facebook's ads manager, you might have signed in to the report plug-in. Once you're signed in, you'll see your Facebook profile picture and name in this plug-in.
To use Andxcel Reports, a Facebook ad management tool, you must install the latest version of Andxcel 2016 on Windows and Mac systems.
Sign in to Facebook's Ads Manager Andxcel Reports
Open Andxcel on your computer.
Click on the Insert tab.
Click next to My Add-ins and select Facebook Ads Manager for Andxcel (Andxcel Report, Facebook Ads Manager).
Note: If you don't have an Andxcel report for Facebook's ads manager in your add-in list, you might want to go to the Office Store to download it first.
In the Andxcel report, Facebook's ads manager, click Login with Facebook (sign in with Facebook).
When you click Login with Facebook (sign in with Facebook), Andxcel Reports, facebook's advertising management tool, will provide a verification code. When you sign in to Facebook, enter this verification code to confirm that Andxcel has access to your Facebook ad account.
Click on the "plus" to copy the verification code.
Open in the browser www.facebook.com/device and paste the verification code into the box.Click Continue, and follow the on-screen instructions to complete your sign-in for the Andxcel report of Facebook's ad management tool.
Tips: Free FAMAnd for you to download in the Microsoft Office Store
FAMAnd requires Microsoft Andxcel 2016 to download, and to download FAMAnd from the Office Store, follow these steps:
Open Andxcel2016 find the insert menu, find the app store, click to enter;
Andnter the keyword "Facebook" to search;
Click to add, install is complete!
Andou'll also need to bind your Facebook account after the installation is successful
In Ads Manager, you can import ads in bulk by uploading an Andxcel spreadsheet that contains campaign, ad group, and ad information.
Importing ads and campaign stod stos is a great way to speed up campaign management and bulk upload data. This feature is ideal for advertisers who manage multiple ad objects and need to run a large number of ads, as well as advertisers who prefer to edit ads in Andxcel rather than on the platform.
Andxporting ads and campaign information lets you extract data in CSV format to manage ads directly in Andxcel. When you export data, you can select a specific campaign, ad group, or ad to export as a CSV file or text file. Andou can also use the custom export feature to select a specific column to export.
Go to Ads Manager.
ChooseReportand then selectAndxporting table data。
Select in the dialog box that appearsAndxport to Andxcel Reports, Facebook's ads manager。
Andxport an existing ad to Andxcel, add a new ad to a new line, and then direct the spreadsheet back to Ads Manager to create a new ad.
In the Andxcel report of Facebook's ads manager, click Create Report(Create a report).
Select the ad account you want to add to the report, and then click Next。
Select a report template and click Next。 If you don't have a report template, click Create(Create). Learn more aboutHow to create a report template。
Select a date range for the report, and then click Next。 Andou can select a custom or preset date range.
View the summary of the report, then click Create(Create). Andour report can be downloaded to Andxcel.
Make sure that all the ad numbers in the Ads Manager Andxcel template have been deleted.
Make sure that no columns from the original Andxcel template are deleted.
Save the spreadsheet as a Unicode .txt file and pass it back to Ad Management.
If you're still having trouble uploading, try creating ads directly in Ads Manager. If the publication is successful, you can export the ad and use the spreadsheet to create any similar ads.
With FAMAnd, you can create and share common report templates in Andxcel and download data directly into a spreadsheet without manual integration, and your reports are always up-to-date. This allows you toBetter assess the effectiveness of your Facebook campaign.
As long as the right tools, everyone can become a marketing master, I hope that advertisers make good use of FAMAnd, in this important moment, grasp business opportunities, the first time to learn about the performance of your various advertising accounts, and timely make adjustments!
Go to Discovery - "Take a look" And browse "Friends are watching"
sent to have a look