Google Analytics project - Search engines
Google Analytics project - Search engines
Embedded Files
This project consisted on following some instructions of the most important search engines data that was necessary to analyze acquisition, engagement and monetization. I picked up the data from the 2nd of June 2022 to 29th of June 2022.
Acquisition
Acquisition
Your manager asked you to find the number and percentage of new users who arrive at the Google Merchandise Store after using one of four search engines.
Google Analytics collects the metrics for Yahoo search services that have been customized and localized for a specific part of the world. For example, there were 5 new users from customized search services in Canada (ca.search.yahoo.com), 3 new users from customized search services in India (in.search.yahoo.com), and 2 new users from customized search services in Brazil (br.search.yahoo.com).
Google Analytics collects the metrics for Baidu searches from mobile users. There were 349 new users from the mobile source, m.baidu.com.
Google
Google
Yahoo
Yahoo
Bing
Bing
Baidu
Baidu
Engagement
Engagement
Your manager asked you to find the total users for the following events:
add_to_cart
begin_checkout
remove_from_cart
purchase
Additionally, your manager asked you to calculate the number of users with cart abandonment and the percentage of users with cart reduction.
add_to_cart
add_to_cart
begin_checkout
begin_checkout
remove_from_cart
remove_from_cart
purchase
purchase
Number of users with cart abandonment: 1,900 − 1,116 = 784
Percentage of users with cart reduction: 1,740 / 5,905 x 100 = 29.47%
Monetization
Monetization
Your manager asked you to find the total revenue, the number of first-time buyers, and the top three best-selling items.
Total income
Total income
First-time purchasers
First-time purchasers
Top items sold
Top items sold
Super G Washed Cap - 63 units
Google Laptop and Cell Phone Stickers - 60 units
Google Campus Bike - 59 units
Page updated
Google Sites
Report abuse