Join Data Science Interview MasterClass (in 3 weeks) 🚀 led by FAANG Data Scientists | Just 6 seats remaining...
Back to Questions
2. Ad CTR Calculation
easy
Metasenior
ads_actions
| Column Name | Type |
|---|---|
| ad_exp_id | int64 |
| ad_name | object |
| cpc_rate | object |
| clicked_ad | int64 |
Expected Output Schema
| Column Name | Type |
|---|---|
| ad_name | object |
| ad_ctr | float64 |
Constraints
Roles
Data Analyst
Analytics Engineer
Data Engineer
Business Intelligence Engineer
Data Scientist
Product Manager
ML Engineer
AI Engineer
Companies
MetaLevels
senior
entry
Tags
sql
aggregation
group-by
click-through-rate
rounding
Similar Questions
Top 3 Click Rateseasy
databaseArtists' Top-10 Songseasy
databaseAd Impressions Counteasy
database19 people are solving this problem
Python EditorLn 1, Col 1