Write a SQL query to retrieve specific user engagement metrics across multiple joined tables, optimizing for query execution speed.
