Excel
KPIs
The Basics
SEM
SEO
100

Formula that counts the number of cells in an array that have a number value in them.

What is =count?

100

Cost per click

What is CPC?

100

Top of Funnel Goal

What is Awareness? 

100

A set of ad groups that share a budget.

What is a campaign?

100

A program used by search engines to collect data from the internet.

What is a crawler?

200

Formula that allows you to add any number of columns or rows by selecting them or typing them in.

What is =sum?

200

Return on Investment

What is ROI?

200

The last and hardest goal for an ad to achieve.

Action

200

Referred to as the SERP

What is the Search Engine Results Page?

200

“A process or set of rules to be followed in calculations or other problem-solving operations, especially by a computer.”

What is the algorithm? 

300

A spreadsheet function that helps you find and output information quickly within a table.

What is VLOOKUP?

300

CTR

What is clickthrough rate?

300

This goal focuses on distinguishing a product or service from the competition or highlight its benefits.

What is consideration? 

300

The goal of a Search Text Ad.

What is a click?

300

Technical optimization to ensure accessibility for search engines and users.

What is coding?

400

Powerful tool in excel to summarize data.

What is a pivot table?

400

CVR

What is conversion rate? 

400

The main difference between Digital and Traditional Marketing.

What is data? 

400

Match type that prevents your text ads from showing if a search query containing that keyword appears.

What is a negative?
400

HTML attribute that provides a brief summary of a web page.

What is a meta description?

500

Formula to capitalize first letters in cells.

What is =proper? 

500

CPA

What is cost per acquisition/cost per conversion? 

500

Google and Facebook are called this within the digital marketing industry.

What is a duopoly?

500

Determined based on how relevant your keywords, ads, and landing pages are to the searches that trigger them

What is quality score?

500

Improves the indexation of your website as Google’s crawler follows link paths throughout the internet to find and index websites.

What is internal linking?

M
e
n
u