Answer the question
In order to leave comments, you need to log in
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
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 questionAsk a Question
731 491 924 answers to any question