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 is...

RTB (Real-Time Bidding)

100

True or False? It's impossible to launch a YouTube campaign using CPV bidding 

No, it's possible, but the goal should be 

Product and brand consideration

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 can be important for a Lead Generation campaign?

CPA (Cost Per Acquisition/Action) or/and Conversions

200

The platform used by advertisers (us!) to manage, buy, and optimize ad inventory, in other words its standard name is...

DSP (Demand-Side-Platform)

200

What is the minimum number of users required for creating a LAL (lookalike) audience in Meta?

100 but Meta says they generally recommend a source audience that has between 1,000-5,000 people 

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 is...

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 from another table from a specified column.

VLOOKUP

300

Can you name the 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

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

First-Party Data

400

True or False? In TikTok, you can see not only the creatives of other advertisers but also performance metrics such as Engagement and CTR. 

Yes, it's true! You can check it via the Creative inspiration tool.

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 our team and it has a 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

It can be requested starting from minimum 1M impressions per month for some tactics and it allows you to track the number of people who visit a physical location after being exposed to an ad and its name is...

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

Few people know, but this is where hard coding usually happens inside Google Sheets

Apps Script

500

The platform that flags and blocks ads if you want to land the users to another marketplace is...

Amazon Ads