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

Count of Days in month?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi, 

 

When creating a customer field, can I get a count of the days in the month?

 

Context: want to multiple my daily budget from an AdWords source by the days in the month. 

 

Thanks, 

1 Expert replyverified_user

Count of Days in month?

Top Contributor
# 2
Top Contributor

Hi Alex, 

this is unfortunately not available. 

Your best bet is is to create "monthly averages" by creating custom fields where you divide a metric by 30 to get a monthly average.

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

Count of Days in month?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks for reply. 

 

I'll see if I can do it manually with a CASE statement and detect the current date and return an integer of month days. 

Count of Days in month?

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

See the three dots next to the date dimension in the field view of the data source? Select count distinct.