正在加载视频...

视频加载失败

返回首页

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?

googledevs's profile picture

Google for Developers

2,658,721 subscribers

23,846 次观看 • 1 年前 •via X (Twitter)

科学技术新闻政治教育
LIVE

Anya Rossi• Live Now

Private livecam show

2 条评论

Google for Developers 的头像
Google for Developers1 年前

Think about how your counting method might be affected by users with multiple activity dates. Also, consider whether your HAVING clause is using the same counting logic as your SELECT statement.

Ash 的头像
Ash1 年前

HAVING COUNT(*) > 100 will show only regions where active users are greater than 100.

相关视频

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.
0:25

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

23,832 次观看 • 1 年前

Developers, can you spot the bug in this seemingly simple code? It's a common C mistake that leads to undefined behavior!
0:22

Developers, can you spot the bug in this seemingly simple code? It's a common C mistake that leads to undefined behavior!

Google for Developers

24,599 次观看 • 5 个月前

5 Common Vegetables You Should Never Refrigerate - Are You Making This Mistake?
1:01

5 Common Vegetables You Should Never Refrigerate - Are You Making This Mistake?

Health | Wellness | Nutrition

29,236 次观看 • 1 年前

Common mistake to confuse me with an actual star. Tune in tonight for stars in the making! #AmericanIdol reveals your Top 24!
0:38

Common mistake to confuse me with an actual star. Tune in tonight for stars in the making! #AmericanIdol reveals your Top 24!

Ryan Seacrest

27,642 次观看 • 1 年前

This should be the #1 Story in the United States 😠 The numbers will irritate you, be warned 🫵
4:41

This should be the #1 Story in the United States 😠 The numbers will irritate you, be warned 🫵

G-PA

226,671 次观看 • 11 个月前

Quick demo of Zero’s new background queries. Zero’s sync is query-based. Rather than specifying what data you want using rules or some other separate system, you just use queries. Right inside the client app, you do a query using a full sql-style language. You get filters, subqueries , limits, etc. Zero syncs the data backing these queries to the client. It’s important to realize Zero isn’t really a cache. It’s a replica. It’s eagerly replicating a precise snapshot of a slice of your database - the slice covered by the queries you have open. So there is never stale data in Zero. When you close a query we delete the rows uniquely returned by that query because we can no longer keep them up to date. Of course that kind of sucks for the common case of doing a query, navigating, then pressing “back”. Ideally we want that back nav to be fast. To address this Zero 0.17 adds background queries. You can add a ttl to a query and it will keep running and syncing in the background. This is much different than normal caching because this data stays up to date. If you make the same query again, the results will be *instantly* available *and already up to date with server*. If you make a different query the data from the background query is used client-side to answer the new query instantly if possible. This all happens completely automatically. Just by adding the ttl flag.
1:01

Quick demo of Zero’s new background queries. Zero’s sync is query-based. Rather than specifying what data you want using rules or some other separate system, you just use queries. Right inside the client app, you do a query using a full sql-style language. You get filters, subqueries , limits, etc. Zero syncs the data backing these queries to the client. It’s important to realize Zero isn’t really a cache. It’s a replica. It’s eagerly replicating a precise snapshot of a slice of your database - the slice covered by the queries you have open. So there is never stale data in Zero. When you close a query we delete the rows uniquely returned by that query because we can no longer keep them up to date. Of course that kind of sucks for the common case of doing a query, navigating, then pressing “back”. Ideally we want that back nav to be fast. To address this Zero 0.17 adds background queries. You can add a ttl to a query and it will keep running and syncing in the background. This is much different than normal caching because this data stays up to date. If you make the same query again, the results will be *instantly* available *and already up to date with server*. If you make a different query the data from the background query is used client-side to answer the new query instantly if possible. This all happens completely automatically. Just by adding the ttl flag.

Aaron Boodman

18,808 次观看 • 1 年前

Kevin Hassett on the jobs numbers: "This is a lower number than seems like you would normally get."
0:44

Kevin Hassett on the jobs numbers: "This is a lower number than seems like you would normally get."

The Bulwark

20,961 次观看 • 9 个月前

DON’T BE THIS TYPE OF PLAYER Nothing worse than a player that won’t challenge themselves defensively. You might not be the best defender, but you can fight, scrap, get steals, and still impact the game on that side of the floor. Also, nothing worse than a player that stops playing when they make a mistake. YOUR TEAM BEEDS YOU TO MAKE THE NEXT PLAY!! Stop being selfish. Challenge yourself to never be this type of player.
0:29

DON’T BE THIS TYPE OF PLAYER Nothing worse than a player that won’t challenge themselves defensively. You might not be the best defender, but you can fight, scrap, get steals, and still impact the game on that side of the floor. Also, nothing worse than a player that stops playing when they make a mistake. YOUR TEAM BEEDS YOU TO MAKE THE NEXT PLAY!! Stop being selfish. Challenge yourself to never be this type of player.

