Advertising Analysis: How to Achieve Accurate Advertising?

Using CTR as the metric, analyzed E-commerce advertising data from channels, times, and groups to provide better solutions for more precisely targeted advertising.

Data Understanding

• Datasets

• ad_feature.csv | user_profile.csv | raw_sample.csv

• Data Storage & Analysis Tools

• MySQL | Excel | XMind
• Analysis Ideas

Data Analysis

• Analyze the CTR of different channels
• Analyze the CTR for different delivery time

• CTR analysis of each time per day
• CTR analysis for each day of the week
• CTR analysis for each time of every day

• Analyze the CTR of crowed characteristics

• CTR analysis of people of different ages
• CTR analysis of people of various consumption levels
• CTR analysis among people of different shopping levels
• CTR analysis of various occupations (college students or not)
• CTR analysis of crowd at different city levels