使用ChatGPT进行亚马逊评价分析

本教程是以亚马逊评价分析为例,此方法同样适用于沃尔玛,独立站,速卖通等等电商平台。除了做评价分析以外,同样还可以以此方法为原理,对退货的feedback进行退货分析。

评价分析的重要性

相信所有亚马逊卖家都会或多或少的进行一些评价分析工作,哪怕是一个新手卖家,或许都可以感知到评价分析的重要性。

进行评价分析的有点包括:

获取客户反馈:

亚马逊评论提供了有关客户产品体验的宝贵见解。 通过分析这些评论,卖家可以更深入地了解客户喜欢和不喜欢他们的产品的哪些方面。 此反馈可以帮助卖家确定需要改进的领域并做出明智的业务决策。

协助产品改进

评论通常会突出显示客户遇到的具体问题或疑虑。 卖家可以使用这些信息来识别常见的痛点并对他们的产品进行必要的改进。 通过处理客户反馈并改进产品,卖家可以提高客户满意度和忠诚度。

完善声誉管理

亚马逊评论有助于卖家的整体声誉和可信度。 积极的评价有助于在潜在客户之间建立信任,并可以吸引更多的销售。 另一方面,负面评论可能会损害卖家的声誉并阻止潜在买家。 通过分析评论,卖家可以识别模式或重复出现的问题,并采取适当的措施来提高其声誉。

了解竞争优势

监控和分析亚马逊评论不仅可以深入了解卖家自己的产品,还可以帮助他们了解竞争对手的优势和劣势。 通过比较客户反馈和偏好,卖家可以确定可以使产品脱颖而出并获得竞争优势的领域。

优化营销销售策略

亚马逊评论通常包含有关客户偏好、需求和购买动机的宝贵信息。 通过分析这些评论,卖家可以确定能引起客户共鸣的关键卖点和独特功能。 这些信息可用于营销和销售策略,以突出产品的优势并吸引潜在买家。

总之,做好亚马逊评价分析,可以帮助我们卖家了解客户情绪、提高产品质量、管理声誉、获得竞争优势并优化营销和销售策略。 它使卖家能够做出数据驱动的决策,最终提高客户满意度、销售额增加和业务增长。

使用Chat-GPT进行亚马逊评价分析

以往人工分析评价,往往会花费大量的时间,现在借助Chat-GPT,我们可以大大的提升评价分析工作的效率。

抓取评价注意事项

本文分享的网页爬取工具,是采用免费的插件进行抓取,大家每天抓取一部分自己或竞争对手的评价,是OK的,但是如果你想要短时间大量抓取亚马逊评价,会很容触发亚马逊的风控算法,因为原则上亚马逊是禁止各种爬虫机器人来爬取包括listing的描述,价格,评价等数据的。

如果你想要大量抓取亚马逊的评价,我会在后面提示一些常用的技术方法,大家可以联系贵公司的技术人员或者外包服务商进行处理,或者购买一些专业的爬虫软件。


2023年7月1日:

亚马逊已经更改了展示review数量,现在只展示100条评论,可以通过星级筛选最多抓取500条评论,原来介绍的关于更改Ip轮换,使用住宅代理,使用无头浏览器等方法已失效,该部分内容我已删除。现在需要大家定期按星级抓取竞争对手新增评价,每个星级单次可抓取100条,根据自己类目对手上评速度考虑每周或每月定期抓取最新评价进行分析。

安装免费抓取插件

安装插件Instant Data Scraper,支持谷歌Chrome与微软Edge浏览器(其实是微软的Edge也换成了谷歌的Chromium内核)

Chrome插件地址:Instant Data Scraper

Edge插件地址:Instant Data Scraper

抓取目标产品评价

Amazon Ring Video Doorbell

这里我们以亚马逊官方的产品Ring Video Doorbeel为例,我这里在评价里做了个筛选,优先展示最新评价,只看验证买家的评价。

Amazon All Reviews Filter

