Columns in the import/export template in Ads Manager

30/11/2019

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.