Google Cloud - Google MySQL DB - Google Spreadsheets & Scripts
In this example we show the steps for creating the following sample query in Google Cloud.
We create a Google Cloud DB, Google Windows Instance, and we use script in order to fetch data in Google Spreadsheets and display them in cells.
----------------------------------------------------------------------------------------------------------- Build one SQL query to create a cohort of Signup to First Order and show the result.
The objective of this cohort is to see, out of the users that signed up in Week N, how many did their first order in Week N+1, N+2, N+3...
As an input, you have 2 tables:
One with user_id, signup_timestamp
And a second one with user_id, order_timestamp
On this page of the site you can watch the video online Google Cloud - Google MySQL DB - Google Spreadsheets & Scripts with a duration of hours minute second in good quality, which was uploaded by the user Dionysios Anastasopoulos 10 May 2019, share the link with friends and acquaintances, this video has already been watched 119 times on youtube and it was liked by 0 viewers. Enjoy your viewing!
