Connect with us

MARKETING

19 Easy Excel Tips, Tricks, & Shortcuts

Published

on

19 Easy Excel Tips, Tricks, & Shortcuts


Sometimes, Excel seems too good to be true. All I have to do is enter a formula, and pretty much anything I’d ever need to do manually can be done automatically.

Need to merge two sheets with similar data? Excel can do it.

Need to do simple math? Excel can do it.

Need to combine information in multiple cells? Excel can do it.

In this post, I’ll go over the best tips, tricks, and shortcuts you can use right now to take your Excel game to the next level. No advanced Excel knowledge required.

What is Excel?

Microsoft Excel is powerful data visualization and analysis software, which uses spreadsheets to store, organize, and track data sets with formulas and functions. Excel is used by marketers, accountants, data analysts, and other professionals. It’s part of the Microsoft Office suite of products. Alternatives include Google Sheets and Numbers. 

Find more Excel alternatives here.

Excel is primarily used for creating financial documents because of its strong computational powers. You’ll often find the software in accounting offices and teams because it allows accountants to automatically see sums, averages, and totals. With Excel, they can easily make sense of their business’ data.

While Excel is primarily known as an accounting tool, professionals in any field can use its features and formulas — especially marketers — because it can be used for tracking any type of data. It removes the need to spend hours and hours counting cells or copying and pasting performance numbers. Excel typically has a shortcut or quick fix that speeds up the process.

You can also download Excel templates below for all of your marketing needs. 

After you download the templates, it’s time to start using the software. Let’s cover the basics first.

Excel Basics

If you’re just starting out with Excel, there are a few basic commands that we suggest you become familiar with. These are things like:

  • Creating a new spreadsheet from scratch.
  • Executing basic computations like adding, subtracting, multiplying, and dividing.
  • Writing and formatting column text and titles.
  • Using Excel’s auto-fill features.
  • Adding or deleting single columns, rows, and spreadsheets. (Below, we’ll get into how to add things like multiple columns and rows.)
  • Keeping column and row titles visible as you scroll past them in a spreadsheet, so that you know what data you’re filling as you move further down the document.
  • Sorting your data in alphabetical order. 

Let’s explore a few of these more in-depth. 

For instance, why does auto-fill matter? 

If you have any basic Excel knowledge, it’s likely you already know this quick trick. But to cover our bases, allow me to show you the glory of autofill. This lets you quickly fill adjacent cells with several types of data, including values, series, and formulas.

There are multiple ways to deploy this feature, but the fill handle is among the easiest. Select the cells you want to be the source, locate the fill handle in the lower-right corner of the cell, and either drag the fill handle to cover cells you want to fill or just double click:

excel autofillSimilarly, sorting is an important feature you’ll want to know when organizing your data in Excel. 

Sometimes you may have a list of data that has no organization whatsoever. Maybe you exported a list of your marketing contacts or blog posts. Whatever the case may be, Excel’s sort feature will help you alphabetize any list.

Click on the data in the column you want to sort. Then click on the “Data” tab in your toolbar and look for the “Sort” option on the left. If the “A” is on top of the “Z,” you can just click on that button once. If the “Z” is on top of the “A,” click on the button twice. When the “A” is on top of the “Z,” that means your list will be sorted in alphabetical order. However, when the “Z” is on top of the “A,” that means your list will be sorted in reverse alphabetical order.

Let’s explore more of the basics of Excel (along with advanced features) next. 

How to Use Excel

To use Excel, you only need to input the data into the rows and columns. And then you’ll use formulas and functions to turn that data into insights. 

We’re going to go over the best formulas and functions you need to know. But first, let’s take a look at the types of documents you can create using the software. That way, you have an overarching understanding of how you can use Excel in your day-to-day. 

Documents You Can Create in Excel

Not sure how you can actually use Excel in your team? Here is a list of documents you can create:

  • Income Statements: You can use an Excel spreadsheet to track a company’s sales activity and financial health.
  • Balance Sheets: Balance sheets are among the most common types of documents you can create with Excel. It allows you to get a holistic view of a company’s financial standing.
  • Calendar: You can easily create a spreadsheet monthly calendar to track events or other date-sensitive information.

Here are some documents you can create specifically for marketers.

This is only a small sampling of the types of marketing and business documents you can create in Excel. We’ve created an extensive list of Excel templates you can use right now for marketing, invoicing, project management, budgeting, and more.

In the spirit of working more efficiently and avoiding tedious, manual work, here are a few Excel formulas and functions you’ll need to know.

Excel Formulas

It’s easy to get overwhelmed by the wide range of Excel formulas that you can use to make sense out of your data. If you’re just getting started using Excel, you can rely on the following formulas to carry out some complex functions — without adding to the complexity of your learning path.

  • Equal sign: Before creating any formula, you’ll need to write an equal sign (=) in the cell where you want the result to appear.
  • Addition: To add the values of two or more cells, use the + sign. Example: =C5+D3.
  • Subtraction: To subtract the values of two or more cells, use the sign. Example: =C5-D3.
  • Multiplication: To multiply the values of two or more cells, use the * sign. Example: =C5*D3.
  • Division: To divide the values of two or more cells, use the / sign. Example: =C5/D3.

Putting all of these together, you can create a formula that adds, subtracts, multiplies, and divides all in one cell. Example: =(C5-D3)/((A5+B6)*3).

For more complex formulas, you’ll need to use parentheses around the expressions to avoid accidentally using the PEMDAS order of operations. Keep in mind that you can use plain numbers in your formulas.

Excel Functions

Excel functions automate some of the tasks you would use in a typical formula. For instance, instead of using the + sign to add up a range of cells, you’d use the SUM function. Let’s look at a few more functions that will help automate calculations and tasks.

  • SUM: The SUM function automatically adds up a range of cells or numbers. To complete a sum, you would input the starting cell and the final cell with a colon in between. Here’s what that looks like: SUM(Cell1:Cell2). Example: =SUM(C5:C30).
  • AVERAGE: The AVERAGE function averages out the values of a range of cells. The syntax is the same as the SUM function: AVERAGE(Cell1:Cell2). Example: =AVERAGE(C5:C30).
  • IF: The IF function allows you to return values based on a logical test. The syntax is as follows: IF(logical_test, value_if_true, [value_if_false]). Example: =IF(A2>B2,”Over Budget”,”OK”).
  • VLOOKUP: The VLOOKUP function helps you search for anything on your sheet’s rows. The syntax is: VLOOKUP(lookup value, table array, column number, Approximate match (TRUE) or Exact match (FALSE)). Example: =VLOOKUP([@Attorney],tbl_Attorneys,4,FALSE).
  • INDEX: The INDEX function returns a value from within a range. The syntax is as follows: INDEX(array, row_num, [column_num]).
  • MATCH: The MATCH function looks for a certain item in a range of cells and returns the position of that item. It can be used in tandem with the INDEX function. The syntax is: MATCH(lookup_value, lookup_array, [match_type]).
  • COUNTIF: The COUNTIF function returns the number of cells that meet a certain criteria or have a certain value. The syntax is: COUNTIF(range, criteria). Example: =COUNTIF(A2:A5,”London”).

