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

Google sheet calculated value does not get updated in Data Studio report

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi all,

 

Right now I am using Google Sheets to convert some data from Google Analytics into sheets.

(The value of an Event where i add a number to to create a new calculated value. This is stored in a separate column in a new sheet.)

 

When I run the report in Google Sheets it gets the new statistics out of GA and into the sheet, but when i reload the report in Data Studio new the calculated value is not updated. Am i missing something? 

 

I was hoping that everytime you reload the report in Data Studio it fetches the latest info from the Google Sheet.

Best regards,

Thijs

 

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Thijs K
December 2016

Google sheet calculated value does not get updated in Data Studio report

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Thijs K,

 

I believe the data will reload every 2 hours, to refresh the data instantly you should use the 'Refresh' button in the top left hand corner, this will refresh the data source, where as refreshing your browser won't.

 

Hope that helps,

Ben

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Thijs K
December 2016

Google sheet calculated value does not get updated in Data Studio report

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Thijs K,

 

I believe the data will reload every 2 hours, to refresh the data instantly you should use the 'Refresh' button in the top left hand corner, this will refresh the data source, where as refreshing your browser won't.

 

Hope that helps,

Ben

Google sheet calculated value does not get updated in Data Studio report

[ Edited ]
Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi Ben,

 

Thanks for the swift reply, awesome!

This was exactly what I was looking for Smiley Happy

 

Have a good weekend.

Thijs