Steve Dagostino

12,891 次观看 • 1 年前

This is something the western mainstream media should be telling you. But they won't.......
1:29

This is something the western mainstream media should be telling you. But they won't.......

Richard

377,781 次观看 • 2 年前

"Modern Football in the NFL is Quarterback driven. You can look at the analytics... QB Success is a higher predictor of winning and losing than Turnover Ratio." - Ben Johnson
1:05

"Modern Football in the NFL is Quarterback driven. You can look at the analytics... QB Success is a higher predictor of winning and losing than Turnover Ratio." - Ben Johnson

Coach Dan Casey

1,102,127 次观看 • 1 年前

What's the truth, @SheehyforMT? Telling investigators one story and then telling others the bullet in your arm is from Afghanistan? This is just one more story that doesn't add up, Tim. Montana deserves better.
0:30

What's the truth, @SheehyforMT? Telling investigators one story and then telling others the bullet in your arm is from Afghanistan? This is just one more story that doesn't add up, Tim. Montana deserves better.

VoteVets

66,421 次观看 • 2 年前

This man reveals the biggest mistake you can do when raising a kid.
0:50

This man reveals the biggest mistake you can do when raising a kid.

The Driven Man

120,438 次观看 • 2 个月前

Silence is telling the whole story. Just look at Dad's face! 😂😭
0:21

Silence is telling the whole story. Just look at Dad's face! 😂😭

Restoring Your Faith in Humanity

122,489 次观看 • 1 个月前

🎉 Check out our amazing growth rates in Google Analytics! 📈 With over 3,000,000 players and more than 1,300,000 daily active users (DAU) 🔥 Incredible results. And this is just the beginning! #hamster_kombat
0:32

🎉 Check out our amazing growth rates in Google Analytics! 📈 With over 3,000,000 players and more than 1,300,000 daily active users (DAU) 🔥 Incredible results. And this is just the beginning! #hamster_kombat

Hamster Kombat

160,880 次观看 • 2 年前

Write this down: If you choose to be part of a team… showing up as less than your best is selfish. Your standard impacts everyone else. When you don’t bring your best, you lower the ceiling for the whole room. Lead accordingly.
0:47

Write this down: If you choose to be part of a team… showing up as less than your best is selfish. Your standard impacts everyone else. When you don’t bring your best, you lower the ceiling for the whole room. Lead accordingly.

Alan Stein, Jr.

17,854 次观看 • 3 个月前

XION has over 800k monthly active users. @EarnOS_io, built on XION, has 4M users. Dave, our Premier Mobile Developer Kit brings in 18M iOS and Android developers. This is what happens when you make blockchain useful, not just usable. Making XION the Unicorn of Unicorns🧵↓
1:44

XION has over 800k monthly active users. @EarnOS_io, built on XION, has 4M users. Dave, our Premier Mobile Developer Kit brings in 18M iOS and Android developers. This is what happens when you make blockchain useful, not just usable. Making XION the Unicorn of Unicorns🧵↓

XION

38,355 次观看 • 10 个月前

Caught up with Mike McAllister on Syracuse men's basketball's transfer portal additions 🍊🏀 Should fans be concerned by the lack of P4 transfers? "Last year, the whole was less than the sum of the parts, and you're hoping this year the whole is greater than the sum of the parts." "They have more resources than last year..the market for transfers is also up. If you look at the roster as a whole, I think you can see the way it's constructed. They want positional size, length, and defensive intensity."
1:24

Caught up with Mike McAllister on Syracuse men's basketball's transfer portal additions 🍊🏀 Should fans be concerned by the lack of P4 transfers? "Last year, the whole was less than the sum of the parts, and you're hoping this year the whole is greater than the sum of the parts." "They have more resources than last year..the market for transfers is also up. If you look at the roster as a whole, I think you can see the way it's constructed. They want positional size, length, and defensive intensity."

Ashley Wenskoski

10,389 次观看 • 1 个月前

A basic mistake that can be made in understanding the followership of Cockroach Janta Party and this mistake should be avoided 🙏
1:37

A basic mistake that can be made in understanding the followership of Cockroach Janta Party and this mistake should be avoided 🙏

Shekhar Dutt

142,690 次观看 • 16 天前

This SQL query looks like it should fail immediately. Instead, it runs and quietly returns the wrong result. Why doesn’t the database complain?
0:40

This SQL query looks like it should fail immediately. Instead, it runs and quietly returns the wrong result. Why doesn’t the database complain?

Google for Developers

11,376 次观看 • 3 个月前

"First two things I look for is intensity and IQ. I can see your skill level, but I need to know what's inside your chest and in between your ears." Talent is common. Be uncommon in the details and in your desire.
0:29

"First two things I look for is intensity and IQ. I can see your skill level, but I need to know what's inside your chest and in between your ears." Talent is common. Be uncommon in the details and in your desire.

The Winning Difference

23,387 次观看 • 9 个月前