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
2.6K members online now
2.6K 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?