Blend data 2 GA4 properties, same dimensions and metrics, different dates

[CindyT]

Hi! I'm new to data blending and formulas/custom fields. How do I blend data sources from two GA4 properties that have the same dimensions and metrics, just different date ranges?

Our original GA4 property was not set up properly so we had it fixed. We want to combine the data of the two properties so we can show continuous data and be able to do YoY and previous period comparisons.

The summary row of my table shows the numbers I'm expecting, but the individual rows and scorecards aren't correct, they show numbers much higher than the summary/grand total row. I can't figure out what formulas to use in my custom fields. For my page path dimension I tried using COALESCE(Page path orig, Page path V2)
and for views I tried SUM(IFNULL(Views orig,0))+SUM(IFNULL(Views V2,0))

Any suggestions? Thanks in advance! Cindy

[sam8]

Hi Cindy! 

It sounds like you're looking for a union, not a join. Blends join together two data sources horizontally, but it sounds like you want to add data sources together vertically.

While this isn't officially supported in Looker Studio, you may want to try a community workaround and upvote the feature request!