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

AdWords calculated fields: Avg. Clicks

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello community!
Need assistant with calculated fields for AdWords Report: 

I need to build time series chart with average number: (all clicks)/(all days)  , since there was 1st ad impression in campaign, on every day in report period. 

For example: 
AdWords Campaign: A
Start date: 05.02.2017 (first ad impr.)
Clicks to date: 
05.02.2017 | (0 clicks
06.02.2017 | 80 clicks
07.02.2017 | 110
08.02.2017 | 90

I need:
05.02.2017 | (0 clicks)/ (1 day)=0
06.02.2017 | (0+80 clicks)/ (1+1 day) = 40
07.02.2017 | (0+80+110) / (1+1+1) = 63.3
08.02.2017 | (0+80+110+90) / (1+1+1+1) = 70

And if i choose date range in my report, for example:
07.02.2017 - 08.02.2017 
I want to see on time series chart 63.3 and 70 avg. clicks number. 
02.02.2017 - 08.02.2017 
I want to see on time series chart 0, 0, 0, 0, 40, 63.3, 70 avg. clicks number. 

Is it possible to do this in DataStudio? any ideas? 

Thank You!