Digital ABC
Programmatic Magic
So Social
Tsar of Excel
What? Where? When?
100

This metric tracks the percentage of users who watched your video ad from start to finish

VCR (Video Completion Rate) 

100

The automated auction-based system used to buy and sell ad inventory in milliseconds

RTB (Real-Time Bidding)

100

A 6-second non-skippable video format on YouTube

Bumper Ads

100

What function sums values in a range based on a specific condition?

SUMIF

100

Where do we usually launch DOOH?

Vistar

200

Which metric is usually "the king" for a Lead Generation campaign?

CPA (Cost Per Acquisition/Action)

200

The platform used by advertisers (us!) to manage, buy, and optimize ad inventory

DSP (Demand-Side-Platform)

200

What is the minimum number of users required in a Meta Custom Audience before you can use it for an ad campaign?

100

200

What tool allows you to instantly transform a large data set into a compact summary report with groups and totals?

Pivot Table

200

Forgotten platforms (where we don't launch anymore), one of them?

ADT/Yahoo/Xandr

300

What does the acronym DOOH stand for?

Digital Out of Home

300

A technology that ensures your ad doesn't appear next to "unsafe" or inappropriate content

Brand Safety

300

Can you adjust age and gender targeting for all types of ad campaigns in Meta?

No, if we talk about Special Ad Categories (Housing, Employment, Credit, or Social Issues/Politics)

300

This legendary function looks for a value in the leftmost column and returns a value in the same row from a specified column.

VLOOKUP

300

Platforms for YouTube ads

DV360, Google Ads

400

This metric measures how many times, on average, a single unique user saw your ad.

Frequency

400

What do we call a data segment that comes directly from our own client’s CRM?

First-Party Data

400

Which specific visual format is strictly forbidden in Health & Beauty ads on both Meta and TikTok?

 Prohibits before-and-after results

400

Which key do you press to toggle between relative and absolute cell references (e.g., changing A1 to $A$1)?

F4 or FN+F4 depends on the laptop you have

400

This platform is well-known among pur team and it has free audience breakdown (age/gender)

Beeswax

500

In GA4, this metric replaced "Bounce Rate" to show users who actually interacted with the site

Engagement Rate

500

The measure of the number of visits to a retail space  

Foot traffic 

500

What is the mandatory security setting that Meta and TikTok now require for all Business Manager/Ads Manager users to prevent account hacking and ad spend draining?

2FA (Two-Factor Authentication

500

Little known fact, but this is where hard coding usually happens inside Google Sheets

Apps Script

500

The platform that flags and blocks ads linking to another marketplaces

Amazon Ads