Data Studio
4.8K members online now
4.8K 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