DM MIC (88) Debojyoti Mukherjee Google analytics.pptx

THIS THE PROJECT ON GOOGLE ANALYTICS

1. User Attributes Report Q1. What percentage of the users spoke Chinese?( Note : Refer to the Language parameter here, NOT the Country parameter) Answer: 3.07

2. User Attributes Report Q2. Out of the total active users, what was the top interest among them? How much revenue was acquired from these users?  Answer : 10.14 %

3. Engagement Report Q3. On which day was the average engagement time the highest? How much was it? Answer: 25 september 2025

4. User Attributes Reports Q4.  Which country generated the second-highest revenue? How much was this? What was its users’ average engagement time? Answer: India generated the second highest revenue. Revenue i.e $ 1 20.67 and avg engagement time is 1m01 s.

5. Acquisition Report Q5. What are the top 5 acquisition channels in terms of users you can see from the report? Answer: Direct,Organic Search,Paid Search,Cross-Network,Referral

6. Acquisition Report Q6. ‘Organic Social performed better than Organic Shopping’, true or false? Give suitable reasons to support your answer. Answer: Yes True , Organic social performed better than Organic Shopping because As you can see, Organic Social has a higher average conversions and total revenue than Organic Shopping. This means that Organic Social is generating more revenue than Organic Shopping.

7. Free Form Report Q7. Go to free-form explorations.  In dimensions, select only ‘Page Title and Screen Class’. Drag this to the ‘Rows’ section.  Add ‘Entrances’ in metrics and drag it to the ‘Values’ section.   Set the date range from May 24th, 2023, to June 20th, 2023. On the report, ensure that you click on the arrow next to the title ‘Entrances’ on the right-hand side column. Ensure it is a downward-facing arrow to see all the accurate data in the ‘Entrances’ column. What do you understand from the data on this page? Answer: Based on the data total ‘Entrances’ are 116 , 489 . It is conclusive that major portion of users entered the page through their desktops. The second highest device used are mobiles. The lowest device listed on the report are smart TVs.

8. Monetization Report Q8. Set the date range from March 1st, 2023, to May 31st, 2023. Which product brings in the most revenue? Justify your answer. Answer: Super G Marine LAyer Banks Hoodie The product that brings the most revenue. It generated a revenue of $ 10,675.00

9. Funnel Exploration Q9. Set the date range from May 24th, 2023, to June 20th, 2023. From which country did the most number of users visit the website? Justify your answer.  Hint : Use ‘Country’ in the breakdown. Answer:

10. Funnel Exploration Q10. People from which of the following countries purchased on the website - India, US, China and Japan? Justify your answer. Answer: US has the highest number of purchases

11. Segment Overlap Q11. Set the date range from May 24th, 2023, to June 20th, 2023. Move the ‘Active User’ metric to the ‘Values’ section. In which country did users aged 25 to 54 access the website from a tablet? How many users were this? Make sure you break down by ‘Country’. Answer: US 3980

12. Segment Overlap Q12.  How many transactions did these users make ? Hint: Further breakdown by ‘Country’ and ‘Transactions’ in the Value bar. Answer:

13. Cohort Exploration Q13. Set the date range from May 24th, 2023, to June 20th, 2023. For Cohort 1 (May 24th to May 27th, 2023) what percentage of paid traffic returned in week 4? Be sure to include your calculations. Hint: Ensure the segment paid traffic is dragged to the ‘Segment Comparison’ section. This should be the only segment here. Remove all the breakdowns.. Answer:

14. Cohort Exploration Q14. Using the same data for Cohort 2 (May 28th, 2023, to June 3rd, 2023), what percentage of learners returned in Week 3? Include your calculation.  Answer:

15. Cohort Exploration Q15. Did Cohort 1 ( May 24-27) perform better than Cohort 2 (May 28 - June 3)? Use Week 3’s data to calculate your answer. Answer: Both Cohort 1 and Cohort 2 worked same on week 3

16. User Lifetime Exploration Q16. Move the ‘Mobile Traffic’ segment to the ‘Segment Comparisons’ section. Move the ‘First User Source’ dimension to rows. Date Range: Last 30 days In the ‘Values’ section, ensure that you have ‘Active Users’, ‘Lifetime Transactions: Average’ and ‘Lifetime Engagement Duration: Average’. Which was the most popular First User Source through mobile traffic? How many users came through this medium? Support your answer with a screenshot Answer: Direct is the most popular First User Source through Mobile Traffic. Total users come from this are : 35,344