Video yükleniyor...

Video Yüklenemedi

Bu video yüklenirken bir sorun oluştu. Bu geçici bir ağ sorunundan kaynaklanıyor olabilir veya video kullanılamıyor olabilir.

Ana Sayfaya Dön

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 görüntüleme • 1 yıl önce •via X (Twitter)

Komedi Bilim & Teknoloji Eğitim

Anya Rossi• Live Now

Private livecam show

2 Yorum

Google for Developers profil fotoğrafı

Google for Developers1 yıl önce

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řízek profil fotoğrafı

Ondřej Pařízek1 yıl önce

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.

Benzer Videolar

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 görüntüleme • 11 ay önce

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,766 görüntüleme • 3 yıl önce

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 görüntüleme • 1 ay önce

🔥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 görüntüleme • 2 yıl önce

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 görüntüleme • 2 ay önce

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 görüntüleme • 2 ay önce

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 görüntüleme • 7 ay önce

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,613 görüntüleme • 1 yıl önce

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,690 görüntüleme • 3 yıl önce

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 görüntüleme • 10 ay önce

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,335 görüntüleme • 2 yıl önce

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 görüntüleme • 2 yıl önce

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 görüntüleme • 3 ay önce

What's wrong with this crucifix? Father Rocky says take a closer look. The wrong person is hanging there — Jesus, who did nothing wrong. It should be us, the sinners. Keep a crucifix at home, look at it daily, and tell Him you're sorry. One lesson, one minute, costs you nothing. Where do you keep a crucifix in your home? Tell us below! #Catholic101 #FatherRocky #Crucifix #RelevantRadio #CatholicFaith

What's wrong with this crucifix? Father Rocky says take a closer look. The wrong person is hanging there — Jesus, who did nothing wrong. It should be us, the sinners. Keep a crucifix at home, look at it daily, and tell Him you're sorry. One lesson, one minute, costs you nothing. Where do you keep a crucifix in your home? Tell us below! #Catholic101 #FatherRocky #Crucifix #RelevantRadio #CatholicFaith

Relevant Radio

36,535 görüntüleme • 19 gün önce

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 görüntüleme • 2 ay önce

"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 görüntüleme • 2 ay önce

.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 görüntüleme • 8 ay önce

What one technological innovation that defines the country to this day? In the run-up to the 250th anniversary of the United States, we asked 25 tech insiders—founders, inventors, thinkers, and more—to tell us about an innovation that they think reflects where American life is headed, speaks to the present in a meaningful way, or otherwise evokes this moment in time. See the full, including what technology has been named over 5 times: 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 seven episodes.

What one technological innovation that defines the country to this day? In the run-up to the 250th anniversary of the United States, we asked 25 tech insiders—founders, inventors, thinkers, and more—to tell us about an innovation that they think reflects where American life is headed, speaks to the present in a meaningful way, or otherwise evokes this moment in time. See the full, including what technology has been named over 5 times: 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 seven episodes.

TIME

25,008 görüntüleme • 2 ay önce