Ta kontakt med oss

SEO

Essential Functions For SEO Data Analysis

Publicerad

Essential Functions For SEO Data Analysis

Learning to code, whether with PythonJavaScript, or another programming language, has a whole host of benefits, including the ability to work with larger datasets and automate repetitive tasks.

But despite the benefits, many SEO professionals are yet to make the transition – and I completely understand why! It isn’t an essential skill for SEO, and we’re all busy people.

If you’re pressed for time, and you already know how to accomplish a task within Excel or Google Sheets, then changing tack can feel like reinventing the wheel.

When I first started coding, I initially only used Python for tasks that I couldn’t accomplish in Excel – and it’s taken several years to get to the point where it’s my defacto choice for data processing.

Looking back, I’m incredibly glad that I persisted, but at times it was a frustrating experience, with many an hour spent scanning threads on Stack Overflow.

This post is designed to spare other SEO pros the same fate.

Within it, we’ll cover the Python equivalents of the most commonly used Excel formulas and features for SEO data analysis – all of which are available within a Google Colab notebook linked in the summary.

Specifically, you’ll learn the equivalents of:

  • LEN.
  • Drop Duplicates.
  • Text to Columns.
  • SEARCH/FIND.
  • CONCATENATE.
  • Find and Replace.
  • LEFT/MID/RIGHT.
  • IF.
  • IFS.
  • VLOOKUP.
  • COUNTIF/SUMIF/AVERAGEIF.
  • Pivot Tables.

Amazingly, to accomplish all of this, we’ll primarily be using a singular library – Pandas – with a little help in places from its big brother, NumPy.

Prerequisites

For the sake of brevity, there are a few things we won’t be covering today, including:

  • Installing Python.
  • Basic Pandas, like importing CSVs, filtering, and previewing dataframes.

If you’re unsure about any of this, then Hamlet’s guide on Python data analysis for SEO is the perfect primer.

Now, without further ado, let’s jump in.

LEN

LEN provides a count of the number of characters within a string of text.

For SEO specifically, a common use case is to measure the length of title tags or meta descriptions to determine whether they’ll be truncated in search results.

Within Excel, if we wanted to count the second cell of column A, we’d enter:

=LEN(A2)
Screenshot from Microsoft Excel, November 2022

Python isn’t too dissimilar, as we can rely on the inbuilt len function, which can be combined with Pandas’ loc[] to access a specific row of data within a column:

len(df['Title'].loc[0])

In this example, we’re getting the length of the first row in the “Title” column of our dataframe.

len function python
Screenshot of VS Code, November, 2022

Finding the length of a cell isn’t that useful for SEO, though. Normally, we’d want to apply a function to an entire column!

In Excel, this would be achieved by selecting the formula cell on the bottom right-hand corner and either dragging it down or double-clicking.

When working with a Pandas dataframe, we can use str.len to calculate the length of rows within a series, then store the results in a new column:

df['Length'] = df['Title'].str.len()

Str.len is a ‘vectorized’ operation, which is designed to be applied simultaneously to a series of values. We’ll use these operations extensively throughout this article, as they almost universally end up being faster than a loop.

Another common application of LEN is to combine it with SUBSTITUTE to count the number of words in a cell:

=LEN(TRIM(A2))-LEN(SUBSTITUTE(A2," ",""))+1

In Pandas, we can achieve this by combining the str.split and str.len functions together:

df['No. Words'] = df['Title'].str.split().str.len()

We’ll cover str.split in more detail later, but essentially, what we’re doing is splitting our data based upon whitespaces within the string, then counting the number of component parts.

word count PythonScreenshot from VS Code, November 2022

Dropping Duplicates

Excel’s ‘Remove Duplicates’ feature provides an easy way to remove duplicate values within a dataset, either by deleting entirely duplicate rows (when all columns are selected) or removing rows with the same values in specific columns.

Excel drop duplicatesScreenshot from Microsoft Excel, November 2022

In Pandas, this functionality is provided by drop_duplicates.

To drop duplicate rows within a dataframe type:

df.drop_duplicates(inplace=True)

To drop rows based on duplicates within a singular column, include the subset parameter:

df.drop_duplicates(subset="column", inplace=True)

Or specify multiple columns within a list:

df.drop_duplicates(subset=['column','column2'], inplace=True)

One addition above that’s worth calling out is the presence of the inplace parameter. Including inplace=True allows us to overwrite our existing dataframe without needing to create a new one.

There are, of course, times when we want to preserve our raw data. In this case, we can assign our deduped dataframe to a different variable:

df2 = df.drop_duplicates(subset="column")

Text To Columns

Another everyday essential, the ‘text to columns’ feature can be used to split a text string based on a delimiter, such as a slash, comma, or whitespace.

As an example, splitting a URL into its domain and individual subfolders.

Excel drop duplicatesScreenshot from Microsoft Excel, November 2022

When dealing with a dataframe, we can use the str.split function, which creates a list for each entry within a series. This can be converted into multiple columns by setting the expand parameter to True:

df['URL'].str.split(pat="/", expand=True)
str split PythonScreenshot from VS Code, November 2022

As is often the case, our URLs in the image above have been broken up into inconsistent columns, because they don’t feature the same number of folders.

This can make things tricky when we want to save our data within an existing dataframe.

Specifying the n parameter limits the number of splits, allowing us to create a specific number of columns:

df[['Domain', 'Folder1', 'Folder2', 'Folder3']] = df['URL'].str.split(pat="/", expand=True, n=3)

Another option is to use pop to remove your column from the dataframe, perform the split, and then re-add it with the join function:

df = df.join(df.pop('Split').str.split(pat="/", expand=True))

Duplicating the URL to a new column before the split allows us to preserve the full URL. We can then rename the new columns:🐆

df['Split'] = df['URL']

df = df.join(df.pop('Split').str.split(pat="/", expand=True))

df.rename(columns = {0:'Domain', 1:'Folder1', 2:'Folder2', 3:'Folder3', 4:'Parameter'}, inplace=True)
Split pop join functions PythonScreenshot from VS Code, November 2022

CONCATENATE

The CONCAT function allows users to combine multiple strings of text, such as when generating a list of keywords by adding different modifiers.

