Bulk import or export ads with Ads Manager

30/11/2019

These articles refer to bulk import/export in the updated Ads Manager. This feature is useful if you need to create or edit a large number of ads and if you prefer to use Excel while you work.

Get started

About importing and exporting ads

In the updated Ads Manager, you can bulk import and export ads by uploading an Excel spreadsheet with campaign, ad set and ad information. This feature is ideal for advertisers who manage many objects and need to run a large number of ads, as well as advertisers who prefer to edit their ads in Excel, rather than on the platform.

What is supported:

~2 MB file limit
List of available columns

Importing

Importing ad and campaign information is a great way to speed up campaign management and bulk upload data. You can either upload an Excel spreadsheet with your data or you can export your ad data as a spreadsheet, manage your ad data on Excel and then upload it on the updated Ads Manager. You have the option to bulk import images as well.

The template is an Excel spreadsheet that lists the available columns, making it easy to input your data and upload it to Ads Manager. Learn about the different columns that you can upload with the bulk import feature.

Exporting

Exporting ad and campaign information enables you to pull your data in CSV format, so that you can manage your ads directly through Excel. This makes it easier to scale ad creation and management, and doesn't limit you to the platform.

Permalink · Share

Export ads

When exporting data, you have the option to select the specific campaigns, ad sets or ads that you wish to export as a CSV or text file. You can also select the specific columns that you wish to export with the Customise export feature. Additionally, you'll see different options in your spreadsheet if you export ads that are using dynamic creative or placement asset customisation.

Steps:

At the campaign, ad set or ad level, click on the Import/Export icon
Click Export all to export all of your ad data at once. You also have the option to select specific campaigns, ad sets or ads that you want to export as a CSV or text file with Export selected and Export selected as text (Ctrl+Shift+C).
- If you want to export specific columns, choose the Customise export feature.

Dynamic creative:

If you export ad sets that are using dynamic creative, you will see the following additional asset columns in your Excel file:

"Additional Image {index} Hash" (1-9)
"Additional Image {index} Crops" (1-9)
"Additional Video {index} ID" (1-9)
"Additional Video {index} Thumbnail URL" (1-9)
"Additional Title {index}" (1-4)
"Additional Link Description {index}" (1-4)
"Additional Body {index}" (1-4)
"Additional CallToAction {index}" (1-4)

There will also be a new column called "Use Dynamic Creative" which will automatically be ticked as "yes" if you export ad sets that are using dynamic creative. When importing ad sets, you will need to set the "Use Dynamic Creative" column to "yes" in order to create a dynamic creative ad set, otherwise the additional assets uploaded will be ignored.

Placement Asset Customisation:

If you export ad sets that are using Placement Asset Customisation, you will see the following placement columns in your Excel file:

"Additional Image {index} Hash" (1-9)
"Additional Image {index} Crops" (1-9)
"Image Placement"
"Additional Image {index} Placement" (1-9)
"Additional Video {index} ID" (1-9)
"Additional Video {index} Thumbnail URL" (1-9)
"Video Placement"
"Additional Video {index} Placement" (1-9)

When importing PAC ads, it will pair the asset column with the placement column (for example, "Additional Image 1 Hash" and "Additional Image 1 Placement"). The placement columns require comma-delimited data for PAC to work.

Example:

Once you export, the file will be downloaded to your computer. Once you've finished managing your ad data, you can import the file back into Ads Manager.

Learn more:

Learn how to import ads.
Learn about import/export best practices.
Learn about troubleshooting import/export.

Permalink · Share

Import ads

Steps:

At the campaign, ad set or ad level, click on the Import/Export icon
Click Import ads in bulk. You will have the option to paste text or upload an Excel file with your campaign, ad set and ad information. You have the option bulk import images and videos at this step as well.
Once you've imported your spreadsheet, you'll see a summary of which information was imported, including any warnings, as well as any blocking errors that prevented information from being imported.
If you see any blocking errors, click View details. This will specify what was wrong and how to fix it. Take a look at the import/export error message guide for help with any errors that you encounter.

Learn more:

Learn how to export ads.
Learn about import/export best practices.
Learn about troubleshooting import/export.

Permalink · Share

Best practices for importing ads in Ads Manager

When you work on campaigns that you have exported in spreadsheets from Ads Manager, the field names and column names in the import/export spreadsheet do not match what you see in Ads Manager. Below is a mapping of field names to spreadsheet column names ( field name → spreadsheet column name) between Ads Manager and the import/export spreadsheet. These mappings apply to fields that appear in the ad creative section, not in audiences or optimisation.

