Excel Challenge

Impressions

Calculated using the formula Clicks/CTR*100.

Total Cost

Can be found using Cost=CPAActions or Cost=CPCClicks.

CPA

Cost per Action, calculated as Cost/Actions.

CPC

Cost per Click, calculated as Cost/Clicks.

CTR

Click-Through Rate, calculated as Clicks/Impressions*100.

Media Mix

Percentage syndication calculated as $ spent on medium divided by total $ spent by brand multiplied by 100.

Share of Spending

Calculated as $ brand spent on medium divided by $ category spent on medium multiplied by 100.

GRP

Gross Rating Points, calculated as Rating multiplied by Average Frequency.

Average Frequency

Calculated as GRPs divided by Rating.

Unit Cost

Arranged from the formula for CPP, calculated as CPP multiplied by Rating.

CPP

Cost per Point, can be calculated by rearranging the formula Unit Cost = CPP * Rating.

Total Impressions

Total impressions calculated as Impressions multiplied by Units.

Missing Ad Spend Report

Calculated as $ spent on medium = media mix * total $ spent by brand / 100.

Action Values

Cost calculated as CPA * Actions.

Total Brand Spending

Reverse calculation from share of spending, $ Total Brand = share of spending * total category.

$ Spent on Medium

The amount spent on a specific medium, calculated using media mix.

Locked Column

Using $ to lock cell references in formulas to maintain consistency when dragging formulas.

Impressions Formula

Impressions can also be found using Impressions = Rating * Universe / 100.

Cost Formula

Total Cost can also be calculated with Cost = Cost per unit * Units.

Units Calculation

Calculated as GRP divided by Rating.

CPM

Cost per Thousand Impressions, calculated as Unit Cost divided by Impressions.

Fill Missing Values

Refers to the process of calculating missing data in a dataset using established formulas.

Cost per Unit

Calculated by Total Cost divided by Units.