I guess I'm not the only one facing this issue, but maybe I can add my voice in the hope that someone at steam sees this:

Suggestion 1: Allow a user to set a game as private via AppID (for ex via command line) or via name dropdown from a list (so we can catch games removed from steam)
Suggestion 2: Mark a game that was removed from steam as "profile features limited" so they can no longer affect our stats.
Suggestion 3: Round up instead of rounding down when calculating the avg ratio
Suggestion 4: Allow users to flag a product as "Achievement defective" and eliminate them from the calculations [god knows there's hundreds such cases]

I realize all of these come with drawbacks but i'm out of ideas.


The story: If you check my profile you will see it the average game completion rate at 99% That can never get to 100% because of games with achievements that got removed from steam.
It's become kind'of my personal white whale.

Thank you for your attention.