Downloading reports from Yandex accounts using a link opening macro

[bhasan01854]

This life hack reduces the time it takes to prepare daily monitoring of advertising campaigns by three times.

There is a macro that allows you to open many links at once with one click of the button . This macro helps to download several reports from Yandex.Direct at once.



First of all, you need to get a link to the report that you need to download. To do this, create the required report in the report wizard and copy the resulting link.



You need to add the &format=xlsx& particle (highlighted in red) to the copied link so that the opened link does not redirect you to the report, but downloads it immediately.

If you often download a number of ebay database reports for consolidation for different dates or from different accounts, you can use the CONCATENATE function to make the necessary parameters (highlighted in green) changeable.

In Excel it will look like this.

Move all links to a separate sheet (not copying values, but referring to cells). And with one click of a button, download all the necessary reports.

!SEMTools
A useful add-on that will help reduce time spent on a huge pool of tasks - working with semantics, writing texts and cleaning search queries. Use it to:

Set match modifiers in one click.