Google Analytical Interview Questions

Sadhana U. - "Know your audience Understand who the end user is and their role within the organization. Adapt technical lingo to lingo that can be understood by the end user. Diagrams of functions with less dense text is helpful for non-technical users. If it presents like a Manual, that's a turnoff. If it presents like a Guide, non-technical people can follow it. Simplify the problem By simplifying the problem you can explain it to your client in her/his own words. Try to use examples from the client'"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

Raj M. - "Never a straight-forward answer. Assuming that this is a company goal to increase ad revenues from Chrome, try and understand the reason for the negative feedback. Is it a systematic issue (ads generally do lower overall user experience) or a specific issue (quality of ads, technical issues)? If the latter, fix that and run the experiment again. If former, how does this compare to user experience for other products with or without ads (YT vs YT premium)? If it above benchmarks, then pause. If in"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

Ted K. - "Depends on the memory available. Also if there's any structure to the data already. If this is just pure numbers random and all over the place and we don't need to worry about space. Then radix sort would be the best. But this all depends on what constraints the interviewer gives you."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

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

Tanshi T. - "How many people are using the shuttle service? what are the stops for the service? What time does the shuttle service run? How many people are driving versus the shuttle service? "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

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

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