Learn business growth with Google Analytics 4 Forums Google Analytics 4 Troubleshooting No Data Issue in Looker Studio Chart with Dual Filters (GA4)

  • Troubleshooting No Data Issue in Looker Studio Chart with Dual Filters (GA4)

    Posted by Ethan on 2 May 2022 at 6:11 pm

    Hey folks, so here’s a strange thing I’ve stumbled upon and it’s got me scratching my head. So, I have this scorecard chart that’s come in really handy for tracking the total number of users who’ve made purchases. It uses GA4 as a data source, and usually, it’s as reliable as a best friend.

    Now, the situation gets interesting when I attempt to apply two specific filters to it:

    1. There’s one for “customer_type = Webonly” – this is pulled from a predefined custom event parameter we’ve set up on the login event.
    2. And a second one for “event name = purchase”.

    You can take a peek at what the scorecard with these two filters looks like in this screenshot.

    I’ve also included screenshots showing the custom dimension in GA4 and the custom field I’ve added to the Looker Studio data source, you can see these here: GA4 and Looker Studio.

    So, the weird thing is, individually, each filter does its job perfectly. But when I team them up on the scorecard, it comes back with “no data”. Now that’s a head-scratcher!

    Just to make sure I wasn’t going crazy, I double-checked the filter values against the analytics. And yes, everything is formatted right and works fine when used alone.

    So, any ideas why these two filters aren’t playing well together?

    James replied 11 months, 2 weeks ago 3 Members · 2 Replies
  • 2 Replies
  • Isabella

    Member
    14 June 2022 at 7:56 pm

    Hey there, let’s try to untangle this!

    These two filters aren’t playing nicely together because they’re trying to apply to the same event at the same time, but your customer_type parameter is actually on a different one altogether. So imagine your GA4 is on the lookout for the event that has both "who's making a purchase" AND "the customer_type is Webonly".

    But oh dear, this is not happening because these two aren’t showing up on the same event.

    So, what can we do? A simple trick could be to put your customer_type parameter within the same scope as the user or include it directly on the purchase event. That should clear up this misunderstanding between your filters. Tada!

    Try it out and let’s see how it works.

  • James

    Member
    24 June 2023 at 2:18 am

    Based on the details you’ve given, one possibility could be due to the nature of your events. The “login” event (where your “customer_type = Webonly” comes from) and the “purchase” event are two separate instances. When you try to apply these filters together, it might be looking for a scenario where both parameters are occurring at the exact same event, which in this case is not possible. Therefore, it returns with “no data”. You can use these filters individually because they’re able to find corresponding events separately. However, when used together, they can’t find any combined events matching both conditions. You may need to adjust your tracking setup or analytic queries to get the desired result.

Log in to reply.