Google Analytical Interview Questions

RockyBalboa - "Clarifying question(s): what constitute a COVID related search? is it more on number of cases by geography, virus strains, vaccine information etc. ? Besides engagement is there anything we should take into account? Which personas are likely to be targeted: Journalists gathering more information for reporting Doctors and SMEs Common crowd with moderate to advanced education on health and safety measures and likely type of at-home entertainment Pharmaceuticals orga"See full answer

Sam M. - "The design review has three stages; In-draft, Review and Complete. I consider a design review completed when the problem statement has been clearly addressed via a feature or a solution and signed off on by all the key stakeholders along with engineerings."See full answer

Rev - "Clarify: Are we talking about the in stream auto video ads played? How is negative feedback affecting the metrics? Decrease in watch time? Other metrics affected? Since when are we observing the -ve feedback? What threshold were we fine with for -ve feedback? Is it observed across any particular geography, OS, device type? More details on what the -ve feedback says? Are we sure there are no technical issues/ systemic issues causing this, and it is indeed the auto play of ads"See full answer

Aishwarya R. - "Need for this feature : A user who has to reach somewhere on time - probably someone commuting to the airport would use this feature. I would pilot this feature in a city where there is a high volume of users using uber to commute to the airport, as well as a high volume of drivers, so that we deliver on what we promise. There are 2 side to this - the end user side, and the driver side. To measure the success of this application, primarily, I would track the number of users who are booking sched"See full answer

Ferri T. - "Clarification questions: What is the mission of the company? To connect people together to unleash their creativity. Is there any geographical areas that I should concentrate on? It is worldwide. Are there any constraints? No, there is none. Success of the usage of the app? The PM to pick. Approach: Establish the nature of the application. Establish the type of users that would be on the platform. Lay out what the user journey is. Define the metrics that are relevant. -"See full answer

Varun J. - "Timeline and trends analyze period when the CTR was down Check external factors Seasonality and holidays Competitive factors Industry-wide changes Ad performance analysis Ad copy Product feed quality Pricing Promotions and discounts Audience targeting and segmentation Specific demographics? User segment? Device across mobile, desktop, and tablet Ad placement and auction insights Anything changed with ad placement?"See full answer

Isnadea soraya R. - "untuk mengurutkan daftar angka secara efisien saya akan menggunakan aplikasi pengolah angka yaitu excel dengan rumus rumus untuk mempermudah dan mempercepat pengurutan daftar angka"See full answer

Shubh T. - "Clarifying Qns: Note: How do we define DAUs? Let's say it's open ended and based on general engagement (watch time, comments, etc.) Did the watch time went down and comments went up for the same videos or are we saying total watch time and total comments on Youtube? (Total) I am assuming we are not including Youtube Live videos because those are typically live chat 1000’s of comments for a single video. (Correct) Do we know if these two could be independent problems not correlated wit"See full answer

Rev - "Clarify shuttle service and carpool. Any objective behind this switch. Data points: Timings of shuttle service #users Location of users Revenue generated Costs associated Feedback of users"See full answer

Anonymous Muskox - "Metrics which Youtube Consider before building a recommender system Number of likes on a video by user The watch time of a video by the user The video disklied by the user The video share by a user The video skipped or churn with 20-30 seconds. Depending on this Youtube build a recommender system. The video suggestion feature in youtube works based on the recommender system. It may use a hybrid of batch prediction and online prediction. So depending on the above metrics, the youtube p"See full answer

Guru M. - "I have softened recruited people through LinkedIn. People from LinkedIn are more than happy to share their feedback on new products and features and to my surprise, I also saved a lot of company money on recruiting through services and offered Amazon vouchers to participants instead."See full answer

Rachel. kazir R. - "developing secured mobile phones for soldiers. too hot. the challenge was to find a creative ideas for power reduction on the existing technology"See full answer