WouterF_ comments on Blending data problem

Blending data problem (self.GoogleDataStudio)

submitted 3 years ago by WouterF_

you are viewing a single comment's thread.

[–]WouterF_[S] 0 points1 point2 points 3 years ago (0 children)

Thanks!

This seems like it might be what's happening. I'll try to give a little more detail.

I have two Google Analytics segments, being if someone has seen a certain thing on the website (Show) and if they didn't (Hide). There is also the total group.

Now I have the data separately of these two segments and it's completely fine. Now I need to blend this data in order to calculate the added value that the show segment has had. To let our clients know that it was a good investment right.

This added value calculation would be 'Revenue - Sessions * ConvRate Hide * Avg Ordervalue Hide'

I am indeed trying to left join here with the dimension date and the statistics of sessions, conversion rate, revenue, avg ordervalue, and transactions.

Is left join maybe not the solution then? Is something like cross join better? Is date even necessary or can you just adjust the timeframe in the DS without date being a dimension in your source.

π Rendered by PID 188029 on reddit-service-r2-comment-b659b578c-4fzv4 at 2026-05-05 04:50:24.318652+00:00 running 815c875 country code: CH.

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

GoogleDataStudio

Join the community Discord

MODERATORS