AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
3.4K members online now
3.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Reporting on an unused dimension

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm trying to figure out how to report on a dimension that is not populated. I haven't solved except manually outside of Google Data Studio.

 

Pageview 1:


ga('set', 'dimension1', 'Pretzel');
ga('set', 'dimension2', 'Beer');

 

Pageview 2:


ga('set', 'dimension1', 'Pretzel');
ga('set', 'dimension2', '');

 

If I pull pageviews on dimension1 alone, I get:

 

dimension1page views
Pretzel2

 

 

But if I pull page views on dimension1 and dimension2 I get:

 

dimension1dimension2page views
PretzelBeer1

 

 

Usually in this case, I would just populate the blank value with a 'NA' if I had the option. Does anyone have a solution to get to:

 

dimension1dimension2pageviews
PretzelBeer1
Pretzel 1

 

 

... using a calculated field or filter? I tried IS NULL on dimension2 and excluding populated values in dimension2 and nothing worked as long as I used dimension2.