Estimating SFMC Contact Growth Queries

Ever been asked to summarize growth for synchronized contacts coming from Sales to Marketing Cloud in an attempt to determine the appropriate allotment to support the coming year?

Here's a query to pivot and report on average growth by month per object being synchronized. Assumes you are syncing the CreatedDate for each object (Lead, Contact, User) and provides enough data to pivot/chart to your heart's content.

Select Count(*), CONVERT(CHAR(7),CreatedDate,120) as MonthYearCreated, 'Lead' as Type
FROM LEAD_SALESFORCE
GROUP BY CONVERT(CHAR(7),CreatedDate,120)

UNION

Select Count(*), CONVERT(CHAR(7),CreatedDate,120) as MonthYearCreated, 'Contact' as Type
FROM CONTACT_SALESFORCE
GROUP BY CONVERT(CHAR(7),CreatedDate,120)

UNION

Select Count(*), CONVERT(CHAR(7),CreatedDate,120) as MonthYearCreated, 'User' as Type
FROM USER_SALESFORCE
GROUP BY CONVERT(CHAR(7),CreatedDate,120)