I will teach you how to preprocess and analyze KakaoTalk advertising messages to extract data. Analyzing advertising messages by time and day of the week can help establish an effective marketing strategy. First, let's learn how to download KakaoTalk advertising messages. Open my KakaoTalk app, oh, I already have it open. Select the chat room with the advertising messages. From the chat menu, choose Export Chat and select to save the messages as a text file. Let me try it in English this time. Now, looking at the data, it is structured with dates and user messages. Let's try inputting the data. First, let's understand how it interprets this data. Shall we analyze this data? Oh, let's take a look. Yes, Professor Smith examined the data as follows. So, looking at the date and user messages, now I will ask this.

Yes, first, I will process this data. There are both advertising messages and non-advertising messages. So, I will only use the messages labeled as advertising for analysis. So, first, I will preprocess them. Secondly, I will create a heatmap chart by time and day from the preprocessed messages. I would appreciate it if you could create it. The results are out. In my opinion, a slightly different image has emerged, so I will summarize this. Applause. Now it's out. Let's analyze the completed heatmap. When looking at the chart, we can see the times and days when advertising messages are mainly received. For example, we can see that the most advertising messages are received around 8 AM, 10 AM, and 2 PM. By looking at the days, we can see that on Saturdays and Sundays, compared to weekdays, advertising messages are mainly seen only at 12 PM on weekends. Let's take a closer look.

We can see it this way. So, shall we ask for an analysis of this? It points out the dots on this heatmap. In this simple way, we were able to see how this company delivers advertising messages. So, we have learned how to preprocess and analyze KakaoTalk advertising messages in data visualization like this.

챗GPT 데이터분석, 카카오톡 광고 메시지 분석

챗GPT 데이터분석, 카카오톡 광고 메시지 분석

스크립트