Okay, ready to get into the nitty-gritty? Let’s get to it. (And to all the Harry Potter fans out there … you’re welcome in advance.)

Note: The GIFs and visuals are from a previous version of Excel. When applicable, the copy has been updated to provide instruction for users of both newer and older Excel versions.

1. Use Pivot tables to recognize and make sense of data.

Pivot tables are used to reorganize data in a spreadsheet. They won’t change the data that you have, but they can sum up values and compare different information in your spreadsheet, depending on what you’d like them to do.

Let’s take a look at an example. Let’s say I want to take a look at how many people are in each house at Hogwarts. You may be thinking that I don’t have too much data, but for longer data sets, this will come in handy.

To create the Pivot Table, I go to Data > Pivot Table. If you’re using the most recent version of Excel, you’d go to Insert > Pivot Table. Excel will automatically populate your Pivot Table, but you can always change around the order of the data. Then, you have four options to choose from.

  • Report Filter: This allows you to only look at certain rows in your dataset. For example, if I wanted to create a filter by house, I could choose to only include students in Gryffindor instead of all students.
  • Column Labels: These would be your headers in the dataset.
  • Row Labels: These could be your rows in the dataset. Both Row and Column labels can contain data from your columns (e.g. First Name can be dragged to either the Row or Column label — it just depends on how you want to see the data.)
  • Value: This section allows you to look at your data differently. Instead of just pulling in any numeric value, you can sum, count, average, max, min, count numbers, or do a few other manipulations with your data. In fact, by default, when you drag a field to Value, it always does a count.

Since I want to count the number of students in each house, I’ll go to the Pivot table builder and drag the House column to both the Row Labels and the Values. This will sum up the number of students associated with each house.

excel pivot table creation

2. Add more than one row or column.

As you play around with your data, you might find you’re constantly needing to add more rows and columns. Sometimes, you may even need to add hundreds of rows. Doing this one-by-one would be super tedious. Luckily, there’s always an easier way.

To add multiple rows or columns in a spreadsheet, highlight the same number of preexisting rows or columns that you want to add. Then, right-click and select “Insert.”

In the example below, I want to add an additional three rows. By highlighting three rows and then clicking insert, I’m able to add an additional three blank rows into my spreadsheet quickly and easily.

excel insert spaces

3. Use filters to simplify your data.

When you’re looking at very large data sets, you don’t usually need to be looking at every single row at the same time. Sometimes, you only want to look at data that fit into certain criteria.

That’s where filters come in.

Filters allow you to pare down your data to only look at certain rows at one time. In Excel, a filter can be added to each column in your data — and from there, you can then choose which cells you want to view at once.

Let’s take a look at the example below. Add a filter by clicking the Data tab and selecting “Filter.” Clicking the arrow next to the column headers and you’ll be able to choose whether you want your data to be organized in ascending or descending order, as well as which specific rows you want to show.

In my Harry Potter example, let’s say I only want to see the students in Gryffindor. By selecting the Gryffindor filter, the other rows disappear.

excel filtersPro Tip: Copy and paste the values in the spreadsheet when a Filter is on to do additional analysis in another spreadsheet.

4. Remove duplicate data points or sets.

Larger data sets tend to have duplicate content. You may have a list of multiple contacts in a company and only want to see the number of companies you have. In situations like this, removing the duplicates comes in quite handy.

To remove your duplicates, highlight the row or column that you want to remove duplicates of. Then, go to the Data tab and select “Remove Duplicates” (which is under the Tools subheader in the older version of Excel). A pop-up will appear to confirm which data you want to work with. Select “Remove Duplicates,” and you’re good to go.

excel duplicates removal

You can also use this feature to remove an entire row based on a duplicate column value. So if you have three rows with Harry Potter’s information and you only need to see one, then you can select the whole dataset and then remove duplicates based on email. Your resulting list will have only unique names without any duplicates.

5. Transpose rows into columns.

When you have rows of data in your spreadsheet, you might decide you actually want to transform the items in one of those rows into columns (or vice versa). It would take a lot of time to copy and paste each individual header — but what the transpose feature allows you to do is simply move your row data into columns, or the other way around.

Start by highlighting the column that you want to transpose into rows. Right-click it, and then select “Copy.” Next, select the cells on your spreadsheet where you want your first row or column to begin. Right-click on the cell, and then select “Paste Special.” A module will appear — at the bottom, you’ll see an option to transpose. Check that box and select OK. Your column will now be transferred to a row or vice-versa.

excel transpose

On newer versions of Excel, a drop-down will appear instead of a pop-up.

Excel transpose tool in newer versions

6. Split up text information between columns.

What if you want to split out information that’s in one cell into two different cells? For example, maybe you want to pull out someone’s company name through their email address. Or perhaps you want to separate someone’s full name into a first and last name for your email marketing templates.

Thanks to Excel, both are possible. First, highlight the column that you want to split up. Next, go to the Data tab and select “Text to Columns.” A module will appear with additional information.

First, you need to select either “Delimited” or “Fixed Width.”

  • “Delimited” means you want to break up the column based on characters such as commas, spaces, or tabs.
  • “Fixed Width” means you want to select the exact location on all the columns that you want the split to occur.

In the example case below, let’s select “Delimited” so we can separate the full name into first name and last name.

Then, it’s time to choose the Delimiters. This could be a tab, semi-colon, comma, space, or something else. (“Something else” could be the “@” sign used in an email address, for example.) In our example, let’s choose the space. Excel will then show you a preview of what your new columns will look like.

When you’re happy with the preview, press “Next.” This page will allow you to select Advanced Formats if you choose to. When you’re done, click “Finish.”

excel text to column

7. Use formulas for simple calculations.

In addition to doing pretty complex calculations, Excel can help you do simple arithmetic like adding, subtracting, multiplying, or dividing any of your data.

  • To add, use the + sign.
  • To subtract, use the – sign.
  • To multiply, use the * sign.
  • To divide, use the / sign.

You can also use parentheses to ensure certain calculations are done first. In the example below (10+10*10), the second and third 10 were multiplied together before adding the additional 10. However, if we made it (10+10)*10, the first and second 10 would be added together first.

Excel simple formulas in action

8. Get the average of numbers in your cells.

If you want the average of a set of numbers, you can use the formula =AVERAGE(Cell1:Cell2). If you want to sum up a column of numbers, you can use the formula =SUM(Cell1:Cell2).

9. Use conditional formatting to make cells automatically change color based on data.

Conditional formatting allows you to change a cell’s color based on the information within the cell. For example, if you want to flag certain numbers that are above average or in the top 10% of the data in your spreadsheet, you can do that. If you want to color code commonalities between different rows in Excel, you can do that. This will help you quickly see information that is important to you.

To get started, highlight the group of cells you want to use conditional formatting on. Then, choose “Conditional Formatting” from the Home menu and select your logic from the dropdown. (You can also create your own rule if you want something different.) A window will pop up that prompts you to provide more information about your formatting rule. Select “OK” when you’re done, and you should see your results automatically appear.

Excel conditional formatting

10. Use the IF Excel formula to automate certain Excel functions.

Sometimes, we don’t want to count the number of times a value appears. Instead, we want to input different information into a cell if there is a corresponding cell with that information.

For example, in the situation below, I want to award ten points to everyone who belongs in the Gryffindor house. Instead of manually typing in 10’s next to each Gryffindor student’s name, I can use the IF Excel formula to say that if the student is in Gryffindor, then they should get ten points.

The formula is: IF(logical_test, value_if_true, [value_if_false])

Example Shown Below: =IF(D2=”Gryffindor”,”10″,”0″)

In general terms, the formula would be IF(Logical Test, value of true, value of false). Let’s dig into each of these variables.

  • Logical_Test: The logical test is the “IF” part of the statement. In this case, the logic is D2=”Gryffindor” because we want to make sure that the cell corresponding with the student says “Gryffindor.” Make sure to put Gryffindor in quotation marks here.
  • Value_if_True: This is what we want the cell to show if the value is true. In this case, we want the cell to show “10” to indicate that the student was awarded the 10 points. Only use quotation marks if you want the result to be text instead of a number.
  • Value_if_False: This is what we want the cell to show if the value is false. In this case, for any student not in Gryffindor, we want the cell to show “0”. Only use quotation marks if you want the result to be text instead of a number.

Excel IF formula in action

Note: In the example above, I awarded 10 points to everyone in Gryffindor. If I later wanted to sum the total number of points, I wouldn’t be able to because the 10’s are in quotes, thus making them text and not a number that Excel can sum.

The real power of the IF function comes when you string multiple IF statements together, or nest them. This allows you to set multiple conditions, get more specific results, and ultimately organize your data into more manageable chunks.

Ranges are one way to segment your data for better analysis. For example, you can categorize data into values that are less than 10, 11 to 50, or 51 to 100. Here’s how that looks in practice: 

=IF(B3<11,“10 or less”,IF(B3<51,“11 to 50”,IF(B3<100,“51 to 100”)))

It can take some trial-and-error, but once you have the hang of it, IF formulas will become your new Excel best friend.

11. Use dollar signs to keep one cell’s formula the same regardless of where it moves.

Have you ever seen a dollar sign in an Excel formula? When used in a formula, it isn’t representing an American dollar; instead, it makes sure that the exact column and row are held the same even if you copy the same formula in adjacent rows.

You see, a cell reference — when you refer to cell A5 from cell C5, for example — is relative by default. In that case, you’re actually referring to a cell that’s five columns to the left (C minus A) and in the same row (5). This is called a relative formula. When you copy a relative formula from one cell to another, it’ll adjust the values in the formula based on where it’s moved. But sometimes, we want those values to stay the same no matter whether they’re moved around or not — and we can do that by turning the formula into an absolute formula.

To change the relative formula (=A5+C5) into an absolute formula, we’d precede the row and column values by dollar signs, like this: (=$A$5+$C$5). (Learn more on Microsoft Office’s support page here.)

12. Use the VLOOKUP function to pull data from one area of a sheet to another.

Have you ever had two sets of data on two different spreadsheets that you want to combine into a single spreadsheet?

For example, you might 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.

I have to combine data sets like this a lot — and when I do, the VLOOKUP is my go-to formula.

Before you use the formula, though, be absolutely sure that you have at least one column that appears identically in both places. 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, Approximate match (TRUE) or Exact match (FALSE))

The formula with variables from our example below: =VLOOKUP(C2,Sheet2!A:B,2,FALSE)

In this formula, there are several variables. The following is true when you want to combine information in Sheet 1 and Sheet 2 onto Sheet 1.

  • Lookup Value: This is the identical value you have in both spreadsheets. Choose the first value in your first spreadsheet. In the example that follows, this means the first email address on the list, or cell 2 (C2).
  • Table Array: The table array is 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: This tells Excel which column the new data you want to copy to Sheet 1 is located in. In our example, this would be the column that “House” is located in. “House” is the second column in our range of columns (table array), so our column number is 2. [Note: Your range can be more than two columns. For example, if there are three columns on Sheet 2 — Email, Age, and House — and you still want to bring House onto Sheet 1, you can still use a VLOOKUP. You just need to change the “2” to a “3” so it pulls back the value in the third column: =VLOOKUP(C2:Sheet2!A:C,3,false).]
  • Approximate Match (TRUE) or Exact Match (FALSE): Use FALSE to ensure you pull in only exact value matches. If you use TRUE, the function will pull in approximate matches.

In the example below, 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.

Excel VLOOKUP function

So when we type in the formula =VLOOKUP(C2,Sheet2!A:B,2,FALSE), we bring all the house data into Sheet 1.

Keep in mind that VLOOKUP will only pull back values from the second sheet that are to the right of the column containing your identical data. This can lead to some limitations, which is why some people prefer to use the INDEX and MATCH functions instead.

13. Use INDEX and MATCH formulas to pull data from horizontal columns.

Like VLOOKUP, the INDEX and MATCH functions pull in data from another dataset into one central location. Here are the main differences:

  • VLOOKUP is a much simpler formula. If you’re working with large data sets that would require thousands of lookups, using the INDEX and MATCH function will significantly decrease load time in Excel.
  • The INDEX and MATCH formulas work right-to-left, whereas VLOOKUP formulas only work as a left-to-right lookup. In other words, if you need to do a lookup that has a lookup column to the right of the results column, then you’d have to rearrange those columns in order to do a VLOOKUP. This can be tedious with large datasets and/or lead to errors.

So if I want to combine information in Sheet 1 and Sheet 2 onto Sheet 1, but the column values in Sheets 1 and 2 aren’t the same, then to do a VLOOKUP, I would need to switch around my columns. In this case, I’d choose to do an INDEX and MATCH instead.

Let’s look at an example. Let’s say Sheet 1 contains a list of people’s names and their Hogwarts email addresses, and Sheet 2 contains a list of people’s email addresses and the Patronus that each student has. (For the non-Harry Potter fans out there, every witch or wizard has an animal guardian called a “Patronus” associated with him or her.) The information that lives in both sheets is the column containing email addresses, but this email address column is in different column numbers on each sheet. I’d use the INDEX and MATCH formulas instead of VLOOKUP so I wouldn’t have to switch any columns around.

So what’s the formula, then? The formula is actually the MATCH formula nested inside the INDEX formula. You’ll see I differentiated the MATCH formula using a different color here.

The formula: =INDEX(table array, MATCH formula)

This becomes: =INDEX(table array, MATCH (lookup_value, lookup_array))

The formula with variables from our example below: =INDEX(Sheet2!A:A,(MATCH(Sheet1!C:C,Sheet2!C:C,0)))

Here are the variables:

  • Table Array: The range of columns on Sheet 2 containing the new data you want to bring over to Sheet 1. In our example, “A” means Column A, which contains the “Patronus” information for each person.
  • Lookup Value: This is the column in Sheet 1 that contains identical values in both spreadsheets. In the example that follows, this means the “email” column on Sheet 1, which is Column C. So: Sheet1!C:C.
  • Lookup Array: This is the column in Sheet 2 that contains identical values in both spreadsheets. In the example that follows, this refers to the “email” column on Sheet 2, which happens to also be Column C. So: Sheet2!C:C.

Once you have your variables straight, type in the INDEX and MATCH formulas in the top-most cell of the blank Patronus column on Sheet 1, where you want the combined information to live.

Excel INDEX and MATCH functions in action

14. Use the COUNTIF function to make Excel count words or numbers in any range of cells.

Instead of manually counting how often a certain value or number appears, let Excel do the work for you. With the COUNTIF function, Excel can count the number of times a word or number appears in any range of cells.

For example, let’s say I want to count the number of times the word “Gryffindor” appears in my data set.

The formula: =COUNTIF(range, criteria)

The formula with variables from our example below: =COUNTIF(D:D,”Gryffindor”)

In this formula, there are several variables:

  • Range: The range that we want the formula to cover. In this case, since we’re only focusing on one column, we use “D:D” to indicate that the first and last column are both D. If I were looking at columns C and D, I would use “C:D.”
  • Criteria: Whatever number or piece of text you want Excel to count. Only use quotation marks if you want the result to be text instead of a number. In our example, the criteria is “Gryffindor.”

Simply typing in the COUNTIF formula in any cell and pressing “Enter” will show me how many times the word “Gryffindor” appears in the dataset.

Excel COUNTIF function

15. Combine cells using &.

Databases tend to split out data to make it as exact as possible. For example, instead of having a column that shows a person’s full name, a database might have the data as a first name and then a last name in separate columns. Or, it may have a person’s location separated by city, state, and zip code. In Excel, you can combine cells with different data into one cell by using the “&” sign in your function.

The formula with variables from our example below: =A2&” “&B2

Let’s go through the formula together using an example. Pretend we want to combine first names and last names into full names in a single column. To do this, we’d first put our cursor in the blank cell where we want the full name to appear. Next, we’d highlight one cell that contains a first name, type in an “&” sign, and then highlight a cell with the corresponding last name.

But you’re not finished — if all you type in is =A2&B2, then there will not be a space between the person’s first name and last name. To add that necessary space, use the function =A2&” “&B2. The quotation marks around the space tell Excel to put a space in between the first and last name.

To make this true for multiple rows, simply drag the corner of that first cell downward as shown in the example.

Excel combination of cells

16. Add checkboxes.

If you’re using an Excel sheet to track customer data and want to oversee something that isn’t quantifiable, you could insert checkboxes into a column.

For example, if you’re using an Excel sheet to manage your sales prospects and want to track whether you called them in the last quarter, you could have a “Called this quarter?” column and check off the cells in it when you’ve called the respective client.

Here’s how to do it.

Highlight a cell you’d like to add checkboxes to in your spreadsheet. Then, click DEVELOPER. Then, under FORM CONTROLS, click the checkbox or the selection circle highlighted in the image below.

Excel checkboxes

Once the box appears in the cell, copy it, highlight the cells you also want it to appear in, and then paste it.

17. Hyperlink a cell to a website.

If you’re using your sheet to track social media or website metrics, it can be helpful to have a reference column with the links each row is tracking. If you add a URL directly into Excel, it should automatically be clickable. But, if you have to hyperlink words, such as a page title or the headline of a post you’re tracking, here’s how.

Highlight the words you want to hyperlink, then press Shift K. From there a box will pop up allowing you to place the hyperlink URL. Copy and paste the URL into this box and hit or click Enter.

If the key shortcut isn’t working for any reason, you can also do this manually by highlighting the cell and clicking Insert > Hyperlink.

18. Add drop-down menus.

Sometimes, you’ll be using your spreadsheet to track processes or other qualitative things. Rather than writing words into your sheet repetitively, such as “Yes”, “No”, “Customer Stage”, “Sales Lead”, or “Prospect”, you can use dropdown menus to quickly mark descriptive things about your contacts or whatever you’re tracking.

Here’s how to add drop-downs to your cells.

Highlight the cells you want the drop-downs to be in, then click the Data menu in the top navigation and press Validation.

Excel drop-down menu option

From there, you’ll see a Data Validation Settings box open. Look at the Allow options, then click Lists and select Drop-down List. Check the In-Cell dropdown button, then press OK.

19. Use the format painter. 

As you’ve probably noticed, Excel has a lot of features to make crunching numbers and analyzing your data quick and easy. But if you ever spent some time formatting a sheet to your liking, you know it can get a bit tedious.

Don’t waste time repeating the same formatting commands over and over again. Use the format painter to easily copy the formatting from one area of the worksheet to another. To do so, choose the cell you’d like to replicate, then select the format painter option (paintbrush icon) from the top toolbar.

Excel Keyboard Shortcuts 

Creating reports in Excel is time-consuming enough. How can we spend less time navigating, formatting, and selecting items in our spreadsheet? Glad you asked. There are a ton of Excel shortcuts out there, including some of our favorites listed below.

Create a New Workbook

PC: Ctrl-N | Mac: Command-N

Select Entire Row

PC: Shift-Space | Mac: Shift-Space

Select Entire Column

PC: Ctrl-Space | Mac: Control-Space

Select Rest of Column

PC: Ctrl-Shift-Down/Up | Mac: Command-Shift-Down/Up

Select Rest of Row

PC: Ctrl-Shift-Right/Left | Mac: Command-Shift-Right/Left

Add Hyperlink

PC: Ctrl-K | Mac: Command-K

Open Format Cells Window

PC: Ctrl-1 | Mac: Command-1

Autosum Selected Cells

PC: Alt-= | Mac: Command-Shift-T

Other Excel Help Resources

Use Excel to Automate Processes in Your Team

Even if you’re not an accountant, you can still use Excel to automate tasks and processes in your team. With the tips and tricks we shared in this post, you’ll be sure to use Excel to its fullest extent and get the most out of the software to grow your business.

Editor’s Note: This post was originally published in August 2017 but has been updated for comprehensiveness.

excel marketing templates



Source link

MARKETING

How data clean rooms might help keep the internet open

Published

on

How data clean rooms might help keep the internet open

Are data clean rooms the solution to what IAB CEO David Cohen has called the “slow-motion train wreck” of addressability? Voices at the IAB will tell you that they have a big role to play.

“The issue with addressability is that once cookies go away, and with the loss of identifiers, about 80% of the addressable market will become unknown audiences which is why there is a need for privacy-centric consent and a better consent-value exchange,” said Jeffrey Bustos, VP, measurement, addressability and data at the IAB.

“Everyone’s talking about first-party data, and it is very valuable,” he explained, “but most publishers who don’t have sign-on, they have about 3 to 10% of their readership’s first-party data.” First-party data, from the perspective of advertisers who want to reach relevant and audiences, and publishers who want to offer valuable inventory, just isn’t enough.

Why we care. Two years ago, who was talking about data clean rooms? The surge of interest is recent and significant, according to the IAB. DCRs have the potential, at least, to keep brands in touch with their audiences on the open internet; to maintain viability for publishers’ inventories; and to provide sophisticated measurement capabilities.

How data clean rooms can help. DCRs are a type of privacy-enhancing technology that allows data owners (including brands and publishers) to share customer first-party data in a privacy-compliant way. Clean rooms are secure spaces where first-party data from a number of sources can be resolved to the same customer’s profile while that profile remains anonymized.

In other words, a DCR is a kind of Switzerland — a space where a truce is called on competition while first-party data is enriched without compromising privacy.

“The value of a data clean room is that a publisher is able to collaborate with a brand across both their data sources and the brand is able to understand audience behavior,” said Bestos. For example, a brand selling eye-glasses might know nothing about their customers except basic transactional data — and that they wear glasses. Matching profiles with a publisher’s behavioral data provides enrichment.

“If you’re able to understand behavioral context, you’re able to understand what your customers are reading, what they’re interested in, what their hobbies are,” said Bustos. Armed with those insights, a brand has a better idea of what kind of content they want to advertise against.

The publisher does need to have a certain level of first-party data for the matching to take place, even if it doesn’t have a universal requirement for sign-ins like The New York Times. A publisher may be able to match only a small percentage of the eye-glass vendor’s customers, but if they like reading the sports and arts sections, at least that gives some directional guidance as to what audience the vendor should target.

Dig deeper: Why we care about data clean rooms

What counts as good matching? In its “State of Data 2023” report, which focuses almost exclusively on data clean rooms, concern is expressed that DCR efficacy might be threatened by poor match rates. Average match rates hover around 50% (less for some types of DCR).

Bustos is keen to put this into context. “When you are matching data from a cookie perspective, match rates are usually about 70-ish percent,” he said, so 50% isn’t terrible, although there’s room for improvement.

One obstacle is a persistent lack of interoperability between identity solutions — although it does exist; LiveRamp’s RampID is interoperable, for example, with The Trade Desk’s UID2.

Nevertheless, said Bustos, “it’s incredibly difficult for publishers. They have a bunch of identity pixels firing for all these different things. You don’t know which identity provider to use. Definitely a long road ahead to make sure there’s interoperability.”

Maintaining an open internet. If DCRs can contribute to solving the addressability problem they will also contribute to the challenge of keeping the internet open. Walled gardens like Facebook do have rich troves of first-party and behavioral data; brands can access those audiences, but with very limited visibility into them.

“The reason CTV is a really valuable proposition for advertisers is that you are able to identify the user 1:1 which is really powerful,” Bustos said. “Your standard news or editorial publisher doesn’t have that. I mean, the New York Times has moved to that and it’s been incredibly successful for them.” In order to compete with the walled gardens and streaming services, publishers need to offer some degree of addressability — and without relying on cookies.

But DCRs are a heavy lift. Data maturity is an important qualification for getting the most out of a DCR. The IAB report shows that, of the brands evaluating or using DCRs, over 70% have other data-related technologies like CDPs and DMPs.

“If you want a data clean room,” Bustos explained, “there are a lot of other technological solutions you have to have in place before. You need to make sure you have strong data assets.” He also recommends starting out by asking what you want to achieve, not what technology would be nice to have. “The first question is, what do you want to accomplish? You may not need a DCR. ‘I want to do this,’ then see what tools would get you to that.”

Understand also that implementation is going to require talent. “It is a demanding project in terms of the set-up,” said Bustos, “and there’s been significant growth in consulting companies and agencies helping set up these data clean rooms. You do need a lot of people, so it’s more efficient to hire outside help for the set up, and then just have a maintenance crew in-house.”

Underuse of measurement capabilities. One key finding in the IAB’s research is that DCR users are exploiting the audience matching capabilities much more than realizing the potential for measurement and attribution. “You need very strong data scientists and engineers to build advanced models,” Bustos said.

“A lot of brands that look into this say, ‘I want to be able to do a predictive analysis of my high lifetime value customers that are going to buy in the next 90 days.’ Or ‘I want to be able to measure which channels are driving the most incremental lift.’ It’s very complex analyses they want to do; but they don’t really have a reason as to why. What is the point? Understand your outcome and develop a sequential data strategy.”

Trying to understand incremental lift from your marketing can take a long time, he warned. “But you can easily do a reach and frequency and overlap analysis.” That will identify wasted investment in channels and as a by-product suggest where incremental lift is occurring. “There’s a need for companies to know what they want, identify what the outcome is, and then there are steps that are going to get you there. That’s also going to help to prove out ROI.”

Dig deeper: Failure to get the most out of data clean rooms is costing marketers money


Get MarTech! Daily. Free. In your inbox.


Source link

Continue Reading

MARKETING

Ascend | DigitalMarketer

Published

on

Ascend | DigitalMarketer

At this stage, your goal is to generate repeat buys and real profits. While your entry-point offer was designed for conversions, your ascension offers should be geared for profits—because if you’re serving your customers well, they’ll want to buy again and again.

Ascension offers may be simple upsells made after that initial purchase… bigger, better solutions… or “done for you” add-ons.

So now we must ask ourselves, what is our core flagship offer and how do we continue to deliver value after the first sale is made? What is the thing that we are selling? 

How we continue to deliver value after the first sale is really important, because having upsells and cross sales gives you the ability to sell to customers you already have. It will give you higher Average Customer values, which is going to give you higher margins. Which means you can spend more to acquire new customers. 

Why does this matter? It matters because of this universal law of marketing and customer acquisition, he or she who is able and willing to spend the most to acquire a customer wins.

Very often the business with the best product messaging very often is the business that can throw the most into customer acquisition. Now there are two ways to do that.

The first way is to just raise a lot of money. The problem is if you have a lot of money, that doesn’t last forever. At some point you need economics. 

The second way, and the most timeless and predictable approach, is to simply have the highest value customers of anyone in your market. If your customers are worth more to you than they are to your competitors, you can spend more to acquire them at the same margin. 

If a customer is worth twice as much to you than it is to your competitor, you can spend twice as much trying to acquire them to make the same margin. You can invest in your customer acquisition, because your customers are investing in your business. You can invest in your customer experiences, and when we invest more into the customer we build brands that have greater value. Meaning, people are more likely to choose you over someone else, which can actually lower acquisition costs. 

Happy customers refer others to us, which is called zero dollar customer acquisition, and generally just ensures you’re making a bigger impact. You can invest more in the customer experience and customer acquisition process if you don’t have high margins. 

If you deliver a preview experience, you can utilize revenue maximizers like up sells, cross sales, and bundles. These are things that would follow up the initial sale or are combined with the initial sale to increase the Average Customer Value.

The best example of an immediate upsell is the classic McDonalds, “would you like fries with that?” You got just a burger, do you also want fries with that? 

What distinguishes an upsell from other types of follow up offers is the upsell promise, the same end result for a bigger and better end result. 

What’s your desired result when you go to McDonalds? It’s not to eat healthy food, and it’s not even to eat a small amount of food. When you go to McDonalds your job is to have a tasty, greasy, predictable inexpensive meal. No one is going there because it’s healthy, you’re going there because you want to eat good. 

It’s predictable. It’s not going to break the bank for a hamburger, neither will adding fries or a Coke. It’s the same experience, but it’s BIGGER and BETTER. 

Amazon does this all of the time with their “Customers Who Bought This Also Bought …” But this one is algorithmic. The point of a cross sell is that it is relevant to the consumer, but it doesn’t necessarily have to be aligned with the original purchase. What you don’t want to do is start someone down one path and confuse them.

You can make this process easy with Bundles and Kits. With a bundle or a kit you’re essentially saying to someone, “you can buy just one piece, or you can get this bundle that does all of these other things for a little bit more. And it’s a higher value.”

The idea behind bundles and kits is that we are adding to the primary offer, not offering them something different. We’re simply promising to get them this desired result in higher definition. 

The Elements of High-Converting Revenue Maximizers (like our bundles and kits) are:

  1. Speed

If you’re an e-Commerce business, selling a physical product, this can look like: offering free shipping for orders $X or more. We’re looking to get your customers the same desired result, but with less work for them.

  1. Automation

If you’re a furniture business, and you want to add a Revenue Maximizer, this can look like: Right now for an extra $X our highly trained employees will come and put this together for you. 

  1. Access 

People will pay for speed, they’ll pay for less work, but they will also pay for a look behind the curtain. Think about the people who pay for Backstage Passes. Your customers will pay for a VIP experience just so they can kind of see how everything works. 

Remember, the ascension stage doesn’t have to stop. Once you have a customer, you should do your best to make them a customer for life. You should continue serving them. Continue asking them, “what needs are we still not meeting” and seek to meet those needs. 

It is your job as a marketer to seek out to discover these needs, to bring these back to the product team, because that’s what’s going to enable you to fully maximize the average customer value. Which is going to enable you to have a whole lot more to spend to acquire those customers and make your job a whole lot easier. 

Now that you understand the importance of the ascend stage, let’s apply it to our examples.

Hazel & Hem could have free priority shipping over $150, a “Boutique Points” reward program with exclusive “double point” days to encourage spending, and an exclusive “Stylist Package” that includes a full outfit custom selected for the customer. 

Cyrus & Clark can retain current clients by offering an annual strategic plan, “Done for You” Marketing services that execute on the strategic plan, and the top tier would allow customers to be the exclusive company that Cyrus & Clark services in specific geographical territories.



Source link

Continue Reading

MARKETING

2023 Facebook Algorithm Guide: Overview & Best Practices

Published

on

2023 Facebook Algorithm Guide: Overview & Best Practices

Every month, 2.7 billion people use Facebook, Meta’s globe-dominating social network. For marketers, this is an un-ignorable audience. However, reaching that audience isn’t always easy – to get content in front of a relevant user, they need to make the Facebook algorithm work in their favor.

Unfortunately, the algorithm can feel very mysterious. Why do some posts go viral with engagement while others wither and disappear without so much as a few courtesy likes?

The good news is that while the technical rules governing Facebook’s algorithm may be in a black box, there are plenty of guidelines and common-sense tips that can help ensure your content gets prioritized and seen. Facebook has published many explainers and tutorials over the past few years to break down how its algorithm ranks and distributes content to users’ Feeds.

Here’s how Facebook’s algorithm works in 2023 with ten expert tips on increasing the impact, performance and lifecycle of your Facebook content.
 

Table of Contents

 

  • What is the Facebook Algorithm?
  • A Recent History of the Facebook Algorithm 
  • How the Facebook Algorithm Works in 2023
  • 10 Best Practices for Working with Facebook’s Algorithm
  • Final Takeaway

 

What is the Facebook Algorithm?

 
The Facebook algorithm is the set of rules and formulas that determine what content users see in their Feeds. Its goal is to make the posts that “matter most to the user” highly visible to that user. To do this, it analyzes each piece of content eligible to be displayed and ranks them according to a set of criteria.

As Facebook explains, the algorithm is actually “not just one single algorithm; it’s multiple layers of [machine learning] models and rankings that we apply to predict the most relevant and meaningful content for each user.”

If that sounds complex, that’s because of the sheer volume of content on the Facebook platform. There are over 2 billion Facebook users and trillions of posts they can see; the algorithm needs to be sophisticated to sort through all that content in an instant between launching the Facebook application and the population of each user’s Feed. 

 

A Recent History of the Facebook Algorithm

 

Since 2017, Facebook has been increasingly transparent about significant changes in how it ranks and distributes content. That also means the algorithm is constantly evolving. In general, those updates have favored user input, posts friends and family over publishers, and content personalized to a user’s interests… all geared toward generating more “meaningful interactions.”  These updates include:

 

  • Meaningful Interactions Update (2018) – This update signaled that the algorithm would predict which posts a user might want to interact with their friends about and show these posts higher in Feed. These posts inspire discussion in the comments and posts that users might want to share and react to. 
  • Updates to Video Rankings (2019) – This update boosted the rankings of video posts that users sought out and returned to, watched for more than one minute at a time, and were original creations and not repurposed content. 
  • Addressing Sensational Health Claims (2019) – This update applied some of the existing “clickbait” rules specifically to posts making medical or health claims in an effort to reduce misinformation. Exaggerated or sensational claims were deprioritized, as were posts promoting products that advertised “miracle” cures.

 

The past three years have seen additional updates, and since they’re more recent, they deserve closer examination.

 

2020: Key takeaway from 2020

 

In 2020, Facebook modified its algorithm again to give more weight to original, credible news sources and create more personalized advertising encounters for users based on their interactions. Additional updates this year included changes designed to comply with Apple’s iOS 14’s privacy guidelines. 

 

  • Prioritizing Original Sources: In response to users continually reporting a preference for “news stories that are credible and informative,” Facebook announced that it would make ongoing updates that “prioritize articles in News Feed that we identify as original reporting on a developing story or topic.”
  • Personalized Ads: The Facebook algorithm serves advertisements to a user’s Feed based on the posts and pages they have engaged with previously. Businesses are also given the option to share information about the actions that users take on their websites and apps so they can show the most relevant content in users’ Facebook Feeds. To balance this process of information gathering and sharing, which also lays the foundation for personalized advertising on the platform, Facebook instituted the “Why am I seeing this ad” feature and the “Ad Preferences” dashboard for users (and to address privacy concerns).
  • Retargeting Limitations: Even with expanded personalization, Facebook had to respond to the significant privacy and permissioning guidelines i=within the Apple iOS 14 update released in 2020 (Tinuiti’s Liz Emery takes a more detailed look at this topic here). When Apple users install or update to iOS 14, they will be prompted to opt-in or opt out of data sharing. While Facebook has other variables that can be used to identify devices, such as the associated email address and phone number, targeting that depends on users sharing their data at the device level is restricted based on this update.

 

2021: Machine Learning and User Control

 

In 2021, Facebook released new details about how the algorithm governing users’ Feeds works and increased the amount of control users have over what they see. 

 

  • Favorites: A new tool where users can control and prioritize posts in their Feeds from the friends and Pages they choose. By selecting up to 30 friends and Pages to include in Favorites, their posts will appear higher in ranked and can also be viewed as a separate filter.
  • Revealing the algorithm’s machine learning mechanics: In 2021, Facebook published an in-depth post explaining how the Feed predicts what users want to see. For the first time, it detailed the machine learning processes behind predicting what users see in their Feeds based on various factors, including what and whom they’ve followed, liked, or engaged with recently. These mechanics are largely still in place today.

 

Source: Facebook

 

2022: From ML to AI

 

Last year, the Facebook algorithm evolved further in the direction of user control and augmented its use of machine learning tools with more sophisticated artificial intelligence systems. These two updates went hand-in-hand. Users were given a new function on each post they saw, the “Show More/Show Less” feature. Selecting “Show More” would increase the ranking score for that post, increasing the likelihood of a similar post or a similar user appearing in the user’s Feed. The inverse would happen when “Show Less” is selected.

These per-post user inputs are simultaneously helping the AI system generalize how relevant future content will be for that user. Or as Facebook puts it, “by offering more ways to incorporate direct feedback into Feed ranking, we’re making our artificial intelligence systems smarter and more responsive.”

Facebook’s AI model generates what the company calls user and content embeddings, which help predict the types of content a person wants to see more of or less of in their Feed. Another Facebook blog post from 2022 explains that a “user embedding captures a person’s tastes, while the content embedding captures the essence of what a post is about.” 

One last update from 2022 – what was once called the Facebook News Feed is now just the “Feed.” That’s how we refer to it throughout this article, except where relevant due to historical discussion.

 

How the Facebook Algorithm Works in 2023

 
That’s the state of the Facebook algorithm in 2023 – it has evolved to become an AI-powered, user-centric model designed to present users with relevant, welcome content in their Feeds. Even though Meta will admit that the algorithm isn’t perfect (and may never be), Facebook has demonstrated a willingness to modify its processes to give users what they want.

Despite the Facebook algorithm’s complexity and integration of new technologies like AI and machine learning, understanding its core functionality boils down to four ranking factors.

The Four Ranking Factors Fueling the Facebook Feed Algorithm

 
Prioritizing what “matters” to users has been one of the most consistent purposes of the Feed and all of its previous iterations. The goal of Facebook’s algorithm is to “show stories that matter to users,” according to Adam Mosseri, VP of Facebook’s News Feed Management. That aim is reflected across the platform’s many updates and tweaks to its algorithm, from more user control to increased personalization on advertisements. 

With that in mind, you should know how Facebook’s different algorithm factors work together to determine which stories “matter” to a user. And Facebook made these factors easy to understand in its published help center post.  
 

1. Inventory

 
Inventory represents the stock of all content that can display to a user on Facebook’s News Feed, which fluctuates based on user activity once scrolling has begun. This includes everything posted by friends and publishers.
 

2. Signals

 
Signals represent the information that Facebook can gather about a piece of content. Signals are the single factor that you have control over.

These are your inputs that Facebook interprets; type of content, the publisher, its age, purpose, and more.

You want your content to signal to Facebook that it’s meaningful and relevant to your target audience.
 

3. Predictions

 
Predictions represent a user’s behavior and how likely they are to engage with a content piece. Will a user watch a video to completion? Will they select the “Show More” feature on the post?

Predictions take authentic engagement like comments, likes, and shares from real profiles into account.
 

4. Relevancy Score

 
Relevancy Score is the final number assigned to a piece of content based on the likelihood that the user will respond positively to it. It also accounts for whether a post is “clickbait,” whether it links to a low-quality webpage, or if it’s misinformative in some way.
 

10 Best Practices for Working with Facebook’s Algorithm

 
So how can you tailor your content to ensure a high Relevancy Score and a strong enough ranking to appear in your target audience’s Feeds? Most of the following tips will be common sense if you currently produce content for social audiences, but many are specific to the sophisticated Facebook algorithm. 

Here are some guidelines and best practices for keeping your content meaningful in Facebook’s eyes, based on our research, Facebook’s recommendations, and Matt Navara and Paul Armstrong’s coverage of Facebook’s News Feed webinar
 

1. Keep posts relevant to your audience

 
Your content should always be relevant to your core audience — the people you want to build a community around. If your content is relevant to a user, the Facebook algorithm is likely to interpret that content as “meaningful,” a key consideration in ranking. 

Stories should be compelling enough for a user to want to share with family and friends. Content should be informative and interesting… and, of course, accurate. 

Products, education and lifestyle imagery, should reinforce your post’s meaningful and informative nature and build on your identity as a brand answering to a specific audience.

 

2. Engage readers and encourage interaction

 
Facebook’s News Feed algorithm favors content that fosters positive interactions between your followers and others.

Any piece of content, from products to education to entertainment — should provoke conversation. Remember that conversations can’t be one-sided; you want your audience to respond, but you must also respond to them when possible. 

You want your content to prompt people to stop their scroll, interact, and share. Interaction is a crucial weighting factor for the Facebook algorithm, so all your content should be tailored to maximize engagement.
 

3. But don’t use clickbait or engagement bait

 
 
Remember all those “like if…” and “share if you are…” posts?

This is considered engagement baiting; it doesn’t add value or interaction for users. It may not entirely be clickbait, but the Facebook algorithm will penalize it as though it were. 

Avoid asking people to “please comment, like, and share.” Your content should inspire them to engage without having to ask.

Facebook penalizes brands that encourage comments, likes, and shares on organic and ad posts. Keep this in mind when developing content for Instagram and Facebook.

 

4. Expand your post reach with employees and brand advocates

 

Because the Facebook algorithm gives preference to posts from users’ friends, families and the pages they interact with, your company’s Facebook page will have naturally limited reach. This is where enlisting employees and brand advocates can have a real impact. 

Facebook represents your widest audience, but to reach them, you need to engage the audience closest to home. Encouraging your work team to share your brand’s content with their networks broadens the reach of the post or piece of content and your brand. Directly engaging with Facebook users who are already devotees of your brand and asking them to share content with their friends and family can have a similar effect.,
 

5. Or put ad dollars behind content with organic momentum

 
 
The new Facebook algorithm values content that performs well organically, and you can build off that momentum by boosting or promoting that content with ad dollars.

Content that already has strong organic traction means lower CPCs which, combined with ad dollars, can act as a snowball effect for your content.

Identify opportunities for ads based on organic post engagement and tap into Facebook Ads Manager tools by leveraging these posts in ads.

Conversely, don’t waste ad dollars on poor-performing organic content. It will have higher CPCs and cost you more while offering less in return.

“If a post performs well with engagement, likes, and shares, there’s an opportunity to place additional ad dollars to drive that performance even further.”

— Nii Ahene, Chief Strategy Officer at Tinuiti
 
Portrait of Nii Ahene
 

6. Create compelling, original video content

 
 
2019 was the year that Facebook began leaning into its video offering in earnest, and it hasn’t stopped since. Today, the video formats available on Facebook have expanded to include Reels and Stories (shorter clips), Video on Demand and Live video. Reels, in particular, is Facebook’s fastest-growing content format “by far.” s video continues to be the top-performing content type across all social media networks, focusing on video should be a central part of your Facebook marketing strategy.

For your video content to perform best in the Feed, Facebook recommends that it be original, capture the audience’s attention, spark engagement, and inspire users to seek additional video content from the same source. 

To create original and authentic Reels, Stories and full-length videos, make sure they capture your brand’s voice and avoid duplicating content. To retain attention, ensure your creative and copy is optimized towards mobile viewing (i.e., shortened copy, readable overlays, shortened headlines). And to generate engagement, encourage discussion and genuine interactions (but like always, avoid engagement bait).

 

7. Inspire audiences and evoke emotion with storytelling

 

Just as videos should be original, engaging and attention-grabbing, so should any content you post on Facebook. Understand the kinds of stories that resonate with your audience and craft your posts to tell those stories in an exciting way.

You can create connections with your audience through authenticity, interactivity and accuracy. But the surest way is by listening. Ask for feedback. Learn their interests. Take cues from their activity on other platforms. When you know what your audience cares about, you have a better chance of inspiring them… and a better chance of rising to the top of their Feeds.

 

8. Post authentic and truthful content

 

Facebook says that “authentic stories are the ones that resonate most” and that users want to see accurate information. After the controversies surrounding “fake news” and the spread of dis- and misinformation on the platform in recent years, the company has made promoting truthful content central to the Facebook algorithm’s function. 

To signal that your content is genuine and accurate, write clear headlines free from exaggeration or sensationalism. Use well-sourced, reliable information, and avoid sharing content from sources you need clarification on. And above all, don’t lie or try to mislead with your content.

 

9. Schedule content when readers are likely to engage

 

The Facebook Feed is no longer chronological, but timing can still impact post performance within the algorithm. You want to post content when your audience is likely to engage with it, which is likely in the evening or overnight, but it can vary widely by the user. There is some research exploring the objectively ideal time for posting, but the ultimate best practice is understanding your audience and when they are most likely to be on the platform. 

 

10. Learn what works by tracking content performance

 

After you’ve published your content, remember to use Facebook Insights to track the performance of your content. This will help you understand how your different content pieces are performing in terms of engagement, which is the key ranking metric. 

Facebook also offers a variety of tools designed to help you measure both organic content and paid ads. Choose the best tools for your brand, and track performance regularly. Learn from your own Insights data and the tools you use, and optimize your content from there.

Final Takeaway

 
The Facebook algorithm is sophisticated and constantly evolving. There are few shortcuts and no way to “hack” it. But the steps outlined in this article can help make the algorithm work for you and help you get your content in front of the Facebook users who need to see it.

Want to work with our team of Facebook experts? Reach out today!

Editor’s Note: This post was originally published by Greg Swan in April 2020 and has been updated for freshness, accuracy, and comprehensiveness.

Source link

Continue Reading

Trending

en_USEnglish