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 data from an ad campaign, make changes while you are offline, and then upload that 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 ad campaigns and create new ones, as well as copy ad groups or keywords from one campaign to another.
Points and restrictions
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.
Several factors affect how many points are available to use: the number of ads rejected during moderation, number of keywords with low CTR, average ad campaign CTR, and average ad 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 |
| 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.
Yandex reserves the right to suspend the option to manage campaigns using XLS/XLSX for certain users without explanation.
How to use XLS/XLSX files
You can use XLS/XLSX files to edit existing ad 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.
In the menu, select and switch to the desired tab in the window that opens.
In the drop-down list, select the campaign where you want to make changes and then specify the file format (XLS or XLSX). You can temporarily block a campaign to prevent adjustments being made to it at the same time. Check the relevant box to do this before clicking "Download". The ability to edit ads, settings and upload other files will not be possible. Please note that you will still be able to change bids. You can remove the block on the campaign settings page.
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.
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.
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.
File format and fields to fill
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. Learn more about filling out these fields.
Contact information: the contact data of a company, the address and phone number for all ads.
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, Ad type, Device type, Connection type and OS version. 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.
The option isn't supported for product ads and ads for “Catalog pages”.
| 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. |
| 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. |
| Mobile ad | Mobile ads aren't supported in UPCs. Filled in as “-”. The “+” values will be ignored. |
| Group ID | Not filled in and not edited. |
| Group name | Required field. |
| Group number | Only numbers are allowed. |
| “Rarely served” | Not filled in and not edited. |
| 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. Attention. 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. Up to 30 characters including spaces, and up to 15 punctuation marks. The maximum length for one word is 22 characters. |
| 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 characters “ More details about link that displayss. |
| 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). |
| 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 | The field value is ignored. |
| Contacts | The field value is ignored. |
| 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 with “||”. Learn more about sitelinks. |
| 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 Read more about parameters. |
| Labels | Filled in only for main ad of group. Separated with commas. Up to 25 characters per tag. Learn more about tags. |
| Image | Required field for image ads. Link to an image (for Text & Image ads) and to a creative (for image ads). |
| Creative | |
| 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. |
| Negative keywords in a group | Separated with commas. Up to 4096 characters. Note. 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. |
| Age restrictions | Not filled in and not edited. |
| Link to app in store | Not filled in and not edited. |
| Device type | Not filled in and not edited. |
| Connection type | Not filled in and not edited. |
| OS version | Not filled in and not edited. |
| Tracking link | Not filled in and not edited. |
| Icon | Not filled in and not edited. |
| Rating | Not filled in and not edited. |
| Number of ratings | Not filled in and not edited. |
| Price | Not filled in and not edited. |
| 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. |
| 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. |
| Mobile ad | Mobile ads aren't supported in UPCs. Filled in as “-”. The “+” values will be ignored. |
| Group ID | Not filled in and not edited. |
| Group name | Required field. |
| Group number | Only numbers are allowed. |
| “Rarely served” | Not filled in and not edited. |
| 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. Attention. 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. Up to 30 characters including spaces, and up to 15 punctuation marks. The maximum length for one word is 22 characters. |
| 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 characters “ More details about link that displayss. |
| 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). |
| 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 | The field value is ignored. |
| Contacts | The field value is ignored. |
| 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 with “||”. Learn more about sitelinks. |
| 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 Read more about parameters. |
| Labels | Filled in only for main ad of group. Separated with commas. Up to 25 characters per tag. Learn more about tags. |
| Image | Required field for image ads. Link to an image (for Text & Image ads) and to a creative (for image ads). |
| Creative | |
| 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. |
| Negative keywords in a group | Separated with commas. Up to 4096 characters. Note. 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. |
| Age restrictions | Not filled in and not edited. |
| Link to app in store | Not filled in and not edited. |
| Device type | Not filled in and not edited. |
| Connection type | Not filled in and not edited. |
| OS version | Not filled in and not edited. |
| Tracking link | Not filled in and not edited. |
| Icon | Not filled in and not edited. |
| Rating | Not filled in and not edited. |
| Number of ratings | Not filled in and not edited. |
| Price | Not filled in and not edited. |
| 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. |
| 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. |
| Mobile ad | Required field. + — mobile ad. - — desktop ad. Read more about mobile ads. |
| Group ID | Not filled in and not edited. |
| Group name | Required field. |
| Group number | Only numbers are allowed. |
| “Rarely served” | Not filled in and not edited. |
| 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. Attention. 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. Up to 30 characters including spaces, and up to 15 punctuation marks. The maximum length for one word is 22 characters. |
| 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 characters “ More details about link that displayss. |
| 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). |
| Bid | Filled in only for main ad of group. Bids for ads on search. The field value is ignored if:
|
| 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:
If the field is empty, the value from the Bid field is used. |
| Contacts | + — ad with vCard (data is filled in on the Contact information tab). - — ad without vCard. Learn more about vCards. |
| 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 with “||”. The total length of the title can not exceed 66 characters. Learn more about sitelinks. |
| 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 Read more about parameters. |
| Labels | Filled in only for main ad of group. Separated with commas. Up to 25 characters per tag. Learn more about tags. |
| Image | Required field for image ads. Link to an image (for Text & Image ads) and to a creative (for image ads). |
| Creative | |
| 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. |
| Negative keywords in a group | Separated with commas. Up to 4096 characters. Note. 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. |
| Age restrictions | Not filled in and not edited. |
| Link to app in store | Not filled in and not edited. |
| Device type | Not filled in and not edited. |
| Connection type | Not filled in and not edited. |
| OS version | Not filled in and not edited. |
| Tracking link | Not filled in and not edited. |
| Icon | Not filled in and not edited. |
| Rating | Not filled in and not edited. |
| Number of ratings | Not filled in and not edited. |
| Price | Not filled in and not edited. |
| 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. |
| 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. |
| Mobile ad | Required field. + — mobile ad. - — desktop ad. Read more about mobile ads. |
| Group ID | Not filled in and not edited. |
| Group name | Required field. |
| Group number | Only numbers are allowed. |
| “Rarely served” | Not filled in and not edited. |
| 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. Attention. 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. Up to 30 characters including spaces, and up to 15 punctuation marks. The maximum length for one word is 22 characters. |
| 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 characters “ More details about link that displayss. |
| 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). |
| Bid | Filled in only for main ad of group. Bids for ads on search. The field value is ignored if:
|
| 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:
If the field is empty, the value from the Bid field is used. |
| Contacts | + — ad with vCard (data is filled in on the Contact information tab). - — ad without vCard. Learn more about vCards. |
| 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 with “||”. The total length of the title can not exceed 66 characters. Learn more about sitelinks. |
| 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 Read more about parameters. |
| Labels | Filled in only for main ad of group. Separated with commas. Up to 25 characters per tag. Learn more about tags. |
| Image | Required field for image ads. Link to an image (for Text & Image ads) and to a creative (for image ads). |
| Creative | |
| 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. |
| Negative keywords in a group | Separated with commas. Up to 4096 characters. Note. 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. |
| Age restrictions | Not filled in and not edited. |
| Link to app in store | Not filled in and not edited. |
| Device type | Not filled in and not edited. |
| Connection type | Not filled in and not edited. |
| OS version | Not filled in and not edited. |
| Tracking link | Not filled in and not edited. |
| Icon | Not filled in and not edited. |
| Rating | Not filled in and not edited. |
| Number of ratings | Not filled in and not edited. |
| Price | Not filled in and not edited. |
| 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. |
| 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. |
| Mobile ad | Not filled in and not edited. |
| Group ID | Not filled in and not edited. |
| Group name | Required field. |
| Group number | Only numbers are allowed. |
| “Rarely served” | Not filled in and not edited. |
| 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. Attention. 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 | Not filled in and not edited. |
| Text | Required field. Up to 75 characters including spaces and punctuation. |
| Title/Text length | Not filled in and not edited. |
| Link | Not filled in and not edited. |
| Display link | Not filled in and not edited. |
| 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). |
| Bid | Filled in only for main ad of group. Bids for ads on search. The field value is ignored if:
|
| 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:
If the field is empty, the value from the Bid field is used. |
| Contacts | + — ad with vCard (data is filled in on the Contact information tab). - — ad without vCard. Learn more about vCards. |
| Ad status | Not filled in and not edited. |
| Phrase status | Not filled in and not edited. |
| Sitelink titles | Not filled in and not edited. |
| Sitelink descriptions | Not filled in and not edited. |
| Sitelink URLs | Not filled in and not edited. |
| Parameter 1 and Parameter 2 | Values will be pasted into the link instead of Read more about parameters. |
| Labels | Filled in only for main ad of group. Separated with commas. Up to 25 characters per tag. Learn more about tags. |
| Image | Required field for image ads. Link to an image (for Text & Image ads) and to a creative (for image ads). |
| Callouts | Not filled in and not edited. |
| Negative keywords in a group | Separated with commas. Up to 4096 characters. Note. 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. |
| Age restrictions | App age ratings (0, 6, 12, 16, 18). |
| Link to app in store | Required field. |
| Device type | Required field. A list of values can be found in the Dictionary of Field Values tab. If field is not filled in or not filled in correctly, then the “Mobile connection and Wi-Fi” value will be set. |
| Connection type | Required field. A list of values can be found in the Dictionary of Field Values tab. If field is not filled in or not filled in correctly, then the “All” value will be set. |
| OS version | Required field. A list of values can be found in the Dictionary of Field Values tab. |
| Tracking link | Learn more about tracking links. |
| Icon | Required field. - — do not add icon. + — add icon. |
| Rating | Required field. - — do not add rating. + — add rating. |
| Number of ratings | Required field. - — do not add number of ratings. + — add number of ratings. |
| Price | Required field. - — do not add price. + — add price. |
| 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. |
| 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. |
| Mobile ad | Not filled in and not edited. |
| Group ID | Not filled in and not edited. |
| Group name | Required field. |
| Group number | Only numbers are allowed. |
| “Rarely served” | Not filled in and not edited. |
| 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. Attention. 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 | Not filled in and not edited. |
| Text | Required field. Up to 75 characters including spaces and punctuation. |
| Title/Text length | Not filled in and not edited. |
| Link | Not filled in and not edited. |
| Display link | Not filled in and not edited. |
| 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). |
| Bid | Filled in only for main ad of group. Bids for ads on search. The field value is ignored if:
|
| 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:
If the field is empty, the value from the Bid field is used. |
| Contacts | + — ad with vCard (data is filled in on the Contact information tab). - — ad without vCard. Learn more about vCards. |
| Ad status | Not filled in and not edited. |
| Phrase status | Not filled in and not edited. |
| Sitelink titles | Not filled in and not edited. |
| Sitelink descriptions | Not filled in and not edited. |
| Sitelink URLs | Not filled in and not edited. |
| Parameter 1 and Parameter 2 | Values will be pasted into the link instead of Read more about parameters. |
| Labels | Filled in only for main ad of group. Separated with commas. Up to 25 characters per tag. Learn more about tags. |
| Image | Required field for image ads. Link to an image (for Text & Image ads) and to a creative (for image ads). |
| Callouts | Not filled in and not edited. |
| Negative keywords in a group | Separated with commas. Up to 4096 characters. Note. 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. |
| Age restrictions | App age ratings (0, 6, 12, 16, 18). |
| Link to app in store | Required field. |
| Device type | Required field. A list of values can be found in the Dictionary of Field Values tab. If field is not filled in or not filled in correctly, then the “Mobile connection and Wi-Fi” value will be set. |
| Connection type | Required field. A list of values can be found in the Dictionary of Field Values tab. If field is not filled in or not filled in correctly, then the “All” value will be set. |
| OS version | Required field. A list of values can be found in the Dictionary of Field Values tab. |
| Tracking link | Learn more about tracking links. |
| Icon | Required field. - — do not add icon. + — add icon. |
| Rating | Required field. - — do not add rating. + — add rating. |
| Number of ratings | Required field. - — do not add number of ratings. + — add number of ratings. |
| Price | Required field. - — do not add price. + — add price. |
How to find out the video ID
On the ad editing page, click 
under Video. In the window that opens, the video ID is specified under the video.
