These are three lists of those close to ranking-up, lacking
less than 20% merits to reach their goal (Activity is reached in all cases (*), they just lack merits):
Hero Members close to Legendary:
https://public.tableau.com/shared/5HPJ3XJ8D?:display_count=yes&:origin=viz_share_link Sr. Members close to Hero Member: https://public.tableau.com/shared/H7K9S478B?:display_count=yes&:origin=viz_share_link
Members close to Full Member: https://public.tableau.com/shared/PHGTM2CYD?:display_count=yes&:origin=viz_share_link
I suggest to expand these three lists to more ones, by including users who are lack of both merits and activities. Of course, relevant thresholds for merits and activities should be chosen. For instance, users who are lack of 20% of required merits and lack of 20% of required activities in maximum will be chosen for expanding lists.