File format and field population rules
To define the data types in columns, column titles are used. Titles must be in Russian. The column order does not matter. You can import files with a single column or files with incomplete data: some columns may be missing.
CSV or TXT format
The file can contain the data of multiple campaigns.
The file must be UTF-8 encoded.
The first line must contain the field names, and the following lines must contain the field values.
The tab character is used as the field delimiter.
XLSX or XLS format
The file contains the data for a single campaign.
Your file consists of several tabs:
-
Texts — the main tab for making changes. Here you will find ad campaign data and all ad settings. Several fields in this tab cannot be edited.
-
Regions — contains the list of values for Region field. This data is of an informational nature, you do not need to make changes in this tab.
-
Dictionary of field values contains the list of values for the fields Campaign type and Ad type. This data is of an informational nature, you do not need to make changes in this tab.
The selection of fields for the Texts tab depends on the campaign type. A description for filling in the fields is given in the table.
Filling in fields
How to fill in fields:
-
Select which ad of the ad group is considered the main ad. The other ads will be considered additional. Your choice of the group's main ad is only used for filling in the file and has no further effect on ad serving.
-
Enter each keyword in a separate line. In the Additional group ad field, enter - (minus).
You can fill in the ad group field and main ad in the ad group in only the first line containing the keyword, or paste them to all lines with the keywords of this ad group (in this case, lines will only differ by the keyword fields, i.e.: ID, keyword with negative keywords, bid, parameter 1, and parameter 2).
-
Also use a separate line for each additional ad. In the Additional group ad field, enter +. Fill in only the ad fields: titles, text, link, image, and so on. Leave the fields related to keywords and the ad group blank (such as ad group name, regions, and shared negative keywords).
-
Use the Group number field to assign ads and keywords to groups.
Note
The option is available for unified performance campaigns other than ads for mobile apps. Available only for Text & Image ads and image ads.
|
Field |
Specifics and limitations |
|
Campaign type |
Filled in only when creating a new campaign. A list of values can be found in the Dictionary of Field Values tab. |
|
Order № |
Not filled in and not edited. |
|
Negative keywords in a campaign |
Separated with commas. Up to 20,000 characters. Learn more about negative keywords in Yandex Direct Help. |
|
Currency |
Not filled in and not edited. |
|
Additional group ad |
Required field. - indicates it is the main ad of group. + indicates other ads of the group. |
|
Ad type |
Filled in only when creating a new campaign. A list of values can be found in the Dictionary of Field Values tab. |
|
Group ID |
Not filled in and not edited. |
|
Group name |
Required field. |
|
Group number |
Only numbers are allowed. |
|
Phrase ID |
Not filled in and not edited. |
|
Phrase (including negative keywords) |
Filled in only for main ad of group. Up to 4096 characters in length (including negative keywords), no more than 35 characters per word. |
|
Ad ID |
Not filled in and not edited. Alert If you delete the value in this field, then new ads will be created in the existing campaign and the old ones will be deleted. |
|
Title 1 |
Required field. Up to 56 characters including spaces and punctuation. The maximum length for one word is 22 characters. |
|
Title 2 |
Optional element. May (but isn't guaranteed to) appear in the ad. |
|
Text |
Required field. Up to 81 characters including spaces, and up to 15 punctuation marks. The maximum length for one word is 23 characters. |
|
Title/Text length |
Not filled in and not edited. |
|
Link |
Required field. Address of site or offer page. |
|
Display link |
Up to 20 characters. Letters, numbers and the symbols " Learn more about display links in Yandex Direct Help. |
|
Region |
Filled in only for main ad of group. The Regions tab contains the list of regions. Priority is given to the regions, which are provided on the file loading page (check Select region for all uploaded ads). |
|
Yandex Business company |
Unique digital ID of your organization in Yandex Business. To find out the organization ID:
|
|
Bid |
Filled in only for main ad of group. Bids for ads on search. The field value is ignored if the automatic management strategy is enabled. |
|
Bid in ad networks |
Filled in only for main ad of group. Bids for ads in networks (YAN and ad exchanges). The field value is ignored. If the field is empty, the value from the Bid field is used. |
|
Ad status |
Not filled in and not edited. |
|
Phrase status |
Not filled in and not edited. |
|
Sitelink titles |
Up to 30 characters including spaces. The maximum length for one word is 23 characters. Titles must be separated using "||". The total length of the title can not exceed 66 characters. Learn more about sitelinks in Yandex Direct Help. |
|
Sitelink descriptions |
Up to 60 characters including spaces. The maximum length for one word is 23 characters. Sitelink descriptions must be separated using "||". |
|
Sitelink URLs |
Must be separated with “ |
|
”. Up to 25 characters in each callout. Learn more about callouts in Yandex Direct Help. |
|
|
Negative keywords in a group |
Separated with commas. Up to 4096 characters. If different negative keywords are specified in different rows of the same group, then they will be merged when the file is uploaded. Learn more about negative keywords in Yandex Direct Help. |
|
Age restrictions |
Not filled in and not edited. |
You can also go to
