Write a SQL query to calculate the conversion rate by customer segment over a specific time period for Rivian marketing campaigns.