启动抓取插件,点击Try Another Table,当插件选取的红色区域为评价区域时,点击Start Crawling即可开始抓取评价,如果没有出现Start Crawling,说明插件没有找到下一页按钮的位置,一般会显示一个locate Next Button的按钮,点击这个按钮再点击评价下一页的位置,即可开始抓取。

下方的抓取数据我一般只选择保留用户名,评价标题和评价详情(大家根据自己实际需求进行保留),可以在抓取前就将不需要的数据列删除,也可以抓取完毕后,导出为CSV文件后再做删除处理。

抓取完评论以后下载评论CSV文件并上传至Google Drive,永 Google Sheets打开文件,并进行处理

数据格式处理与转换为YAML格式

将CSV文件中的数据表格标题进行修改,改为Name, Review Title, Review Description(使用英语)

下载此CSV文件

Chat GPT直接分析处理CSV表格内的文本内容容易出现混淆,需要将CSV的文本内容转换为Chat GPT更容易识别的YAML格式内容

访问下方网站,上传CSV文件,将CSV格式文件转换成YAML格式数据
https://www.convertcsv.com/csv-to-yaml.htm

点击Choose File 选择CSV文件上传,然后点击Convert CSV to YAML转换为YAML格式,转换完成后下面有一个Download Reslut下载转换好的文件。

转换好的YAML文件打开如下图:

使用Chat-GPT进行评价分析

注意:所有分析指令请全部输入英语指令,正确率更高

Chat-GPT中输入下方指令,此指令是我自己撰写的。

主要分析内容包括:

  1. 高频词汇
  2. 正面反馈
  3. 关注问题
  4. 改进建议
  5. 趋势偏好
  6. 竞争分析
  7. 意外见解

如果还有其他需要分析的部分,可以在此基础上进行优化:

Here's the list of reviews to analyze:

Perform a comprehensive analysis on the provided Amazon Product Reviews. Utilize your understanding and insights to conduct a study on customer sentiments and preferences.

Please develop your analysis report under the following sections:

Frequently Mentioned Phrases: Identify the top 10 phrases that customers commonly use to characterize the product.

Positive Feedback: Delineate the top 10 features or aspects of the product that are highly praised by customers, and provide some examples of these positive comments for each feature.

Areas of Concern: Ascertain the top 10 features or aspects that customers find less satisfactory or problematic. Explain each point with representative customer reviews.

Improvement Suggestions: Extract the top 10 suggestions for product improvements from the customer feedback. For each suggestion, provide a brief assessment of how it might enhance the product or user experience.

Trends and Patterns: Outline any observable trends or patterns in the reviews that could indicate changes in customer behavior or preferences over time.

Comparative Analysis: Draw comparisons, if applicable, between the product and similar products on the market based on customer reviews.

Unexpected Insights: Document any unexpected or unusual findings that may not fit into the above categories but could provide valuable insights for product enhancement or strategy adjustment.

List of Reviews:

使用Chat GPT 3.5进行分析即可,3.5一次可以输入3000词,GPT4对大量文本不会响应

一次分析40到50条,根据实际字数来,以下为ChatGPT示例分析结果:

Analysis Report:

Frequently Mentioned Phrases:

  1. Easy installation
  2. Picture quality
  3. Motion detection
  4. Battery life
  5. Recording feature
  6. Missing items
  7. Charging issues
  8. Monthly subscription fee
  9. App quality
  10. Security concerns

Positive Feedback:

  1. Easy installation: “I just installed it pretty easily and look at that picture!”
  2. Picture quality: “Great quality, easy installation, amazing app. Just love it!”
  3. Motion detection: “Perfect for a mosey neighbor… me.”
  4. Battery life: “Good video quality.”
  5. Recording feature: “Notifications and recordings were on point.”
  6. App quality: “Easy to install and takes amazing video and pictures of who is at your door and around your house.”
  7. Security concerns: “I feel protected & now my packages are safe!”
  8. No screws required: “I didn’t want no screws on my door so I went and got the double sided Gorilla Tape… works like a charm.”
  9. Improved experience: “Works as described. Just hate relying on the ring cloud but my wife wanted it.”
  10. Better than previous doorbell: “Especially compared to the overpriced – poor quality – horrible app doorbell camera we had before.”

Areas of Concern:

  1. Motion detection accuracy: “Ring still has the same problem as it did when 1st started… It’s not accurate with the motion detection.”
  2. Slow live video display: “Takes foreeeveerrrr for the live video to show.”
  3. Error messages and loading issues: “Most of the time doesn’t even load, just gives error message.”
  4. Inadequate recording and saving of footage: “Doesn’t record, doesn’t save footages.”
  5. Missing items: “Missing security screwdriver.”
  6. Difficult installation: “The new mount design is horrible… It’s so hard to install.”
  7. Charging problems: “The battery worked for a while but stopped working” and “The charge does not last long!”
  8. Monthly subscription fee: “A month after you buy this doorbell, you lose the recording feature. To have it back, you need to subscribe to a plan and pay a monthly fee.”
  9. Missing wall mount: “The mount piece was just not there.”
  10. Unsatisfactory customer support: “No returns after your ‘trial’ period ends.”

Improvement Suggestions:

  1. Improve motion detection accuracy to ensure accurate notifications and recordings.
  2. Enhance live video display speed to provide a real-time view.
  3. Address error messages and loading issues for seamless user experience.
  4. Enable reliable recording and saving of footage for security purposes.
  5. Ensure all necessary items are included in the package to avoid missing parts.
  6. Simplify the installation process for user convenience.
  7. Optimize battery life to reduce the frequency of recharging.
  8. Evaluate the pricing model and consider alternative options to the monthly subscription fee.
  9. Include the wall mount piece with the product to avoid customer dissatisfaction.
  10. Improve customer support and extend the return policy beyond the “trial” period.

Trends and Patterns:

  1. Positive feedback often emphasizes easy installation, good picture quality, and motion detection.
  2. Negative feedback commonly mentions issues with motion detection accuracy, slow live video display, and charging problems.
  3. Customers express concerns about missing items, difficult installation, and the requirement of a monthly subscription fee.
  4. Several customers mention improved experiences compared to previous doorbell cameras.
  5. There is a desire for better recording features and options for saving recordings.

Comparative Analysis: Based on customer reviews, the product has positive aspects such as easy installation, good picture quality, and motion detection. However, it also faces challenges in terms of motion detection accuracy, slow live video display, and charging issues. Some customers compare it favorably to previous doorbell cameras they have used, highlighting its superior features and performance.

Unexpected Insights:

  1. Some customers express frustration with the monthly subscription fee required to access certain features, feeling that they should have full functionality without additional costs.
  2. The absence of necessary items, such as the wall mount and security screwdriver, is a recurring concern for customers, indicating a need for improved quality control in packaging.
  3. Customers appreciate the ease of installation and the option of using double-sided Gorilla Tape instead of screws, indicating a preference for hassle-free installation methods.
  4. The reliance on the Ring cloud for storage and access to recordings is a source of dissatisfaction for some users, who would prefer more flexibility in saving and managing their recorded footage.

Overall, while the product receives positive feedback for its easy installation, picture quality, and motion detection capabilities, there are areas that require improvement, such as motion detection accuracy, charging performance, and the inclusion of necessary items. Addressing these concerns, offering more flexible pricing options, and exploring alternative recording and storage solutions could enhance customer satisfaction and improve the overall user experience.

如果对于大量的Review数据需要分批次录入分析,使用一下指令,第一次输入在Group 1 下方输入第一组Review数据,后面新的评价数据只需要在对话中输入Group 2+评价数据,Greoup 3+评价数据的形式即可,在同一个对话界面内会重复执行初始分析指令。

We're about to conduct a comprehensive analysis of a large set of Amazon product reviews, categorized into groups each containing up to 50 reviews. For each group, please carry out the following analysis:

Frequently Mentioned Phrases: Identify the top 10 phrases customers frequently use to characterize the product.

Positive Feedback: Highlight the top 10 aspects or features of the product that customers appreciate the most, accompanied by representative customer comments for each aspect.

Areas of Concern: Discover the top 10 aspects or features that customers find less satisfactory or problematic, each detailed with supporting customer reviews.

Improvement Suggestions: Assemble the top 10 customer suggestions for product improvements and assess how each might enhance the product or user experience.

Trends and Patterns: Report any significant trends or patterns in the reviews that may indicate shifts in customer behavior or preferences.

Comparative Analysis: If possible, draw comparisons between this product and similar ones on the market based on customer reviews.

Unexpected Insights: Document any unusual or unexpected findings that may provide valuable insights for product enhancement or strategy adjustment.

List of Reviews (Group 1):

[Insert first group of reviews here]

After all the groups of reviews have been processed, provide a summary of the overall analysis. The summary should bring together the findings from each group and present them in a tabular format for easy comparison.

汇总输出中文分析结果

输入以下prompt指令:

Translate the analysis results to Chinese, and output in table form, Each analysis part for a single table

Chat-GPT 汇总后输出结果:

频繁提及短语中文翻译原词
安装简单Easy installation
图像质量Picture quality
运动检测Motion detection
电池续航Battery life
录像功能Recording feature
缺少物品Missing items
充电问题Charging issues
月度订阅费Monthly subscription fee
应用质量App quality
安全问题Security concerns
积极反馈对应内容示例评论
安装简单Easy installation“我很容易安装,看看那个画面!”
图像质量Picture quality“品质很好,安装简单,应用程序也很棒。我很喜欢!”
运动检测Motion detection“对于我这样好奇的邻居来说,非常完美。”
电池续航Battery life“视频质量不错,但是我每个月都需要充电,这很麻烦。”
录像功能Recording feature“通知和录像都非常准确。”
应用质量App quality“安装简单,拍摄出门口和周围环境的视频和照片效果很棒。”
安全问题Security concerns“我感到安全,现在我的包裹都安全了!”
无需螺丝No screws required“我不想在门上打螺丝,所以我用了双面大猩猩胶带…效果非常好。”
改善的体验Improved experience“功能如描述。只是不喜欢依赖Ring云服务,但是我妻子想要。”
胜过之前的门铃Better than previous doorbell“特别是与我们之前由当地警报/监控公司提供的过价、质量差、应用糟糕的门铃相比,简直太棒了。”
关注点对应内容代表性客户评论
运动检测准确性Motion detection accuracy“Ring仍然存在与最初启动时相同的问题…运动检测不准确。”
慢的实时视频显示Slow live video display“实时视频显示时间太长。”
错误信息和加载问题Error messages and loading issues“大部分时间甚至无法加载,只显示错误信息。”
录像和保存问题Recording and saving issues“无法录像,无法保存录像片段。”
缺少物品Missing items“缺少安全螺丝刀。”
安装困难Difficult installation“新的安装设计太糟糕了,安装非常困难。”
充电问题Charging issues“电池一开始工作一段时间后就停止工作。”
月度订阅费Monthly subscription fee“购买一个设备后一个月后,失去了录像功能。要恢复该功能,需要订阅计划并支付月费。”
缺少壁挂支架Missing wall mount“非常期待打开和使用我的Ring门铃,但是缺少壁挂支架,这是无法接受的!”
客户支持问题Customer support issues“试用期结束后无法退货。”
改善建议对应内容简要评估
提高运动检测准确性Improve motion detection accuracy“确保准确的通知和录像。”
加快实时视频显示速度Enhance live video display speed“提供实时观看体验。”
解决错误信息和加载问题Address error messages and loading issues“确保无缝的用户体验。”
可靠的录像和保存功能Enable reliable recording and saving features“为了安全起见,实现可靠的录像和保存功能。”
提供完整的配件Provide complete accessories“确保所有必要的物品都随附产品,避免缺失。”
简化安装过程Simplify installation process“为用户提供更便捷的安装方法。”
优化电池续航Optimize battery life“减少充电频率,延长电池使用时间。”
重新评估定价模型Reevaluate pricing model“评估定价模型,并考虑替代性选择,以满足不同用户的需求。”
解决月度订阅费问题Address monthly subscription fee issue“重新考虑计费方式,提供更灵活的选择。”
改进客户支持Improve customer support“提升客户支持水平,延长退货政策。”
趋势和模式对应内容相关发现
积极反馈常强调安装简单、图像质量和运动检测功能。Positive feedback often emphasizes easy installation, good picture quality, and motion detection capabilities.“积极的反馈通常强调安装简单、画面质量好和运动检测能力强。”
消极反馈中经常提到运动检测准确性、实时视频显示慢和充电问题。Negative feedback commonly mentions issues with motion detection accuracy, slow live video display, and charging problems.“消极的反馈通常提到运动检测准确性问题、实时视频显示慢和充电问题。”
客户对于缺少物品,如壁挂支架和安全螺丝刀,表示担忧。Customers express concerns about missing items, such as the wall mount and security screwdriver.“客户对于缺少壁挂支架和安全螺丝刀等物品表示担忧。”
客户欣赏安装简单和使用双面大猩猩胶带代替螺丝的便利性。Customers appreciate the ease of installation and the option of using double-sided Gorilla Tape instead of screws.“客户欣赏安装简单和使用双面大猩猩胶带代替螺丝的便利性。”
对于Ring云服务存储和访问录像的依赖引起一些用户的不满,他们希望能够更灵活地保存和管理录像。The reliance on the Ring cloud for storage and access to recordings is a source of dissatisfaction for some users, who would prefer more flexibility in saving and managing their recorded footage.“对于Ring云服务存储和访问录像的依赖引起一些用户的不满,他们希望能够更灵活地保存和管理录像。”
一些客户对于需要支付月度订阅费来使用某些功能表示不满,他们希望能够在没有额外费用的情况下享受全部功能。Some customers express frustration with the monthly subscription fee required to access certain features, feeling that they should have full functionality without additional costs.“一些客户对于需要支付月度订阅费来使用某些功能表示不满,他们希望能够在没有额外费用的情况下享受全部功能。”
一些客户比较产品与之前使用过的门铃摄像头,认为该产品具有更好的功能和性能。Some customers compare it favorably to previous doorbell cameras they have used, highlighting its superior features and performance.“一些客户将该产品与之前使用过的门铃摄像头进行比较,认为该产品具有更好的功能和性能。”
用户期望更好的录像功能和保存录像的选项。There is a desire for better recording features and options for saving recordings.“用户期望更好的录像功能和保存录像的选项。”

重复此过程,一直分析完产品所有评价即可,每月再对新增评价进行新的分析,汇总。

知识共享许可协议
本作品采用知识共享署名-非商业性使用-禁止演绎 4.0 国际许可协议进行许可。转载请注明出处!
Picture of Lawrence Kuok
Lawrence Kuok

拥有8年数字营销经验,我是一位跨境电商外贸专家。精通谷歌SEO、PPC广告投放、网站建设、红人营销和联盟营销,致力于在简中数字世界中创造有价值有深度的干货内容。

0 0 votes
Article Rating
Subscribe
Notify of
guest
2 Comments 评论
Most Voted
Newest Oldest
Inline Feedbacks
View all comments
Jevy
Jevy
Guest
November 22, 2023 6:58 pm

thanks , very helepful

ufabet911
Guest
April 8, 2024 6:05 pm

There is definately a lot to find out about this subject. I like all the points you made

本文作者
Picture of Larry Kuok
Larry Kuok

专注跨境电商外贸数字营销

扫码订阅我的微信公众号

目录
2
0
有任何有趣的想法?咱们评论区见!x
()
x
Scroll to Top
Skip to content