Note: Leave the Story ID column blank when using the ad fields below. Otherwise, Ads Manager will ignore the values that you provide for your ad creative and use the Page post specified by your Story ID instead. Please also set the Creative type column as Page Post Ad.

Traffic and conversions

Facebook Page → Link Object ID (use format o:123456789 where 123456789 is the ID of your Page)
Website URL → Link
Text → Body
Headline → Title
Link Description → Link Description
Display Link → Display Link
Image → Image Hash (use format 13e564b42dd6329a6942a152aef7674d or 123456789:13e564b42dd6329a6942a152aef7674d where 123456789 is the ad account ID where the image is stored). Use the Image column instead of Image hash to provide the filename of an image that will be included when uploading your spreadsheet.
Call to Action → Call to Action (corresponding values listed below)
- Book Now → BOOK_TRAVEL
- Download → DOWNLOAD
- Learn More → LEARN_MORE
- Shop Now → SHOP_NOW
- Sign Up → SIGN_UP

Engagement (Post Engagement)

Facebook Page → Link Object ID (use format o:123456789 where 123456789 is the ID of your Page)
Text → Body
Image → Image Hash (use format 13e564b42dd6329a6942a152aef7674d or 123456789:13e564b42dd6329a6942a152aef7674d where 123456789 is the ad account ID where the image is stored). Use the Image column instead of Image hash to provide the filename of an image that will be included when uploading your spreadsheet.

Video views

Facebook Page → Link Object ID (use format o:123456789 where 123456789 is the ID of your Page)
Text → Link Description
Video → Mobile App Video (use format v:123456789 where 123456789 is the ID of your video)
Video Preview → Video Thumbnail URL (this is an image URL generated by Facebook after selecting a custom thumbnail)
Website URL → Link
Display Link → Display Link
Call to Action → Call to Action (corresponding values listed below)
- Book Now → BOOK_TRAVEL
- Download → DOWNLOAD
- Learn More → LEARN_MORE
- Shop Now → SHOP_NOW
- Sign Up → SIGN_UP
- Watch More → WATCH_MORE

Event responses

Facebook Page → Link Object ID (use format o:123456789 where 123456789 is the ID of your Page)
Event → Link (the URL for your Facebook event)
Text → Body

Permalink · Share

Columns in the import/export template in Ads Manager

Bear in mind that the columns that are in the import worksheet do not completely match the columns that you see in Ads Manager. Learn how to download the import template in Ads Manager.

The columns in the import/export template in Ads Manager are:

Ad level

Ad ID

The ID number for the ad. If you're creating a new ad, leave this blank.

Format	Required?
	This is required for editing ads.

Ad name

The name of the ad.

Format	Required?
There's a 35-character limit.	This is required.

Ad status

The run status of an ad. If you're editing the status of your ad, make sure that your campaign status is the same as your ad status. For example, if your ad status is set to On, the campaign status should also be set to On.

Format	Required?
On, Off	The run status should be correlated between ad, ad set and campaign.

Body

The body copy for your ad.

Format	Required?
There's a 90-character limit for right column ads, and a 500-character limit for News Feed ads. The body copy must adhere to the ad guidelines.	This is required.

Creative type

The type of ad you're creating or editing.

Format	Required?
	This should say "Page post ad" to be shown everywhere. You'll also need to enter the Page ID in the "Link object ID" column. This should say "Standard" if you only want to run a right column ad.

Display link

The shorter, friendlier URL that's shown instead of a long website address.

