UBS, Recently Asked Online Assessments in 3 July, 2025 | SQL: Advertising Campaign Engagement Summary

1. SQL: Advertising Campaign Engagement Summary Problem Statement: In digital advertising, gauging campaign engagement levels is crucial for refining marketing strategies and enhancing client satisfaction. A development team is creating a query for the customer panel dashboard to generate a report showing campaign engagement metrics. The result should have the following columns: name / total_views / total_clicks / engagement_rate. name - the name of the advertising campaign total_views - the total number of views the campaign received total_clicks - the ...