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

Data Averaging Problem

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi, I have a custom data source that works perfectly, except that when I take away the data dimension google automatically sums all the metrics. This is a problem b/c metrics like CPC shouldn't be summed but averaged over a time period. Google automatically averages cpc from google analytics data when the date dimension is removed, so I'm wondering if there's a way to tell google to average metrics instead of sum them when the date dimension is removed. Thanks!