May 2009 - May 2017 论坛八周年-你的足迹,我的骄傲



查看: 2076|回复: 15

[Analytics] product analytics/ sense 跟踪记录贴

[复制链接] |试试Instant~ |关注本帖
calalia 发表于 2016-10-17 13:47:55 | 显示全部楼层 |阅读模式


您需要 登录 才可以下载或查看,没有帐号?获取更多干活,快来注册

谈不上总结。刷题日记。 来自B2B的怪物要熟悉 2C的世界了

一点点记录下来 自己看的资料和感想。以后再整理. 鐗涗汉浜戦泦,涓浜╀笁鍒嗗湴

之前面analyst 的帖子。 ... p;extra=#pid2587312.鐣欏璁哄潧-涓浜-涓夊垎鍦

现在已经做了一年PM 在面PM神马的

系统知识理论 和 解题并进 感觉都是套路
. from:
之前面Anlyst的时候很多东西想不通 也找不到 原来都在Pm面试里面

现在只能零散的记录 以后出一份中文的专门给数据的童鞋.鐣欏璁哄潧-涓浜-涓夊垎鍦





  • · Job|主题: 69, 订阅: 4
 楼主| calalia 发表于 2016-10-18 03:40:03 | 显示全部楼层
晕。好像最近Apply出错超级多 self management 备受质疑啊

下周一个G家. Waral 鍗氬鏈夋洿澶氭枃绔,
Recruiter 给力的回复

Position Overview

As an overview, our Product Managers bring to fruition new products and features that genuinely benefit our users while at the same time make good business sense. They act as general managers of our products, providing leadership across functional teams to conceptualize, build and deliver Google's next great app. Product Managers find our entrepreneurial culture to be exciting and challenging, because they are never stuck maintaining an existing product, but are instead focused on developing new product ideas and strategies.

We have openings across all of our products in areas such as Consumer, Mobile, Apps, Enterprise, Infrastructure and Hardware to name a few. As a brief outline, we have an agnostic interview process in which we aim to hire Product Manager "generalists", who may have niche experience but can easily float through our evolving product lines. We find this keeps our Product Managers fresh and with distributed, homogeneous experiences for our project teams. So, in a nutshell, we do not hire for a specific product, but rather, are seeking generalists who can work on multiple products. As such, you'll interview with Product Managers working on any number of our various products. At a later point, our leadership reviews your interests, background and interviews to identify relevant projects that align with business need.

Interviewing @ Google

Interviewing for a new job can be scary and intimidating. At Google, we hope they’ll be challenging and enjoyable. As we aim to hire generalists, you can expect to interview with Product Managers working on any number of our products - our Product Managers are centered on problem solving ability so there won’t be many questions about specific experiences or domains.
. 1point 3acres 璁哄潧
In preparation, you can expect discussions around the following:

*Product design - Thinking creatively/critically about products - eg, how to monetize twitter, how to change Gmail, design an app for the Louvre. Give feedback and analysis on features (think of how to best delight the user), technical design, UI design.. 涓浜-涓夊垎-鍦帮紝鐙鍙戝竷

*Product strategy - Understand Google’s competitive landscape and discuss the vision for Google, the mobile market, the ad market, the internet, and technology in general. Discuss long term product roadmaps & strategies to increase market share.

*Analytical - May be a market analysis, problem solving or brain teaser question, eg. How would you store all the phone calls in the world? Most important is attention to detail and communication of how you’d break the problem into smaller nuggets to reach an overall solution.

