Knowledge Hub

Success in the dynamic landscape of marketing depends on engaging the right audience effectively. However, not all audiences respond the same to advertisements.

At the core of this lies a pivotal question:

Would customers buy without the corresponding paid advertising?
This question is at the core of incrementality in marketing, revealing three different ways people react to ads.

Understanding Audience Behavior

This basic exploration breaks down how audiences react into three different groups:

1. Non-responsive Audience: This group is unaffected by ads no matter how much they see them. They don't feel like engaging or buying because of ads.
2. Pre-existing Demand Audience: People in this group were already planning to buy, ads or not. Ads might change when they buy, but they won't change their mind about buying.
3. Incremental Audience: Importantly, this group includes people who are directly affected by ads. These potential customers engage or buy only because they saw ads, showing how much ads affect their behavior.

In typical SQL world (Structured Query Language), usually managing and manipulating data efficiently is very crucial for its performance, database lifecycle or DWH scalability. Temporary tables and materialized views are two powerful constructs (objects) that help in achieving both objectives simultaneously. Even though each serves a unique purpose within data operations and data streams. Let´s look at both little closer.

Temporary Tables

We can define them as typical tables which are created within a database session and are only available during the lifetime of that particular session. Lifetime during session is critical as they are designed to store intermediate results, results of window functions for complex calculations or data processing tasks and massive data manipulations.

Temporary tables are essentially useful in scenarios where data needs to be temporarily held and manipulated without affecting the main database tables. Here comes why it is called “temporary”. After your session ends, the temporary table is automatically discarded - same as you run command DROP TABLE, after query results are taken into another step. This way processing ensures no permanent database storage is consumed. You can imagine storing all 245 steps and their output tables consisting of 6 billion rows and 700 columns each day to have versions of each step.

MBO, OKR, and KPI are closely related concepts in performance management, but they operate at different levels. MBO (Management by Objectives) is a management philosophy introduced by Peter Drucker that focuses on aligning employees and managers around clearly defined objectives, usually on an annual basis. OKR (Objectives and Key Results) is a structured goal-setting framework that defines short-term objectives and measurable results, typically in quarterly cycles. KPI (Key Performance Indicator) is a measurable metric used to track performance and monitor progress over time.

In simple terms, MBO defines the overall management approach, OKR defines how goals are structured and reviewed in shorter cycles, and KPI provides the numerical indicators that measure performance. MBO and OKR focus on goal setting and alignment, while KPIs focus purely on measurement. They are not competing systems but different layers of performance management that can work together.