-
ROAS Vs Cost in Data Studio
I am preparing my first data studio report of the monthly results of 4 accounts combined.
I wanted to do a graph of the variation of ROAS and Cost throughout the month but I am having issues. If someone could help me with the following I would be very grateful:
1) My first idea was to have a graph with all of the 4 accounts, but I am assuming this would be confusing to present. But would it be possible?
2) Since having 2 lines (ROAS and cost) for each of the 4 accounts (8 lines in total) would be messy, I wanted to do a graph of the mean ROAS and mean cost for all accounts. Would this be possible? If so, how can I do it? I am trying to mess around with fields but I cannot find a way to create some sort of variable plus a loop to generate mean ROAS and cost for the 4 accounts.
​
Any idea of how to present this data? Sorry if this question is confusing. Thank you!
-
1 Reply
-
If all else fails, you can use Google Sheets to do math and pull in from there.
-
Both are possible. Look into blending data (it combines different data sources and uses a common merge field like Date to bridge the two).
You’ll build out your graphs, score cards, etc. and then combine together.
For blended ROAS you’re going to have to combine the data for cost and conv value separately, then create a new metric for ROAS from the combined data that = (ConvValue[source1] + ConvValue[source2] + ConvValue[source3] + ConvValue[source4] ) / (Cost[source1] + Cost[source2] + Cost[source3] + Cost[source4]). Otherwise it’s just going to average out your ROAS final numbers and you won’t get a true number (since you are spending differently in each platform and need that to be taken into account).
Log in to reply.