Questions / Columbia University Marketing Analytics Specialist 1 Measure Brand Awareness Campaign Success Written 84× 2 Handling Missing and Dirty SQL Data SQL 199× 3 Experience in Higher Education or Non-Profit Written 1× 4 Statistical Significance for Marketers Written 1× 5 Classify Leading vs Lagging Metrics Written 390× 6 Ensure Data Accuracy for Leadership Written 1× 7 Resume Walkthrough Written 9× 8 Investigate Application Drop Causes Written 1× 9 Excel Functions for Data Cleaning Written 1× 10 Explain Campaign Attribution Simply Written 1× 11 Excel Auditing with Pivots and Lookups Written 1× 12 Metrics for Brand Awareness Campaigns Written 1× Show all 23 questions ↓ Show fewer ↑ 13 Complex SQL for Business Impact Written 1× 14 Diagnose Traffic Drop by Region Written 1× 15 SQL Cleaning and Summarization Written 1× 16 Enrollment Funnel KPIs Written 1× 17 SQL Joins, Subqueries, Aggregates Written 1× 18 Post-Mortem for Recruitment Trends Written 1× 19 SQL Conversion Rate Join Written 1× 20 Evaluate Brand Awareness Long-Term Written 1× 21 KPIs for Non-Profit vs Product Written 1× 22 Attribution Across Marketing Channels Written 1× 23 Marketing ROI Reporting Frameworks Written 1× 