Prepare for and practice interview questions from Condé Nast.

Condé Nast Interview Questions

Condé Nast Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Condé Nast Salaries by Position

The New Yorker is a multi-platform media enterprise, spanning print, digital, audio, video, and live events. Founded in 1925, The New Yorker is considered by many to be the most influential magazine in the world, renowned for its in-depth reporting, political and cultural commentary, fiction, poetry, humor, and cartoons. In addition to the weekly print magazine, The New Yorker has become a daily digital destination for news and cultural coverage by its staff writers and other contributors. In print and online, The New Yorker stands apart for its commitment to truth and accuracy, for the quality of its prose, and its insistence on exciting and moving every reader. To see all New Yorker job openings, visit newyorker.com/careers. Job Description Location: New York, NY The Director of Analytics will provide strategic guidance to The New Yorker through in-depth analyses and reporting to key stakeholders across Editorial, Audience Development, Business Leadership, and more to help achieve audience and consumer goals for the magazine. The Director of Analytics will partner closely with these teams to develop and apply insights with the goal of deepening the brands' relationship with the reader. They will also be responsible for evangelizing the use of analytics for insight-based business decisions, both strategic and tactical, while serving as the analytic subject matter expert to various levels of business stakeholders, including analysts at other Cond Nast brands. The ideal candidate will be someone who is highly quantitative, but also nimble and creative, with the ability to think critically and influence the decision-making process through data and testing. Curiosity, motivation, rigor, and expertise with digital analytics tools are a must; a love for the New Yorker brand is a plus. This position reports to the Senior Director of Audience Development and Analytics for The New Yorker. Responsibilities: <ul> <li>Collaborate with brand stakeholders to develop and execute data-driven audience and revenue growth plans across all content distribution platforms </li><li>Use analytics to connect brand initiatives with larger company goals </li><li>Work closely with senior leadership to optimize and develop content strategy for various platforms and communicate best practices with the goal of driving audience growth, engagement, and loyalty. </li><li>Analyze and provide recommendations on editorial programming and planning, department staffing levels, and budgeting </li><li>Review, analyze, and report on confidential financial information and revenue data related to customer acquisition and retention. </li><li>Collaborate with business development to forecast long-term prospective investments, using confidential financial data to create accurate costs and revenue projections. </li><li>Manage and oversee junior members of the Audience Development and Analytics team. Responsible for hiring, training, and developing analysts at Cond Nast in new analysis techniques and skill sets. </li><li>Own The New Yorker's full suite of dashboards and ongoing daily, weekly, and monthly reports </li><li>Apply data mining and information-gathering techniques to identify and interpret patterns and trends in visitor and subscriber behavior on the website </li><li>Work cross-functionally with consumer revenue and commercial teams to identify opportunities, execute brand initiatives, and maximize customer acquisition and retention, including visibility into confidential subscriber and revenue data. </li><li>Collaborate with product and engineering to test and measure the efficacy of product changes, The New Yorker's app, and improve and QA analytics tools </li><li>Work with leadership to determine and meet growth KPIs and ensure that they align with revenue strategy </li><li>Additional duties as required, or as assigned by manager </li></ul>Skills and Qualifications: <ul> <li>8+ years of experience in digital analytics at media company or digital advertising agency with a thorough understanding of online business models and strategies </li><li>2+ years of experience managing a team of direct reports and hiring analysts </li><li>Expert in writing SQL queries and building dashboards for stakeholders (Python a plus) </li><li>Proficiency in synthesizing, reporting, and analyzing data in spreadsheets (Google Sheets a plus) </li><li>Hands-on experience with reporting and analysis using a major web analytics tool such as Omniture, Google Analytics, Parsely, etc. </li><li>Hands-on experience QAing and validating data sets </li><li>Hands-on experience managing digital audience acquisition programs </li><li>Hands-on experience with subscription funnels and subscriber analytics </li><li>Entrepreneurial, digitally savvy, creative and experimental in the approach to problem solving, with exceptional analytical and critical thinking skills </li><li>Ability to clearly articulate and present initiatives to editorial and technical teams alike, and adept at communicating with and managing a variety of stakeholders </li><li>Comfortable with statistical concepts </li></ul> The expected base salary range for this position is from $155,000-$180,000. Salary offers are based on a wide range of factors including but not limited to relevant skills, training, experience, and education. In addition to salary and a generous employee benefits package, successful candidates may also be eligible to receive discretionary bonus compensation. #LI-VS1 What happens next? If you are interested in this opportunity, please apply below, and we will review your application as soon as possible. You can update your resume or upload a cover letter at any time by accessing your candidate profile. Cond Nast is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, age, familial status and other legally protected characteristics.

Condé Nast Interview Questions

Condé Nast Interview Guides

Condé Nast Interview Questions

Condé Nast Salaries by Position

Condé Nast Opening Jobs