Ad Performance Analysis Using CTR and CPC Metrics

meta During a data science interview within the Oculus team, utilize tools such as Python, R, or SQL for data analysis. Solve the following problem: Given an advertisement dataset, use statistical methods to analyze ad performance and suggest ways to improve ad effectiveness. The dataset includes ad ID, number of impressions, number of clicks, and amount spent. Define and calculate the click-through rate (CTR) and cost per click (CPC), and perform an analysis based on these metrics. Provide examples of optimization strategies you would implement for underperforming ads. Complete the analysis with a detailed process and conclusions within 1 hour. Example Input {'AdID': [1], 'Impressions': [1000], 'Clicks': [50], 'Spent': [500]}