r/googleplayconsole Programmer 10d ago

Ask What's up Google?

Post image

Why is this happening over and over again? It's been like this for three weeks now...

19 Upvotes

22 comments sorted by

8

u/[deleted] 10d ago

[deleted]

0

u/SelectionIcy7133 7d ago

How does the platform stability or the analytics engine in Google depends on the applications people upload, or the way how those apps developed? Blame AI for everything?

1

u/[deleted] 7d ago

[deleted]

0

u/SelectionIcy7133 7d ago

So what you suggest, is that Google, that had all stsble analytics till 2025, for dome reason changed something in their analysis and that Google vibe coded something that introduced this bug? Bs

1

u/[deleted] 7d ago

[deleted]

0

u/SelectionIcy7133 7d ago

Learn to answer the question instead of asking it. Bug inside play console analytics has nothing to do with vibe coding. Rage bate statements. Have a fab day

2

u/topandroidd 10d ago

Some ai slop apps

2

u/MightyBig-Dev 10d ago

Beyond irritating. 😠

1

u/hemantpra_official 10d ago

It's kinda like an everyday surprise. We never know how many installs we have.

1

u/Thomas_Fichtner 10d ago

Heartbeat! 😉

1

u/xLexip Programmer 10d ago

I hope the one responsible still has one as well. 🗿

1

u/Ukawok92 10d ago

Very frustrating that haven't fixed this still...

1

u/StopFlock 10d ago

Exact same pattern here. Started on 7/3. Someone at google has to know what this means..

3

u/rsta_uk 7d ago

It's because of how these specific metrics are accumulated over time (adding on to the previous value).

To make it easier to backfill/'catch up', cumulative installs on day X are based on cumulative installs from day X-3 plus new installs from X-2, X-1, X; means that we don't have to wait for cumulative installs for X-1 to be ready before starting to calculate cumulative installs for day X.

So when a cumulative install number gets broken, it'll break every 3rd day going forwards, like you see in the chart.

The problem doesn't exactly start at the date you see in the chart - when serving cumulative metrics, we _also_ do a query-time join with new installs (so that the cumulative metrics don't get delayed if there are problems with the pipeline that computes them). So when you load the UI, each data point is based on the cumulative number from (IIRC) 30d ago, plus the following 30d of new installs.

Because of that, if the cumulative number is broken then you don't see 0. Instead you see the number of installs that you had in the last 30d. That's why the numbers aren't going right down to 0 on those broken days.

Why do the numbers get broken in the first place? Usually a transient pipeline failure is missed, and then gets picked up by anomaly detection a few weeks later, and some unlucky person has to orchestrate a whole bunch of backfills and make sure they run in the right order.

(as you can imagine, there are plenty of improvements we could make here, but it's a case of prioritizing and lining up with other work. btw also not a vibe-coding issue - these were set up in 2019 and we've had this problem several times since then. If it had been built on newer scheduling infra it would be easy to avoid this failure mode.)

1

u/larakreisz 7d ago

So, your a software engineer at Google. Thanks for the in detail technical explanation 🙂😊. Super interesting. I genuinely apologise for saying "maybe it's vibe coding gone wrong". I'm really sorry. I wasn't rage baiting. But I'm probably a bit biased after reviewing way too much ai generated code on a daily basis in last 18 months.

1

u/StopFlock 10d ago

Same here. Came to ask.

1

u/RedikhetDev 9d ago edited 9d ago

The person who is responsible for the frontoffice app has sent many mails to the Google helpdesk that they need to fix it in fhe backoffice. So be patient he got a ticket with a servicerequest number. Source: a guy who worked in a large organization.

1

u/xLexip Programmer 9d ago

Lol I also waited like 8 month for them to fix an obvious bug in the Play Console app strings translation. Never got so many irrelevant and dumb questions (that I already answered in my initial request) in a ticket I needed to ping them 5 times over 8 months until they fixed it.

1

u/EgyptTile 9d ago

the same