*Technical - You could be asked architecture/design (eg multi-tiered web apps, data storage in databases) or conceptual questions (eg internet technologies and protocols). Possibly even an algorithm/coding question or two..鏈枃鍘熷垱鑷1point3acres璁哄潧
How can I prepare for interviews?
- Read through this blog, 1point 3acres 璁哄潧
- Listen and view Cracking the PM Interview by Gayle Laakmann McDowell
- Listen and view Cracking the Coding Interview by Gayle Laakmann McDowell
- Read and study the following books: Business Model Generation, The Algorithm Design Manual, Escape Velocity, The Design of Everyday Things, and Cracking the Coding Interview
- Familiarize yourself with all of Google – not just web search (Hint: 涓浜-涓夊垎-鍦帮紝鐙鍙戝竷
- Research our industry dynamics and current/recent industry events (hint: use Google News)
- Visit these links:    Fortune magazine ranks Google the #1 Best Company to work for in America   |  Sundar Pichai wants to bring the Internet to the rest of the world  |   Life at Google. From 1point 3acres bbs

回复 支持 1 反对 0

使用道具 举报

 楼主| calalia 发表于 2016-10-17 13:49:43 | 显示全部楼层
本帖最后由 calalia 于 2016-10-17 22:07 编辑 .1point3acres缃
今天的系统知识 已经更新在了旧帖子里
我还是觉得 就算是数学的同学. visit for more.
面Case的时候 也必须 Think as PM
Pm就必须think as 大老板 所谓拿着买白菜的钱 操着卖白粉的心

那今天差不多结束 拿两个题练练

Tell me how you would scale a social media software platform?framework : AARRR

. 1point 3acres 璁哄潧
补充内容 (2016-10-18 16:27):
Asked me how I monetized a mobile app which I had supervised. Kept digging on this issue even though I've plainly stated that I couldn't figure out an effective way to monetize a socialization-based mobile app. The flow of the interview got to a snail's pace.

补充内容 (2016-10-18 16:29):
PM's primary objective is to build a product that achieves or strives to achieve one or more stated business goals. For monetization - customers are paying for silly and elementary services like note taking and even turning their smart phones into a glowstick/flashlight. You should have at least tried to think of a few possible ideas.
回复 支持 1 反对 0

使用道具 举报

ppstacy 发表于 2016-10-18 02:00:27 | 显示全部楼层
回复 支持 反对

使用道具 举报

 楼主| calalia 发表于 2016-10-19 06:23:36 | 显示全部楼层
What is the marginal cost of a gigabyte in gmail?.鐣欏璁哄潧-涓浜-涓夊垎鍦
边际成本?。。。。。 gmail
好像是个Pricing问题 相当于说 如果要加容量 1G多少钱这样

Here's my guess at what they're looking for. Marginal cost - this is the additional cost for adding a user. It doesn't need to take in to account the software development effort, but it should take out the atomized cost for everything else. You need to price out the the cost of the enterprise HD/GB. We can call it $1 by GB. Then you need to realize that there needs to be redundancy, so at the lest we need to double that number, if they put a super high value on data retention triple it. Then you need to think about server cost and divide that out, server rack space cost and physical rack area...etc. So if it's $1 for the actual HD space it's probably more like $2.50-$3.50 for the total marginal cost. I don't work for google, but my guess is that they're looking at the though process. What will change with a marginal user increase and what will not. If you only think of the cost of the HD then you're not getting a job with google.. Waral 鍗氬鏈夋洿澶氭枃绔,
. 鐗涗汉浜戦泦,涓浜╀笁鍒嗗湴
回复 支持 反对

使用道具 举报

 楼主| calalia 发表于 2016-10-19 06:24:22 | 显示全部楼层
you are on a biz trip and travelling from one city to another. you have a stack of unsorted flight boarding passes. only departure city and destination city are on the boarding pass. how do you find the first departure city and your final destination city
回复 支持 反对

使用道具 举报

 楼主| calalia 发表于 2016-10-19 06:26:24 | 显示全部楼层
What would you do to double the revenue for an existing Google product in the next 12 months?

I would ask the interviewer to clarify the question by: - what specific product - what are the current focused segment of the product - to increase revenue, you need to either find other focused segment (i.e.,e adjacent market) or increase market share in the current focused segment - if you already have large mkt share, then it is best to focus on creating solution for other focused segments
Enter new markets or segments, look at your LTV and focus on growth within the highest LTV segment (repeat engagement / purchases).. 1point 3acres 璁哄潧

回复 支持 反对

使用道具 举报

 楼主| calalia 发表于 2016-10-19 06:32:05 | 显示全部楼层
calalia 发表于 2016-10-16 23:49 鏉ユ簮涓浜.涓夊垎鍦拌鍧.
今天的系统知识 已经更新在了旧帖子里
我还是觉得 就算是数学的同学
面Case的时候 也必须 Think as PM

. dug deep into at least 3 monetization methods we've undertaken:. from:
1. Back-end photo printing service (revenue share with printer) given that our site stores photo albums. 2. General display ads. 3. Location-based ad (based on locations photos were taken).

We got deep into the discussion, just falling short of details such as percentage of revenue share, display ad click-through rate, etc., which I consider trade secrets even though I'm no longer associated with that company.'s operations I grew frustrated as the interviewer only seems to be interested in what we did, what succeeded and what failed.

He was not interested in learning more about me. I tried several times to guide the discussion back to myself and what I might contribute to Google, but to no avail.

回复 支持 反对

使用道具 举报

 楼主| calalia 发表于 2016-10-19 06:36:39 | 显示全部楼层
Given a set of 2D coordinates for the 4 corners of each building in a city skyline (as if in a photograph), how would you determine the outline of the silhouette of all buildings, where buildings may or may not overlap?

回复 支持 反对

使用道具 举报

 楼主| calalia 发表于 2016-10-19 06:44:55 | 显示全部楼层

Suppose there is a smart phone API that can give you a person's mood and that there are 100 different moods. There can be varying level of moods, such as happy, very happy, sad, extremely sad, etc. You can also have more than one mood at a time (such as nervous and excited). What app would you create to take advantage of this API?
回复 支持 反对

使用道具 举报

 楼主| calalia 发表于 2016-10-19 07:27:46 | 显示全部楼层
How would u solve a problem in performance in a theoretical web app?.鐣欏璁哄潧-涓浜-涓夊垎鍦
  . more info on

LC skyline problem
回复 支持 反对

使用道具 举报

 楼主| calalia 发表于 2016-10-19 07:37:17 | 显示全部楼层
one Interview:

1) Design a Washer and Dryer - You need to ask the interviewer questions about who the users would be. When I asked him, he said "The same sort of people who would buy a nest thermostat (Younger, more tech savvy and somewhat affluent).. more info on
2) How would you measure the success of Apple's WWDC event (This year vs Last Year). Note: The key here is to discern the difference between the event itself being better vs Apple releasing cooler stuff this year thereby getting more press coverage etc..1point3acres缃
3) How would you improve Youtube

