CallOne Consultants Interview Questions and Answers

Q1. No qualifications were discussed, more personal details were asked
Add your answer

Q1. To know basic details about my profile, if I match the profile criteria and company matches my expectations.
Add your answer

There was a task provided to me for the role and I had to submit it within the provided timeline.

Q1. It was more related to my assignment, skills, and past experience. Situations I handled in the past. More of a practical round.
Add your answer

Q1. Final discussion round.
Add your answer

Q1. Are you planning pregnancy?
Ans. 
It is not appropriate to ask about pregnancy in a job interview as it is a personal matter.
• Politely redirect the conversation back to your qualifications and experience

• Explain that personal matters such as family planning are not relevant to the job

• Express that you are focused on your career and committed to your work
Answered by AI
Add your answer
Q2. Are you comfortable working late nights?
Add your answer

Q1. SQL Window Functions and RANK, DENSE RANK Difference
Ans. 
SQL Window Functions like RANK and DENSE RANK are used to assign a rank to rows within a partition.
• RANK function assigns a unique rank to each distinct row within a partition.

• DENSE RANK function assigns a unique rank to each distinct row within a partition, but without any gaps.

• Both functions are used with the OVER() clause in SQL to define the partition and order of rows.
Answered by AI
Add your answer
Q2. Hadoop Default Replication Factor
Add your answer

Q1. Tell me about yourself?
Ans. 
Experienced performance marketing manager with a proven track record of driving successful campaigns and maximizing ROI.
• Over 5 years of experience in performance marketing

• Proficient in utilizing various digital marketing channels such as PPC, SEO, and social media advertising

• Strong analytical skills to track and optimize campaign performance

• Managed budgets effectively to achieve desired results

• Previously increased conv
Answered by AI
Add your answer
Q2. Attribution models in Google ads?
Ans. 
Attribution models in Google Ads determine how credit for conversions is assigned to different touchpoints in a customer's journey.
• Common attribution models include last click, first click, linear, time decay, and position-based.

• Each model has its own way of assigning credit to touchpoints based on their position in the customer journey.

• For example, the last click model gives all credit for a conversion to the last tou...read more
Answered by AI
Add your answer
Q3. Define Ad Rank?
Ans. 
Ad Rank is a value used to determine the position of an ad on a search engine results page.
• Ad Rank is calculated based on the bid amount, ad quality, and ad extensions.

• Higher Ad Rank increases the chances of an ad being shown in a higher position.

• Ad Rank formula: Ad Rank = Bid Amount x Quality Score + Ad Extension Impact.

• Example: An ad with a high bid amount, good quality score, and relevant ad extensions will have a h
Answered by AI
Add your answer

Basic email writing and one concepts para for the product line

Q1. Past job experience
Add your answer
Q2. Why amitoje and were you se yourself
Add your answer