---
metadata:
- name: generator
content: Diplodoc Platform v5.50.6
alternate:
- https://yandex.com/support/direct/en/alternative-interfaces/xls-interface.md
- https://yandex.com/support/direct/ru/alternative-interfaces/xls-interface.md
- https://yandex.com/support/direct/tr/alternative-interfaces/xls-interface.md
- https://yandex.com/support/direct/zh/alternative-interfaces/xls-interface.md
---
> **Documentation Index:** Fetch the complete configuration index at https://yandex.com/support/direct/en/llms.txt
# Managing campaigns with XLS and XLSX files
You can manage ad campaigns for Yandex Direct not only via the web interface, but also using XLS and XLSX files. The latter feature allows you to save time when working with a large quantity of ads, as well as work on campaigns and ads when you don't have access to the internet.
For example, you can download a file with campaign data, edit it offline, and upload the file back to Yandex Direct. After this, ads in the interface will be automatically updated in accordance with changes in the file. You can edit existing campaigns and create new ones, as well as copy ad groups or keywords from one campaign to another.
{% note alert %}
When you copy a campaign using XLS or XLSX files, the strategy settings aren't saved. By default, your new campaigns will use the **Maximum clicks** strategy with no budget limit and your ads will show on all sites. Make sure to edit strategy settings after copying.
{% endnote %}
## Points and restrictions {#limits}
You can manage campaigns using XLS/XLSX files for free, but there are certain limitations due to the technical peculiarities of Yandex Direct. The number and type of operations available during a 24-hour period depend on how many points are on your account. Your balance is recalculated every 24 hours. All points not used up in the past day are removed.
The number of points you can use depends on several factors: the number of ads rejected during moderation, number of keywords with low CTR, average campaign CTR, and average campaign budget.
Points are debited for the following operations:
#|
||
Adding a new ad | 12 points
||
||
Editing an ad | 4 points
||
||
Adding a new keyword | 2 points
||
||
Editing a keyword | 1 point
||
|#
The number of points used for one loading is displayed on the loading confirmation page. The points are deducted only if data is successfully imported. If there are errors during loading, the points are not deducted.
{% note alert %}
Yandex reserves the right to suspend the option to manage campaigns using XLS/XLSX for certain users without explanation.
{% endnote %}
## How to use XLS/XLSX files {#how-to}
You can use XLS/XLSX files to edit existing campaigns and create new ones. To edit an existing campaign, you need to download the campaign as a file, make changes to it and then upload the updated file back to the original campaign. To create a new campaign, use a [template file](https://doc-static.yandex.net/src/support/direct/ru/files/direct_example.xlsx).
In the menu, select **Tools** → **Manage in Excel** and in the window that opens, switch to the tab you need.
{% list tabs %}
- Download
In the drop-down list, select the campaign where you want to make changes and then specify the file format (XLS or XLSX).
- Upload
Choose the file you want to upload. It should be in the XLS or XLSX format, with no more than 60,000 rows. The structure must match the [template](https://doc-static.yandex.net/src/support/direct/ru/files/direct_example.xlsx). If you want to specify a shared region for all ads, check the corresponding box.
Choose one of the following actions:
- **Change campaign** — ads will be added to the campaign, the number of which is indicated in the **Order №** field in the XLS/XLSX file. If the **Order №** field is empty or not filled in correctly, then this action will not be available.
- **Create new campaign** — when the file is uploaded to create a new campaign, the number of ads that will be created will be the same as the number of the unique rows in the spreadsheet for the fields **Title**, **Text** or **Link**.
- **Add to existing campaign** — ads will be added to a campaign which you choose from the drop-down list. The number specified in the **Order №** field is not taken into account. If you upload ads you've already created from one campaign to another, the ad system will duplicate them.
If errors are found in the uploaded file, then the data won't be imported and you'll see an error message.
If there are no errors in your file, you may continue the upload process. Your campaign will be automatically blocked for five minutes so changes cannot be made. To continue the upload process, you need to agree to the terms of the offer.
- History
The History tab lets you see a list of downloaded and uploaded files that indicates both the date the action took place, and each file's campaign number.
If when working with a file an error occurs while uploading an image (such as the size, file, format or link to it do not meet the requirements), then you will see the corresponding status next to it. This page also contains a link where you can download an error report.
{% endlist %}
## Filling in file fields {#fields}
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.
{% note info %}
The option is available only for combinatorial, Text & Image, and image ads in a unified performance campaign.
{% endnote %}
{% note alert %}
Since June 30, Text & Image ads in unified performance campaigns are available for editing only. When you import files containing new Text & Image ads, these ads will now automatically be created as combinatorial ads. To learn more about this update, see [Upgrading Text & Image ads to combinatorial ads](https://yandex.com/support/direct/en/unified-performance-campaign/upgrade-to-comb.md).
{% endnote %}
#|
||
**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.
Read more about [negative keywords](https://yandex.com/support/direct/en/keywords/negative-keywords.md).
||
||
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.
{% note 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.
{% endnote %}
||
||
Combinatorial ads | Section for fields with combinatorial ad elements.
||
||
Title 1 | Required field.
Up to 56 characters including spaces and punctuation.
The maximum length for one word is 22 characters.
||
||
Title 2–7 | Optional element.
Up to 56 characters including spaces and punctuation.
The maximum length for one word is 22 characters.
||
||
Text 1 | Required field.
Up to 81 characters including spaces, and up to 15 punctuation marks.
The maximum length for one word is 23 characters.
||
||
Text 2–3 | Optional element.
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.
||
||
Image 1–5 | [Image](https://yandex.com/support/direct/en/efficiency/images.md) link.
||
||
Vertical, square, or horizontal video 1–2 | Video ID.
||
||
Asset moderation status | 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 "`-`", "`№`", "`/`", "`%`", "`#`" are allowed. You do not need to specify the domain.
More details about [link that displayss](https://yandex.com/support/direct/en/efficiency/display-link.md).
||
||
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:
1. Find the organization on [Yandex Maps](https://yandex.ru/maps) and click the link in the title.
1. Copy the ID from the address bar. For example, on the page `https://yandex.ru/maps/org/gum_katok/1008627065/`, the unique ID is `1008627065`.
||
||
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](https://yandex.com/support/direct/en/efficiency/quick-links.md).
||
||
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 “||”.
||
||
Parameter 1 and Parameter 2
|
Values will be pasted into the link instead of `{param1}` and `{param2}`.
Read more about [parameters](https://yandex.com/support/direct/en/statistics/use-url-tags.md).
||
||
Labels
|
Filled in only for main ad of group.
Separated with commas. Up to 25 characters per tag.
Learn more about [tags](https://yandex.com/support/direct/en/campaigns/tags.md).
||
||
Image
|
Required field for image ads.
Link to an [image](https://yandex.com/support/direct/en/efficiency/images.md) (for Text & Image ads) and to a [creative](https://yandex.com/support/direct/en/unified-performance-campaign/create-image.md) (for image ads).
||
||
Moderation status of creative | Not filled in and not edited.
||
||
Callouts
|
Must be separated with “||”. Up to 25 characters in each callout.
Learn more about [callouts](https://yandex.com/support/direct/en/efficiency/callout.md).
||
||
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.
Read more about [negative keywords](https://yandex.com/support/direct/en/keywords/negative-keywords.md).
||
||
Age restrictions | Not filled in and not edited.
||
|#
### How to find out the video ID {#video-id}
When editing your ad, you can find the video ID below the clip in the **Video** section.
{.border-yes}
Use the **Video ID** dimension in the [Report Wizard](https://yandex.com/support/direct/en/statistics/new-reports-wizard.md) to see how well your videos are performing.
#### Have questions? {#questions}
{% note alert %}
Our customer support can only assist you with campaigns linked to the username you are contacting us from. You can check your username by opening [ya.ru](http://ya.ru/) in another browser tab. Our team can access your data only when processing your request.
{% endnote %}
Scan the QR code or tap it to follow the link.
If you select Telegram or WhatsApp, keep in mind that Yandex does not control and is not liable for how third-party messengers store your data and chat history.
{% cut "Call" %}
You can contact us from 10:00 to 19:00 (UTC+3) by phone:
**Moscow**: [+7 495 139-91-93](tel:+74951399193)
**Russia**: [8 (800) 700-47-45](tel:88007004745) (toll-free within Russia)
To access campaigns, the customer service specialist will need your [PIN](https://yandex.com/support/direct/en/troubleshooting/pin-code.md).
{% endcut %}
{% cut "Leave a message" %}
{% endcut %}