Onsite:. From 1point 3acres bbs
1st Interview:
1) Latest trends in technology
2) What are the network implications of a handheld device meant for elementary schools kids
3) If Google has invented a way to make air travel 4x cheaper and 4x faster, what would you do with this technology?. 鐗涗汉浜戦泦,涓浜╀笁鍒嗗湴

2nd Interview:
1) Design an app for the dmv
2) Explain recursion to my grandma 鏉ユ簮涓浜.涓夊垎鍦拌鍧.
3) You have an ecommerce site in Spain and you've just localized this and now see that traffic has reduced. What could be the reasons.
4) Give me 3 features you like about your favorite google product and 3 that you would improve.
回复 支持 反对

使用道具 举报

 楼主| calalia 发表于 2016-10-19 07:47:40 | 显示全部楼层
3rd Interview: 1) How would you improve throughput of an airport by 100% 2) You've done all this stuff to improve throughput , what are the implications for the airport itself 3) How much storage space is required to host all the images of Google street view. 4) You see starbucks' on either side of the road sometimes, why do you think Starbucks Corp does this?

understand how much increase would get to +100%. Also need to know bottlenecks needed to achieve +100% throughput.

Breaking down throughput: avg # of people through airport per time period (day)
* The utilization rate of the airport by planes (can I fit more planes traffic into airport)?
* Utilization rate of planes (is there opportunity to get more butts in seats)?
* Airport plane capacity (if there's high utilization of planes and airport, do we need to build more terminals to accommodate the traffic)?
. 涓浜-涓夊垎-鍦帮紝鐙鍙戝竷* Airport human capacity (is the airport's capacity to process passengers a constraint)?
* Seasonality (are there days/months where the airport is under utilized, can we improve upon that)?

If we optimize everything, can we get to 100% increase in throughput? What's the revenue vs. cost impact of doing so (would the incremental increase in revenue cover the cost? how quickly could it cover the cost?)
回复 支持 反对

使用道具 举报

 楼主| calalia 发表于 2016-10-19 08:48:38 | 显示全部楼层
本帖最后由 calalia 于 2016-10-18 18:50 编辑

The goal cat be known beforehand since you don't know who the user is. Need to start there first- What the best guess for who this user is? I would use any one of several IP traffic analysis services (E.g. Alexa, Comscore) to get a demographic profile of the user. The service takes into consideration things like time of day the user is accessing the service, location (Based on IP lookup), type of browser (based on UA string), if available 3rd party cookies etc to form a profile that will tell you with a n atached confidence interval if this person is male, 30-45, interested in hiking etc- Can be pretty granular.

Second- Once I have that profile, map that onto heuristics that have been predetermined based on Youtube's biz goals and prior user study- E.g. Single males 30-45 are most likely to watch sports videos. This demographic is more likely to pay for exclusives/ More likely to click on associate videos. Make 4 more similar inferences.

Finally- Use those 6 inferences to pick from a virtual carousel fo videos (E.g. Latest Vs. Most liked Vs. Most views etc)- Idea is to mix it up. 鏉ユ簮涓浜.涓夊垎鍦拌鍧.
-google 1point3acres
Let's start with the problem ? - get started with YouTube ?
Goal - is to get them to view a video ? be a sticky customer ? convince them that this is a replacement to their TV ?

if someone is logging into YouTube for the first time it could be one of two people

> they have used YouTube before
. 鍥磋鎴戜滑@1point 3 acres> they haven't used YouTube before and have started by signing up first and then using YouTube
> they have just up with google elsewhere and are just logging in on YouTube with their google credentials.

In short.
> we may not have their YouTube history but might have their other Google history
> external signals (web/mobile, time of day, region, country etc).. 鐣欏鐢宠璁哄潧-涓浜╀笁鍒嗗湴
. 鍥磋鎴戜滑@1point 3 acres
> Let's think about type/format of content
   > Typical YouTube content ( movie trailers, songs, funny video etc)
   > Custom content
      - Introduction to YouTube
      - What's on ? (similar to the way they have with Cable where a channel continuously spins what's new and latest)
   > Short form and long form content.
> Age Group (suitable for a particular age group)
> Such type of content is across various categories ( entertainment, science, technology)


For a moment think about how does history of YouTube help you ?.1point3acres缃
> Show recently viewed.
> People who viewed this also viewed y (recommendation)
   .. basically you get better at predicting what a user might like and improve the probability of them viewing your recommendation.


Let's say we come up with various options on which 8 videos to show

Option 1 : Top videos across closest matching affinity group (let's say user is based in Kansas) - what's the top video watched 8 videos in Kansas for today
. Waral 鍗氬鏈夋洿澶氭枃绔,
Option 2 : Custom / Personalized content (What's on , Introduction) + 6 top videos

Evaluate various option based on user persona, goals .. 涓浜-涓夊垎-鍦帮紝鐙鍙戝竷


there isn't going to be a right answer to this question so the best guess is to make an educated guess well enough so that you can run your first experiment then be ready with other experiments so you can pick the best one
回复 支持 反对

使用道具 举报

 楼主| calalia 发表于 2016-10-19 10:02:56 | 显示全部楼层
-google 1point3acres


A very simplistic answer is success is when I meet the goals I set for the product. however a more elaborate answer would::

Typically I would think that success should equate success for my stakeholders or my customers. lets breakdown who the stakeholders are in this process.
My Org/Company - products are built to further company goals so success should translate to goals of the company
> Revenue goals
> Acquisition goals.

Buyers of my software - products should solve a problem for them (helping them design their process).鏈枃鍘熷垱鑷1point3acres璁哄潧
> Usage, Repeat purchase, NPS # of processes designed, # of complaints are all metrics to measure health of software use.1point3acres缃
> Qualitatively - through feedback etc one can get a sense of if the buyer feels value in our product and that's a key ingredient of success.
. from:
Team success. visit for more.
> at the end of the day your team is one that helps deliver on the product. the team could deliver on the product but then feel so burnt out or have a terrible experience that they may not want to work on the next iteration - although this does not contribute to product success it's not something
> other way to look at it is to see did we launch it in time within budget etc ?

Resellers-google 1point3acres
> if the products are offered by resellers, you can track their individual metrics as well.. 鐗涗汉浜戦泦,涓浜╀笁鍒嗗湴

. 鐗涗汉浜戦泦,涓浜╀笁鍒嗗湴
From a financial perspective a measure of success can be

> are we tracking per the business plan ?
> what's our acquisition cost ?. 鐗涗汉浜戦泦,涓浜╀笁鍒嗗湴
> how much did we spend to build the product?
. visit for more.
Operational perspective

> are we incurring more supply chain, servicing costs.

the key in my view is that success is not a single # - although one can always roll up to a # that can be a proxy for all others but an appreciation of how and what success means for everyone in the value chain is important to help answer the question what is success.

Acquisition, Activation, Retention, Referral, Revenue << framework is also a good way to think about answering this question
回复 支持 反对

使用道具 举报

hyper8866 发表于 2017-5-1 22:39:50 | 显示全部楼层
记录自己的学习 感觉这个方法不错!
回复 支持 反对

使用道具 举报



一亩三分地推荐上一条 /5 下一条

手机版|小黑屋|一亩三分地论坛声明 ( 沪ICP备11015994号 )

custom counter

GMT+8, 2017-5-29 10:19

Powered by Discuz! X3

© 2001-2013 Comsenz Inc. Design By HUXTeam

快速回复 返回顶部 返回列表