Havas Media Media Planner Interview Questions and Answers

15 mins aptitude test to be given

Q1. WHat are your career goals
Add your answer
Q2. Give example of your accomplishment
Add your answer

Q1. About paid media as per my exp. Google adwords and facebook
Add your answer

Q1. Salary related Document submission n all How soon you can join?
Add your answer

Q1. 1. Explain about your self and the current company you work with.
Add your answer
Q2. 2. Any revenues achieved if yes was it a team target or on Individual role?
Add your answer
Q3. 3. Do you have any idea about our company 3 Minds Digital ?
Add your answer

Q1. 1. Explain about yourself, overall journey and your current role.
Add your answer
Q2. 2. Explain about your revenue contribution to the company.
Add your answer
Q3. 3. Explain about what understanding you have about the company 3 Minds Digital.
Add your answer
Q4. 4. One to One Client Game.
Add your answer

1. Basic Aptitude Test in order to check the ability. Duration was about 60 minutes.

Q1. SQL Questions, 1. Difference between truncate and drop. 2. how to create a empty duplicate table based on existing table.
Add your answer

Easy leetcode data structure question

Q1. Write working code for calling a rest API, design rate limiter
Ans. 
Code for calling a REST API and designing a rate limiter
• Use a library like requests or axios to make the API call

• Implement a token bucket algorithm for rate limiting

• Set a maximum number of requests per second and queue excess requests

• Consider using a distributed rate limiter for scalability
Answered by AI
Add your answer

Q1. Design Database schema for instagram
Ans. 
Design a database schema for Instagram.
• Create tables for users, posts, comments, likes, and follows.

• Use primary and foreign keys to establish relationships between tables.

• Store user data such as username, email, and password securely.

• Include fields for post content, location, and timestamp.

• Track likes and comments on posts.

• Implement a notification system for follows and likes.

• Consider scalability and performance in the...read more
Answered by AI
Add your answer

Q1. Laravel framework question.
Add your answer

Q1. Laravel framework question
Add your answer

Q1. Reasons for the drop in CPM
Ans. 
Possible reasons for drop in CPM include seasonality, changes in ad inventory, shifts in audience demographics, and increased competition.
• Seasonal fluctuations in advertising demand

• Changes in available ad inventory

• Shifts in audience demographics affecting targeting effectiveness

• Increased competition leading to lower bids
Answered by AI
Add your answer
Q2. Types of floor in GAM
Ans. 
Types of floors in GAM include carpet, hardwood, tile, and laminate.
• Carpet

• Hardwood

• Tile

• Laminate
Answered by AI
Add your answer