Solution Automate Reports in Power Bi

[mehadihasan123456]

It became clear that due to manual report compilation and data comparison, we cannot promptly and, most importantly, make the necessary changes to advertising campaigns in a timely manner. We decided to automate the data collection process. To do this, we built a solution based on Power BI, the BigQuery cloud database, and the R programming language.

We downloaded data on expenses and clicks from Yandex.Direct and Google Ads advertising accounts via API, and data on conversions from Yandex.Metrica. The obtained data was then compared by UTM tags using the R language, so that it could be downloaded to the BigQuery cloud database. To visualize the data, we used a solution from Microsoft — Power BI.

Ultimately, we created an automated report, where forex data the following data became available to us for analysis:

Parameters:

channel;
campaign;
product;
device type;
target location (Geo) and others.
Metrics:

shows,
clicks,
expenses;
conversions (orders from Yandex.Metrica using the “First Click” attribution model)
CPO and others.