Blend 2 google search console properties

[Klaudio]

Hello, maybe someone can help, I've done a lot of search before posting.

What I'm looking to do

I'm try to blend 2 google search console properties with different domains:

• domain1.com
• domain2.com

And I need to have only a subfolder from each property in order to "stack" them together over time and see how they perform.

What I've tried

Attempt 1: I tried to blend using "Date" dimension and it almost works as I'd expect it to. But the issue is that I cannot filter (include or exclude) any Landing Page thus I can't compare apples to apples (see screenshot).

Attempt 2: I tried also adding Landing Page dimension but when I do that, the Sum of Clicks is totally wrong.

Any help is appreciated.

Note: In both scenarios I've used Full outer join. 

[Mehdi_Oudjida]

@Klaudio 

You need to mimic the UNION ALL statement with the data blending. Here a tutorial describing how to do:

https://how.withlookerstudio.com/data-sources/20220222-how-to-mimic-union-all-operator-with-google-d...

I hope it helps.

Feel free to tell me if you need more info, otherwise you can accept this answer as a solution. 

Mehdi 

[Klaudio]

@Mehdi_Oudjida I came across your article even before posting but still cannot make it happen. 

The COALESCE calculated field, you're creating that when doing the 2 GSC blendings?

What should be in the dimensions and in join conditions then?

[smganalytics]

I know this is an old post, but I'm replying in case anyone else is still looking for the answer for this! I couldn't find the answer anywhere. When connecting the GSC data source, select 'Url Impression' instead of 'Site Impression'. This will give you the landing page dimension. Since this is different for each property, use this as the join connector.