Hello,
I have the following issue:
I made a data blend of Google Ads and GA4 data for search campaigns. The goal is to have a dashboard that displays campaign performance, some metrics from Google Ads and key events from GA4.
I noticed that scorecards and graphs show bad results when I use the data filter. If I have just one month (or certain days within one month) results are fine, but if I select multiple months, data multiplies by the number of months selected.
For example, if I had 100 impressions in November and 100 in December, if I select 12/1/24 - 12/31/24 scorecard will show 100, but if I select 11/1/24 - 12/31/24, scorecard will show 400 (100+100 multiplied by 2 months). If I were to select a range of six months the result would multiply by 6.
Is there a way to fix this? Did I blend data wrong? This is how it’s now:
Thank You!