# Quick Cheat Sheet of Digital Marketing Formulas

• Oct 24, 2018

• by Rakhi Chowdhary

0
Get in
touch

## Digital Marketing Formulas: Your Everyday Cheat Sheet

Who does not want traffic on their websites? In this marketing world, SEO has proved to be a cost-effective result-driven approach for boosting your business, so why not gain the lucrativeness of SEO? What a digital agency promises are not rocket science or top secrets. Our online experiences start with a search engine and end with a search engine, what lies in between is our strategies to utilize these resources and build a full plan to implement those in the right direction.

I would like to share a few formulas for your daily use in the digital marketing world. You can surely save some time if you have these digital advertising formulas on your fingertip.

## List of Metrics & Formulas used in SEO Optimisations

Excel has always been one of the favourite tools amongst SEOs, and now, so is Google Sheets. Here are a few simple and easy to use Google Sheet/Excel formulas for SEO.

 Term Formula Details Example SUM Syntax: SUM(number1;number2;…) The SUM function is used to make large scale addition a breeze. Example: =SUM(B2;B7;B13) LEN Syntax: LEN(text/cell) The LEN function returns the number of characters in a text string/cell. Example: =LEN(A6) LOWER / UPPER / PROPER Syntax: LOWER(text/cell) Syntax: UPPER(text/cell) Syntax: PROPER(text/cell) To change sentence case. Example: =UPPER(A2) Example: =LOWER(A3) Example: =PROPER(A4) CONCATENATE CONCATENATE(text1, [text2], …) This is used to join multiple text strings/cells so that the content appears as one in a new cell. Example: =CONCATENATE(A3;B3;C3) IF IF(logical_test, value_if_true, [value_if_false]) This is used to tell IF a condition is met in a certain cell. Example: =IF(A2=”>12″;”Yes”;”No”) VLOOKUP VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) This function is used to find things in a range. Example Formula: =VLOOKUP(A4;’Lookup Table’!A2:D1000;4;FALSE) Keyword Density Keyword Density = (Nkr / Tkn) x 100 Density = your keyword density Nkr = how many times you repeated a specific keyword Tkn = total words in the analysed text Keyword density is the percentage of times a keyword or phrase appears on a web page compared to the total number of words on the page. So, if your article or piece of content (the text you are analysing) is 500 words in length and you have used your keyword 15 times, the keyword density for that keyword is… Keyword density = (Nkr / Tkn) x 100 = (15 / 500) x 100 = 0.03 x 100 =3 Keyword density = 3%

## List of Daily Metrics & Formulas for Google Analytics

Here are few Google Analytics Metrics Formulas

 Term Formula Details Example Pages per Session Pages per Session = PageViews / Sessions Average number of pages viewed per session. This is a good engagement metric for businesses that want low bounce rates and high levels of engagement. For example, a website that has had 1,000 sessions and 3,500 PageViews, we would get the following: 3,500 / 1,000 = 3.5 Pages Per Session (PageViews Per Session) Bounce Rate Bounces / Clicks (or Sessions) The rate at which users leave a site after visiting only one page. This metric is represented by a percentage. For example, if you have received 150 Clicks and 70 of those Clicks bounced (left the site after viewing just one page), we could get the following: 70/ 150 = 0.467 = 46.7% Bounce Rate. Meaning that in this example 46.7% of Clicks result in a bounce. Avg. Session Duration (Seconds) Avg. session duration (seconds) = total duration of all sessions (in seconds) / number of sessions The average amount of time (in seconds) that a visitor session last. Goal Conversion Rate Goal Completions / Sessions Goal Abandonment Rate (No. of Goal Starts – No. of Goal Completions)/ No. of Goal Starts Exit % Exit/ Pageviews New Sessions % New Users / Sessions Ecommerce Conversion Rate Transactions / Sessions Cost per Transaction Cost / Transactions RPC – Revenue Per Click (Revenue + Goal Value) / Clicks

## Conclusion

The most imperative thing is what you do with your data. If you don’t plan to change your campaigns with the purpose of improving them, then there's no use in collecting data in the first place. It’s critical that you use these formulas to collect information and then change your campaigns accordingly to attain the right type of conversions and ROI that you want. I’d love to hear your thoughts on our digital marketing formula cheat sheet. Feel free to discuss your favourite formulas in the comment section.

##### Would you like to work with us? Get in touch.

• Rakhi Chowdhary

Currently, an SEO manager at Envigo Marketing Pvt. Ltd., Rakhi Chowdhary with over 12 years of SEO experience in an array of industry verticals, is focused on leveraging her expertise across industries for different service areas. She has successfully created and managed campaigns for various promotional strategies.

View posts by Rakhi Chowdhary

• ### Marketing Trends to Watch in 2024

Feb 05, 2024

2023 left you breathless, didn't it? From privacy regulations tightening their grip to the AI revolution accelerating...