What's Your Name Again?
Welcome to Media
Appearances Count
Function Junction
Metric Blvd
100

This is a powerful tool that summarizes data.

What is a Pivot Table?

100

This is the name of the ad campaign you're viewing in reporting.

What is Campaign?

100
These are vertical on the worksheet and are designated with letters.
What columns?
100

This function returns a custom result when a formula generates an error and a standard result when no error is detected.

What is IFERROR?

100

These are very useful in measuring the success of an ad or the health of a business.

What are KPIs?

200

The average cost for 1,000 impressions.

What is CPC?

200

This is the unique ID of the ad you're viewing in reporting.

What is AD ID?

200
These are horizontal on the worksheet and are designated with numbers?
What are Rows?
200

This function strips extra spaces from text, leaving only a single space between words and no space for characters at the start or end of the text.

What is TRIM?

200

To report on marketing activities, metrics fall into either of these two categories.

What are simple or calculated?

300

The percentage of times people saw your ad and performed a click.

What is CTR?

300

This is a group of people who can potentially see your ads.

What is Audience?

300
This is a grouping of adjacent cells and is designated with a colon (:).
What is a Range?
300

This function runs multiple tests and returns a value corresponding to the first TRUE result.

What is IF?

300

 This is the number of times an ad has been viewed

What are Views?

400

The average cost for each video view.

What is CPV?

400

This is the estimated total amount of money you've spent on your campaign, ad set or ad during its schedule.

What is Media Spend?

400

This is the individual cell of a worksheet in which one piece of information is stored

What is Field?

400

This function combines the text from multiple ranges and/or strings.

What is CONCAT?

400

 This is the average cost for each click.

What is Cost Per Click?

500

This is the process of transforming and mapping data from one "raw" data form into another format with the intent of making it more appropriate and valuable.

What is Data Wrangling?

500

This is the amount of revenue earned per every dollar spent on media.

What is ROAS?

500
This is the most widely used view of the Excel worksheet.
What is the Normal View?
500

This function’s input arguments are lookup_value, table_array, col_index, [range_lookup].

What is VLOOKUP?

500

When the amount is low this is good.

What is CPC or CPA?

M
e
n
u