Compute signup rate and retention from raw logs

You are analyzing an A/B test for a marketing campaign that gives new users a free one-month trial. The experiment data is stored in two event-level tables, experiment_assignment and event_log. Assume all timestamps are in UTC, and each user appears at most once in experiment_assignment. Use only the following tables: The relevant rows in event_log have event_type equal to either 'signup' or 'app_open'. Metric rules: The assignment population consists of users assigned from…