This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Data Quality Engineer at Google. The ad measurement team needs to verify device type consistency between impression and click events. Both tables record device type independently, but some records have missing values. Your task is to clean the missing device types, merge the two event streams, and flag whether the device type recorded at the impression matches the device type recorded at the click.
You are a Data Quality Engineer at Google. The ad measurement team needs to verify device type consistency between impression and click events. Both tables record device type independently, but some records have missing values. Your task is to clean the missing device types, merge the two event streams, and flag whether the device type recorded at the impression matches the device type recorded at the click.