To create and update Yandex campaign data in bulk, you can use Search, Social, & Commerce bulksheet files formatted specifically for Yandex accounts. You can either a) generate bulk sheet files for existing accounts in the required file format or b) create them manually (see “Supported Bulksheet File Formats” for general information about the supported file formats).
Each bulksheet must include the header fields and corresponding data fields required for the specific operations you want to perform (such as creating an ad). When a field isn’t required, you can omit it from the header and data rows. All custom columns are deleted when you upload the bulk sheet file.
The following are the available header fields and descriptions of the corresponding data fields, as well as more information about which are required to add, edit, or delete data.
Available data fields
The following table shows which fields are required, optional, or not applicable when you add, edit, or delete each type of component record. When a field isn’t applicable to the action, any value entered in the field is ignored.
NOTE
The values in all text columns are case-sensitive.
When you create a new record and don’t include values for all required data fields, then some of those fields are assigned the specified default values.
For fields that aren’t specified below, the default value for the ad network is used.
The following table is wide. To expand your viewing area, you can temporarily hide the table of contents and the right pane by clicking
at the top of the left pane and
at the top of the right pane. You can also use the scrollbar at the bottom of the table to view the full contents.
Field
Campaign
Ad Group
Keyword
Text Ad
Sitelink
Description
Platform
n/a
n/a
n/a
n/a
n/a
(Included in generated bulksheets for information purposes) The ad platform. Required unless each row includes an AMO ID for the entity.
Acct Name
Required/Optional
Required/Optional
Required/Optional
Required/Optional
Required/Optional
(Included in generated bulksheets for information purposes) The ad platform. Required unless each row includes an AMO ID for the entity.
Campaign Name
Required
Required
Required
Required
Required
The unique name that identifies a campaign for an account.
Campaign Start Date
Required: Create Optional: Edit or delete
n/a
n/a
n/a
n/a
The first date on which bids may be placed for a campaign, in the advertiser’s time zone and in one of the following formats: m/d/yyyy, m/d/yy, m-d-yyyy, or m-d-yy. The default for new campaigns is the current day.
Campaign Budget
Required: Create Optional: Edit or delete
n/a
n/a
n/a
n/a
A lifetime spending limit for the campaign, with or without monetary symbols and punctuation.
Delivery Method
Required: Create Optional: Edit or delete
n/a
n/a
n/a
n/a
How quickly to show ads for the campaign each day:
Standard (Distributed) (the default for new campaigns): To spread your ad impressions across the day.
Accelerated: To display your ads as often as possible until your budget is reached. As a result, your ads may not appear later in the day.
Ad Group Name
n/a
Required
Required
Required
n/a
The ad group.
Ad Title
n/a
n/a
n/a
Required
n/a
The headline of the banner (ad). The maximum length is 33 characters, and a single word can’t include more than 23 characters.
Note: Changing the ad copy deletes the existing ad and creates a new one.
Ad Description
n/a
n/a
n/a
Required
n/a
The body of the banner (ad). The maximum length is 75 characters, and a single word can’t be more than 22 characters.
Note: Changing the ad copy deletes the existing ad and creates a new one.
Base URL
n/a
n/a
Optional
Required
n/a
The landing page URL to which end users are taken when they click your ad, including any append parameters configured for the campaign or account. The maximum length is 1024 characters, including the protocol.
Base/final URLs at the keyword level override URLs at the ad level and higher.
Destination URL
n/a
n/a
n/a
n/a
n/a
(Included in generated bulksheets for information purposes; not posted to the ad network) For accounts with destination URLs, this value is the URL that links an ad to a base URL/landing page on the advertiser’s website (sometimes via another site that tracks the click and then redirects the user to the landing page). It includes any append parameters configured for the Search, Social, & Commerce campaign or account. If you generated tracking URLs, this value is based on the tracking parameters in your account settings and campaign settings. If you appended ad network-specific parameters, they may be replaced with the equivalent parameters for Search, Social, & Commerce.
SiteLink Title
n/a
n/a
n/a
n/a
Required
The sitelink text. For new sitelinks, include the campaign name within the sitelink row. For ad group-level or ad-level sitelinks, also include the ad group name or the ad title and text, respectively.
Note: You can have up to four sitelinks.
SiteLink Base URL
n/a
n/a
n/a
n/a
Required
The base URL for a sitelink; it must be the base URL for the banner. See "Base URL."
SiteLink Destination URL
n/a
n/a
n/a
n/a
n/a
The destination URL for a sitelink; it must be the destination URL for the banner. See "Destination URL."
Keyword
Optional / n/a
n/a
Required
n/a
n/a
The phrase (keyword string). An ad must have at least one phrase. Each keyword can have a maximum of seven words, excluding stop words.
Notes:
To exclude a phrase at the campaign level, set the Match Type to Negative.
Changing a phrase deletes the existing phrase and creates a new one.
Changing a Yandex keyword phrase or match type deletes the existing keyword phrase and creates a new one.
Max CPC
n/a
Required: Create Optional: Edit or delete
Optional
n/a
n/a
The maximum cost per click (CPC), which is the highest amount to pay for a banner (ad) click on the search network, with or without monetary symbols and punctuation. You can set values for ad groups and keywords. The default for a new keyword is inherited from the ad group level.
Match Type
Optional / n/a
n/a
Optional: Create Required/Optional: Edit or delete
n/a
n/a
The keyword matching option for the phrase: Content or Search. Define negative keywords using the "Negative Keywords" column.
Note: Changing a Yandex keyword phrase or match type deletes the existing keyword phrase and creates a new one.
Search Network Status
Optional
n/a
n/a
n/a
n/a
Whether to place ads on the search network: Yes (the default) or No.
Content Network Status
Optional
n/a
n/a
n/a
n/a
Whether to place ads on the Yandex advertising (display) network: Yes (the default) or No.
Negative Keywords (Yandex)
n/a
n/a
Optional
n/a
n/a
Negative keywords (phrases) that are shared by all phrases in an ad group, preceded by a minus sign (such as -mykeyword). If a negative keyword matches a keyword in a phrase, then the negative keyword isn’t applied to the phrase.
Param1 (Yandex)
n/a
n/a
Optional
n/a
n/a
Value of the {param1} substitution variable. It can include up to 255 bytes. To delete the existing value, use the value [delete] (including the brackets).
Param2 (Yandex)
n/a
n/a
Optional
n/a
n/a
Value of the {param2} substitution variable. It can include up to 255 bytes. To delete the existing value, use the value [delete] (including the brackets).
Campaign Status
Optional: Create or edit Required: Delete
n/a
n/a
n/a
n/a
The display status of the campaign: active, archived, deleted, disapproved, pending, or stop (paused). The default for new campaigns is active.
Notes:
If a campaign has ever been active, you can’t delete it. Instead, archive it. Campaigns may be automatically archived or removed in some situations.
You can’t manually set the status to disapproved or pending, nor change those statuses.
Ad Group Status
n/a
Optional: Create or edit Required: Delete
n/a
n/a
n/a
The display status of the ad group: active, archived, deleted, disapproved, pending, or stop (paused). The default for new ad groups is active.
Notes:
If an ad group has ever been active, you can’t delete it. Instead, archive it. You can’t manually set the status to disapproved or pending, nor change those statuses.
Ad Status
n/a
n/a
n/a
Optional: Create or edit Required: Delete
n/a
The display status of the banner (ad): active, archived, deleted, disapproved, pending, or stop (paused). The default for new banners is active.
Note: You can’t manually set the status to disapproved or pending, nor change those statuses.
Keyword Status
n/a
n/a
Optional: Create or edit Required: Delete
n/a
n/a
The display status of the phrase (keyword): active. The default for new phrases is active.
Note: You can’t manually set the status to disapproved or pending, nor change those statuses.
SiteLink Status
n/a
n/a
n/a
n/a
Optional: Create or edit Required: Delete
The display status of the sitelink: [*UICONTROL Active] or [*UICONTROL Paused]. The default for new sitelinks is [*UICONTROL Active].
The unique ID that identifies an existing campaign. In CSV and TSV files, it must be preceded by a single quote (').[1] Required only when you change the campaign name, unless the row includes an AMO ID for the campaign.
The unique ID that identifies an existing ad group. In CSV and TSV files, it must be preceded by a single quote (').[1:1] Required only when you change the ad group name, unless the row includes an AMO ID for the ad group.
Ad ID
n/a
n/a
n/a
n/a: Create Required/Optional: Edit or delete
n/a
The unique ID that identifies an existing keyword. In CSV and TSV files, it must be preceded by a single quote (').[1:2] Required only when you change the keyword name, unless the row includes a) sufficient property columns to identify the keyword or b) an AMO ID.
The unique ID that identifies an existing keyword. In CSV and TSV files, it must be preceded by a single quote (').[1:3] Required only when you change the keyword name, unless the row includes a) sufficient property columns to identify the keyword or b) an AMO ID.
AMO ID
n/a
n/a
n/a
n/a
n/a
(In generated bulksheets) An Adobe-generated unique identifier for a synced entity. For responsive search ads, the AMO ID is required to edit or delete ads unless you include the Ad ID. To edit data for all other entity types with an AMO ID, the AMO ID is required to edit or delete the data unless you include the entity ID and parent entity ID.
Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.
[Advertiser-specific Label Classification]
Optional
Optional
Optional
Optional
n/a
(Named for an advertiser-specific label classification, such as “Color” for a label classification called Color) A value for the specified classification that is associated with the entity. You can include only one value per classification per entity (such as “red” for the “Color” label classification for Campaign A). The maximum length is 100 characters, and the value can include ASCII and non-ASCII characters.
Label classifications and their label values are applied to all child components; new components that are added later are automatically associated with the label. Label classifications for product groups are applied to the unit (most granular) level.
The classification name and the classification value aren’t case-sensitive.
Constraints
Optional
Optional
Optional
n/a
n/a
A constraint that’s assigned to the entity. You can assign only one constraint per entity.
Constraints are inherited by child entities, so you don’t need to enter values for child entities unless you want to override the inherited values.
EF Error Message
n/a
n/a
n/a
n/a
n/a
(Included in generated bulksheets for information purposes) Placeholder for displaying error messages from Search, Social, & Commerce regarding data in the row; error messages are included in EF Errors files. This value isn’t posted to the ad network.
Excel converts large numbers to scientific notation (such as 2.12E+09 for 2115585666) when it opens the file. To view digits in the standard notation, select any cell in the column and click inside the formula bar. ↩︎↩︎↩︎↩︎
