This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Data Engineer at Unity Ads. The analytics team has flagged inconsistencies in the impressions data — device types and country codes use mixed casing, timestamps include unnecessary time components for daily reports, and costs are stored in micros instead of dollars. Your task is to produce a cleaned view of non-bot impressions with standardized fields.
You are a Data Engineer at Unity Ads. The analytics team has flagged inconsistencies in the impressions data — device types and country codes use mixed casing, timestamps include unnecessary time components for daily reports, and costs are stored in micros instead of dollars. Your task is to produce a cleaned view of non-bot impressions with standardized fields.