Explain how you would write a SQL query to calculate the retention rate of users acquired through paid social campaigns month-over-month.