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

How can I create a monthly report that has these filters?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Time Period for report: Last 60 days or last 90 days
Products that have had at least 2 units sold (Google Analytics seems to call this "unique Purchases"
I need the report to provide BOTH the sku and the product name
"Average Price" needs to be at least $40 or greater

That shows the top 100 products (ranking/sort order determined by Product Revenue)

Re: How can I create a monthly report that has these filters?

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭
This would be very interesting to me as well. I've always been mystified that GA doesn't seem in the normal UI to allow you to define a report date range dynamically for a reporting subscription other than current or last month. What if you need more data to review for your analysis?

Anyone have ideas on how to create the requested report?