ML Engineer MasterClass (August) | 8 seats left

Back to Questions

2. Ad CTR Calculation

easy
MetaMeta
senior
ads_actions
Column NameType
ad_exp_idint64
ad_nameobject
cpc_rateobject
clicked_adint64
Expected Output Schema
Column NameType
ad_nameobject
ad_ctrfloat64

Constraints

Hint 1
Hint 2
Hint 3
Roles
Data Analyst
Analytics Engineer
Data Engineer
Business Intelligence Engineer
Data Scientist
Product Manager
ML Engineer
AI Engineer
Companies
MetaMeta
Levels
senior
entry
Tags
sql
aggregation
group-by
click-through-rate
rounding

Similar Questions

Top 3 Click Ratesmedium
database
Ad Impressions Counteasy
database
Artists' Top-10 Songseasy
database
42 people are solving this problem
Python LogoPython Editor
Ln 1, Col 1

Input Arguments

Edit values below to test with custom inputs

You need tolog in/sign upto run or submit