Comcast Data Analyst Intern Interview Questions and Answers for Freshers

Q1. Find 3rd transaction of user from uber cab dataset
Ans. 
To find the 3rd transaction of a user from the Uber cab dataset.
• Identify the user's transactions in the dataset

• Sort the transactions by date/time

• Select the 3rd transaction of the user
Answered by AI
Add your answer
Q2. Find last quarter ordered product from logistics dataset
Ans. 
To find the last quarter ordered product from logistics dataset.
• Identify the date range for the last quarter

• Filter the dataset for orders within that date range

• Identify the product ordered in the last quarter
Answered by AI
Add your answer

Q1. General questions about self and resume.
Add your answer

Q1. General questions about digital market and current digital marketing trends.
Add your answer

Q1. Questions about digital advertising and logical reasoning. Checking if you're the right fit for the company.
Add your answer

Q1. General question about educational background
Add your answer

General aptitude test

Q1. Details about professional & educational backgound
Add your answer

Q1. Regarding the job skills
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
• I have a Bachelor's degree in Statistics and experience working with large datasets

• I am proficient in statistical software such as R and Python

• I have a proven track record of delivering actionable insights to drive business decisions
Answered by AI
Add your answer
Q2. Why Ad Operations
Add your answer
Q3. What do you know about display ads
Ans. 
Display ads are online advertisements that appear on websites, apps, or social media platforms in various formats.
• Display ads can include text, images, videos, or interactive elements

• They are typically targeted based on user demographics, interests, or browsing behavior

• Common types of display ads include banner ads, pop-up ads, and native ads

• Display ads can be purchased on a cost-per-click (CPC) or cost-per-impression ...read more
Answered by AI
Add your answer
Q4. How much you rate yourself in excel
Ans. 
I rate myself 8 out of 10 in Excel proficiency.
• Proficient in creating complex formulas and functions

• Skilled in data analysis and visualization using pivot tables and charts

• Experienced in VLOOKUP, INDEX-MATCH, and conditional formatting

• Familiar with macros and automation tasks
Answered by AI
Add your answer

General logical reasoning & graphical representation questions

Q1. General knowledge related topics
Add your answer

Q1. Discussion about yourself, your likes & dislikes. Basically getting to know you & understand your English speaking skills.
Add your answer

Q1. Speaking, listening and writing questions with American and British accent.
Add your answer

Q1. What is google ads auction
Ans. 
Google Ads auction is a process where advertisers bid on keywords to have their ads displayed on Google search results.
• Advertisers bid on keywords relevant to their target audience

• The ads that appear on Google search results are determined by a combination of bid amount and ad quality score

• The winner of the auction gets their ad displayed in the ad space on Google search results
Answered by AI
Add your answer
Q2. What are different types of match types?
Ans. 
Different types of match types include exact match, phrase match, broad match, broad match modifier, and negative match.
• Exact match: Ads are shown only when the search term matches exactly.

• Phrase match: Ads are shown when the search term includes the exact phrase.

• Broad match: Ads are shown for variations of the keyword, including synonyms and related searches.

• Broad match modifier: Ads are shown for searches that includ...read more
Answered by AI
Add your answer
Q3. What are bid strategies?
Ans. 
Bid strategies are the approach or method used to determine how much to bid on advertising placements in order to achieve specific goals.
• Bid strategies help advertisers optimize their ad spend and maximize their return on investment.

• Common bid strategies include manual bidding, automated bidding, target cost-per-acquisition (CPA), target return on ad spend (ROAS), and maximize clicks.

• Advertisers can choose bid strategi...read more
Answered by AI
Add your answer
Q4. What are types of targeting options?
Ans. 
Types of targeting options include demographic, geographic, behavioral, and psychographic.
• Demographic targeting focuses on factors such as age, gender, income, education, etc.

• Geographic targeting targets specific locations or regions.

• Behavioral targeting is based on user behavior such as browsing history, purchase history, etc.

• Psychographic targeting focuses on personality traits, values, interests, etc.
Answered by AI
Add your answer
Q5. How to do a keyword research?
Ans. 
Keyword research involves identifying popular search terms relevant to your content or business.
• Start by brainstorming relevant topics and terms related to your content or business.

• Use keyword research tools like Google Keyword Planner, SEMrush, or Ahrefs to identify popular search terms and their search volume.

• Analyze competitor keywords to see what terms they are ranking for and consider incorporating those into your...read more
Answered by AI
Add your answer

Q1. Tell me about yourself.
Add your answer
Q2. Why do you want to join this company and how do you think you are a good candidate?
Add your answer
Q3. What are your strengths and weaknesses?
Add your answer
Q4. What projects have you worked on in past? Please explain them.
Add your answer