Please refer this guardrail. https://experienceleague.adobe.com/en/docs/experience-platform/profile/guardrails
These are system guardrail, which clearly tells that data larger than this size would be dropped from profile store but present in the dataLake.
But all your formula is based on dataLake.
Guardrail Limit Limit Type Description
Maximum ExperienceEvent size 10KB System-enforced guardrail The maximum size of an event is 10KB. Ingestion will continue, however any events larger than 10KB will be dropped.
Maximum profile record size 100KB System-enforced guardrail The maximum size of a profile record is 100KB. Ingestion will continue, however profile records larger than 100KB will be dropped.
Maximum profile fragment size 50MB System-enforced guardrail The maximum size of a single profile fragment is 50MB. Segmentation, exports, and lookups may fail for any profile fragment that is larger than 50MB.
Can you please provide a formula to get this data ?
Profile Attribute Size Profile Count
> 100 KB
> 100 KB & < 90 KB
> 90 KB & < 80 KB
> 80 KB & < 70 KB
> 70 KB & < 60 KB
> 60 KB & < 50 KB
> 50 KB & < 40 KB
> 40 KB & < 30 KB
> 30 KB & < 20 KB
> 20 KB & < 10 KB
< 10 KB
Experience Event Size Profile Count
> 10 KB
> 10 KB & < 9 KB
> 9 KB & < 8 KB
> 8 KB & < 7 KB
> 7 KB & < 6 KB
> 6 KB & < 5 KB
> 5 KB & < 4 KB
> 4 KB & < 3 KB
> 3 KB & < 2 KB
> 2 KB & < 1 KB
< 1 KB
Profile fragments(Attribute) size Profile Count
> 50 MB
> 50 MB & < 40 MB
> 40 MB & < 30 MB
> 30 MB & < 20 MB
> 20 MB & < 10 MB
< 10 MB
Profile fragments(Exp Event) size Profile Count
> 50 MB
> 50 MB & < 40 MB
> 40 MB & < 30 MB
> 30 MB & < 20 MB
> 20 MB & < 10 MB
< 10 MB
Profile size (compiled by merge policy) Profile Count
> 50 MB
> 50 MB & < 40 MB
> 40 MB & < 30 MB
> 30 MB & < 20 MB
> 20 MB & < 10 MB
< 10 MB
When we contact Adobe engineering team, we get 'Profile richness' formula to divide dataLaker size by addressable profile count. But this doesnt answer the original question of knowing the profile size for each bucket or average profile size ?