In this case, we’re adding “mens” and whitespace to column A’s list of product types:

=CONCAT($F$1," ",A2)
concat Excel
Screenshot from Microsoft Excel, November 2022

Assuming we’re dealing with strings, the same can be achieved in Python using the arithmetic operator:

df['Combined] = 'mens' + ' ' + df['Keyword']

Or specify multiple columns of data:

df['Combined'] = df['Subdomain'] + df['URL']
concat PythonScreenshot from VS Code, November 2022

Pandas has a dedicated concat function, but this is more useful when trying to combine multiple dataframes with the same columns.

For instance, if we had multiple exports from our favorite link analysis tool:

df = pd.read_csv('data.csv')
df2 = pd.read_csv('data2.csv')
df3 = pd.read_csv('data3.csv')

dflist = [df, df2, df3]

df = pd.concat(dflist, ignore_index=True)

SEARCH/FIND

The SEARCH and FIND formulas provide a way of locating a substring within a text string.

These commands are commonly combined with ISNUMBER to create a Boolean column that helps filter down a dataset, which can be extremely helpful when performing tasks like log file analysis, as explained in this guide. E.g.:

=ISNUMBER(SEARCH("searchthis",A2)
isnumber search ExcelScreenshot from Microsoft Excel, November 2022

The difference between SEARCH and FIND is that find is case-sensitive.

The equivalent Pandas function, str.contains, is case-sensitive by default:

df['Journal'] = df['URL'].str.contains('engine', na=False)

Case insensitivity can be enabled by setting the case parameter to False:

df['Journal'] = df['URL'].str.contains('engine', case=False, na=False)

In either scenario, including na=False will prevent null values from being returned within the Boolean column.

One massive advantage of using Pandas here is that, unlike Excel, regex is natively supported by this function – as it is in Google sheets via REGEXMATCH.

Chain together multiple substrings by using the pipe character, also known as the OR operator:

df['Journal'] = df['URL'].str.contains('engine|search', na=False)

Find And Replace

Excel’s “Find and Replace” feature provides an easy way to individually or bulk replace one substring with another.

find replace ExcelScreenshot from Microsoft Excel, November 2022

When processing data for SEO, we’re most likely to select an entire column and “Replace All.”

The SUBSTITUTE formula provides another option here and is useful if you don’t want to overwrite the existing column.

As an example, we can change the protocol of a URL from HTTP to HTTPS, or remove it by replacing it with nothing.

When working with dataframes in Python, we can use str.replace:

df['URL'] = df['URL'].str.replace('http://', 'https://')

Or:

df['URL'] = df['URL'].str.replace('http://', '') # replace with nothing

Again, unlike Excel, regex can be used – like with Google Sheets’ REGEXREPLACE:

df['URL'] = df['URL'].str.replace('http://|https://', '')

Alternatively, if you want to replace multiple substrings with different values, you can use Python’s replace method and provide a list.

This prevents you from having to chain multiple str.replace functions:

df['URL'] = df['URL'].replace(['http://', ' https://'], ['https://www.', 'https://www.’], regex=True)

LEFT/MID/RIGHT

Extracting a substring within Excel requires the usage of the LEFT, MID, or RIGHT functions, depending on where the substring is located within a cell.

Let’s say we want to extract the root domain and subdomain from a URL:

=MID(A2,FIND(":",A2,4)+3,FIND("/",A2,9)-FIND(":",A2,4)-3)
left mid right ExcelScreenshot from Microsoft Excel, November 2022

Using a combination of MID and multiple FIND functions, this formula is ugly, to say the least – and things get a lot worse for more complex extractions.

Again, Google Sheets does this better than Excel, because it has REGEXEXTRACT.

What a shame that when you feed it larger datasets, it melts faster than a Babybel on a hot radiator.

Thankfully, Pandas offers str.extract, which works in a similar way:

df['Domain'] = df['URL'].str.extract('.*://?([^/]+)')
str extract PythonScreenshot from VS Code, November 2022

Combine with fillna to prevent null values, as you would in Excel with IFERROR:

df['Domain'] = df['URL'].str.extract('.*://?([^/]+)').fillna('-')

If

IF statements allow you to return different values, depending on whether or not a condition is met.

To illustrate, suppose that we want to create a label for keywords that are ranking within the top three positions.

Excel IFScreenshot from Microsoft Excel, November 2022

Rather than using Pandas in this instance, we can lean on NumPy and the where function (remember to import NumPy, if you haven’t already):

df['Top 3'] = np.where(df['Position'] <= 3, 'Top 3', 'Not Top 3')

Multiple conditions can be used for the same evaluation by using the AND/OR operators, and enclosing the individual criteria within round brackets:

df['Top 3'] = np.where((df['Position'] <= 3) & (df['Position'] != 0), 'Top 3', 'Not Top 3')

In the above, we’re returning “Top 3” for any keywords with a ranking less than or equal to three, excluding any keywords ranking in position zero.

IFS

Sometimes, rather than specifying multiple conditions for the same evaluation, you may want multiple conditions that return different values.

In this case, the best solution is using IFS:

=IFS(B2<=3,"Top 3",B2<=10,"Top 10",B2<=20,"Top 20")
IFS ExcelScreenshot from Microsoft Excel, November 2022

Again, NumPy provides us with the best solution when working with dataframes, via its select function.

With select, we can create a list of conditions, choices, and an optional value for when all of the conditions are false:

conditions = [df['Position'] <= 3, df['Position'] <= 10, df['Position'] <=20]

choices = ['Top 3', 'Top 10', 'Top 20']

df['Rank'] = np.select(conditions, choices, 'Not Top 20')

It’s also possible to have multiple conditions for each of the evaluations.

Let’s say we’re working with an ecommerce retailer with product listing pages (PLPs) and product display pages (PDPs), and we want to label the type of branded pages ranking within the top 10 results.

The easiest solution here is to look for specific URL patterns, such as a subfolder or extension, but what if competitors have similar patterns?

In this scenario, we could do something like this:

conditions = [(df['URL'].str.contains('/category/')) & (df['Brand Rank'] > 0),
(df['URL'].str.contains('/product/')) & (df['Brand Rank'] > 0),
(~df['URL'].str.contains('/product/')) & (~df['URL'].str.contains('/category/')) & (df['Brand Rank'] > 0)]

choices = ['PLP', 'PDP', 'Other']

df['Brand Page Type'] = np.select(conditions, choices, None)

Above, we’re using str.contains to evaluate whether or not a URL in the top 10 matches our brand’s pattern, then using the “Brand Rank” column to exclude any competitors.

In this example, the tilde sign (~) indicates a negative match. In other words, we’re saying we want every brand URL that doesn’t match the pattern for a “PDP” or “PLP” to match the criteria for ‘Other.’

Lastly, None is included because we want non-brand results to return a null value.

np select PythonScreenshot from VS Code, November 2022

VLOOKUP

VLOOKUP is an essential tool for joining together two distinct datasets on a common column.

In this case, adding the URLs within column N to the keyword, position, and search volume data in columns A-C, using the shared “Keyword” column:

=VLOOKUP(A2,M:N,2,FALSE)
vlookup ExcelScreenshot from Microsoft Excel, November 2022

To do something similar with Pandas, we can use merge.

Replicating the functionality of an SQL join, merge is an incredibly powerful function that supports a variety of different join types.

For our purposes, we want to use a left join, which will maintain our first dataframe and only merge in matching values from our second dataframe:

mergeddf = df.merge(df2, how='left', on='Keyword')

One added advantage of performing a merge over a VLOOKUP, is that you don’t have to have the shared data in the first column of the second dataset, as with the newer XLOOKUP.

It will also pull in multiple rows of data rather than the first match in finds.

One common issue when using the function is for unwanted columns to be duplicated. This occurs when multiple shared columns exist, but you attempt to match using one.

To prevent this – and improve the accuracy of your matches – you can specify a list of columns:

mergeddf = df.merge(df2, how='left', on=['Keyword', 'Search Volume'])

In certain scenarios, you may actively want these columns to be included. For instance, when attempting to merge multiple monthly ranking reports:

mergeddf = df.merge(df2, on='Keyword', how='left', suffixes=('', '_october'))
    .merge(df3, on='Keyword', how='left', suffixes=('', '_september'))

The above code snippet executes two merges to join together three dataframes with the same columns – which are our rankings for November, October, and September.

By labeling the months within the suffix parameters, we end up with a much cleaner dataframe that clearly displays the month, as opposed to the defaults of _x and _y seen in the earlier example.

multi merge PythonScreenshot from VS Code, November 2022

COUNTIF/SUMIF/AVERAGEIF

In Excel, if you want to perform a statistical function based on a condition, you’re likely to use either COUNTIF, SUMIF, or AVERAGEIF.

Commonly, COUNTIF is used to determine how many times a specific string appears within a dataset, such as a URL.

We can accomplish this by declaring the ‘URL’ column as our range, then the URL within an individual cell as our criteria:

=COUNTIF(D:D,D2)
Excel countifScreenshot from Microsoft Excel, November 2022

In Pandas, we can achieve the same outcome by using the groupby function:

df.groupby('URL')['URL'].count()
Python groupbyScreenshot from VS Code, November 2022

Here, the column declared within the round brackets indicates the individual groups, and the column listed in the square brackets is where the aggregation (i.e., the count) is performed.

The output we’re receiving isn’t perfect for this use case, though, because it’s consolidated the data.

Typically, when using Excel, we’d have the URL count inline within our dataset. Then we can use it to filter to the most frequently listed URLs.

To do this, use transform and store the output in a column:

df['URL Count'] = df.groupby('URL')['URL'].transform('count')
Python groupby transformScreenshot from VS Code, November 2022

You can also apply custom functions to groups of data by using a lambda (anonymous) function:

df['Google Count'] = df.groupby(['URL'])['URL'].transform(lambda x: x[x.str.contains('google')].count())

In our examples so far, we’ve been using the same column for our grouping and aggregations, but we don’t have to. Similarly to COUNTIFS/SUMIFS/AVERAGEIFS in Excel, it’s possible to group using one column, then apply our statistical function to another.

Going back to the earlier search engine results page (SERP) example, we may want to count all ranking PDPs on a per-keyword basis and return this number alongside our existing data:

df['PDP Count'] = df.groupby(['Keyword'])['URL'].transform(lambda x: x[x.str.contains('/product/|/prd/|/pd/')].count())
Python groupby countifsScreenshot from VS Code, November 2022

Which in Excel parlance, would look something like this:

=SUM(COUNTIFS(A:A,[@Keyword],D:D,{"*/product/*","*/prd/*","*/pd/*"}))

Pivot Tables

Last, but by no means least, it’s time to talk pivot tables.

In Excel, a pivot table is likely to be our first port of call if we want to summarise a large dataset.

For instance, when working with ranking data, we may want to identify which URLs appear most frequently, and their average ranking position.

pivot table ExcelScreenshot from Microsoft Excel, November 2022

Again, Pandas has its own pivot tables equivalent – but if all you want is a count of unique values within a column, this can be accomplished using the value_counts function:

count = df['URL'].value_counts()

Using groupby is also an option.

Earlier in the article, performing a groupby that aggregated our data wasn’t what we wanted – but it’s precisely what’s required here:

grouped = df.groupby('URL').agg(
     url_frequency=('Keyword', 'count'),
     avg_position=('Position', 'mean'),
     )

grouped.reset_index(inplace=True)
groupby-pivot PythonScreenshot from VS Code, November 2022

Two aggregate functions have been applied in the example above, but this could easily be expanded upon, and 13 different types are available.

There are, of course, times when we do want to use pivot_table, such as when performing multi-dimensional operations.

To illustrate what this means, let’s reuse the ranking groupings we made using conditional statements and attempt to display the number of times a URL ranks within each group.

ranking_groupings = df.groupby(['URL', 'Grouping']).agg(
     url_frequency=('Keyword', 'count'),
     )
python groupby groupingScreenshot from VS Code, November 2022

This isn’t the best format to use, as multiple rows have been created for each URL.

Instead, we can use pivot_table, which will display the data in different columns:

pivot = pd.pivot_table(df,
index=['URL'],
columns=['Grouping'],
aggfunc="size",
fill_value=0,
)
pivot table PythonScreenshot from VS Code, November 2022

Final Thoughts

Whether you’re looking for inspiration to start learning Python, or are already leveraging it in your SEO workflows, I hope that the above examples help you along on your journey.

As promised, you can find a Google Colab notebook with all of the code snippets here.

In truth, we’ve barely scratched the surface of what’s possible, but understanding the basics of Python data analysis will give you a solid base upon which to build.

Fler resurser:


Featured Image: mapo_japan/Shutterstock



Källlänk

Klicka för att kommentera

Lämna ett svar

Din e-postadress kommer inte publiceras. Obligatoriska fält är märkta *

SEO

An In-Depth Guide For Beginners

Publicerad

An In-Depth Guide For Beginners

Every month, 2.98 billion people around the globe open up their laptops or smart devices and navigate their way to Facebook.

That’s roughly a quarter of everyone in the world, visiting the same social media platform, every single day.

Mark Zuckerberg likely didn’t imagine such astounding reach in his wildest dreams when he launched the first iteration of what would become the world’s most popular social networking site in 2003.

These days, nearly everyone uses Facebook, and it’s become as much a part of daily life as watching television.

For marketers, this means a massive opportunity to reach and engage with new audiences.

But you can’t just set up a company page and hope to attract millions of followers. You need a plan to capitalize on these opportunities and make the maximum impact.

If you’re a Facebook marketing beginner, this may sound like a daunting task, but don’t worry – it’s easier than you think.

Continue reading for an in-depth guide to Facebook marketing that you can use to get started right away.

What Is Facebook Marketing?

Facebook marketing is the process of using the social media platform to promote your business to potential buyers.

There are a variety of ways to do this, both paid and organic.

Paid Facebook marketing means using advertising campaigns within the platform to target people on the site and ideally, convert them into customers.

Organic marketing on Facebook occurs when you post content that your targets will find valuable, with the goal of increasing your following and engaging with your audience.

Why You Should Be Marketing On Facebook

If nearly 2 billion potential customers using Facebook didn’t entice you to create your own business profile, maybe this will: There are currently more than 200 million businesses already using Facebook’s free tools and apps.

And, of those, more than 3 million are actively advertising on the platform.

That means there’s a good chance your competition is already using this social media site to grow their business.

And if they’re not, jumping on board now will give you a serious edge over them.

So, with no further ado, let’s get started.

How To Set Up Facebook For Business

The very first thing you need to do to launch your marketing efforts on Facebook is to create a page for your business.

It’s free to set up and gives you a place for people to like or follow you. It also gives you a chance to engage with your customers (and potential customers), and share content with them via posts.

In your web browser, go to facebook.com/pages/create and select the category that best describes your organization. For most people, that’s going to be “Business or Brand.”

You’ll then be directed to a page where you can enter your brand’s name, select the category your business falls under, and add bio information.

If you’re a bit stuck on what to include in your bio, don’t worry – you can always change it later.

You’ll also have an opportunity to add a logo and cover image – again, don’t worry, these can be changed.

Next, you’ll be able to claim your unique URL, which will likely be something along the lines of facebook.com/TheNameOfYourBusiness.

The next step is an important one: editing your page info.

Make sure you provide all relevant details including your address, service hours, and other details customers and prospects might be looking for.

Congratulations – you’ve just created your Facebook business page. Now, it’s time to figure out how to use it for marketing.

How To Build A Facebook Marketing Strategy

As you probably already know, Facebook makes its money via advertising revenue. As such, it has made it simple for even the most technologically inept person to use it for marketing.

And this includes offering free information on how to create your own social media strategy.

You can read that helpful guide at your leisure, but for now, let’s break it down into eight steps:

  • Set your goals – What do you hope to accomplish via Facebook marketing? Facebook has three marketing objectives: awareness, consideration, and conversion.
  • Identify your audience – How old are they? Where do they live? What is their level of education? How can your offering solve their problem? Facebook lets your market with remarkable precision, so the more information you have on your targets, the better.
  • Plan your content – Decide what kind of things you’ll post. It could be industry news, behind-the-scenes pictures, or promotions – get as creative as you like. Just make sure you’re planning content your audience will like.
  • Create a content calendar – Decide when you will post specific pieces of content. Be as accurate as you can, right down to publishing time, because there will likely be times when your audience is more active.
  • Create your content – It’s time to put step three into action and create engaging pieces. Read this article for tips on keeping your content interesting and relevant.
  • Explore Facebook’s free tools – Facebook has several options for sharing content, including text, image, and video posts, as well as Stories and live streams.
  • Determine how you will use ads – You have multiple options for advertising on Facebook. We’ll go into them in more detail in the next section so you can choose what’s right for your needs.
  • Add the Facebook Pixel to your website – Don’t forget to add the tracking code to your website to collect data, enable retargeting, and track conversions.

Types Of Facebook Posts For Marketing

Facebook offers incredible flexibility when it comes to marketing, with numerous post and paid ad options.

Let’s first dive into the posts.

Facebook Marketing Post Types

The type of post you use when marketing on Facebook will depend on what you’re hoping to accomplish. Some of the more popular are:

  • Text posts or status updates – these are a great way to initiate conversations, share information, and educate your followers.
  • Photo posts – A great way to capture attention, images are useful for attracting new customers.
  • Video posts – Videos are a great way to engage with your audience and encourage interaction.
  • Facebook Live – Use the platform’s live streaming capabilities for product demonstrations, answering questions, or interacting with your followers.
  • Link posts – Use posts with direct links to your external website or blog. They include an automatic preview.
  • Stories – Just like Instagram Stories, Facebook Stories are great for building engagement without disrupting your followers’ feeds.
  • Pinned posts – Stuck at the top of your page, these are great for maximizing the reach of top-performing posts or relaying critical information, promotions, or events.

Once you have your business page set up and you’ve begun sharing content, the next phase of Facebook marketing is to venture into paid ads.

Facebook Ad Types

At the moment, there are four main types of ads on the platform:

Image Ads

Screenshot from Facebook, January 2023

These are static ads in JPG or PNG format. They should include a headline of up to 40 characters and the main text of 125 characters.

You also have a link description area which should be used for a clear and succinct CTA.

Image ads are easy to set up and work well for driving traffic to your website.

For a list of best practices for this ad format, click here.

Video Ads

Facebook Marketing: An In-Depth Guide For BeginnersScreenshot from Facebook, January 2023

Facebook video ads are a great way to boost your brand and don’t require expensive recording equipment or software. You can record these spots using your phone and there are a number of free editing apps that can help you.

Video ads can be placed in-stream (the short commercials that are shown before a video your target wants to watch), in-feed, or in Stories.

As a general rule of thumb, they should be under two minutes long and have an attention grabber within the first three seconds.

For more video best practices, click here.

Carousel Ads

Facebook Marketing: An In-Depth Guide For BeginnersScreenshot from Facebook, January 2923

Carousel ads combine multiple videos and images into a single ad, which is a great way to improve your chances of conversion.

They tend to work best for ecommerce brands, as they allow you to showcase multiple products or angles of a single product in one ad.

Ideally, these should point to a purpose-built landing page.

Here are some other best practices offered by Meta.

Collection Ads

Facebook Marketing: An In-Depth Guide For BeginnersScreenshot from Facebook, January 2023

Collection ads are another way for e-commerce brands to showcase products but are more similar to image ads than carousels.

You are restricted to a 40-character headline and a 125-character primary text.

Read about collection ads best practices here.

Which Goal Should I Focus on For Facebook Marketing?

The type of marketing that will work best for your brand depends on your goals.

As was mentioned previously, Facebook has three objectives that correspond with the top, middle, and bottom of the sales funnel, respectively:

Awareness

Facebook has two awareness objectives to help you expand your reach and generate interest:

  • Brand awareness – Used to entice a new audience or keep your brand top of mind. This usually results in little audience action.
  • Reach – Designed to reach as many people as possible within your ad budget.

Consideration

Consideration lets you choose from six objectives:

  • Traffic – Choose this objective when you want to increase the number of visitors to your external website.
  • Engagement – This is used to encourage people to like and comment on your posts, or respond to event invitations.
  • App promotion – Used to drive downloads of your app in Google Play or the App Store.
  • Video views – If you’re showcasing your brand or highlighting a unique value proposition (UVP). It’s also a good way to lay the groundwork for future retargeting.
  • Lead generation – Collect information about your customers and add them to your sales funnel.
  • Messages – Use this when you’re seeking to start conversations around your brand.

Conversions

Conversions lets you choose from three objectives:

  • Conversions – This could be making a purchase, signing up for a newsletter, or taking any other action.
  • Catalog sales – By connecting your e-commerce store with Facebook Ads, you can promote products from your catalog.
  • Store traffic – Use this to drive traffic to your physical location by targeting nearby potential customers.

Once you have determined your objectives, you can determine which format will work best to help you accomplish your goals.

From here, you’ll need to determine your budget and schedule. You can opt for either a daily or monthly budget, with the option for an end date for time-sensitive promotions.

Next, you’ll choose your audience – a process we’ll dive into in the next section – and select your placements.

If you’ve never placed ads on Facebook before, you will probably be best served by selecting Automatic Placements, which will allow the social media platform to determine where you’re likely to get the best results.

If you know what you’re doing, you can customize your placement and select things like device type and operating system.

When Not To Use Facebook Ads

There’s no question that running Facebook ad campaigns can be extremely beneficial. But it’s not a magical sales multiplier.

In fact, in some situations, it can be a complete waste of money – and Facebook Ads can be quite costly.

Here are some situations when you should not use Facebook Ads:

  • You’re unclear on your targeting – Nothing will blow through your ad spend faster, and with less to show for it, than going after the wrong demographic.
  • You’re not using your metrics – As with every marketing campaign, your Facebook Ads should be subject to measurement and A/B testing to find the optimal placement and format.
  • You don’t have anything worth sharing – To get engagement, your ads need to be compelling. It could be a unique product, a special event, or a sale, but people need a reason to click your ads.
  • Your landing page and ad are disconnected – If you’re promising one thing in your Facebook Ad and then delivering something different on your website, people will not follow through with your CTA.

Using Facebook Analytics

Facebook’s biggest value to marketers lies in its analytics capabilities via Facebook Insights.

To access it, go to your Page Manager and click on Insights.

You’ll be presented with quite a lot of data, created using a default range of 28 days. You can change this as needed.

The first thing you’ll likely want to check is the Overview tab, which will tell you how your page is performing. This gives you key metrics about your page and your most recent posts, and compares you to similar pages.

Use the Likes tab to see the averages, growth, and source of your likes to help you understand how your page is performing.

The Reach tab tracks how many people have seen your posts, their reactions, comments, and shares, as well as how many have hidden them or reported them as spam.

Page views help you identify where your traffic is coming from and how many views your posts are receiving.

Under the Actions of Page tab, you’ll get a report of what actions visitors took on your Facebook page, as well as demographic information on the people who clicked your phone number or website or took another action.

There are also separate tabs to tell you how your posts, events, and videos are performing on the platform.

The People tab gives you information about who saw and engaged with your posts or page. It gives you data on your fans, as well as reach and engagement numbers.

The Messages tab tracks Messenger analytics, including response time, while Promotions gives you an overview of recent sales and promotions.

Branded Content lists your mentions from Verified Pages (those with a blue checkmark).

Finally, there’s the Local tab, which while not relevant for strictly online businesses, is extremely valuable for any company with a physical location.

It gives you information about the foot traffic in your area, as well as demographic information about these people and the number of people nearby who saw your ads.

How To Create Great Facebook Campaigns

There is no question that Facebook can be an excellent marketing tool for virtually any organization.

But if you don’t pay attention to what you’re doing, it can also be an easy way to blow through your advertising budget in no time.

To ensure your Facebook marketing campaigns give you the biggest bang for your buck, here are some key takeaways to keep in mind:

  • Identify your audience and write to it – Keep your posts only as long as is required to persuade a target. Keep your ads within specified limits. Keep your CTAs short and to the point.
  • Don’t take a “one-size-fits-all” approach – Facebook allows you incredible targeting options. Use them. Highly targeted ads are going to perform much better than those that take a scattergun approach.
  • Have a good offer – Even the best copy and image can’t overcome a bad offer. Make sure you’re providing something people want.
  • Connect your visuals with your copy – Copy should reinforce your images and videos and vice versa. Make sure yours does.
  • Refine your strategy – You’re not going to get everything perfect for your first, second, or even hundredth Facebook campaign. In fact, there are no perfect campaigns. That means you should always be working on your strategy and content, striving to find something better.

Fler resurser:


Featured Image: Production Perig/Shutterstock



Källlänk

Fortsätt läsa

SEO

7 Essential Tips & Tricks You Might Not Know

Publicerad

7 Essential Tips & Tricks You Might Not Know

It may not look like one of the fancy, paid SEO tools you’re used to logging into, but Excel remains one of the most versatile and powerful tools in an SEO professional’s toolbox.

You can use Excel to track and analyze key metrics such as rankings, website traffic, and backlinks.

Use it to create and update meta tags, track and analyze competitors’ SEO strategies and performance, build automated reports, and take care of many of the data tasks you’ll encounter every day.

Combine your Excel knowledge with Python, Tableau, R, and other tools, and there is nothing you can’t do.

If you’ve never worked with data before, you’ll find Excel has a bit of a learning curve, but you can use it right from the start. And it’s flexible enough to scale and grow as your site grows.

Why Excel For SEO Tasks?

While many paid tools can help you do the same tasks, Excel is a fantastic option to enhance, combine, or replace those tools.

  • It’s affordable and comes with a range of tools you already use.
  • There are a ton of resources and courses to help you learn.
  • Easily handles large amounts of data.
  • Sorting and de-duplicating – a feature often missing when you need it.
  • Create and manage databases with simple formulas.
  • Data ports easily to other tools and is available for other tasks.
  • Pivot tables and smart charts.

1. Combine Multiple Data Sources

You will often find yourself having to merge data from multiple sources.

This is intuitive and quick in Tableau, Python, or R, but you can do the same in Excel using Power Query.

There are a few steps to this process, but it’s not as complicated as you might think – even if you are new to working with data or Excel.

Power Query has automated and simplified tasks that required a lot of time and skill.

And it is probably THE best Excel feature for business and SEO professionals.

Seem a bit daunting? Don’t worry. There are several courses and tutorials on YouTube to get you started.

What It’s Good For:

  • Building reports.
  • Analytics and sales data.
  • Combining data sources to identify opportunities and gain insights.

2. Data Cleaning

Much of your time is lost simply preparing data for analysis. It doesn’t have to be that way.

Large lists are often larger than they need to be. Finding and manually removing all the duplicates, however, can be a serious pain.

Excel can do this instantly for you. Simply go to the “Data” tab and click “Remove Duplicates.”

Screenshot from Excel, January 2023.

Unwanted spaces and blank lines tend to cause havoc with many tasks, formulas, and statistics.

Excel will remove them for you simply by going to Edit > Find > Go To. Select “Special,” “Blanks,” and tell Excel how it should handle them.

“Convert text to columns” can be a lifesaver, especially if you’ve received data where the addresses or names are all in the same cell or you need to extract domains from email addresses.

Go to Data > Text to Columns. Then, indicate what to use for Delimiters (comma or space) and preview the results. When you’re ready, click “Next,” choose a destination, and click “Finish.”

When To Use It:

  • Data analysis.
  • Data processing.
  • Processing and cleaning lead databases.
  • Working with any data.

 3. Power Excel With Add-On Tools

Some of the more complex tasks, such as crawling, require a bit of coding knowledge.

If you don’t have that in your skillset, however, there are tools you can download, integrate with other tools, and add on.

Power Excel With Add-On ToolsScreenshot from SEOTools, January 2023.

SEOTools offers off and on-page SEO tools, integrations, connectors, spiders, and several other tools that make it easy to customize your Excel and create custom projects.

SEOGadget brings the power of Moz, Grepwords, and Majestic to Excel.

Analysis ToolPak is for serious data analysis. This add-on improves and automates in-depth statistics, perfect for forecasting, trending, regression analysis, and more complex data analysis tasks you might otherwise perform in R or Python.

When To Use It:

  • Reporting.
  • Regular data analysis.
  • Presentations.
  • Integrating and coordinating with other teams.

4. Infographics And Charts

Data is useless if you can’t understand it.

In fact, data visualization and storytelling are likely some of the most important skills you can have. This is where tools like Power Query and PivotTables come in.

Built right into Excel, pivot tables are the other valuable tools you have for this purpose.

However, instead of just creating a straight pivot table and a related chart, save yourself some steps by creating a master “template” first that you can then replicate as needed and adjust to suit your needs.

Excel pivot tables for reportingScreenshot from Excel, January 2023.

In many instances, however, you will need to work with dates or segments of the data. For that, you’ll want to enter splicers and timelines.

  • To splice data into segments: Select the pivot table and go to PivotTable Tools > Analyze > Filter > Insert Slicer. Then, simply input how you would like to segment the content (e.g., by product or topic).
  • To utilize timelines: Click the pivot table’s tools option, go to Analyze > Filter > Insert Timeline. Once there, you can choose what you’d like to use, style it, add captions, and more.

If you’ve never used Excel’s PivotTables before, a short tutorial will have you on your way to analyzing data in no time.

Still want a little more? Make your reports, social media, and updates even better by upping your data visualization game with add-ons like People Graph.

When To Use It:

  • Reporting.
  • Daily updates.
  • Surface data analysis.
  • Team collaboration and integration.

5. Automate Common Tasks With Macros

SEO, particularly agency SEO, is full of repetitive tasks like weekly reporting that consume much of your time. Excel’s macros are the answer. And they’re really easy to use.

Under the “View” tab, click “Macros” and “Record Macro.”

Automate Common Tasks With MacrosScreenshot from Excel, January 2023.

Fill out the details.

The macro is now recording. So, simply walk through the steps that you’d like to automate. And when you’re done, go back to the ribbon and stop the recording.

When you’re ready to run the automation, go to the macro button in the ribbon, click “View Macros,” and select the desired macro from the list.

If you have some macros that you use more often than others, you can add them to the Quick Access Toolbar.

When To Use It:

  • Sorting.
  • Calculations.
  • Reformatting data.
  • Setting up new site documents or new pages for reports.

6. Easily Import Feeds And Data Into Excel

If you use Google Alerts or publish frequently, automatically importing feeds into Excel can be a huge time saver.

To start, simply grab the RSS feed address. (Or, create an alert for Google Alerts and have them delivered as an RSS feed.)

Importing rss feeds into google sheets for excelScreenshot from Google Sheets, January 2023.

Then, go to Google Sheets and use the IMPORTFEED function to bring the updates straight into a spreadsheet.

Alternatively, you can add the information to separate columns.

Importing rss feeds into excel through google sheetsScreenshot from Google Sheets, January 2023.

From here, you can regularly download and import the data into Excel, combine it with other related data, or integrate it into your custom dashboards.

If you need something a little more automatic, use Google Apps Script or one of the add-ons available to automate the process.

Want a little more data behind your reports? You can scrape and import Google Search Results into Excel, too.

7. Backlink Analysis

To analyze backlinks with Excel, collect backlink data with tools such as Ahrefs, Majestic, or Google Search Console.

Then, import it into Excel and use it to analyze your backlinks in a number of ways:

  • Who links to you: Use Excel’s sorting and filtering tools to filter the data and use the IF function: IF(logic, true_value,[false_value]) to sort and identify domains linking to you.
  • What do people link to: Sort and filter to see the anchor text used most often for your backlinks (using frequency/count).
  • When did people link to you: Organize the data by date to see how old your links are and when most of your backlinks were acquired.

Find trends or patterns in your backlink profiles with pivot tables, groups, charts, and graphs by combining your backlink and sales or conversion data.

Highlight specific data based on certain conditions with conditional formatting. This makes it easy to spot backlinks from high-authority websites or backlinks with specific anchor text.

Summary

Many people overlook Excel either because they think it’s too basic to be of much use. Or it looks too intimidating or daunting to learn.

But those of us who use it understand just how powerful it can be and the unlimited possibilities it provides.

Hopefully, these tips will help you craft better strategies, find new opportunities, and tell your story with better reports and dashboards.


Utvald bild: Paulo Bobita/Search Engine Journal



Källlänk

Fortsätt läsa

SEO

12 fantastiska länkbyggande verktyg som är avgörande för din framgång

Publicerad

12 Great Link Building Tools That Are Essential To Your Success

Link-building strategies, along with SEO tools, have certainly changed over the years.

Since the old automated link-building tools that automatically placed content like KontentMachine or GSA’s Search Engine Ranker, modern tools have moved to manual research and outreach platforms.

Tools that many of my link-building colleagues and I use today look more like ones used for public relations (PR) rather than link-building. However, there are still tools specific to link building that aren’t going anywhere.

These can be divided into four categories:

  • Link research.
  • Prospecting and outreach.
  • Reporting.
  • AI-powered tools.

Emerging technologies powered by AI can make the link-building process easier.

Link Research Prospecting And Outreach Reporting AI-Powered Tools
1. Majestic

Excellent for identifying the types of domains you should generate links from.

3. Pitchbox

Combines email outreach with SEO metrics.

8. Agency Analytics

Connects a variety of performance metrics.

10. Link Whisperer

Good for internal linking efforts.

2. Ahrefs

Provides useful reports to analyze trends.

4. BuzzSumo

Use to identify authors and sharers/backlinkers.

9. Cyfe

Customizable but automatic reporting.

11. Postaga

Find opportunities and initiate outreach.

5. Hunter.IO

A browser extension that helps you find contact information.

12. CTRify

WordPress plugin that generates content.

6. BrightLocal

Submit and manage citations.

7. HARO

Link Research Tools

Link research is vital to figuring out what type of sites you should be approaching. This includes establishing quality criteria, categories of sites, authority metrics, and others.

Majestic och Ahrefs are two research tools that provide large databases and robust reporting.

I’ve included both of these sites as I constantly see each having data that the other doesn’t.

You may find some links to your competitors’ sites in Majestic that aren’t listed in Ahrefs and vice versa.

These tools can be used together to build a comprehensive list of sites to analyze. As with many SEO tools, the pricing depends on how many features your team needs.

1. Majestic

  • Pricing: $49.99 per month with one user for the ‘Lite’ package. $99.99 per month for the “Pro” package, which they recommend for SEO agencies and consultants.
  • Payment options: Monthly or receive a discount for an annual subscription.
Screenshot from Majestic, January 2023

Here are some recommendations on using it and what reports should influence your link-building.

  • Topics: This data can be used to identify the types of sites you should be generating links from. Consider running this report on the link profiles for top-ranking sites, then finding sites that fit into similar categories.
  • Referring Domains: Use this to evaluate the number of unique domains you should focus on building for your site. This also offers a look into the trust/citation flow distribution (count of domains by trust/citation flow).

2. Ahrefs

  • Pricing: $99 per month with only one user for the ‘Lite’ plan. $199 per month for the “Standard” plan.
  • Payment options: Monthly or receive a discount for an annual subscription.
Ahrefs toolScreenshot from Ahrefs, January 2023

In contrast to Majestic, Ahrefs has some reports that are much easier to run inside the tool. It certainly costs more, but if you want more data, then Ahrefs is the right choice.

Here are reports to use in Ahrefs over Majestic:

  • Pages > Best by links: Two useful applications of this report are:
    • Identify competitors’ most linked content to influence your content strategies.
    • Identify the type of sites that link to the content you will produce.
  • Pages > Best by link growth: This is a “trend” report providing content that has been generating links over the last 30 days. Find content here that is receiving a rapid number of links and create more robust content.

Prospecting And Outreach Tools

Finding highly relevant sites that may link to your content is the most excruciating part of link building.

You can create a large list of sites and bulk outreach to save time, but when evaluating your link-building success on links gained per hour and the quality of those links, it’s best to handle prospecting manually or in a semi-automated approach.

I’ll go through five tools, Pitchbox, BuzzSumo, Hunter.io, BrightLocal, and HARO.

These tools can be used for the most popular link-building strategies.

3. Pitchbox

  • Pricing: Averages $500+ per month.
  • Payment options: Prices are dependent on an individual walkthrough with Pitchbox.

Pitchbox is one of the pricier tools on the market compared to email tools like MailChimp, but integrated prospecting helps reduce the time to qualify sites.

The prospecting sites list builder and SEO metrics integrated right into the opportunities report make the tool stand out.

PitchboxScreenshot from Pitchbox, January 2023

4. BuzzSumo

  • Pricing: $99 per month for the “Pro” package. $179 per month for the “Plus” package. There’s a pared-down free version with limited searches per month.
  • Payment options: There is also a free version with limited features.

This is an excellent tool for building lists of blogs, influencers, and authors. Out of all the prospecting tools on the list, BuzzSumo has the best filtering options.

You can use the tool for a lot of purposes, but for link building, these are two effective use cases:

  • Identifying authors: The content research and influencers sections provide lists of authors/influencers that are searchable by keywords in the content they shared or produced. One fantastic use for this is to search through the “most shared” report and find influencers that received more than 2,000 shares of their content, then outreach to them to share yours. This can yield a lot of natural links.
  • Identifying sharers/backlinks: The second use goes a layer deeper than the first, finding those that have shared the content. Pull a list of shares or backlinking websites by content, then create similar but better content.
Buzzsumo platformScreenshot from Buzzsumo, January 2023

5. Hunter.io

  • Pricing: Starts at free. The first two upgraded packages are $49 per month and $99 per month.
  • Payment options: Free for 25 monthly searches up to $399 per month for 30,000 searches.

This browser extension finds email addresses for easy contact options.

It helps cut down on time spent sifting through About pages. You can also take it a step further and use the tool for outreach.

Hunter.ioScreenshot from Hunter.io, January 2023

6. BrightLocal

  • Pricing: $29-$79 per month, depending on package size.
  • Payment options: You can also pay for the citation builder, reviews, or enterprise.

Citation building is important for local SEO and should be considered a link-building project.

One of the tools with the best value for submitting and managing citations is BrightLocal.

There are two components: citation monitoring and citation building. The tool also allows you to figure out how you’re ranking based on the local competition.

BrightLocalScreenshot from BightLocal, January 2023

7. HARO

  • Pricing: Starts at free. The first paid plan is $19 per month, which adds alerts and search functionality.
  • Payment options: The free options offer media options delivered to your email three times a day and up to $149/month for premium.

While this tool is traditionally used in the journalism world, it can also help link builders. It connects you with credible sources and allows you to build natural backlinks.

HAROScreenshot from HARO, January 2023

Reporting Tools

Although many of the tools in the previous section have reporting functionality built in, I’ve found them lacking in custom reporting or the ability to associate links to ranking performance.

These tools solve that issue; AgencyAnalytics och Cyfe.

8. Agency Analytics

  • Pricing: $12 per month, per campaign. $18 per month per campaign for custom reporting features.
  • Payment options: Pay annually to save money.

Agency Analytics automatically populates the dashboard with data from Moz and Majestic and connects that data to critical performance metrics, like ranking and organic traffic.

Qualified traffic that converts to leads or sales is the purpose of link-building and SEO efforts, so reporting needs to make a connection between them.

Agency AnalyticsScreenshot from Agency Analytics, January 2023

9. Cyfe

  • Pricing: $19 per month for one user, with higher tiers for more users.
  • Payment options: Unlimited users for $89/month.

This tool can be built out as a hybrid between Google Sheets and Agency Analytics, meaning it’s very customizable but can also automatically and easily aggregate data from multiple sources to create a meaningful report.

CyfeScreenshot from Cyfe, January 2023

AI-Powered Tools

AI-powered tools can significantly simplify otherwise complex and time-consuming tasks. Remember that some of your processes will require a human touch, so always evaluate how performance is impacted when integrating AI into your processes.

The following tools, Link Whisper, Postaga, and CTRify använda AI för att upptäcka möjligheter och automatisera processer.

10. Link Whisper

  • Pricing: $77 per månad för en webbplats, med ytterligare planer för fler webbplatser.
  • Payment options: En till 50 webbplatslicenser.

Link Whisper är användbart för internt länkbyggande.

AI-tekniker erbjuder automatiska länkförslag när innehåll produceras. Det kan också hjälpa dig att känna igen gammalt innehåll som behöver fler länkar riktade till det.

Verktygen automatiserar även länkar baserat på nyckelord och erbjuder intern länkrapportering. Det är ganska allomfattande och kan hjälpa till att påskynda internt länkbygge automatiskt.

Link WhispererSkärmdump från Link Whisperer, januari 2023

11. Postaga

  • Pricing: $84 per månad för ett konto med fem användare. $250 per månad för 30 konton med obegränsat antal användare.
  • Payment options: Spara genom att betala årligen.

Postaga gör allt från att hitta möjligheter till att initiera uppsökande verksamhet.

AI spelar in med den uppsökande assistenten, som hittar relevant information från influencers att inkludera i e-postmeddelanden. Du kan också ange din domän i verktyget för att hitta relevanta kampanjidéer.

PostagaSkärmdump från Postaga, januari 2023

12. CTRify

  • Pricing: En gratisversion. $197 eller $497, beroende på planen.
  • Payment options: Engångsbetalning.

CTRify är ett WordPress-plugin som är bra för att skapa innehåll.

Allt som krävs är ett enda nyckelord, och AI skapar det innehåll du behöver för en specifik kampanj. Du kan sedan automatiskt publicera inläggen – det blir inte mycket enklare än så.

CTRifySkärmdump från CTRify, januari 2023

Slutsats

Jag har sammanställt den här listan med avsikten att erbjuda ett verktyg för varje läsare, tillhandahålla prisvärda lösningar på företagsnivå och mycket tekniska verktyg.

Det finns en mångfald i de tillgängliga verktygen och du måste välja rätt för jobbet.

Du behöver inte ha en $1 000 månatlig verktygsbudget för att vara en länkbyggare, men alla uppgifter kommer att ta tid. Att allokera din tid och din budget i rätt kombination förbättrar affärsresultaten.


Utvald bild: Paulo Bobita/Search Engine Journal



Källlänk

Fortsätt läsa

Trendigt

sv_SESvenska