Programming > CODING SOLUTION > The ads24x7 is a Digital Marketing company which has now got seed funding of $10 Million. They are e (All)

The ads24x7 is a Digital Marketing company which has now got seed funding of $10 Million. They are expanding their wings in Marketing Analytics. They collected data from their Marketing Intelligence team and now wants you (their newly appointed data analyst) to segment type of ads based on the features provided. Use Clustering procedure to segment ads into homogeneous groups.

Document Content and Description Below

DATASET :Clustering+Clean+Ads_Data.xlsx https://docs.google.com/spreadsheets/d/139NY-LrMCR4CkShUHhYOlJVPW6lbBbjJ/edit?usp=sharing&ouid=110978125633473056861&rtpof=true&sd=true Clustering: ... Digital Ads Data: The ads24x7 is a Digital Marketing company which has now got seed funding of $10 Million. They are expanding their wings in Marketing Analytics. They collected data from their Marketing Intelligence team and now wants you (their newly appointed data analyst) to segment type of ads based on the features provided. Use Clustering procedure to segment ads into homogeneous groups. The following three features are commonly used in digital marketing: CPM = (Total Campaign Spend / Number of Impressions) * 1,000 CPC = Total Cost (spend) / Number of Clicks CTR = Total Measured Clicks / Total Measured Ad Impressions x 100 Perform the following in given order: Part 1 - Clustering: Read the data and perform basic analysis such as printing a few rows (head and tail), info, data summary, null values duplicate values, etc. Part 1 - Clustering: Treat missing values in CPC, CTR and CPM using the formula given. Part 1 - Clustering: Check if there are any outliers. Do you think treating outliers is necessary for K-Means clustering? Based on your judgement decide whether to treat outliers and if yes, which method to employ. (As an analyst your judgement may be different from another analyst). Part 1 - Clustering: Perform z-score scaling and discuss how it affects the speed of the algorithm. Part 1 - Clustering: Perform Hierarchical by constructing a Dendrogram using WARD and Euclidean distance. Part 1 - Clustering: Make Elbow plot (up to n=10) and identify optimum number of clusters for k-means algorithm. Part 1 - Clustering: Print silhouette scores for up to 10 clusters and identify optimum number of clusters. Part 1 - Clustering: Profile the ads based on optimum number of clusters using silhouette score and your domain understanding [Hint: Group the data by clusters and take sum or mean to identify trends in Clicks, spend, revenue, CPM, CTR, & CPC based on Device Type. Make bar plots]. Part 1 - Clustering: Conclude the project by providing summary of your learnings. Computer Science Engineering & Technology Python Programming CS PW [Show More]

Last updated: 6 months ago

Preview 1 out of 8 pages

Buy Now

Instant download

We Accept: