Skip to content

MattDurocher/Amazon_Vine_Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Amazon_Vine_Analysis

Overview

Our goal today was to go over data provided to us and compare reviews written from paid sponsorships vs. free reviews from general customers. I chose to review a dataset of mobile electronics. After this data was analyzed and broken down into various data frames, I then pushed it to a SQL database using AWS.

customers_table

products_table

review_id_table

vine_table

Results

As seen in the chart below, there were:

  • 4 paid reviews vs. 1060 free reviews
  • 1 paid five star review vs. 527 free five star reviews
  • 25% of the being reviews were five star reviews vs. 49.5% of the free reviews being five star reviews

vine

Summary

In my dataset, there is not a positivity bias for paid reviews vs. the free ones. Obviously, the sample size was much smaller but it seems that the free reviews were much more positive than the paid ones. There were nearly two free five star reviews for every one paid five star review. In my opinion, this comes from the product that is being discussed. While mobile electronics is a broad subject group, I am assuming that this is describing important purchases such as a cell phone. The free reviews are coming from people who went and purchased that device vs. the competition so they most likely knew that they were going to like the product before even purchasing it. Due to this, Amazon would be better off putting their advertisement dollars in other categories since the free reviews are producing better results than the paid ones.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published