2
2
25hp2017-09-29 18:32:30
Google
25hp, 2017-09-29 18:32:30

How to split two metrics from different reports in Google data studio?

Hello. I want to calculate, for example, the cost of a user. Accordingly, you need to create a calculated indicator: Cost / User. But since it apparently pulls out the Cost from the "Expense Analysis" report, it will also take the number of users contained in this report (who came from the advertising campaign that I set in the filter). But I would like to count in the formula all users on the site who visited the page I need.
That is, in fact, you can do - Calculated indicator: Cost (campaign) / User (campaign).
And you need - Calculated indicator: Cost (campaign) / User (page)
As I understand it, he does not know how to take an indicator from the dashboard and therefore the option - to make two summary separately and divide them - is impossible.
Does anyone know how this can be done

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Sergey_Galchuk, 2018-01-12
@Sergey_Galchuk

Hello, so far the only way to do this is to upload everything first to google sheets, and then create the necessary indicators and parameters there, unfortunately this function is not yet available in the data studio, but foreign colleagues have already written a lot about it in the community, maybe they will implement it soon

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question