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