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
1.7K members online now
1.7K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Filter with Product Name won't work

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello everyone,
I have a problem with scorecard report in data studio

I set up a real simple query.
custom date range

metric = transactions
filter = product name equals "XYZ"

which doesn't work.

When I remove the filter however I get the total amount of transactions. But I'd like to report the total amount of transactions for one specific product.
I also tried it's product sku, it's product category and so forth.

What am I doing wrong here?

thanks in advance.

1 Expert replyverified_user

Filter with Product Name won't work

Top Contributor
# 2
Top Contributor

Hi, replace the transaction metric with unique purchases 

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan

Filter with Product Name won't work

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks for your reply.
I tried your solution and it works but I need transaction metric. Why the transaction metric cannot be filtered?

Thanks in advance.

Filter with Product Name won't work

Top Contributor
# 4
Top Contributor

Unique purchases = transactions that bought product X.

Transactions and products are measured with separate systems so if you want transactions as a total metric, use a separate widget.

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan