Connect with us

MARKETING

15 Excel Formulas, Keyboard Shortcuts & Tricks That’ll Save You Lots of Time

Published

on

For most marketers, trying to organize and analyze spreadsheets in Microsoft Excel can feel like walking into a brick wall repeatedly if you’e unfamiliar with Excel formulas. You’re manually replicating columns and scribbling down long-form math on a scrap of paper, all while thinking to yourself, “There has to be a better way to do this.”

Truth be told, there is — you just don’t know it yet.

Excel can be tricky that way. On the one hand, it’s an exceptionally powerful tool for reporting and analyzing marketing data. It can even help you visualize data with charts and pivot tables. On the other, without the proper training, it’s easy to feel like it’s working against you. For starters, there are more than a dozen critical formulas Excel can automatically run for you so you’re not combing through hundreds of cells with a calculator on your desk.

What are excel formulas?

Excel formulas help you identify relationships between values in the cells of your spreadsheet, perform mathematical calculations using those values, and return the resulting value in the cell of your choice. Formulas you can automatically perform include sum, subtraction, percentage, division, average, and even dates/times.

Advertisement

We’ll go over all of these, and many more, in this blog post.

How to Insert Formulas in Excel

You might wonder what the “Formulas” tab on the top navigation toolbar in Excel means. In more recent versions of Excel, this horizontal menu — shown below — allows you to find and insert Excel formulas into specific cells of your spreadsheet. 

formulas-toolbar-excel

The more you use various formulas in Excel, the easier it’ll be to remember them and perform them manually. Nonetheless, the suite of icons above is a handy catalog of formulas you can browse and refer back to as you hone your spreadsheet skills.

Excel formulas are also called “functions.” To insert one into your spreadsheet, highlight a cell in which you want to run a formula, then click the far-left icon, “Insert Function,” to browse popular formulas and what they do. That browsing window will look like this:

insert-function-menuWant a more sorted browsing experience? Use any of the icons we’ve highlighted (inside the long red rectangle in the first screenshot above) to find formulas related to a variety of common subjects — such as finance, logic, and more. Once you’ve found the formula that suits your needs, click “Insert Function,” as shown in the window above.

Now, let’s do a deeper dive into some of the most crucial Excel formulas and how to perform each one in typical situations.

Advertisement

To help you use Excel more effectively (and save a ton of time), we’ve compiled a list of essential formulas, keyboard shortcuts, and other small tricks and functions you should know.

NOTE: The following formulas apply to the latest version of Excel. If you’re using a slightly older version of Excel, the location of each feature mentioned below might be slightly different.

1. SUM  

All Excel formulas begin with the equals sign, =, followed by a specific text tag denoting the formula you’d like Excel to perform. 

The SUM formula in Excel is one of the most basic formulas you can enter into a spreadsheet, allowing you to find the sum (or total) of two or more values. To perform the SUM formula, enter the values you’d like to add together using the format, =SUM(value 1, value 2, etc).

The values you enter into the SUM formula can either be actual numbers or equal to the number in a specific cell of your spreadsheet. 

Advertisement
  • To find the SUM of 30 and 80, for example, type the following formula into a cell of your spreadsheet: =SUM(30, 80). Press “Enter,” and the cell will produce the total of both numbers: 110. 
  • To find the SUM of the values in cells B2 and B11, for example, type the following formula into a cell of your spreadsheet: =SUM(B2, B11). Press “Enter,” and the cell will produce the total of the numbers currently filled in cells B2 and B11. If there are no numbers in either cell, the formula will return 0. 

Keep in mind you can also find the total value of a list of numbers in Excel. To find the SUM of the values in cells B2 through B11, type the following formula into a cell of your spreadsheet: =SUM(B2:B11). Note the colon between both cells, rather than a comma. See how this might look in an Excel spreadsheet for a content marketer, below:

sum-formula-excel

2. IF

The IF formula in Excel is denoted =IF(logical_test, value_if_true, value_if_false). This allows you to enter a text value into the cell “if” something else in your spreadsheet is true or false. For example, =IF(D2=”Gryffindor”,”10″,”0″) would award 10 points to cell D2 if that cell contained the word “Gryffindor.”

There are times when we want to know how many times a value appears in our spreadsheets. But there are also those times when we want to find the cells that contain those values, and input specific data next to it.

We’ll go back to Sprung’s example for this one. If we want to award 10 points to everyone who belongs in the Gryffindor house, instead of manually typing in 10’s next to each Gryffindor student’s name, we’ll use the IF-THEN formula to say: If the student is in Gryffindor, then he or she should get ten points.

  • The formula: IF(logical_test, value_if_true, value_if_false)
    • Logical_Test: The logical test is the “IF” part of the statement. In this case, the logic is D2=”Gryffindor.” Make sure your Logical_Test value is in quotation marks.
    • Value_if_True: If the value is true — that is, if the student lives in Gryffindor — this value is the one that we want to be displayed. In this case, we want it to be the number 10, to indicate that the student was awarded the 10 points. Note: Only use quotation marks if you want the result to be text instead of a number.
    • Value_if_False: If the value is false — and the student does not live in Gryffindor — we want the cell to show “0,” for 0 points.
  • Formula in below example: =IF(D2=”Gryffindor”,”10″,”0″)

Excel formulas and keyboard shortcuts: IF THEN

3. Percentage

To perform the percentage formula in Excel, enter the cells you’re finding a percentage for in the format, =A1/B1. To convert the resulting decimal value to a percentage, highlight the cell, click the Home tab, and select “Percentage” from the numbers dropdown.

There isn’t an Excel “formula” for percentages per se, but Excel makes it easy to convert the value of any cell into a percentage so you’re not stuck calculating and reentering the numbers yourself.

Advertisement

The basic setting to convert a cell’s value into a percentage is under Excel’s Home tab. Select this tab, highlight the cell(s) you’d like to convert to a percentage, and click into the dropdown menu next to Conditional Formatting (this menu button might say “General” at first). Then, select “Percentage” from the list of options that appears. This will convert the value of each cell you’ve highlighted into a percentage. See this feature below.

percentage-formula-in-excel

Keep in mind if you’re using other formulas, such as the division formula (denoted =A1/B1), to return new values, your values might show up as decimals by default. Simply highlight your cells before or after you perform this formula, and set these cells’ format to “Percentage” from the Home tab — as shown above.

4. Subtraction

To perform the subtraction formula in Excel, enter the cells you’re subtracting in the format, =SUM(A1, -B1). This will subtract a cell using the SUM formula by adding a negative sign before the cell you’re subtracting. For example, if A1 was 10 and B1 was 6, =SUM(A1, -B1) would perform 10 + -6, returning a value of 4.

Like percentages, subtracting doesn’t have its own formula in Excel either, but that doesn’t mean it can’t be done. You can subtract any values (or those values inside cells) two different ways.

Subtraction formula in Excel

  • Using the =SUM formula. To subtract multiple values from one another, enter the cells you’d like to subtract in the format =SUM(A1, -B1), with a negative sign (denoted with a hyphen) before the cell whose value you’re subtracting. Press enter to return the difference between both cells included in the parentheses. See how this looks in the screenshot above.
  • Using the format, =A1-B1. To subtract multiple values from one another, simply type an equals sign followed by your first value or cell, a hyphen, and the value or cell you’re subtracting. Press Enter to return the difference between both values.

5. Multiplication

To perform the multiplication formula in Excel, enter the cells you’re multiplying in the format, =A1*B1. This formula uses an asterisk to multiply cell A1 by cell B1. For example, if A1 was 10 and B1 was 6, =A1*B1 would return a value of 60.

Advertisement

You might think multiplying values in Excel has its own formula or uses the “x” character to denote multiplication between multiple values. Actually, it’s as easy as an asterisk — *.

multiplication-formula-in-excel

To multiply two or more values in an Excel spreadsheet, highlight an empty cell. Then, enter the values or cells you want to multiply together in the format, =A1*B1*C1 … etc. The asterisk will effectively multiply each value included in the formula.

Press Enter to return your desired product. See how this looks in the screenshot above.

6. Division

To perform the division formula in Excel, enter the cells you’re dividing in the format, =A1/B1. This formula uses a forward slash, “/,” to divide cell A1 by cell B1. For example, if A1 was 5 and B1 was 10, =A1/B1 would return a decimal value of 0.5.

Division in Excel is one of the simplest functions you can perform. To do so, highlight an empty cell, enter an equals sign, “=,” and follow it up with the two (or more) values you’d like to divide with a forward slash, “/,” in between. The result should be in the following format: =B2/A2, as shown in the screenshot below.

Advertisement

excel-division-formula

Hit Enter, and your desired quotient should appear in the cell you initially highlighted.

7. DATE

The Excel DATE formula is denoted =DATE(year, month, day). This formula will return a date that corresponds to the values entered in the parentheses — even values referred from other cells. For example, if A1 was 2018, B1 was 7, and C1 was 11, =DATE(A1,B1,C1) would return 7/11/2018.

Creating dates in the cells of an Excel spreadsheet can be a fickle task every now and then. Luckily, there’s a handy formula to make formatting your dates easy. There are two ways to use this formula:

  • Create dates from a series of cell values. To do this, highlight an empty cell, enter “=DATE,” and in parentheses, enter the cells whose values create your desired date — starting with the year, then the month number, then the day. The final format should look like this: =DATE(year, month, day). See how this looks in the screenshot below.
  • Automatically set today’s date. To do this, highlight an empty cell and enter the following string of text: =DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY())). Pressing enter will return the current date you’re working in your Excel spreadsheet.

excel date formula

In either usage of Excel’s date formula, your returned date should be in the form of “mm/dd/yy” — unless your Excel program is formatted differently.

Advertisement

8. Array

An array formula in Excel surrounds a simple formula in brace characters using the format, {=(Start Value 1:End Value 1)*(Start Value 2:End Value 2)}. By pressing ctrl+shift+center, this will calculate and return value from multiple ranges, rather than just individual cells added to or multiplied by one another.

Calculating the sum, product, or quotient of individual cells is easy — just use the =SUM formula and enter the cells, values, or range of cells you want to perform that arithmetic on. But what about multiple ranges? How do you find the combined value of a large group of cells?

Numerical arrays are a useful way to perform more than one formula at the same time in a single cell so you can see one final sum, difference, product, or quotient. If you’re looking to find total sales revenue from several sold units, for example, the array formula in Excel is perfect for you. Here’s how you’d do it:

  1. To start using the array formula, type “=SUM,” and in parentheses, enter the first of two (or three, or four) ranges of cells you’d like to multiply together. Here’s what your progress might look like: =SUM(C2:C5
  2. Next, add an asterisk after the last cell of the first range you included in your formula. This stands for multiplication. Following this asterisk, enter your second range of cells. You’ll be multiplying this second range of cells by the first. Your progress in this formula should now look like this: =SUM(C2:C5*D2:D5)
  3. Ready to press Enter? Not so fast … Because this formula is so complicated, Excel reserves a different keyboard command for arrays. Once you’ve closed the parentheses on your array formula, press Ctrl+Shift+Enter. This will recognize your formula as an array, wrapping your formula in brace characters and successfully returning your product of both ranges combined.

Excel array formula

In revenue calculations, this can cut down on your time and effort significantly. See the final formula in the screenshot above.

9. COUNT

The COUNT formula in Excel is denoted =COUNT(Start Cell:End Cell). This formula will return a value that is equal to the number of entries found within your desired range of cells. For example, if there are eight cells with entered values between A1 and A10, =COUNT(A1:A10) will return a value of 8.

Advertisement

The COUNT formula in Excel is particularly useful for large spreadsheets, wherein you want to see how many cells contain actual entries. Don’t be fooled: This formula won’t do any math on the values of the cells themselves. This formula is simply to find out how many cells in a selected range are occupied with something.

Using the formula in bold above, you can easily run a count of active cells in your spreadsheet. The result will look a little something like this:

count-formula-in-excel

10. AVERAGE

To perform the average formula in Excel, enter the values, cells, or range of cells of which you’re calculating the average in the format, =AVERAGE(number1, number2, etc.) or =AVERAGE(Start Value:End Value). This will calculate the average of all the values or range of cells included in the parentheses.

Finding the average of a range of cells in Excel keeps you from having to find individual sums and then performing a separate division equation on your total. Using =AVERAGE as your initial text entry, you can let Excel do all the work for you.

For reference, the average of a group of numbers is equal to the sum of those numbers, divided by the number of items in that group.

Advertisement

11. SUMIF

The SUMIF formula in Excel is denoted =SUMIF(range, criteria, [sum range]). This will return the sum of the values within a desired range of cells that all meet one criterion. For example, =SUMIF(C3:C12,”>70,000″) would return the sum of values between cells C3 and C12 from only the cells that are greater than 70,000.

Let’s say you want to determine the profit you generated from a list of leads who are associated with specific area codes, or calculate the sum of certain employees’ salaries — but only if they fall above a particular amount. Doing that manually sounds a bit time-consuming, to say the least.

With the SUMIF function, it doesn’t have to be — you can easily add up the sum of cells that meet certain criteria, like in the salary example above.

  • The formula: =SUMIF(range, criteria, [sum_range])
    • Range: The range that is being tested using your criteria.
    • Criteria: The criteria that determine which cells in Criteria_range1 will be added together
    • [Sum_range]: An optional range of cells you’re going to add up in addition to the first Range entered. This field may be omitted.

In the example below, we wanted to calculate the sum of the salaries that were greater than $70,000. The SUMIF function added up the dollar amounts that exceeded that number in the cells C3 through C12, with the formula =SUMIF(C3:C12,”>70,000″).

SUMIF formula in Excel

12. TRIM

The TRIM formula in Excel is denoted =TRIM(text). This formula will remove any spaces entered before and after the text entered in the cell. For example, if A2 includes the name ” Steve Peterson” with unwanted spaces before the first name, =TRIM(A2) would return “Steve Peterson” with no spaces in a new cell.

Email and file sharing are wonderful tools in today’s workplace. That is, until one of your colleagues sends you a worksheet with some really funky spacing. Not only can those rogue spaces make it difficult to search for data, but they also affect the results when you try to add up columns of numbers.

Advertisement

Rather than painstakingly removing and adding spaces as needed, you can clean up any irregular spacing using the TRIM function, which is used to remove extra spaces from data (except for single spaces between words).

  • The formula: =TRIM(text).
    • Text: The text or cell from which you want to remove spaces.

Here’s an example of how we used the TRIM function to remove extra spaces before a list of names. To do so, we entered =TRIM(“A2”) into the Formula Bar, and replicated this for each name below it in a new column next to the column with unwanted spaces.

trim-formula-in-excel

Below are some other Excel formulas you might find useful as your data management needs grow.

13. LEFT, MID, and RIGHT

Let’s say you have a line of text within a cell that you want to break down into a few different segments. Rather than manually retyping each piece of the code into its respective column, users can leverage a series of string functions to deconstruct the sequence as needed: LEFT, MID, or RIGHT.

LEFT

  • Purpose: Used to extract the first X numbers or characters in a cell.
  • The formula: =LEFT(text, number_of_characters)
    • Text: The string that you wish to extract from.
    • Number_of_characters: The number of characters that you wish to extract starting from the left-most character.

In the example below, we entered =LEFT(A2,4) into cell B2, and copied it into B3:B6. That allowed us to extract the first 4 characters of the code.

LEFT formula in Excel

MID

  • Purpose: Used to extract characters or numbers in the middle based on position.
  • The formula: =MID(text, start_position, number_of_characters)
    • Text: The string that you wish to extract from.
    • Start_position: The position in the string that you want to begin extracting from. For example, the first position in the string is 1.
    • Number_of_characters: The number of characters that you wish to extract.

In this example, we entered =MID(A2,5,2) into cell B2, and copied it into B3:B6. That allowed us to extract the two numbers starting in the fifth position of the code.

MID formula in Excel

RIGHT

  • Purpose: Used to extract the last X numbers or characters in a cell.
  • The formula: =RIGHT(text, number_of_characters)
    • Text: The string that you wish to extract from.
    • Number_of_characters: The number of characters that you want to extract starting from the right-most character.

For the sake of this example, we entered =RIGHT(A2,2) into cell B2, and copied it into B3:B6. That allowed us to extract the last two numbers of the code.

RIGHT formula in EXCEL

14. VLOOKUP

This one is an oldie, but a goodie — and it’s a bit more in depth than some of the other formulas we’ve listed here. But it’s especially helpful for those times when you have two sets of data on two different spreadsheets, and want to combine them into a single spreadsheet.

My colleague, Rachel Sprung — whose “How to Use Excel” tutorial is a must-read for anyone who wants to learn — uses a list of names, email addresses, and companies as an example. If you have a list of people’s names next to their email addresses in one spreadsheet, and a list of those same people’s email addresses next to their company names in the other, but you want the names, email addresses, and company names of those people to appear in one place — that’s where VLOOKUP comes in.

Advertisement

Note: When using this formula, you must be certain that at least one column appears identically in both spreadsheets. Scour your data sets to make sure the column of data you’re using to combine your information is exactly the same, including no extra spaces.

  • The formula: VLOOKUP(lookup value, table array, column number, [range lookup])
    • Lookup Value: The identical value you have in both spreadsheets. Choose the first value in your first spreadsheet. In Sprung’s example that follows, this means the first email address on the list, or cell 2 (C2).
    • Table Array: The range of columns on Sheet 2 you’re going to pull your data from, including the column of data identical to your lookup value (in our example, email addresses) in Sheet 1 as well as the column of data you’re trying to copy to Sheet 1. In our example, this is “Sheet2!A:B.” “A” means Column A in Sheet 2, which is the column in Sheet 2 where the data identical to our lookup value (email) in Sheet 1 is listed. The “B” means Column B, which contains the information that’s only available in Sheet 2 that you want to translate to Sheet 1.
    • Column Number: The table array tells Excel where (which column) the new data you want to copy to Sheet 1 is located. In our example, this would be the “House” column, the second one in our table array, making it column number 2.
    • Range Lookup: Use FALSE to ensure you pull in only exact value matches.
  • The formula with variables from Sprung’s example below: =VLOOKUP(C2,Sheet2!A:B,2,FALSE)

In this example, Sheet 1 and Sheet 2 contain lists describing different information about the same people, and the common thread between the two is their email addresses. Let’s say we want to combine both datasets so that all the house information from Sheet 2 translates over to Sheet 1. Here’s how that would work:

Excel formulas and shortcuts: VLOOKUP

15. RANDOMIZE

There’s a great article that likens Excel’s RANDOMIZE formula to shuffling a deck of cards. The entire deck is a column, and each card — 52 in a deck — is a row. “To shuffle the deck,” writes Steve McDonnell, “you can compute a new column of data, populate each cell in the column with a random number, and sort the workbook based on the random number field.”

In marketing, you might use this feature when you want to assign a random number to a list of contacts — like if you wanted to experiment with a new email campaign and had to use blind criteria to select who would receive it. By assigning numbers to said contacts, you could apply the rule, “Any contact with a figure of 6 or above will be added to the new campaign.”

  • The formula: RAND()
    • Start with a single column of contacts. Then, in the column adjacent to it, type “RAND()” — without the quotation marks — starting with the top contact’s row.
    • RANDBETWEEN allows you to dictate the range of numbers that you want to be assigned. In the case of this example, I wanted to use one through 10.
    • bottom: The lowest number in the range.
    • top: The highest number in the range,For the example below: RANDBETWEEN(bottom,top)
    • Formula in below example: =RANDBETWEEN(1,10)

 

excel formulas and keyboard shortcuts example: Randomize
Helpful stuff, right? Now for the icing on the cake: Once you’ve mastered the Excel formula you need, you’ll want to replicate it for other cells without rewriting the formula. And luckily, there’s an Excel function for that, too. Check it out below.

Sometimes, you might want to run the same formula across an entire row or column of your spreadsheet. Let’s say, for example, you have a list of numbers in columns A and B of a spreadsheet and want to enter individual totals of each row into column C.

Obviously, it would be too tedious to adjust the values of the formula for each cell so you’re finding the total of each row’s respective numbers. Luckily, Excel allows you to automatically complete the column; all you have to do is enter the formula in the first row. Check out the following steps: 

Advertisement
  1. Type your formula into an empty cell and press “Enter” to run the formula.SUM formula entered in column C of Excel spreadsheet to find the sum of cells B2 and C2.
  2. Hover your cursor over the bottom-right corner of the cell containing the formula. You’ll see a small, bold “+” symbol appear.
  3. While you can double-click this symbol to automatically fill the entire column with your formula, you can also click and drag your cursor down manually to fill only a specific length of the column.insert-formula-in-excel-for-entire-columnOnce you’ve reached the last cell in the column you’d like to enter your formula, release your mouse to copy the formula. Then, simply check each new value to ensure it corresponds to the correct cells.

Excel Keyboard Shortcuts

1. Quickly select rows, columns, or the whole spreadsheet.

Perhaps you’re crunched for time. I mean, who isn’t? No time, no problem. You can select your entire spreadsheet in just one click. All you have to do is simply click the tab in the top-left corner of your sheet to highlight everything all at once.

Quickly select rows, columns, or the whole Excel spreadsheet

Just want to select everything in a particular column or row? That’s just as easy with these shortcuts:

For Mac:

  • Select Column = Command + Shift + Down/Up
  • Select Row = Command + Shift + Right/Left

For PC:

  • Select Column = Control + Shift + Down/Up
  • Select Row = Control + Shift + Right/Left

This shortcut is especially helpful when you’re working with larger data sets, but only need to select a specific piece of it.

1658936298 619 15 Excel Formulas Keyboard Shortcuts Tricks Thatll Save You

2. Quickly open, close, or create a workbook.

Need to open, close, or create a workbook on the fly? The following keyboard shortcuts will enable you to complete any of the above actions in less than a minute’s time.

Quickly open, close, or create an Excel workbook

For Mac:

  • Open = Command + O
  • Close = Command + W
  • Create New = Command + N

For PC:

  • Open = Control + O
  • Close = Control + F4
  • Create New = Control + N

3. Format numbers into currency.

Have raw data that you want to turn into currency? Whether it be salary figures, marketing budgets, or ticket sales for an event, the solution is simple. Just highlight the cells you wish to reformat, and select Control + Shift + $.

Format numbers into currency in Excel

The numbers will automatically translate into dollar amounts — complete with dollar signs, commas, and decimal points.

1658936299 589 15 Excel Formulas Keyboard Shortcuts Tricks Thatll Save You

Note: This shortcut also works with percentages. If you want to label a column of numerical values as “percent” figures, replace “$” with “%”.

4. Insert current date and time into a cell.

Whether you’re logging social media posts, or keeping track of tasks you’re checking off your to-do list, you might want to add a date and time stamp to your worksheet. Start by selecting the cell to which you want to add this information.

Then, depending on what you want to insert, do one of the following:

Advertisement
  • Insert current date = Control + ; (semi-colon)
  • Insert current time = Control + Shift + ; (semi-colon)
  • Insert current date and time = Control + ; (semi-colon), SPACE, and then Control + Shift + ; (semi-colon).

Insert a current date and time into a cell in Excel

Other Excel Tricks

1. Customize the color of your tabs.

If you’ve got a ton of different sheets in one workbook — which happens to the best of us — make it easier to identify where you need to go by color-coding the tabs. For example, you might label last month’s marketing reports with red, and this month’s with orange.

Simply right click a tab and select “Tab Color.” A popup will appear that allows you to choose a color from an existing theme, or customize one to meet your needs.

Customize the color of your tabs in Excel

2. Add a comment to a cell.

When you want to make a note or add a comment to a specific cell within a worksheet, simply right-click the cell you want to comment on, then click Insert Comment. Type your comment into the text box, and click outside the comment box to save it.

Cells that contain comments display a small, red triangle in the corner. To view the comment, hover over it.

Add a comment to a cell in Excel

3. Copy and duplicate formatting.

If you’ve ever spent some time formatting a sheet to your liking, you probably agree that it’s not exactly the most enjoyable activity. In fact, it’s pretty tedious.

For that reason, it’s likely that you don’t want to repeat the process next time — nor do you have to. Thanks to Excel’s Format Painter, you can easily copy the formatting from one area of a worksheet to another.

Advertisement

Select what you’d like to replicate, then select the Format Painter option — the paintbrush icon — from the dashboard. The pointer will then display a paintbrush, prompting you to select the cell, text, or entire worksheet to which you want to apply that formatting, as shown below:

Excel formulas and keyboard shortcuts example: Copy and Duplicate Formatting in Excel

4. Identify duplicate values.

In many instances, duplicate values — like duplicate content when managing SEO — can be troublesome if gone uncorrected. In some cases, though, you simply need to be aware of it.

Whatever the situation may be, it’s easy to surface any existing duplicate values within your worksheet in just a few quick steps. To do so, click into the Conditional Formatting option, and select Highlight Cell Rules > Duplicate Values

Identify duplicate values in Excel

Using the popup, create the desired formatting rule to specify which type of duplicate content you wish to bring forward.

1658936300 260 15 Excel Formulas Keyboard Shortcuts Tricks Thatll Save You

In the example above, we were looking to identify any duplicate salaries within the selected range, and formatted the duplicate cells in yellow.

Excel Shortcuts Save You Time

In marketing, the use of Excel is pretty inevitable — but with these tricks, it doesn’t have to be so daunting. As they say, practice makes perfect. The more you use these formulas, shortcuts, and tricks, the more they’ll become second nature.

Advertisement

Editor’s note: This post was originally published in January 2019 and has been updated for comprehensiveness.

excel marketing templates

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address

MARKETING

Unlocking Hidden Revenue: The Inbox Retargeting Methodology

Published

on

Unlocking Hidden Revenue: The Inbox Retargeting Methodology

Page conversion rates have ALWAYS been a problem. The simple fact is most people don’t convert even on the most optimized pages. 

What’s why traditional retargeting on ad networks has been so dang powerful. While retargeted leads come cheap, they still aren’t free. Worse, you’re back competing against your competition in the ol’ ad auction system.

For the last 6 years, I’ve been using a tactic called Inbox Retargeting to identify who lands on my key pages and directly reach out to them in their inbox.

No more ads. No more auctions. Just a targeted contact that showed they were interested, but didn’t quite take the leap yet.

Before I dive into the “What’s” and “How’s”, this tactic can only be used in the good ol’ US of A. If you aren’t in the states or don’t have clients in the states, you’re out of luck. Sorry!

How It Works

Inbox retargeting doesn’t take a lot of heavy lifting. I’ll share the strategy next but I wanted to start with some of the logistics.

Advertisement

DISCLAIMER: I am not a lawyer or coder, so keep that in mind if technical or legal questions pop up.

If you have a website, you have tracking scripts, e.g.,  GA4, the Facebook Pixel, Heatmap software, etc…

To get started with Inbox retargeting, you just need to be able to copy and paste two scripts on your site:

  • A collection script: This fires and tries to identify the visitor

A suppression script: You’d fire this on your conversion confirmation pages, you don’t want people who converted to land in your Inbox Retargeting campaigns.

1710795438 253 Unlocking Hidden Revenue The Inbox Retargeting Methodology

The tech works off of a database of contacts in the United States that are eligible for emails, so it’s completely above board with your ESP. However, you’ll want to do a few things before you start treating them like a regular member of your email list.

We initially tested this on one of our paid media campaigns. We already had a really strong campaign that we wanted to squeeze more leads out of…and boy did we.

We were driving traffic from Meta (Facebook for the OGs) to this landing page:

1710795438 272 Unlocking Hidden Revenue The Inbox Retargeting Methodology

This page converts at 58%. Yeah, that’s a humble brag…deal with it.

Even with a 58% conversion rate, we’re still missing out on 42% of the traffic we’ve already paid for. That’s kind of a bummer.

Advertisement

After we added the collection script to the page, they were able to capture a lot more leads. The conversion rate jumped from 58% to a very sweet 87% – that’s a 50% increase!

That was the impact on a single page, that’s when we knew it was time to go bigger.

The Strategy

Most of the tools out there, whether it’s Retention.com or Customers.ai, are going to charge based on the number of contacts. So it can get pretty easy to burn through contact credits if you run the script on every page you manage, your site and your clients’ sites included.

That’s why you’ll want to make sure to select pages that capture intent versus targeting all of your traffic.

ID Key Pages

Here are some of the pages you should consider adding the collection script:

  1. Campaign Landing Pages – If you’re paying to send someone to a page, the referring source piqued their interest. If they didn’t convert, you’d definitely want to follow up.
  2. Product Pages – If someone is viewing this page they’re evaluating a particular product they were interested in.
  3. High Intent/Value Content Pages – This could be your pillar content on your blog pages, podcast pages, or your top level service pages.
  4. Registration Pages – This is a subset of a landing page, but if someone got all the way to a registration or sigh up page, they’re a prime candidate for outreach.
  5. Cart Pages – People abandon carts all the time. If you weren’t able to catch their details during checkout, this is an ideal opportunity.

Effectively it’s any page where you’re pushing a specific action. While the above pages are the pages to choose from, a homepage is acceptable but will require a little more finesse when you follow up.

Map to Email Campaigns

Now that you’ve identified where you’re going to identify leads, you’ll need to map it to your automation tool.

Advertisement
Unlocking Hidden Revenue The Inbox Retargeting MethodologyUnlocking Hidden Revenue The Inbox Retargeting Methodology

GET CERTIFIED. Discover the proven plan for effortless, automated email marketing. Click Here

Most tools have a direct integration with your email service provider, but worst case scenario you may have to pass the data through a no code integration tool like Zapier.

Once you’ve worked out the digital plumbing, you’ll want to follow up based on the page the contact was collected on. Here’s how you should approach follow up:

  1. For Campaign Landing Pages – Give them the specific asset. They were interested in it, you’ve got their contact information, just hand over the goods. This builds good will at the start of the relationship.
  2. Product Pages – Send over the details of the product or product category they were viewing. This could be as simple as a reminder or you could build goodwill with a special offer or coupon.
  3. High Intent/Value Content Pages – Send over some of your best content or freebies that move people to the next phase of the Customer Value Journey.
  4. Registration Pages – Treat these like an “abandoned cart” type of email and get them to take that next step.
  5. Cart Pages – Same as “Registration Pages” but it’s, you know, an actual abandoned cart reminder. Similar to the product pages you could entice them to come back with a deal or coupon.
  6. Homepages – If you do run these on the homepage, you’ll need to do more of a reintroduction then transition to showcasing your best stuff.

Email Structure

The initial message you send needs to have a very specific flow. There are four critical things that need to happen when they open up your Inbox Retargeting message.

First, remind them about who you are and how they know you. This can be as simple as a, “Hey, thanks for stopping by…” message. Have some fun with it.

Next, you need to provide highly specific value based on their browsing intent. If you get this wrong, they’re just going to file your message under SPAM.

After that, you’ve got to set expectations with what they’re getting and now you’ll be communicating with them moving forward.

And Finally, you need to give them an EASY OUT. These campaigns have our highest unsubscribe rate, but that’s because we outright ask people to unsubscribe if they don’t want any additional contact.

Advertisement

Once you’e gone through this, you treat them like one of your regular subscribers with all your fancy ascension automations, content emails, and promotional emails.

Here are the email stats from one of our PPC Campaigns:

1710795439 568 Unlocking Hidden Revenue The Inbox Retargeting Methodology

With an average open rate of 53.87%, we know there’s a base line interest in the deliverable. The click rate is DANG good for messaging visitors who didn’t convert.

Sure the unsubscribe rate is a little high for this campaign, but that is intentional. We push them to opt-out in the first email so we don’t get dinged later with complaints.

The Payoff: An Additional 109k Last Year

I mean, who doesn’t want another cool 100 grand for adding a script to your website and writing a couple of emails? Here’s how the numbers work out:

Last year, we identified 3,714 leads using this method. IMPORTANT: When I was pulling these numbers, I realized we installed the code wrong on some pages and missed out on about another 2k leads…oops!

Our average lead cost was ~$7, so the leads themself were a $26,000 additional value. This alone would be a reason to use the tech.

Advertisement

BUT JUSTIN, did they convert?!

Yes!

We closed $36,000 in IPPC business from this lead source. For what we spent on those leads we’re looking at a 750% ROAS. Not too shabby.

The rest of the money we made was by selling this service to our clients. Since we run paid ads for clients, this method is a complete no brainer. We ran a pilot program and only offered this to a handful of clients last year, we averaged about 4k/month in sales.

We sold clients the leads at ~$2/lead for some of the niches we work in, that’s a steal. 

If you decide to sell this you need to make sure the client knows these are lower intent leads and will require longer term nurtures. If you follow the email strategy I shared above, you’ll be good to go!

Advertisement

Protip: Charge for building the follow up sequence! 

So that’s it! If you’re running your own business or are an agency owner, you’ve got to consider Inbox Retargeting. Though, I do have some bad news…

Not to be “Chicken Little” but this is starting to get way more attention, there are services popping out of the woodwork so this will become a table stakes method. So get ahead of this today.

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

MARKETING

What’s Media Mix Modeling? [Marketer’s Guide with Examples]

Published

on

What’s Media Mix Modeling? [Marketer’s Guide with Examples]

Privacy


By Emily Sullivan

Have you ever felt in the dark when it comes to understanding the real impact your marketing dollars are having across multiple channels? 

Determining where and how conversions are occurring is crucial in optimizing your budget to drive the most impact with your marketing budget. Media mix modeling (MMM) is an analytical approach used to gauge the effectiveness of various marketing channels in driving sales and conversions. This method allows us to decipher the true influence of advertising spend across diverse platforms by accounting for a myriad of factors, both within their control (like media channel spend, promotional strategies) and outside their control (such as economic conditions, competitor actions, and seasonal influences).

Advertisement

One of the key strengths of media mix modeling is its ability to incorporate long-term brand building effects alongside immediate sales impacts, offering a comprehensive view of marketing effectiveness. It helps in identifying which channels are most efficient, how different channels influence each other, and how external factors affect marketing performance.

Media mix modeling is a powerful tool for marketers seeking to optimize their marketing investments. By providing a holistic view of how various factors contribute to sales and conversions, MMM enables data-driven decisions that enhance marketing efficiency and business growth.

In this article, we explore how media mix modeling works, and how businesses can use analytics to drive smarter ad spend decisions.

What Is Media Mix Modeling?

Media mix modeling (MMM) is a type of analysis that measures the impact of media buys across multiple channels, showing the role various elements play in achieving a desired outcome—often a conversion or revenue KPI. With this information, marketing stakeholders are able to make specific adjustments to campaign spend to improve their progress toward reaching a given goal.

Media mix modeling can be used to address common brand marketing questions and pain points, including:

  • Which of our marketing efforts are having the biggest impact on reaching our goals—or, more simply—what’s working?
  • How big of an impact does seasonality have on our marketing performance?
  • How closely is our performance tied to promotional efforts? 
  • Are shifting consumer trends negatively or positively impacting outcomes?
  • Which specific mix of spend allocation drives the highest ROI?
  • How will these channels likely perform in the future based on their optimized spend allocation?

“Media mix modeling is a top-down , privacy resilient approach that evaluates how historical media activity, promotions, pricing, seasonality, and uncontrollable factors—such as economic activity—impact key business outcomes such as sales revenue. MMM is a scientific approach to attribution in the sense that it applies statistical methods to analyze and interpret marketing data, providing a systematic understanding of how different marketing channels contribute to overall business goals in the broader context of the market. The quality of insights derived from MMM heavily depends on the quality and granularity of the data used.”

— Annica Nesty, Group Director of Marketing Science at Tinuiti

Advertisement

MMM leverages aggregate data, and can measure both online (digital) and offline (traditional) advertising channel performance, including (but not limited to): paid media channels such as social media channels, traditional print advertising, linear TV advertising, and other performance marketing efforts, organic media, operational factors like promotions, external factors like seasonality, economic conditions, outcome KPIs such as sales revenue, new customers, and conversions. 

How Does Media Mix Modeling Work?

The MMM framework is a type of statistical analysis that uses statistical methods and econometric models such as a regression analysis. This econometric model helps analysts determine the strength of relationships between a single dependent variable and an array of independent variables.

Media mix modeling analysis measures the impact of your media spend today, and is also helpful in predicting the future outcome of your marketing investments on a given variable.

Example:

Let’s assume a scenario where our target metric, or dependent variable, is revenue, a critical indicator of business success. We aim to dissect the influence of various marketing initiatives on this revenue. These initiatives, our independent variables, encompass a diverse array of digital advertising campaigns, including those run on TikTok, Instagram, Snapchat, as well as broader Display and Streaming platforms.

The number of independent variables under scrutiny does not dilute our core objective. The mission is to measure the relationship between the marketing endeavors and the revenue they generate. This involves not only identifying the direct contributions of each campaign to revenue but also understanding the nuanced interplay between them by observing how changing aspects of those independent variables impacts the chosen business outcome

Advertisement

What can MMM Measure?

When using MMM to assess campaign success, marketers should leverage statistical methods and econometric models to get the most accurate picture possible. Data quality is essential in achieving an accurate media mix analysis, so take any needed time to clean your data before using it in your analysis. 

Key elements an MMM equation can measure include:

  • Base and incremental sales volume impact
  • Channel effectiveness and return on investment
  • Marketing spend saturation

Media Mix Modeling vs. Data-Driven Attribution Modeling

Like media mix modeling, attribution modeling also studies the efficiency of marketing strategies — but there are important differences.

Attribution modeling is a general term that refers to tracking engagement to better understand how specific tactics drive action at the user level. This modeling works well for analyzing specific customer touchpoints, focusing on elements like how a consumer converted, which creative on which channel led to that conversion, and what the expected ROI could be if more ad budget were shifted to that channel. 

Media mix modeling takes a higher-level, more comprehensive picture. This modeling isn’t designed to measure user-level engagement like impressions and clicks, rather its primary function is measuring the impact of an entire touchpoint on specific marketing objectives. 

Data-driven attribution modeling and MMM each have their own set of strengths. It’s not a matter of one being better than the other, rather one being better-suited to different types of marketing analysis. 

For example:

Advertisement
  • The precision of the data-driven attribution: Let’s assume you want to invest more spend in a social ad campaign during the holiday season. While MMM is an option for determining where to allocate those dollars, data-driven attribution excels in dissecting the intricate customer journey, offering a microscopic view of user interactions. For instance, if you’re keen on understanding the exact value of a single click from your social media campaign, Data-Driven Attribution can illuminate the path. 
  • The holistic perspective of the media mix modeling:  Media mix modeling, can consider the impact of offline actions and initiatives. Unlike the more narrowly focused attribution models, which might overemphasize the first or last touchpoint, MMM assesses the collective impact of all channels over time. This makes it an indispensable tool for strategic planning and long-term investment decisions in your marketing portfolio.

“Attribution modeling is based on a bottom-up approach while media mix modeling takes a top-down approach. Media mix modeling provides a long-term view of the marketing ROI of media activity, while attribution modeling evaluates individual-level activity to provide a short term view of marketing ROI.” 

— Annica Nesty, Group Director of Marketing Science at Tinuiti

Why Does MMM Make Sense for a Post-cookie/Post-IDFA World?

In the post-cookie and post-IDFA landscape, where privacy concerns and regulatory changes limit access to individual user-level data, media mix modeling has become a pivotal analytical tool. MMM’s emphasis on overall marketing spend allocation and its proficiency in establishing cause-and-effect models, address the challenges posed by the diminishing availability of explicit conversion information, providing marketers with a privacy-respecting and insightful approach to navigate the evolving digital advertising ecosystem.

An Example of Media Mix Modeling

With the right media mix model, a business can measure their past marketing performance to improve future ROI by optimizing the allocation of the media budget by channel and/or tactic, including: traditional and digital media channels, promotions, pricing, competitor spend, economic conditions, weather, and more.

Example:

An international ecommerce brand wanted to forecast their second-half of the year and create an optimal media mix to make their marketing dollars work smarter. A combination of client data, marketing data, and machine learning were required to create a powerful, custom media mix model. 

To build the model, the business used 2+ years of digital marketing and revenue data, analyzing it by market, tactic, and day. The data was then used to create model to assess future spend showing how changes in investment across channels could impact revenue and sales.

Advertisement
media mix modeling

The full digital media mix model gave the ecommerce brand a detailed analysis of where to optimize their spend across all digital marketing channels. 

One recommendation was to shift dollars away from social—which historically had been at or near 30%—to paid search. This recommendation came with another layer of insight: The brand realized they were overinvesting in awareness campaigns, and needed to invest more heavily in capturing current demand during the 2nd half of the year.

Results: Working with a robust media mix model, the brand was able to break down how much media spend was needed by each channel in order to achieve the 30% YoY revenue goal they targeted. 

The Benefits & Challenges of Media Mix Modeling

MMM helps you accurately connect all the dots, leveraging (ideally) a wealth of provided data, to understand how disparate aspects of marketing campaigns work together in helping you reach your business goals. 

Benefits of Media Mix Modeling

The benefits of MMM are multifaceted, offering marketers a strategic edge in navigating the intricacies of their advertising efforts. Let’s dive into each benefit in detail… 

Omnichannel Campaigns: MMM excels in providing insights for omnichannel campaigns, allowing marketers to understand and optimize the impact of their initiatives across various channels. This capability is crucial in today’s interconnected digital landscape, where consumers engage with brands through diverse platforms.

Improved Oversight Over Media Spend Impact: MMM provides a comprehensive view of the impact of media spend, enabling marketers to assess the effectiveness of their investments. This improved oversight ensures a clearer understanding of how each component of the media mix contributes to overall campaign success.

Advertisement

Media Spend Optimization: With MMM, marketers can optimize their media spend by identifying the most impactful channels and touchpoints. This data-driven approach allows for strategic adjustments in budget allocation, ensuring that resources are directed towards the avenues that yield the highest return on ad spend.

Effective Targeting of Audiences: MMM’s analysis helps in refining audience targeting strategies. By understanding which elements of the marketing mix resonate most with specific demographics, marketers can tailor their campaigns to effectively reach and engage their target audience segments.

Forecasting with Certainty: One of MMM’s strengths lies in its ability to forecast results with a high degree of certainty. This forecasting capability empowers marketers to make informed decisions based on predictive analytics, aiding in long-term planning and goal setting.

Reduced Reliance on Personally Identifiable Information (PII): MMM minimizes the reliance on personally identifiable information for analysis. This is especially crucial in an era where privacy concerns are more important than ever. 

Media mix modeling is a comprehensive and powerful tool, offering a range of benefits that contribute to a more effective, data-driven, and privacy-conscious approach to marketing strategy and decision-making. While there are many benefits to MMM, there are challenges as well. Let’s look into common challenges of MMM in our next section.

Challenges of Media Mix Modeling

MMM grows increasingly complex as the media landscape becomes more fragmented, and the customer journey more personalized. Whereas in the past, advertisers may have wanted to measure something as simple as the impact of a print ad in a Cleveland newspaper, today’s consumers are exposed to brands in a wide variety of locations and formats, from a subway transit poster to a Sponsored post on Instagram.

Advertisement

Working with high-quality data is important in any measurement initiative, but for MMM to work effectively, it also needs a lot of data to build a reliable model. For example, if you wanted your model to consider the performance impact of seasonality, it would ideally need at least three full seasons (three years) of data to consider in its analysis.

This makes media mix modeling a ‘long game’ initiative with infrequent reporting by its nature. Brands and advertisers who are more accustomed to daily or weekly updates may struggle with ‘waiting out’ the analysis.

Because it’s not designed to make considerations based on user-level data, instead providing aggregate insights, media mix modeling offers limited insights on brand impact, personalized targeting, and customer experience. However, advanced models are available that can provide highly granular insights, but traditional MMM provides aggregate insights.

Common Misconceptions About Media Mix Modeling

Media mix modeling, like many other analytics solutions, has also become a marketing buzzword that has generated its fair share of misconceptions.

Here are a few of the most common misconceptions around media mix modeling.

Media Mix Models Are Not Transparent

With large datasets and statistical analysis involved in media mix modeling, the methods behind the technique have been critiqued for their obscurity. If there is no perceived transparency in the process, how does a brand know if its media mix model is really accurate?

Advertisement

Any organization specializing in media mix modeling should provide a transparent approach, with deliverables such as outlines, milestones, and performance reports. Additionally, you may want to consider partnering with an agency that truly understands how media mix modeling aligns with your needs and expectations. Every business is unique and each media mix model is based on multiple factors.

Media Mix Models Do Not Provide Real-time Data

Today, results are often measured by the timeliness of their delivery, with the current digital marketplace allowing for almost instantaneous real-time data. Media mix models do actually provide compelling real-time marketing insights, perfect for evaluating new campaigns, new competitors, and assessing pricing actions or changes in promotional strategies. 

A powerful partner in media mix modeling will provide sophisticated tools and real-time approaches to satisfy your business performance assessments. Your partner should also be able to provide forecasting, simulation, or AI- and machine-learning-integrated models to suggest future movements. 

Media Mix Modeling is Biased to Offline Channels

Though media mix strategies do integrate and consider offline channels in their approaches, media mix modeling also considers all digital channels — including display, email, paid search, social, and more. Remember—it’s considering your media mix. If that includes ten different channels and you provide enough high-quality data for each, they will all be considered in your marketing mix analysis. 

In fact, as customers have become more intertwined with digital channels, media marketing models have adapted to go even deeper into the analyses provided by those channels’ respective insights to support better budgeting choices and customer segmentation reports. 

Conclusion: MMM Closes the Loop on Marketing Performance

In an ever-evolving digital landscape, MMM’s adaptability to the post-cookie/post-IDFA world positions it as an essential tool for marketers. As businesses seek to connect the dots, leverage data, and make strategic decisions, MMM is a crucial ally in the dynamic realm of mixed media advertising.

Advertisement

“At Tinuiti, we leverage measurement best practices such as MMM and incrementality to understand media effectiveness, predict future outcomes, create deeper insights, analyzing what-if scenarios to provide recommendations that optimize media performance. This helps brands understand what channels they should be investing in, how they should shift budgets (media mix), creating a high-level view of what channels are driving overall sales and ROI. Our goal here is to deliver growth for our clients by maximizing the return on investment through best in class measurement”

— Annica Nesty, Group Director of Marketing Science at Tinuiti

At Tinuiti, we know, embrace, and utilize MMM. Our Rapid Media Mix Modeling sets a new standard in the market with its exceptional speed, precision, and transparency. 

Our proprietary measurement technology, Bliss Point by Tinuiti, allows us to measure what marketers have previously struggled to measure – the optimal level of investment to maximize impact and efficiency.  But this measurement is not just to go back and validate that we’ve done the right things. This measurement is real-time informing what needs to happen next.

Curious about how we can tailor strategies to hit your unique marketing bliss point, including Rapid Media Mix Modeling? We’re eager to chat. Contact us today for details.

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

MARKETING

Email Ready to Send? Make Sure to Tick These Things off First!

Published

on

Email Ready to Send? Make Sure to Tick These Things off First!

Designing and developing an email campaign is a complex mechanism; a few things will inevitably escape your attention during the process. So, before you hit that send button, you must draw up a foolproof checklist to ensure every single component in your campaign is in its rightful place. Wondering what an ideal pre-flight checklist looks like? We’ve carefully compiled everything necessary in this blog. Read on to find out!

Subject Line and Pre-header Text

A subject line can make or break your emails. It’s the first thing about your email that reaches the audience, and if it fails to hit the right notes, you’ll have a tough time convincing your subscribers to engage with your emails.

What makes a subject line tick, you ask? Let’s take a look!

  • Your subject line should prioritize an economy of words; this will help you on two accounts- firstly, a crisp and to-the-point subject line increases your probability of catching the reader’s attention. Secondly, longer subject lines run the risk of being clipped on mobile devices, thereby spoiling the subscriber’s user experience. By keeping your subject lines concise, you eliminate this possibility.
  • Ensure your subject line clearly explains what readers can expect upon opening the email. The more guesswork your subject line demands of readers, the less likely they are to open your email.
  • Steer clear of using words that might be considered spammy. With email filters becoming more and more sophisticated, usage of any sort of contentious term in your subject line will result in ISPs flagging your email as spam.
  • Personalize your subject line. In a climate of increasingly crowded email boxes, personalization is one technique you simply can’t afford to overlook.

Besides fine-tuning your subject line, you also need to pay attention to your pre-header text. Building upon the context provided by your subject line, pre-header texts give readers an additional nudge to open their emails. Two crucial things that you must keep in mind while curating your pre-header texts are:

  1. It must exist only as an extension of your subject line; it must not try to introduce any new ideas on its own.
  2. It must be mobile-optimized.

Broken Links

Given that the links embedded in your email eventually facilitate a conversion, it is imperative that you thoroughly evaluate their health prior to delivering your emails. Broken links aren’t just bad for business; they also spoil a subscriber’s user experience.

Here are a few things you must check after embedding a link in your email:

  • This might sound trivial, but do check if the link you have inserted is the one you intended to or not; the only thing perhaps worse than having a broken link is having an irrelevant one.
  • Check that the link is redirecting the user to the desirable destination.
  • If the download of a resource is supposed to be triggered by clicking the link, check if that’s functioning properly; you wouldn’t want subscribers clicking umpteen times on your link only for it to return nothing.

Accessibility

Apart from acing your content and design, you must also work towards making your email campaigns accessible; people making use of assistive technologies must be able to engage with and comprehend your emails in an absolutely hassle-free manner.

Given below are a few measures that will help you make your campaigns accessible to all:

Advertisement
  • Organize your email content. Break down long paragraphs into small sections of 2-3 lines. Use bullets and subheadings wherever necessary. This will make it easy for assistive technologies such as screen readers to parse through your content.
  • Write descriptive alt texts for the images you’re including. Besides improving accessibility, alt texts also enable search engines to crawl your page more efficiently, thereby boosting your SEO.
  • Use semantic markup; this will help screen readers navigate your emails in a smooth fashion.
  • Try to stick to a single-column layout while designing your email template.

This email from AllTrails is an ideal example of an accessible template.

Inbox Preview

Different email clients render emails differently, even if only slightly. Hence, before sending out your emails, you must preview them across different environments and clients to check if they appear as desired. If you are designing your email for dark mode, too, it becomes that much more important to preview it before delivering.

Wrapping It Up

For your email campaigns to be able to drive maximum impact, they must be free of blemishes of all kinds. We hope the pre-flight checklist we shared above proves to be of help to you when you sit down to create your next campaign.

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

Trending

Follow by Email
RSS