Format	Required?
www.example.com (http://www.example.com/)	This is optional.

Image

The image file name and file extension.

Format	Required?
Image file name (e.g. image1.jpg).	This is required.

Image hash

The unique identifier of the image for your ad. The image hash will appear in the exported file only after the image has been uploaded to the account.

Format	Required?
	This is only required when you're making edits to ads.

Link

The destination URL.

Format	Required?
A complete URL.	This is required if you want to link to an external website.

Link description

Additional text that's used to emphasise why someone may want to visit your website. Link descriptions only appear in News Feed.

Format	Required?
	This is required.

Story ID

The ID number associated with the specific post.

Format	Required?
The story ID.	This is required if you're setting up a Page post ad or if you want to use an existing post.

Title

The title copy for your ad.

Format	Required?
There's a 25-character limit, and the title must adhere to the Facebook ad guidelines.	This is required.

URL tags

The way you identify what traffic is coming from specific ad campaigns you're running by letting you know which link a person clicked to get to your ad destination.

Format	Required?
Key1=value1&key2=value2	This is optional.

Ad set level

Ad set daily budget

The daily budget for your ad set.

Format	Required?
X.XX (a currency symbol isn't required)	A daily budget is only required if you're creating a new ad set that you want to use a daily budget for. You must either have a daily budget or a lifetime budget for your ad set.

Ad set ID

The ID number of the ad set.

Format	Required?
Standard numbering format; don't use decimals or commas	Yes, if you're editing an existing ad set. If you don't specify an ad set ID, we'll try and match the ad set ID by the ad set name. If we can't find the ad set name, we'll create a new ad set ID with the specified name. Leave this blank if you're creating a new ad set.

Ad set lifetime budget

A lifetime budget for your ad set.

Format	Required?
X.XX (a currency symbol isn't required)	A daily budget is only required if you're creating a new ad set that you want to use a daily budget for. You must either have a daily budget or a lifetime budget for your ad set.

Ad set name

The name of the ad set.

Format	Required?
35-character limit	An ad set name is recommended for new and existing ad sets. If this is an existing ad set, we'll try to match it with its ad set ID. If we can't find an existing ad set ID with the same name, we'll create a new ad set.

Ad set status

Whether the status of your ad set is active or paused. The status of your ad set should be the same as your ad. For example, if your ad is set to "active" and your ad set is set to "paused", your ad won't be able to run because it's part of an ad set that's paused.

Format	Required?
Active; Paused	The run status of your ad set is recommended.

Ad set time start

The date and time you want your ad set to start running. You should enter a value if you're creating a new ad set or an existing ad set (if the start time is later than the current time).

Format	Required?
MM/DD/YY HH:MM	If you don't want your ad set to run automatically once it's live, add in the date and time that you want it to start. If you specify a future start date, leave the ad set status and ad status columns blank.

Age max.

The maximum age you want to target. The oldest age you can target is 64. If you don't enter a maximum age, we'll default the maximum age to 64.

Format	Required?
Standard number format	A maximum age is optional.

Age min.

The minimum age you want to target. The lowest age you can target is 13. If you don't enter a minimum age, we'll default the minimum age to 13.

Format	Required?
Standard number format	A minimum age is optional.

Application ID

The ID number of the application. You can find the ID number of your application on the Facebook developer site: https://developers.facebook.com/. Bear in mind that you'll need to register your app before you can run any ads for it.

Format	Required?
The application ID.	This is only required for app install ads and app engagement ads.

Bid amount

The maximum amount you are willing to pay per action taken on your ad.

Format	Required?
X.XX (no currency symbol)	A bid amount is required for CPC and CPM ads.

Billing event

The maximum amount you are willing to pay per action taken on your ad.

Format	Required?
Use one of the following: APP_INSTALLS, OFFER_CLAIMS, LINK_CLICKS, PAGE_LIKES, POST_ENGAGEMENT, IMPRESSIONS or VIDEO_VIEWS.	The amount you are charged based on the actual results of your optimisation goals in the ad auction.

Broad category clusters

The broad categories from the targeting section that you want to target.

Format	Required?
Find the ID and names of each broad category by creating an ad in Ads Manager (don't publish it) with the broad categories that you want selected, and export the ad to Excel. [ID]:[Broad Category Name].	This is optional.

Cities

The cities you want your ad set to target. Don't indicate a city if you want to target multiple countries or if you want to target all cities in a country.

Format	Required?
Use a semicolon between cities (e.g. London, England; Edinburgh, Scotland)	City targeting is optional.

University end year

Target people who finished university in a specific year. Leave this field empty to target all.

Format	Required?
YYYY (e.g. 2007)	A university end year is optional.

University start year

Target people who started university in a specific year. Leave this field empty to target all.

Format	Required?
YYYY (e.g. 2007)	A university start year is optional.

Connections

Target people who are already connected to your group, Page or app.

Format	Required?
Use the ID for the group, Page or app. To target multiple objects, separate the ID numbers by commas.	This is optional.

Countries

The countries you want your ad set to target. If you want to target multiple countries, don't specify a region or city.

Format	Required?
ISO country code (e.g. GB for the United Kingdom)	Country targeting is required.

Custom Audiences

Target a Custom Audience.

Format	Required?
Find the ID and Custom Audience name by creating an ad in Ads Manager(don't publish it) with the Custom Audiences that you want to target, and export the ad to Excel. [ID]:[Custom Audience Name], separate each Custom Audience with a comma: 123:Customers, 321:Other customers	This is optional.

Education status

The education degree and status you want to target your ad set to. Leave this field empty to target all.

Format	Required?
Use a comma to separate degree statuses (e.g. University graduate, Doctoral degree)	An education status is optional.

Excluded connections

Target people who are not already connected to your group, Page or app.

Format	Required?
Target people who are not already connected to your group, Page or app.	This is optional.

Excluded Custom Audiences

Custom Audiences you don't want to show your ad to.

Format	Required?
Find the ID and Custom Audience name by creating an ad in Ads Manager (don't publish it) with the Custom Audiences that you want to target, and export the ad to Excel. [ID]:[Custom Audience Name], separate each Custom Audience with a comma: 123:Customers, 321:Other customers	This is optional.

Excluded video engagement

This column targets people who don't engage with your videos.

Required?
No.

Friends of connections

Target people who are not already connected to your group, Page or app.

Format	Required?
Use the ID for the group, Page or app. To target multiple objects, separate the ID numbers by commas.	This is optional.

Gender

The gender you want to target. Leave this blank if you want to target all genders.

Format	Required?
Men, women	Specific gender targeting is optional.

Interested in

Target the genders that your target audience is interested in. Leave this field empty to target all.

Format	Required?
Use a comma to separate genders (e.g. men, women).	This is optional.

Link object ID

The ID number associated with your Page or event. To find your Page or event's ID number, click on the "Edit Page" link and copy and paste the string of numbers at the end of the web URL. This is normally a string of at least eight digits that can be found in your web address bar.

Format	Required?
The Page ID or event ID.	This is only required if you choose a "fan" or "rsvp" creative type.

Locales

The languages you want to target your ad set to.

Format	Required?
Use a comma to separate languages.	This is optional.

Max. bid

The max bid you want to use for CPC or CPM ads.

Format	Required?
X.XX (no currency symbol).	A max. bid is required for CPC and CPM ads.

Optimisation Goal

The goal of your ad set (e.g. Page likes).

Format	Required?
Choose one of these options: IMPRESSIONS, APP_INSTALLS, PAGE_LIKES, OFFER_CLAIMS, LINK_CLICKS, POST_ENGAGEMENT, CLICKS, BRAND_AWARENESS, EVENT_RESPONSES, LEAD_GENERATION, OFFSITE_CONVERSIONS, PAGE_LIKES, REACH or VIDEO_VIEWS.	An optimisation goal is required.

Regions

The regions you want your ad set to target. Don't indicate a region if you want to target multiple countries or if you want to target all regions in a country.

Format	Required?
Enter the full name of the region or state. Use a comma between regions.	Region targeting is optional.

Relationship

Target people with a relationship status indicated in their profiles. Leave this field empty to target all.

Format	Required?
Use a comma to separate relationship statuses (e.g. single, relationship, engaged, married).	This is optional.

Video engagement

This column targets people who engage with your videos.

Required?
No.

Postcode

The postcode of the regions you want your ad set to target.

Format	Required?
Use a comma between postcodes. Please only enter valid postcodes for the countries you're targeting.	Postcode targeting is optional.

Campaign level

Buying type

The way you want to pay for your ad campaign. You'll use "Auction" to pay for your ad campaigns based on your target audience and duration.

Format	Required?
Auction, Fixed.	Yes (for new campaigns).

Campaign ID

The ID number of the campaign.

Format	Required?
Standard numbering format (don't use decimals or commas).	Yes, if you're editing an existing campaign. If you're creating a new ad, leave this blank. If you're editing an existing ad, a campaign ID is required. If you don't specify a campaign ID, we'll try and match the campaign ID by the campaign name. If we can't find the campaign name, we'll create a new campaign with the ID you've included.

Campaign name

The name of the campaign.

Format	Required?
35-character limit.	No, but a campaign name is recommended for new and existing campaigns. If you're editing an existing campaign, we'll try to match its name with its campaign ID. If we can't find an existing campaign ID with the same name, we'll create a new campaign.

Campaign objective

The advertising goal you want to optimise for in your campaign.

Required?: Yes (for new campaigns).

Format:

Brand Awareness
Traffic
Conversions
Lead Generation
Page likes
Page Post Engagement
Desktop app installs
Mobile app installs
Desktop app engagement
Mobile app engagement
Offer claims
Product Catalogue Sales
Event responses
Local Awareness
Reach
Store Visits
Video Views

Campaign spend limit

Maximum campaign spending limit.

Format	Required?
Standard numbering (decimals up to two points). The currency symbol isn't necessary.	No, but it's recommended.

Campaign Status

Shows whether your campaign is active or paused.

Format	Required?
Active; Paused.	No, but it's recommended.

Download a blank import template

Because you will be creating new ads that haven't run yet, the template includes fewer columns than when you export a set of ads or campaigns that you have already created.

Go to Ads Manager and click on either the Ads, Ad sets or Campaigns tabs.
Click Download template.
An Excel file will download to your computer. Edit this file to make changes to your campaigns, and save the file to your computer. You will need to upload the file to apply your changes to your account.

Export campaigns in a spreadsheet

Go to Ads Manager and click on either the Ads, Ad sets or Campaigns tabs.
To edit a set of ads, ad sets or campaigns that you're currently working on, select the rows that you want to edit and click either Export selected or Export all to download everything in this account.
An Excel file will download to your computer. Edit this file to make changes to your campaigns, and save the file to your computer. You will need to upload the file to apply your changes to your account.

Get more guidance on editing exported campaigns.

Permalink · Share

Use Excel

Edit ads in Ads Manager using Excel

You can make changes to multiple campaigns, ad sets and ads with Excel by using Ads Manager's export and import features by uploading files or by copying and pasting info.

Upload Excel files

Click Campaigns, Ad sets or Ads.
If you want to edit a specific group of campaigns, ad sets or ads, tick the boxes next to each one. If you want to edit all of your campaigns, ad sets or ads, you won't need to tick any boxes.
Click , then select either Export selected or Export all.
Open the Excel spreadsheet that you exported from Ads Manager and make any changes necessary. Bear in mind that you can change any of the fields except for Ad ID, Campaign ID and Image hash.
Save the changes in your Excel spreadsheet and then go back to Ads Manager.
Click and then select Import ads in bulk.
In the Bulk import window, click Choose file. Choose your saved Excel file from your computer and then click Import.
When the file finishes uploading, click Close.
Click Review Changes to publish your changes.
Check the items that you want to publish and then click Continue.

Copy and paste

Click Campaigns, Ad sets or Ads.
If you want to edit a specific group of campaigns, ad sets or ads, tick the boxes next to each one. If you want to edit all of your campaigns, ad sets or ads, tick the box at the top of the column to auto-select all items.
Press Ctrl + Shift + C on your keyboard.
In the Export as text window, press Ctrl + C (on PC) or Cmd + C (on Mac) to copy the text, and then click Close.
Click and then select Import ads in bulk.
Under Bulk import, select Paste text from tab separated document.
Press Ctrl + V (on PC) or Cmd + V (on Mac) to copy the text into the field and then click Import.
When Ads Manager finishes uploading the text, click Close.
Click Review Changes to publish your changes.
Check the items that you want to publish and then click Continue.

Troubleshooting

Here are some tips to help you import changes in Ads Manager:

Best practices for importing in Ads Manager
Troubleshooting issues with bulk import updates to existing ads
Troubleshooting issues with bulk importing new ads using a custom Excel spreadsheet
Troubleshooting issues with bulk importing new ads into the Ads Manager Excel template

Permalink · Share

Create a new ad in Excel

Create new ads in Excel by exporting existing ads, adding new ads as new rows and then importing your spreadsheet back to Ads Manager

Select ads or campaigns from the Ads or Campaigns view in the main pane, click Export & import, and select Export selected. An Excel file will download.
Open and save the downloaded file on your hard drive before adding new ads. This file will show you data about the ads that you selected, or all of the ads belonging to the campaigns that you selected.
Add a new row in the spreadsheet and fill in each column except for the Ad ID for each new ad that you want to create. If you want to create new ads within a new campaign, you should also leave the Campaign ID and Campaign name blank. Save the file.
Click Export & import in Ads Manager, and select Import ads in bulk. You can also copy the spreadsheet using Ctrl+C or Command+C, click in Ads Manager, select Import → Paste into text area, then paste using Ctrl+V or Command+V.
Using the Image upload functionality of the Import ads in bulk button, add your pictures one by one or by uploading a zip file. Please make sure that your pictures' names match the names that you entered in your Excel spreadsheet in the Image column.

Permalink · Share

Troubleshoot

If you are running into issues or error messages while importing or exporting ads, read the troubleshooting guide.

More resources

* Nguồn: Facebook