YoY comparison for blended data

Data Studio Data Studio Q&A
1

Hi all!

I’ve created a board in Looker Studio with different sources, which are GA4, Google Ads and LinkedIn Ads. Now, there is no data pre April '24 for GAds and there’s not been advertising done on LinkedIn before November '23. However, the GA4 account existed for give or take 1.5 years.

There’s an automatic comparison that I can toggle in Looker Studio to show a comparison to the previous year, however in the table that I created, it doesn’t return any values.

Below is what the table looks like. The columns are the following:

Year month comes from GA4 // Web sessions = Sessions (GA4) // Total spend = LinkedIn ad spent + GAds ad spent // Leads = key events from GA4 // CPL = Total spent / Leads

STRAREXDigital_0-1720689472160.png
STRAREXDigital_0-1720689472160.png1744×634 61.5 KB

The web sessions have data for the last 12 months and longer ago, so I can’t wrap my head around why the YoY % doesn’t find any information. I’d greatly appreciate your help to understand why it’s not working, how it can be fixed or how it should be set up.

Thanks in advance!

2

Try using the COALESCE function with the dates, it’s likely happening as you have some null dates before the GA4 account existed.