Kinesso
Purview Interview Questions and Answers
Q1. Ecosystem of Programmatic Advertising
Programmatic advertising ecosystem is a complex network of players and technologies that enable automated buying and selling of digital ad inventory.
The ecosystem includes advertisers, publishers, ad exchanges, demand-side platforms (DSPs), supply-side platforms (SSPs), data management platforms (DMPs), and ad networks.
Programmatic advertising uses real-time bidding (RTB) to automate the buying and selling of ad inventory.
Data is a critical component of programmatic advertisi...read more
Q2. What is gtm, what is difference b/w dv360 and gtm.
GTM stands for Google Tag Manager, a tool for managing website tags. DV360 is a demand-side platform for programmatic advertising.
GTM is used for managing website tags, such as tracking codes and pixels.
DV360 is a demand-side platform used for programmatic advertising, allowing advertisers to buy ad inventory across multiple ad exchanges.
GTM is primarily used for tracking and managing website data, while DV360 is used for buying and optimizing digital ad campaigns.
GTM is more...read more
Q3. What are different programmatic buy types
Different programmatic buy types include open auction, private marketplace, programmatic direct, and preferred deals.
Open auction: Real-time bidding on ad inventory available to multiple buyers.
Private marketplace: Invitation-only auctions where premium inventory is sold to select buyers.
Programmatic direct: Directly buying ad inventory from publishers through automated platforms.
Preferred deals: Negotiated deals between buyers and sellers for specific inventory at fixed pric...read more
Q4. What is programmatc advertising
Programmatic advertising is automated buying and selling of online advertising space in real-time auctions.
Uses algorithms to target specific audiences
Real-time bidding for ad space
Optimizes campaigns based on performance data
Examples: Google Ads, Facebook Ads, DSPs
Q5. Difference between while and having
While is a loop statement used for iterating over a block of code until a condition is met. Having is a clause used in SQL to filter results based on a condition.
While is used in programming languages like Python, Java, etc. to execute a block of code repeatedly until a condition is true.
Having is used in SQL to filter results based on a condition that is applied to a group created by the GROUP BY clause.
While loops can be infinite if the condition is never met, whereas Havin...read more
Q6. what is pixel and gtm
A pixel is a small piece of code placed on a website to track user behavior, while GTM (Google Tag Manager) is a tool used to manage and deploy marketing tags on a website.
Pixel is a tracking code placed on a website to collect data on user interactions.
GTM is a tool that simplifies the process of adding and updating tags on a website without needing to edit the website's code directly.
Pixels are commonly used for tracking conversions, retargeting users, and measuring the eff...read more
Q7. queries using Joins
Joins are used to combine data from two or more tables based on a related column.
Joins are used to retrieve data from multiple tables in a single query.
Common types of joins include inner join, left join, right join, and full outer join.
Joins are typically performed using the JOIN keyword and specifying the columns to join on.
Example: SELECT * FROM table1 JOIN table2 ON table1.column = table2.column;
Joins can also be used with subqueries to further refine the data being retri...read more
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month