Import Campaign Spreadsheet

If available in your account, you can select the Import sub-link below the Campaigns tab to import the campaign spreadsheet. You may download the template in XML format in a MS Excel 2003 spreadsheet, or you can download the template in CSV format. The template file that you can download is used to record your campaigns, ad groups, keywords and ad information.

The spreadsheet also includes the following features to assist you in entering values in the spreadsheet cells:

Update only the columns you select by choosing ‘update: yes’ or ‘update: no’ options from the top row.
Select column options from cell dropdowns for columns with specific entry options (this feature is only available in the .XML format).
View tool-tips displaying help text beside each cell in the header row with descriptions of the cell and possible value entries (this feature is only available in the .XML format).
View an ‘in-sheet’ error message if your spreadsheet cannot be validated and requires changes (this feature is only available in the .XML format)

The columns that appear in the template file are explained in the chart below:

Column #	Column Name	Definition
A	Campaign Name	The unique name that you create to identify a campaign. This column must be filled out for every row in the spreadsheet.
B	Ad Group Name	The unique name that you create to identify an ad group. This column must be filled out for every row in the spreadsheet, except for the Campaign rows.
C	Component Type	A component type can be a campaign, ad group, ad, keyword, or ad group excluded word. Complete this column to indicate the component type for a particular row.
D	Component Status	Indicates the status of the component type entered in a particular row. When a component status is enclosed in square brackets, one of its parent component types has a deleted status. For example, a keyword row with status indicated as [On] means the keyword’s ad group or campaign is deleted. This column must be filled out for every row in the spreadsheet, except for rows with the component type specified as an ad group’ excluded word.
E	Display Status	Lists the Component Type display status.
F	Keyword	The keyword you are creating, editing or deleting. This column must be filled out for each row in the spreadsheet with the component type specified as “keyword.”
G	Keyword Alt Text	Alternate text defined for a keyword, which allows you to reword the keyword to better fit within the sentence structure of the title or description when using the Keyword Insertion feature for Sponsored Search and Content Match. This column must be filled out for each row in the spreadsheet with the component type specified as “keyword.”
H	Keyword Custom URL	Custom URL specified for a Sponsored Search keyword. This column may be filled out for rows where the component type is specified as “keyword.”
I	Sponsored Search Bid (USD)	This column is used when campaign optimization is OFF and will be blank if optimization is ON. The values include Default and {BID VALUE}. Default means that the default bid is in use. {BID VALUE} is the custom bid you specified. Please do not use "$" or "{" in the template file. Example: 1.35 This column may be filled out for rows with the component type specified as either “ad group” or “keyword.”
J	Sponsored Search Bid Limit (USD)	This column is used when campaign optimization is ON and will be blank if optimization is OFF. The values include Default and {BID LIMIT VALUE}. Default means the keyword is using the default bid limit. {BID LIMIT VALUE} is the custom bid limit you specified. Please do not use "$" or "{" in the template file. Example: 1.35 The campaign bid limit will not appear in this column. This column may be filled out for rows with the component type specified as either “ad group” or “keyword.”
K	Sponsored Search Min Bid (USD)	Displays the Sponsored Search minimum bid for your keyword.
L	Sponsored Search Status	Indicates whether Sponsored Search is on or off. This field may be filled out for rows with the component type specified as either “campaign” or “ad group.”
M	Match Type	Indicates whether the standard match type or advanced match type for Sponsored Search is on. Advanced means the advanced match type. Standard means the standard match type. This column may be filled out for rows with the component type specified as “campaign,” “ad group,” or “keyword.”
N	Content Match Bid (USD)	This column is used when campaign optimization is OFF and will be blank if optimization is ON. The values include Default, {BID VALUE}. Default means the default bid is in use. {BID VALUE} is the custom bid you specified. Please do not use "$" or "{" in the template file. Example: 1.35 This column may be filled out for rows with the component type specified as “ad group.”
O	Content Match Bid Limit (USD)	This column is used when campaign optimization is ON and will be blank if optimization is OFF. The values include Default and {BID LIMIT VALUE}. Default means the ad group is using the default bid limit. {BID LIMIT VALUE} is the custom bid limit you specified. Please do not use "$" or "{" in the template file. Example: 1.35 The campaign bid limit will not appear in this column. This column may be filled out for rows with the component type specified as “ad group.”
P	Content Match Min Bid (USD)	Displays the Content Match minimum bid for your ad group.
Q	Content Match Status	Indicates whether Content Match is On or Off. This field may be used in rows with the component type specified as either “campaign” or “ad group.”
R	Ad Name	Unique name that identifies an ad, for use in rows with the component type specified as “ad.”
S	Ad Title	Title that appears in the ad. Maximum length is 40 characters. This field may be filled out for rows with component type specified as “ad.”
T	Ad Short Description	Short description of the ad used in certain ad formats. Maximum length is 70 characters. This field may be used for rows with the component type specified as “ad.”
U	Ad Long Description	Long description of the ad used in certain ad formats. Maximum length is 190 characters. This field may be used for rows with the component type specified as “ad.”
V	Ad Display URL	The Display URL designated to appear with the ad, instead of the destination URL. Maximum length is 250 characters. This field may be used for rows with the component type specified as “ad.”
W	Ad Destination URL	The Destination URL is the landing page that is displayed when the ad is clicked. Maximum length is 1024 characters. This field may be used for rows with the component type specified as “ad.”
X	Watch List	A list of campaigns, ad groups, and keywords that may be of particular interest to you. The Watch List can be viewed from the Dashboard page. Values include On and Off.
Y	Campaign ID	A number that uniquely identifies a campaign. Please do not edit this value, as it is used when editing an existing campaign, ad group, ad or keyword.
Z	Campaign Description	Brief summary of the campaign. This appears in rows with the component type specified as “campaign.”
AA	Campaign Start Date	The first date that a campaign is scheduled to run, formatted depending on your market (e.g. MM/DD/YYYY).
AB	Campaign End Date	The last date that a campaign is scheduled to run, formatted depending on your market (e.g. MM/DD/YYYY).
AC	Ad Group ID	A number that uniquely identifies an ad group, included in rows with the component type specified as “ad group” and its associated ad and keyword rows. This column must be filled out for every row except those with the component type specified as “campaign.” Please do not edit this value.
AD	Ad Group: Optimize Ad Display	Indicates whether Optimize Ad Display is On or Off.
AE	Ad ID	A number that uniquely identifies an ad, for use when editing or deleting rows with the component type specified as “ad.” Please do not edit this value.
AF	Keyword ID	A number that uniquely identifies a keyword, used when editing or deleting rows with the component type specified as “keyword.” Please do not edit this value.
AG	Checksum	Internal value used to determine whether a row has been updated. Please do not edit this value.
AH	Error Message	This column may contain a system message returned in the Feedback File after an import is processed. Please do not edit this value.

Was this article helpful?

Thank you for your feedback.

Top Questions

More Help

Tools

Links

Ask Yahoo! Search Marketing Help
		Enter keywords to search help.