Percent change is the percentage difference between the starting value and the ending value.. Percent change is frequently used in marketing and advertising to evaluate month-over-month and year-over-year changes in numbers.
To calculate percent change, enter the starting value and the ending value.
Percent Change Excel Formula
=sum(((ending value-starting value)/starting value)*100)
Spend: Spend is the net advertising cost. This does not include management fees, creative or anything else - purely the advertising hard cost.
Impressions: Impressions are the amount of times ads appeared, or were shown, in the given channel. Essentially how many ads were served by the advertising spend.
Click-through Rate (CTR): CTR is the rate at which impressions result in a viewer of the ad clicking on it. If 100 ads are shown and 1 person clicks, that is a 1% CTR. Clicks / Impressions = CTR
Clicks: Clicks are the amount of people who clicked on, or took an action on an ad. The click metric is also commonly associated with the number of website visitors.
Cost-per-click (CPC): Cost-per-click is the average amount paid in advertising spend per click on the ad. Spend / Clicks = CPC
Conversions: Conversions - which could be sales, leads, downloads, email opt-ins - is the total volume of conversion actions attributed to the ad spend.
Conversion Rate: Conversion rate is the rate at which a click turns into a conversion action such as a lead form submission, ebook download, email opt-in, sale, etc. Conversions / Clicks = Conversion Rate
Cost / Conv.: Cost-per-conversion is the average amount of advertising spend invested per resulting conversion action. Spend / Conversions = Cost-Per-Conversion
Spend more time working on your business and
trust your advertising to an expert.
© Dallas Mclaughlin, LLC 2023
Made with ❤️ in Tempe, Arizona 🌵
