Adding keywords to Yandex.Direct via Excel

[nusaiba130]

There are phrases, the cost per click for which, even to obtain a minimum volume of traffic, is too high and exceeds the projected income from such a key. Here it is advisable to calculate the maximum allowable costs for 1 click and set rates with an upper limit that cannot be exceeded. Add such a cost as a condition in the Bid Wizard for automatic bidding on all keywords.

Adding a small number of keywords via Direct. Commander manually is possible and easy. But what to do when there are more than 20 keywords and ads? In this case, automated adding of keywords using Excel tables will help (we are not saying goodbye to Commander).


As mentioned above, the advantage of Direct. Commander is uk telegram data the ability to work with large data arrays. Thus, the program has a useful function “Import campaign from file” and “Import campaigns from clipboard”. In both cases, prepare information for the program in Excel tables.

To properly export keywords with ads, create an Excel file with the following headers:

Campaign name
Group number
Group name
Phrases
Heading 1
Heading 2
Ad text
Display link
Link
Sitelink Headers
Quick Link Addresses
Quick Link Descriptions
Clarifications
If you only need to upload keywords, for example, to an already running campaign, the first four columns are enough: