Loading video...

Video Failed to Load

There was a problem loading this video. This could be due to a temporary network issue or the video might be unavailable.

Your user global app’s metrics might be muddled by a gotcha! Check out this SQL dev challenge about a common tracking issue that affects users worldwide. Tell us where we went wrong and how to fix it in the comments below.

Google for Developers

2,571,521 subscribers

23,832 views • 1 year ago •via X (Twitter)

Comedy Science & Technology Education

Anya Rossi• Live Now

Private livecam show

2 Comments

Google for Developers1 year ago

Hint: Think about what happens when a user logs in at 11:59 PM in California while your server is in New York. Which day should that login count towards?

Ondřej Pařízek1 year ago

Hi, I think there's a timezone issue here. The query doesn't reflect each user's local time, which can lead to incorrect daily counts. Ideally, we should store the user's timezone and convert both login_time and CURRENT_DATE to that timezone when aggregating login data.

Related Videos

Is your user analytics query telling the whole story? This SQL developer challenge reveals a common mistake in counting active users. Can you spot what's making the numbers look lower than they should be?

Is your user analytics query telling the whole story? This SQL developer challenge reveals a common mistake in counting active users. Can you spot what's making the numbers look lower than they should be?

Google for Developers

23,846 views • 1 year ago

From the archive: We asked Mark Chen (Chief Research Officer at OpenAI) how chasing user metrics could harm AI development. He highlighted how chasing simple metrics like daily active users (DAU) can distort a model’s behavior over time: “If you just boost responses where users say thumbs up, it creates a condition for a model...where it just starts sucking up to you, saying ‘hey, you're right,’ even in complicated situations where objectively you'd say this person's in the wrong.” Chen described the need for a careful approach to metrics: “We need to be opinionated about the features that we build. Build for the things people will want, maybe don't necessarily know they want today, and then use DAU as a byproduct." "We don't want to fall into these traps where three, four years from now this turns into engagement bait.”

From the archive: We asked Mark Chen (Chief Research Officer at OpenAI) how chasing user metrics could harm AI development. He highlighted how chasing simple metrics like daily active users (DAU) can distort a model’s behavior over time: “If you just boost responses where users say thumbs up, it creates a condition for a model...where it just starts sucking up to you, saying ‘hey, you're right,’ even in complicated situations where objectively you'd say this person's in the wrong.” Chen described the need for a careful approach to metrics: “We need to be opinionated about the features that we build. Build for the things people will want, maybe don't necessarily know they want today, and then use DAU as a byproduct." "We don't want to fall into these traps where three, four years from now this turns into engagement bait.”

TBPN

37,685 views • 10 months ago

If you could travel anywhere in the 🌍, where would you go? Tell us in the comments below along with your &ID and you might just win a spark ⚡

If you could travel anywhere in the 🌍, where would you go? Tell us in the comments below along with your &ID and you might just win a spark ⚡

slice

20,765 views • 3 years ago

I want you to watch this one. Not just because im in it but because this is a story that affects every single person who commutes in this country. We spent weeks researching 30 years of Ghana’s bus and rail record. What we found was less about bad luck and more about patterns we keep repeating. The full explainer is out now. Watch it. And tell me in the comments how long is your commute every morning?

I want you to watch this one. Not just because im in it but because this is a story that affects every single person who commutes in this country. We spent weeks researching 30 years of Ghana’s bus and rail record. What we found was less about bad luck and more about patterns we keep repeating. The full explainer is out now. Watch it. And tell me in the comments how long is your commute every morning?

Jacqueline Ansomah Yeboah

22,177 views • 15 days ago

🔥Stop Hanging Back🔥 A common tendency for the recreational golfer is ”hanging back” When you try to “rotate”, we forget that we need to shift “laterally” first, which gets our pressure into the lead side, then you are free to rotate Check out the video below for more explanation on how to fix this issue 👊🏼

🔥Stop Hanging Back🔥 A common tendency for the recreational golfer is ”hanging back” When you try to “rotate”, we forget that we need to shift “laterally” first, which gets our pressure into the lead side, then you are free to rotate Check out the video below for more explanation on how to fix this issue 👊🏼

Ryan Mouque

114,254 views • 2 years ago

Economic experts have been warning us about the next financial crisis since 2018. I gave up waiting for it to happen but this might be a sign that we are getting very close. Check out this video by Matt Baker.

Economic experts have been warning us about the next financial crisis since 2018. I gave up waiting for it to happen but this might be a sign that we are getting very close. Check out this video by Matt Baker.

RyanMatta 🇺🇸 🦅

250,160 views • 1 month ago

An aerospace revolution might be on us. We went to Tennessee to check out Whisper Aero's ultra quiet engines and put them to the test. Full, glorious epsiode down below

An aerospace revolution might be on us. We went to Tennessee to check out Whisper Aero's ultra quiet engines and put them to the test. Full, glorious epsiode down below

Ashlee Vance

92,027 views • 8 months ago

Today we are launching a new BPI campaign at to stop the shadow ban on Bitcoin — and we need your help 🇺🇸 Right now, Bitcoin financial services are severely limited due to guidance from central banks called “Basel” that treat bitcoin as a toxic, high risk asset. Basel serves as a backdoor way for global central banks to limit what Bitcoin products and services Americans have access to. US regulators are actively considering revising this guidance. They are accepting public comments on this issue until June 18th — We need your help to make this issue a priority for the administration. On our website below you can learn more about this issue and submit a comment. We’ve even provided a sample comment to help you get started. Check it out below.

Today we are launching a new BPI campaign at to stop the shadow ban on Bitcoin — and we need your help 🇺🇸 Right now, Bitcoin financial services are severely limited due to guidance from central banks called “Basel” that treat bitcoin as a toxic, high risk asset. Basel serves as a backdoor way for global central banks to limit what Bitcoin products and services Americans have access to. US regulators are actively considering revising this guidance. They are accepting public comments on this issue until June 18th — We need your help to make this issue a priority for the administration. On our website below you can learn more about this issue and submit a comment. We’ve even provided a sample comment to help you get started. Check it out below.

Conner Brown

51,437 views • 1 month ago

Asked by Ben Smith about how he views the politics of AI and the data center build out, Governor Josh Shapiro says: "AI is being developed. The real question is, is it going to be developed here in the US or in communist China? My view is that all of us should want it developed in the US. The US should lead on this. This is a national security issue. I think this is an issue that threatens our freedom if we allow China to overtake us when it comes to AI development."

Asked by Ben Smith about how he views the politics of AI and the data center build out, Governor Josh Shapiro says: "AI is being developed. The real question is, is it going to be developed here in the US or in communist China? My view is that all of us should want it developed in the US. The US should lead on this. This is a national security issue. I think this is an issue that threatens our freedom if we allow China to overtake us when it comes to AI development."

Semafor

99,123 views • 6 months ago

Avoid the headache at TGE for new launches and check out this 10 minute walkthrough to agents(dot)land. This guide will show you what to look for, where to click and how to avoid some common mistakes 🧠 Let us know if you have any questions in the comments below!

Avoid the headache at TGE for new launches and check out this 10 minute walkthrough to agents(dot)land. This guide will show you what to look for, where to click and how to avoid some common mistakes 🧠 Let us know if you have any questions in the comments below!

agents(dot)land

132,598 views • 1 year ago

You CAN be financially free! Tell us in the comments what you want to be financially free from & you might win a prize worth up to $1,000. How to enter: 1️⃣Follow MoneyLion 2️⃣Tell us what you want to be financially free from in the comments below 3️⃣Retweet for an extra entry!

You CAN be financially free! Tell us in the comments what you want to be financially free from & you might win a prize worth up to $1,000. How to enter: 1️⃣Follow MoneyLion 2️⃣Tell us what you want to be financially free from in the comments below 3️⃣Retweet for an extra entry!

MoneyLion

342,646 views • 3 years ago

9 out of 10 traders make losses in stock markets (yes 90%, let that sink in!!!)🤯. As per our analysis, ~50% of the CoinDCX traders make profits when they trade🤩. We took a challenge to take this % profitable users to even higher. But how? we spoke to our users and realised, finding where and what to trade in can be tricky. We have also learned that most of the traders make the same simple mistakes over and over again. After many months of user calls and research on good trading behaviours and risk management... we have recently rolled out something exciting we're proud of – Introducing #TradeSignals on 'Pro mode' in CoinDCX : India Ka Crypto Coach app, your new smart trading buddy! These are cherry-picked top trades from our super successful traders to simplify your trading decisions. Check out their '30-day win rate' and 'P&L' – no more stress, just real-time opportunities coming your way. We're pumped about this 🥳 Try it out and and tell us what you think! DMs are open.

9 out of 10 traders make losses in stock markets (yes 90%, let that sink in!!!)🤯. As per our analysis, ~50% of the CoinDCX traders make profits when they trade🤩. We took a challenge to take this % profitable users to even higher. But how? we spoke to our users and realised, finding where and what to trade in can be tricky. We have also learned that most of the traders make the same simple mistakes over and over again. After many months of user calls and research on good trading behaviours and risk management... we have recently rolled out something exciting we're proud of – Introducing #TradeSignals on 'Pro mode' in CoinDCX : India Ka Crypto Coach app, your new smart trading buddy! These are cherry-picked top trades from our super successful traders to simplify your trading decisions. Check out their '30-day win rate' and 'P&L' – no more stress, just real-time opportunities coming your way. We're pumped about this 🥳 Try it out and and tell us what you think! DMs are open.

Sumit Gupta (CoinDCX)

16,372 views • 2 years ago

Hon. Beatrice Elachi: For us to recover in the next finance bill, we should have a conversation with KRA. They should come in and tell us where we went wrong and what steps we should take to ensure that they can collect more revenue. #NewDawn

Hon. Beatrice Elachi: For us to recover in the next finance bill, we should have a conversation with KRA. They should come in and tell us where we went wrong and what steps we should take to ensure that they can collect more revenue. #NewDawn

K24TV

14,334 views • 2 years ago

Benedict Cumberbatch and Olivia Colman tell us about finally getting to star in a movie together with ‘THE ROSES’ “We’ve been friends for a while… we talked about it sort of drunkenly and noncommittally and then some grown ups went ‘this might work’”

Benedict Cumberbatch and Olivia Colman tell us about finally getting to star in a movie together with ‘THE ROSES’ “We’ve been friends for a while… we talked about it sort of drunkenly and noncommittally and then some grown ups went ‘this might work’”

DiscussingFilm

127,485 views • 9 months ago

A political bomb has exploded in Brussels: #Hungary might be leaking EU secrets to Russia. #EuropeToday's Jakub Janas breaks down the scandal in this #EuropeTodayExplains. What do you think about it? Tell us in the comments.

A political bomb has exploded in Brussels: #Hungary might be leaking EU secrets to Russia. #EuropeToday's Jakub Janas breaks down the scandal in this #EuropeTodayExplains. What do you think about it? Tell us in the comments.

euronews

13,029 views • 2 months ago

What one piece of art or design defines where the United States is right now? We asked 25 designers, artists, collectors and art-world insiders to tell us about a work reflects where American culture is headed or otherwise evokes this moment in time. Here are their picks. See the full list here: Is there a work of art, piece of culture, or special place that speaks to your hopes for America’s future? Tell us in the comments and we might feature your pick in upcoming nine episodes.

What one piece of art or design defines where the United States is right now? We asked 25 designers, artists, collectors and art-world insiders to tell us about a work reflects where American culture is headed or otherwise evokes this moment in time. Here are their picks. See the full list here: Is there a work of art, piece of culture, or special place that speaks to your hopes for America’s future? Tell us in the comments and we might feature your pick in upcoming nine episodes.

TIME

11,633 views • 1 month ago

"Ringo went round to the studio and drummed a bit. I said to Andrew we should make a track and send it to him. So this song is done totally with Ringo in mind. In writing the song I’m talking about where we came from in common with a lot of people" "Home To Us" #PaulMcCartney 🐦‍⬛

"Ringo went round to the studio and drummed a bit. I said to Andrew we should make a track and send it to him. So this song is done totally with Ringo in mind. In writing the song I’m talking about where we came from in common with a lot of people" "Home To Us" #PaulMcCartney 🐦‍⬛

Carlos 🎧 🇦🇷 ⭐️⭐️⭐️

26,315 views • 1 month ago

.Senator John Curtis and I might not be actors, but we are a Republican and a Democrat who can disagree respectfully and come together where we have common ground. In one hour, we'll be having a discussion at UVU to talk with students about how we move forward in a time of division. Watch it on

.Senator John Curtis and I might not be actors, but we are a Republican and a Democrat who can disagree respectfully and come together where we have common ground. In one hour, we'll be having a discussion at UVU to talk with students about how we move forward in a time of division. Watch it on

Senator Mark Kelly

39,283 views • 7 months ago