Currently, the Weekly Metrics emails are really only counting ACTIVE memberships. It includes membership types that are categorized as "Prospective" or "Pending," but doesn't actually show any numbers from them so it's just a lot of 0s.
If the report is not going to count these, then those types shouldn't be included at all. Otherwise, there should actually be some real numbers represented.