When you have a new website, URL redirection may seem not that important. Because a fresh website has only a few pages to deal with. But over time your site grows and more pages are added. And, more pages means more URL to manage.
Suppose, a URL isn’t performing as much as you expect, or, later you realize that URL is too complex to remember. So, how would you deal with this situation?
In that case, you may need to upgrade or redesign your site which is why you’re bound to shut down your site temporarily. Having said that shutting down a website for a while is too risky to maintain the flow of traffic.
To handle all these situations, a vivid knowledge on how to redirect URL can rescue you. How? Well, keep reading the blog. You’ll get everything about the topic.
What Is URL Redirect in WordPress
An URL redirect means you set a new destination for the old URL. That means you’re remapping your web pages. When you redirect a URL, you’re simply forwarding it to another address on the same, or different domain.
It ensures visitors don’t end up on a 404 page and instead find something relevant to what they were originally looking for.
And, it keeps you from losing the value of any links you’ve built to that page. That is important for search engine optimization (SEO), as well as the user experience of anyone who clicks one of those links.
Why & When Do I Need to Create a Redirect URLs
To be very honest, creating a URL redirection doesn’t need any auspicious reason. You can create it anytime you wish to.
However, we have listed the top 5 points when you might be thinking to create a URL redirection. So, whenever you’re in any of these below-mentioned situations, you can redirect the URL so that you won’t be losing your audience by giving them a 404 error page.
Having Duplicate Content: Multiple posts that contain the same content can negatively impact SEO. Search engines can’t decide which URL is the correct one and which one to rank on the SERP.
Managing Multiple Domains: Instead of using multiple domains to display the same page, you can instead redirect them to the main one.
Moving to a New Domain: Suppose, you have a domain name “mywebsite.com”. Now you want to change it because you think it isn’t that attractive for anyone to remember. Or, you are threatened with legal action because your domain name infringed on someone else’s copyright.
Simplifying and Tracking Display Ads: If you are advertising with banner ads, you might want to track the ads’ responses. You can accomplish this by using specific URLs that you include in your advertisements. Then, with a simple redirect, you can send the traffic from that specific URL to the homepage or any of the pages on your site.
Types of Redirect That You Need to Know
There are a few types of URL redirection that people often use. The most commonly used redirects are 301 Moved Permanently, 302 Found, 307 Temporary Redirect, and Meta Refresh.
301 Moved Permanently: This is known as a permanent redirect and is used to indicate to search engines that the originating URL has permanently moved to a new URL. From an SEO perspective, link juice is passed via a 301 redirect.
302 Found: 303 redirect is like, what you’re searching for isn’t available right now. But it will be available certainly after a certain time. A 302 redirect was originally used for temporary redirects (in the HTTP 1.0 specifications). It is still used extensively for temporary redirects, but a 307 redirect should be used instead.
307 Temporary Redirect: A 307 redirect is used for when you’re redesigning your site, but want to direct users to a different domain while you finish. Or, if you want to A/B test two different versions of a page, before committing to a new version. A 307 redirect doesn’t pass link juice.
Meta Refresh: It’s a type of redirect executed on the page level rather than the server level. This is most commonly associated with a five-second countdown with the text “If you are not redirected in five seconds, click here.” Meta refreshes do pass some link equity but are not recommended as an SEO tactic due to poor usability and the loss of link equity pass
How to Redirect URLs in WordPress (Without Plugins)
Redirecting a URL in WordPress can be done without using a plugin. Yeah, that’s right. You can create URL redirection using cPanel and .htaccess files. So, let’s get started with “Using cPanel” which is arguably the easiest way to redirect a URL.
Method 01: Using cPanel
When signed into your cPanel account, scroll down to the Domains section. Scroll down and find the Redirects icon, as shown in the photo. Then, click on it.
In the dropdown menu under Type, you can choose between Permanent (301) or Temporary (302). Make your selection. We recommend keeping the field Type as Permanent (301).
Afterward, select the domain name you wish to redirect to outside. For instance, http://mysamplewebsite.com/specificpage.html is our source URL.
Under Redirects to, place the details of the destination URL. For example, we will redirect to http://www.anotherwebsite.com/.
Click Add, and the URL redirect is done! The source URL will redirect to another URL.
Congratulations! You have done all the procedures to redirect a URL in WordPress site.
Method 02: Using .htaccess File
As you know .htaccess is one of the most vital files of a WordPress website, it mainly handles the redirects. So, access the .htaccess file with care.
As always, you need to log in to your cPanel account and open the file manager from the Files section, it consists of all the core files and folders of your WordPress site.
Find out public_html from the left vertical navigation menu and click that file.
Search for the .htaccess file. As you can see, .htaccess has a dot prefix, which reflects its nature to be a hidden file.
Note: If it happens you couldn’t find the .htaccess file, chances are that it is hidden. To display the hidden file, click on the Settings button at the top right corner of the screen. A dialog box will pop open as soon as you click the button. In the box, check Show hidden dotfiles and click Save.
Once you find it, download that file to your computer.
Note: This step is incredibly important. Like I said, .htaccess is the configuration file for your whole server, so you don’t want to make a mistake. That’s why you should always keep a copy of your original .htaccess file. That way, if anything goes wrong you can just re-upload the original file.
So, before making the changes in the next section, make a copy of the .htaccess file you downloaded from your site and keep the original file safe, secure, and unedited.
Open your .htaccess file and edit it as following;
To redirect a single post or page, add the following short snippet for each post or page you want to redirect:
Once you are completed with the .htaccess file editing, upload it to the server. For uploading the file, make sure you have FTP access to the server.
Top WordPress Redirect Plugins to Redirect URLs
For basic users and non-developers, setting up a working redirection path can be quite tricky. That’s why the easiest way to go about it is by using a plugin.
When you install a WordPress redirection plugin, you can simply manually type in which page or website you want to redirect your users to with no coding knowledge necessary.
These are the top-rated WordPress plugins for URL redirection.
WP 404 Auto Redirect to Similar Post
SEO Redirection Plugin
Easy HTTPS redirection plugin
All 404 Redirect to Homepage
Redirection is the first pick on our list. It’s a 4-star plugin that has more than one million active installations. With it you can easily manage 301 redirections, keep track of 404 errors, and generally tidy up any loose ends your site may have. This can help reduce errors and improve your site ranking.
Redirection creates a manager page where all issues are listed and can be acted upon. Its settings also allow you to specify who has access to the plugin and what browsers to include or exclude.
301 Redirects – Easy Redirect Manager
As an all-around solution for all problems related to redirecting in WordPress, 301 Redirects is definitely one of the best plugins for redirection. Even if you have never done redirection and you don’t even know where to start, you’ll be able to easily set up a redirection path only a couple of seconds after activating it.
With over 100K+ active downloads, 301 Redirects is one of the most popular WordPress redirection plugins. It also has a high rating of 4.5/5 stars.
SEO Redirection Plugin
SEO Redirection is also one of the simplest ways of setting up and managing your redirects. It’s especially good if you’re thinking about using redirection to boost your SEO, because it also fixes crawl errors in the Google Search Console, helping your search engine rankings along the way.
It’s a 4 star rated plugin that has already 40K+ active installations. The number of active users is showing how well it’s working on their site.
Easy HTTPS Redirection Plugin
Easy HTTP Redirection plugin doesn’t deal with 404 error pages redirection, but it makes sure that all of your visitors are going to the HTTPS version of your website. Of course, in order for it to work, you will need to have a working SSL certificate.
After you install and activate the plugin, all visitors who try to access an HTTP version of your WordPress site will be automatically directed to HTTPS. This can do wonders for your SEO because search engines favor sites that are SSL-encrypted.
All 404 Redirect to Homepage
If your goal is to redirect all of your 404 error pages to your homepage, All 404 Redirect to Homepage is the plugin to do it. However, you will not have the same options available as in some of the other plugins, since this one is designed specifically for that.
But, if you want to redirect to your homepage exclusively and use redirection only as a means of managing 404 error pages, this is the simplest and easiest way to do that.
Bonus: Common Challenges You May Face While Redirecting URLs
While redirecting a URL in your WordPress site, you may face some common problems. Don’t be panicked as it can be solved in moments. Let’s talk about some of those common problems that people face very often while redirecting a URL.
Suppose, your page was originally at URL A, then moved to URL B, so you put a redirect in place to send any traffic and link juice that was going to URL A to URL B. Then somewhere down the road the decision is made to move to URL C.
So, you redirect the page from URL A to URL C.
This is a mistake that many people commit. Don’t do that rather than you should redirect the page from URL A to URL B, then URL B to URL C. This is the best practice.
Using 302 Redirects Rather Than 301 Redirects
A 302 redirect sends users and search engines to the new URL, but don’t pass the link juice or page equity to the new URL.
A 301 redirect sends everyone to the new URL and passes some of the link equity to the new URL. If you’re using 302’s from a page that’s never coming back, you’re not taking full advantage of what you’ve already built up for that page.
Infinite redirect is like the page redirects to itself, or in some cases redirects to another page, which then redirects back to the original page, and so on. The browser will take a couple of moments, then show the error.
The best way to identify infinite redirects is to look in the crawl errors section of Google Webmaster Tools where they’ll tell you all of the issues they’ve encountered while attempting to crawl your site.
Setting up a URL redirection may seem intimidating for the non-technical person. But no worries! Following this guide you can redirect a URL anytime, it doesn’t matter whether you not know to code.
Having said that if you fall into any problematic situation while redirecting a URL to your WordPress site, you can let us know. We’d love to assist you.
WordPress RSS feed is a well-known method for content marketing. RSS feed mainly shares the latest post or content of your website to your users. By adding this, your users can easily get the content they are looking for.
In most cases, bloggers would like to separate their RSS feed for each category in WordPress. Today, in this definite guide, we will show you the entire process of making a separate RSS feed for each category in a WordPress website or blog step by step.
Before we dive into the tutorial, let’s briefly describe what an RSS feed is and why you should consider it on your website.
Let get started.
What is RSS Feed all about?
RSS is a web feed mainly stands for Rich Site Summary or Really Simple Syndication that allows your website users or visitor to receive the latest news or content from your website.
The RSS feed works primarily by publishing the latest content to an XML file format. This feed collects your full content or summary, including metadata like author, date, category, etc.
After that, the XML file can be read with an RSS feed reader. You can find RSS feed reader software on different types of operating systems, even for desktop computers and mobile devices. By default, WordPress generates an RSS feed for posts and comments in Atom and RSS 2 formats.
Why Do You Need to Utilize an RSS Feed?
In the early days, you must remember the name of the different websites that you followed or read their content. However, to get regular updates you had to check those websites’ regular basis.
But now, the synopsis is different. Today, you don’t need to remember your favorite website’s domain name rather you can subscribe to their WordPress RSS feed.
By subscribing to their website RSS feed, you can easily get the latest published posts or content of their website. That means, whenever they publish a new post or update old content from their website, you will get an instant notification email from them.
RSS feed helps the website visitor as well as the site owner. As a webmaster or blogger, your main motive is to make sure your website content reaches your audience. On the other hand, as a user, you are always looking for those content on your favorite website.
Besides, you can read all the necessary posts in the same place and able to read content offline as well.
The most important thing about using an RSS feed in your WordPress website is that it helps in your content marketing.
How to Separate WordPress RSS Feed for Each Category
As we already mentioned that WordPress creates a separate RSS feed for posts and comments. However, making an RSS feed for the individual categories is a great way to reach your content to the users. By doing this, your users only get those content notifications that they are interested in.
Let’s see how to do the entire process step by step. We will be showing you two methods.
First Method : Manually Separate RSS Feed
In the first method, we manually separate RSS feed for each categories.
To do this first, go to the Category page.
Then click on the View button for each of your categories that wants to add RSS feed separately.
Then you should add an extra word feed next to end of your current URL.
Well, you can create a separate RSS feed for each of your categories by adding a simple code on the sidebar through widgets. Here is the code.
Now you should change the URL to the feed image because it will show an RSS icon next to your list of categories. Finally, you can paste this code into your sidebar where you have the category code.
Second Method : Using a Plugin
In the first method, we’ve shown the manual process of separate an RSS feed for each category. Now is the time to show the second method. Here we will use a free WordPress plugin to do the whole process.
First, navigate to Plugins->Add New.
Then search for the ‘Category Specific RSS Feed’ plugin. And click the Install button and Activate the plugin.
Now go to Settings->Category Specific RSS . Now go to the usage and settings.
On this page, you will also see the shortcode for the plugin and PHP call function.
We will try to use the Category Specific RSS plugins in our website Sidebar through Widgets. To add the widgets, navigate to Appearance->Widgets.
Then find the ‘Category Specific RSS‘ Widgets and drag it to your sidebar where you want to display the RSS feed on your website.
Note: You have to make sure that each of your categories has content. If the category doesn’t have any posts, it won’t display on your site.
WordPress RSS feed is a powerful feature that allows sending your website content to your target audience with great ease.
In this article, we’ve talked about what is an RSS feed, why you should use it, and its benefits. Besides, we covered that how can you separate RSS feed for each category in WordPress and why.
Do share your idea with us about the RSS feed in WordPress.
Visitors are the lifeline of a website. And, to be benefited from the visitors, it is obligatory to know the true colors of them. Like, how many people visit your site at a certain time, why they visit your site, what’s their activity on your site, etc.
And, as you know, for every purpose WordPress has numbers of plugins available out there, so, to track website visitors, of course, there are plugins to get the job done.
In this tutorial guide, we will show you how to track website visitors using the WordPress plugin in minutes. But before that let me show you why you need to track your website visitors.
Why You Need to Track Visitors on Your Site
Having a WordPress website means you have spent a certain amount of time, effort, and energy to build this site. Now, it’s time to track the visitors to your website. Because knowing your visitor can help you to design products as per their demands. That can also help you to increase the number of traffic to your site.
And, as you know more visitors mean more opportunities for converting them into subscribers and customers. Let’s find out more points about why it is important to track website visitors.
Know Your Visitors: You can find out which country or region your visitors are from, so you can create content that solves a problem that’s specific to their country and create personalized marketing messages.
Identify Popular Content: Website visitor tracking can help you find out which content post is performing and getting a lot of traffic, so you can come up with similar topics.
Make Data-Driven Decisions: Traffic stats can help you set your website goals that are backed by data, so you can grow those numbers and increase your revenue.
Apart from it, without tracking your site visitors, you will never know whether your effort is working or not. So, let’s take a look at how to track the number of site visitors coming to your WordPress site.
How to Track Visitors on Your WordPress Site
To track visitors on a WordPress site, you will get a number of free plugins for WordPress analytics. However, in this tutorial, we are going to use WP Statistics as a free WordPress plugin to track visitors to our website.
Basically, there are reasons to choose WP Statistics as our analytics plugin. With 500K+ active installations and 10M+ total downloads, it proves itself such a plugin that we are looking for. If you’re looking for something that will give you the below-mentioned advantages, then you can use this plugin.
Visitor Data Records including IP, Referring Site, Browser, Search Engine, OS, Country, and City
Stunning Graphs and Visual Statistics
The number of visitors coming from each Search Engine
The number of Referrals from each Referring Site
Statistics on Contents based on Categories, Tags, and Writers
After choosing the plugin, it’s time to move forward to the tutorial on how to track website visitors.
Step 01 – Installing WP Statistics
Log in to your WordPress admin panel.
In the left column navigation mouse over the “Plugins” link and click the “Add New” link.
In the “Search plugins…” box, enter “WP Statistics.”
Once you have located the plugin, click the “Install Now” button.
When the plugin has been installed, click the “Activate” button.
Step 02 – Configuring WP Statistics
In the left column navigation, mouse over “Statistics” and click the “Settings” link.
Click the “Externals” link/tab.
Click the “Enable” box for GeoIP collection and GeoIP City. This translates the visitor IP addresses to countries and cities.
Note: Geo-location using IP addresses is not 100% accurate for any program. But in most cases, it will provide relevant and useful information.
Scroll down and click the “Update” button.
Step 03 – Reading the Statistics
There are several statistics pages available. The Overview page displays the top or most recent statistics for most of the stats below on a single page.
The “Hit Statistics” page is a graph displaying the total number of visitors to your site during an adjustable time frame.
The “Online Users” page displays a list of users currently on the site. It also shows how long they have been on the site, their country, and browser.
The “Top Referring Sites” page shows a list of the referring sites that people visited before coming to your site. This works great for tracking things like backlinks and social engagement.
The “Latest Search Words” page is a list of the search words that lead a visitor to your site.
The “Search Engine Referral Statistics” is a graph displaying incoming search engine traffic to your site. It will reflect traffic from Google, Bing, DuckDuckGo, Yahoo!, and Yandex.
The “Top Pages” page displays both a graph and a list of posts and pages on your site, ranked by the number of views.
The “Recent Visitors” page is a list of visitor sessions on your site. Including the visitor’s IP addresses, browsers, referrers, and date of visit.
The visitor’s page numbers will be different from the hits or pages stats because one visitor can be responsible for multiple entries in hits and pages.
The “Category Statistics” page is useful if your posts are in multiple categories. If you don’t use categories, as our test site here does not, then these numbers will represent the total number of visitors.
The “Tag Statistics” page is similar to Categories in that it only provides useful data if you use tags on your posts. If you don’t, as our test site here does not, the graph and list in this section will be blank.
The “Author Statistics” page will display the statistics per author. If your site only has one author, then these numbers are just visit totals.
The “Browser Statistics” page displays pie charts detailing the browsers being used to visit your site. This also includes the visitor’s operating systems.
Top Visitors Today
The “Top 100 Visitors Today” page displays information about the top visitors to your site for the date selected.
Step 04 – Displaying Stats on Your Site
WP Statistics provides a couple of ways to display certain stats on your website. But the easiest one is using the Statistics widget.
To activate the widget, mouse over “Appearance,” click the “Widgets” link.
Scroll and find the Statistics widget. Click “Widget”, then select a position where you want to show the data.
Click “Add widget”
Add a name and select which stats to display.
Then click the “Save” button.
Now the stats you selected are displayed in the site footer.
Congratulations! You have completed all the steps to track visitors on your website.
Top Plugins to Track Visitors on WordPress (WP Statistics Alternatives)
Apart from WP Statistics, there are a few prominent WordPress plugins to track website visitors. We are going to show you such WordPress plugins as the alternatives to WP Statistics. And, all of them are completely free to download and easy.
Google Analytics Dashboard for WP by ExactMetrics: The ExactMetrics Google Analytics for WordPress plugin helps you properly setup all the powerful Google Analytics tracking features without writing any code or hiring a developer. The number of active installations (1M+ till to date) shows how people love to use this plugin.
GA Google Analytics: This plugin enables Google Analytics for your entire WordPress site. It’s a lightweight and fast plugin that comes with plenty of great features. So far it has 500K+ active installations.
Site Kit by Google: Site Kit is the official WordPress plugin from Google for insights about how people find and use your site. It provides authoritative, up-to-date insights from multiple Google products directly on the WordPress dashboard for easy access, all for free.
Google Analytics Dashboard Plugin for WordPress by Analytify: Google Analytics Dashboard for WordPress by Analytify makes Google Analytics simple for everywhere in WordPress (posts, pages, and custom post types). It presents the statistics from Google Analytics in a beautiful way under the WordPress Posts/Pages at the front end, backend, and in its own Dashboard.
Google Analyticator: Google Analyticator makes it super easy to view Google Analytics within your WordPress dashboard. This eliminates the need to edit your template code to begin logging. Google Analyticator also includes several widgets for displaying Analytics data in the admin and on your blog.
Note: If you’re still in hesitation to choose a visitor tracking plugin for your website, you got nothing to worry about. Because you can make a comparison between each plugin using the WPHive Plugin comparison feature. This will help you to make your decision in no time.
Learn how to create a news website in WordPress within minutes with our beginner friendly tutorial. (Bonus: 7 awesome WordPress newspaper theme recommendation at the end).
You will see hundreds and thousands of newspaper sites around you. But people are always eager to get real news and new thoughts. If you want to create a news website using WordPress, follow our step by step tutorial.
A good newspaper, I suppose, is a nation talking to itself. –Arthur Miller
Journalism is a great profession. Writing capability is also a divine gift. Today it’s easy to reach people with the news and views by just creating a news website. Treat the technological advancement as a reward. Go ahead with your efforts and a creative team of writers.
If you’re an aspiring data analyst, Excel is still the most essential tool out there. It’s very important to learn different functions if you want to do data analytics in excel. But, it’s not always as easy as it may seem. There are more than 500 functions in excel. This big collection of functions help you work with big data set and do analytics. Moreover learning these functions will also help you do similar tasks using Google Sheets, which is quite similar to Excel in terms of features and formulas.
However, learning all these functions is not an easy task to do, especially if you are someone who is new in data analytics. So we filtered out some of the most important functions that will help you do data analytics in Excel.
In today’s world data analysis has many applications for all sorts of business. Be it an offline business or an online business, data analysis shows you how you can make intelligent data-driven decisions reducing the margin of error. Data analytics can also help stay ahead of your competition data analysis by giving you an edge over others, in terms of customer insights.
Apart from these data analysis can also help you with –
Excel or spreadsheet is one of the most influential tools ever developed by Microsoft. It has varied applications and data analysis is one of the most important ones from those.
Excel has a huge collection of formulas that make it very easy to analyze, filter, sort, or make reports from a large quantity of data. Moreover, it is very easy to learn and start working with. You don’t even need to learn all the formulas that excel offers, in order to start with data analytics in excel. Starting with only a few most used formulas can get you through the initial learning stage and give you the most sought after information.
So it’s quite obvious why you should start data analytics in excel. It is quick to learn, easy to understand, and very affordable as well.
Excel vs Google Sheets: Things to Consider
When writing an article about Excel and its importance in data analysis, it is almost impossible to do it without mentioning Google Sheets. Though Excel was built long before Google Sheets, these two are now almost comparable in terms of features and popularity. So what are the major difference between Excel and Google sheets? Let’s get to know.
Functions: Excel has an edge over Google Sheets in terms of the number of functions it has. Large number of formulas make Excel the popular choice till now, but it can change in the recent future as Google is adding new functions aggressively over the last years.
Price: Microsoft Office 365 costs $8.25 per month. While you can use Google Sheets for free. However, there is a business subscription that costs $5 per month.
Data Analysis & Visualization: If you are planning to mostly perform data analytics, Excel is surely a superior option given its large array of functions as well as built-in charts and visualization options. Google Sheets, on the other hand, has fewer number of formulas and only manual visualization capability.
Ease of Use: Ease of use is where Google Sheets dominate Excel. It offers simultaneous edit from multiple people, while Excel doesn’t have that luxury. This is because Excel is an offline software where Google Sheets is a cloud-based one.
Now that you know the differences between this two spreadsheet software, it is clear that as of now Excel is only a slight bit ahead. But in because of the complete package and ease of use, more and more people are choosing Google Sheets as their primary software.
Most Important Excel Functions for Data Analysis
Now that we know the way we should use excel for data analysis, let’s learn the most important functions that are a must for data analysts. If you are a beginner, these are the formulas that you will be working with the most.
We’re starting with one of the most important functions, CONCATENATE. This handy function lets you combine the data of multiple cells into one single cell. Once you start your journey as a professional data analyst, you’ll realize the tur importance of this function.
Also, below is an example of how it works.
Formula: =CONCATENATE(cell1, cell2)
LEN is another function that is highly used in data analysis. We often need to calculate the number of characters on a cell. For example, if you analysis a product dataset for an eCommerce business, you’ll find lots of different SKUs. If you can display the number of characters, you can easily get to know it. Apart from that, you might need to set a word limit for a cell, which is quite easy with this function.
SORT is one of the self-explanatory features that say it all through its name. This is not only a necessary feature but also a lifesaver. Imagine finding a certain value from thousands of disordered data? It could’ve been a nightmare for a data analyst had there not been this function.
With SORT, you can just arrange your data by highest or lowest value, and easily find out the one you need. An ordered list also makes life easy for a data analyst in many ways.
Here’s how you can use this feature.
As you can see, there is a dedicated feature for sorting a list of data. Here we have selected the Length data and sorted them starting from the smallest.
The good thing is when you sort a single column of data, it also sorts the corresponding row with it.
FILTER is another super handy feature from excel. It is used when you need to show that contains one or more specific terms. When you have thousands of data to analyze, this is another feature that will help immensely.
Have a look at how you can work with one of the most used functions to do data analytics in excel. Click on the Filter option from the Sort & Filter button. You can see a downward arrow with every collum as soon as you click on the Filter.
Now you can filter out the result that matches your desired data.
And as you can see, the sheet is now showing only the rows that includes 1995.
Ah, the VLOOKUP! Even if you haven’t worked as a data analyst, you must know this function if you did even some small task-completion with excel. It is considered as one of the most recognized excel function.
Using VLOOKUP, you can easily find data associated with a value that the user chooses. This feature has multiple impressive applications. You can search within a single table or multiple tables.
For example, you have Name and Employee ID in one table and Name and Salary in another, you can easily add them together using VLOOKUP.
Let’s see how VLOOKUP works.
VLOOKUP formula consists of 4 different parameters, LOOKUP_VALUE, TABLE_ARRAY, COL_INDEX_NUM, [RANGE_LOOKUP
LOOKUP VALUE is the value you want to look for.
TABLE ARRAY is the table where you want the function to look.
INDEX NUM is the column number of the information you need.
RANGE LOOKUP is used to specify the type of lookup.
Here’s how we started the VLOOKUP. We specified the value we want to look at, which is Johnny in our case. Then we selected the cell where the value Johnny is.
After that, we selected the data which has the birth year related to all the name here. We put in sheet 2.
Then we also selected the column where our desired information is. Which is in B or Column 2 in our case.
Remember what CONCATENATE does? Well, the LEFT/RIGHT function does the opposite. With these two functions, you can extract data extract specific text/number from a cell. While the LEFT formula extracts these data from the beginning part, the RIGHT formula does it from the end.
Here’s how you can perform the operation with these functions. Staring with the LEFT function.
And the RIGHT.
Here is the end result.
Formula: =LEFT(cell, length of data to extract from left)
=RIGHT(cell, length of data to extract from right)
7. FIND & REPLACE
FIND & REPLACE! Does it need any extra introduction? With this feature, you can find a specific text or number within a table. Then it replaces all the data that matches your provided term with a new term that you provide.
It can be used to replace large numbers of mistaken data at once. You can also use it to slightly modify a large number of data. No wonder it is used heavily to do data analytics in excel.
Using Find & Replace is quite easy.
But it does give back some good results. You can see that the word Johnny is now replaced with Adam everywhere in the sheet.
With the IF function, you can make excel do a specific task or show a result based on the outcome of another operation. Let’s see an example of what IF does and how we can automate a decision using this function.
We want to if the birth year is 1996 or not, so we selected ==1996 in the first parameter, and then set the formula to show True if the value is true and False if the value is false.
Here is the result.
Formula: =IF(logical test, value if true, value if false)
SUMIF is another excel function that you must learn to start doing data analytics in excel.SUMIF sums up all the number that matches specific criteria.
Let’s say you have many different numbers, but you want to get the sum of a specific number (i.e. 50) of that table. This function will find how many times the number is present on that table and do a sum.
Here’s how it works.
Now we can find the sum of the values that are exactly 1995. Here is the result.
Formula: =SUMIFS(sum range, criteria)
COUNTIF function is almost like the SUMIF. But unlike SUMIF, it does not actually sum-up all the number that matches your criteria. COUNTIF calculates and shows you how many times your desired data is present on the sheet.
The operation of COUNTIF is very straightforward and goes like below.
And now you can exactly how many times 1995 is present in the sheet.
Formula: =COUNTIFS range, criteria)
The growing demand for data analysis is not a miracle. The application of data analysis is diverse. Despite the emergence of many new data analytics software, excel is still one of the most powerful tools for data analysis.
Learning excel functions is a must for any aspiring data analyst. But you can’t just learn all the functions at once and start data analytics in excel over night.
The right way to learn them is to just start data analysis with some important functions and learn all other functions from time to time when you need them. So, make sure to learn the use of the most important excel functions and get started with your journey of being a data analyst.
A photo gallery is a versatile tool that allows you to add photos in rows and columns on a WordPress website. It also helps to add more images in less space and makes it easier for visitors to explore.
In May 2017, Google announced that Google Photos has over 500 million users, who upload over 1.2 billion photos every day.
In this article, we like to show how to create a WordPress photo gallery following some easy guides. If you follow these steps, you can able to make a stunning photo gallery for free.
Before that, let’s know why you should create an image gallery.
Why Create a WordPress Photo Gallery
A gallery can use on a website for many purposes. It’s not just for the photographs. You can create a gallery for displaying your eCommerce products or services. You are able to showcase your company’s works.
Here, you find some reasons for creating a photo gallery on your site.
You can create a photo gallery to sell your photos
Show the latest events in your company
Display your company’s work
Also, you can display your profile, such as member bio, partner logo, or case studies.
By adding a gallery, you can promote affiliate products of other companies.
Moreover, for a photographer, having a photography website is a smart way to portray your work to the world. You not only showcase your photos but also can sell them to make some money.
WordPress Photo Gallery Best Practices
Creating a photo gallery with WordPress is not difficult. But you need to be careful about some important aspects while creating the gallery. Like,
Use high-quality images
Make it mobile-friendly
Add relevant photos
Use JPEG format
Avoid uploading many photos
Size and scale of your photos
Focus on image optimization
Avoid adding so many gallery elements
Give logical photo name that tells the photo story
Add white space surrounding your gallery
Ignore unusual options like zooming and 360-degree viewing
Disable right-click option
Use a watermark on all photos
Update your image metadata, company name, photographer name, and date for copyright purposes
Use a responsive, retina-ready WordPress theme or page builder like Elementor
If you want to create a dynamic photo gallery for your website like the other photography website, you should go for photo gallery WordPress plugins. Here we present some of the best photo gallery plugins that are advanced, easy to use, and allow you to create any type of gallery in minutes.
How to Create a WordPress Photo Gallery (4 Easy Steps)
Now it’s time to show how to create a photo gallery in WordPress following 4 simple steps. Let’s get started.
1- Create New Page For Photo Gallery
To create a gallery, we should create a gallery page where we can design our gallery. You can also create a gallery in your other existence page or post.
However, first, you need to login to the WordPress Dashboard and click on the Pages > Add New.
After that you have to put the name of your page into the Title section.
2- Choose The Gallery Block
After creating a new gallery page, your next task is to select the Gallery Block. Just click on the ‘+’ icon and choose the Gallery Block.
3- Upload Gallery Photos
Now you can upload your gallery photos into the galley. To do this, click on the Upload or Media Library
And select the images that you want to upload here.
4- Edit Your Gallery
First, you can write individual image captions and add a gallery caption. To write the image caption, you need to click on the Write Captions of the image.
You can also set the column number of your gallery. Here we select 3 Columns that mean in one column three images are displayed. In addition, you add an Attachment Page in the Link section and also resize your Image Sizes.
If you want to add a link in your gallery image or change caption text color, you can do it easily. You just click the image and select the dropdown menu to change Text Color.
After finishing the edit part, it’s time to show the preview of your gallery.
If you want to create a video gallery, check out the below blog.
WordPress has a default option to create a beautiful gallery. But it has some limitations. You can’t add advanced function in the default gallery block. If you want to add extra functionalities in your WordPress photo gallery, you can check out the gallery plugins that we mentioned earlier.
We hope that this article helps you a lot to design your ultimate photo gallery. Best of luck.
The significance of content marketing is, of course, limitless. It helps to get people engaged, keeping current customers, and targeting a broad, new audience. Marketer all over the world takes content marketing is an opportunity to spread out their products and services.
60% of marketers create at least one piece of content each day
Another study shows that over 4.4 million blog posts are published every day. So, creating content in such a crowd that pulls traffic over time, which is called evergreen content, is obviously a tough job.
To make your job easy, today, we have come with a fully comprehensive guide of content marketing plans that will help you to create evergreen contents in no time. So, keep reading!
What Type of Content Falls Under Evergreen Category
Before anything else let me tell you what does evergreen content means. Evergreen content is content that doesn’t lose its relevance in a short time and that also continues to drive results over time, such as traffic, leads, and sales. People will be interested in evergreen content whether it was created five years ago or yesterday.
Evergreen content can be a video, image, or write-up that will always stay relevant to your audience. It plays an important part in your digital marketing strategy that can drive online success.
To create an evergreen content, there are some category you can follow.
Tutorials and “How to” Guides: They are the main type of perennial content. However, tutorial articles related to technology might require updates from time to time. Suppose, you have published a blog on “How To Create A Medical Website Using WordPress & Elementor“. This is a tutorial guide and this type of content can be evergreen contents if you keep updating this blog when technology changes.
Problem-Solving: As a business online, you sell a product or service that provides a benefit and/or solves a problem. In saying that, if you can identify the kind of problems people are experiencing and use such problems to craft brilliant fresh evergreen problem-solving content; you can turn such readers into leads. You can check How to Survive in the Tough Time to get the idea.
List Posts: Whether you like list posts or not, there is a lot of data that proves that they simply perform better. If you can create a list post with handpicked items, it can attract people over time. A post like Best WordPress Localhost Services can be an evergreen content if you can create with real-life data.
Great Video Content and Podcasts: Video blogging and podcasts may provide you with the content you need in order to grow your brand and your reputation. You can create podcasts and videos that may fall into the evergreen category.
Glossaries of Terms or Phrases: It’s hard to start writing your own dictionary. However, there will always be some terms and phrases specific to your industry that you can group into a wiki type website or in a blog category. A content like SEO Glossary can fall into the evergreen category.
6 Evergreen Content Marketing Tips for Small Business
Evergreen content is the backbone of a solid content marketing strategy. Because evergreen content gets results: better SEO, more traffic, and more leads.
Check our 6 evergreen content marketing tips to create evergreen contents for your business.
Choose Topics Wisely
Create Content That Aligns with Your Niche
Make It SEO Friendly
Create Beginner’s Friendly Content
Use Good Visuals and Formatting
Don’t Forget to Update on a Regular Basis
Let’s look at the six evergreen content marketing tips to become successful in this challenging industry.
Choose Topics Wisely
If your goal is to write evergreen valuable content, then you will have to conduct research for every new topic you want to write about. Not every idea you think of can be good evergreen content.
You might want to check with your Search Engine Optimization (SEO) expert for keywords or trends to find out what your audience wants to know about your niche. You can also take a look at Google Trends and Google Analytics for guidance.
When choose a topic, remember the following tips.
Be appealing enough for social media
Have enough search volume to justify the time/money investment
Solve actual reader problems
Beat competitors in terms of quality and depth
You should avoid the followin topics if you want to create an evergreen content.
Statistics or reports that will quickly go out of date
Articles focused on pop culture or a current trend
Current clothing and fashion trends
Remember, evergreen content has no real expiration date and retains its value long-term, so an article about a presidential election or this year’s marketing trends may be popular content for now but it won’t make the cut as evergreen content.
Create Content that Aligns with Your Niche
You should create such contents that align with your niche. Pay attention to this advice because evergreen content, if properly created, will also help you grow awareness on your brand and make it more visible to Internet users. It will help you to monetize your blog when needed.
It may attract more customers, fans, or readers but at the same time, it will help your audience remember your brand and associate your name with the great content you are providing. So, focus on what your brand sells to create a following.
Suppose, you sell WordPress plugins from your site. And, as content marketing tips you should create contents that tell about plugin usage, features, benefits, implementation, and something related to the WordPress plugin.
The Content Must be SEO Friendly
What’s the use of a content if it doesn’t appear on the search engine results. You need to optimize your content so that it appears on the top results of search engines. And, SEO doesn’t mean just putting keywords throughout your article.
There’s more work than simply placing keywords across your content to get you on the front page of a search engine. Get your content optimized by an SEO expert. If you prefer to do it on your own, it would be best to check SEO best practices.
When it is an evergreen content and at the same time it appears on the top search results, you will be getting traffic over time. And, ultimately, it will help you to get potential customers from that traffic.
However, you can use free SEO plugins to get your job done. Moreover, top SEO plugins will suggest you the best ways to optimize your article.
Most evergreen content is targeted to beginners than experts. That’s why it’s a good evergreen tactic to make your content easy to understand and concise enough to retain the attention of people new to your niche.
This isn’t a must, but it’s usually applicable. Content with a long shelf life usually appeals to beginners. That’s because advanced level content tends to be tactical. Tactics change pretty quickly. Strategy, on the other hand, doesn’t.
Use Good Visuals and Formatting
Design is becoming more and more important. There’s a glut of products and information on the web. There’s no reason for someone to stick around your poorly designed and optimized content. They can hit the back button and find 10,000 more results.
No, you’ve got to put in the time and effort to make your content easy to read and a joy to look at. Here are a few tips:
Short sentences – 25 words or less
Short paragraphs – 3 lines or less
Ample white space
A lot of images
Subheadings to break the page into sections
Bullets and numbered lists to break up sections
Use bold to highlight your points
Plain English only – nobody cares about your vocabulary. Really, we don’t.
Don’t Forget to Update on a Regular Basis
In addition to highlighting your content, you must also ensure that it stays up-to-date. While there shouldn’t be much you have to do to update evergreen content, there will be new findings, new articles to which you can hyperlink and other new developments.
When you’re updating content, keep the following elements in mind:
Usefulness (Can users take action immediately?)
Clarity (Is there any confusing terminology? Does the piece flow logically?)
Tone (Is your writing friendly, approachable, and full of expert advice?)
Shareability (Can readers easily share the content on social media via sharing apps or otherwise?)
Once you’ve updated your content, promote it as if it’s a new piece.
Bonus: Checklist for Writing a Perfect Content
Content writing is not something that you just write it without care. You should be aware of what you are writing and how you want to display it. Every day thousands of content is being published all around the world.
So, you should follow a perfect checklist to write content so that people will love to read your content. Here, we are going to share exactly the same checklist that we follow every time we create content.
Content Research: Before starting writing a blog, make sure you know more than your audience about that topic. You can’t produce great content unless you’re aware of what you are going to write.
Word Count: Your every good content should be consist of 1900-2500 words. Google prioritizes the content that contains on average 2000 words. So, before publishing it, check the number of words it containing.
LSI Keywords: Do you use LSI keywords for your content? Because many of us overlook LSI keywords, though it has a great significance on the search results. Use 2-3 LSI keywords in your every blog post apart from your main keyword.
Slug/URL: URL should be short and clear. A long URL makes a bad impression to search engines and visitors as well. Putting the main keyword in the URL is the best practice, you can also set a few words other than the main keyword to form your URL.
Internal and External Links: Check Wikipedia to know the best usage of internal and external linking. Both the linking have great importance to get the top result on search engines. Your every post should contain 2-3 external and 10-12 internal links.
Image with Alternative Text: Your every image that is being used in your blogs should have alternative texts. You can use your main keywords as alternatives texts. But remember, do not use your main keyword in your every image. It can be a practice of black hat SEO. Instead, you can twist your main keyword and use it as alternative texts smartly.
Feature Image: Always use a feature image to give a standard look of your content. It’s also known as blog banner.
Review: After completing your blog, ask someone to review it. Check and correct if it has any grammatical or technical errors. A childish error can create a bad impression on your readers.
Follow These Content Marketing Tips to Create an Evergreen Content
Content doesn’t qualify as evergreen unless you’re able to get people to keep reading it. They won’t read it unless they feel like you know what you’re talking about. They won’t feel like you know what you’re talking about unless you showcase your authority.
These content marketing tips will help you to get a strong authority on your content. Start writing your evergreen content following this comprehensive guide, as it takes time to get the ball rolling.
If you don’t have a successful content marketing funnel, you can’t effectively guide people from simply being aware of your existing brand to finally making a purchase.
A marketing funnel is a smart way to move people from one stage of your content to another and ultimately create leads. It’s a multi-wise process where you first create a buzz of your product, consider and evaluate that the product can solve their needs, finally convince them to buy.
Let’s clear up the entire process step by step. Before that, you must understand the functions of a marketing funnel that drives sales.
What is a Content Marketing Funnel and How it Works
A content marketing funnel is a process of generating high-quality leads to your product or services through different stages of content.
In other words, it is a system that helps to get more potential customers and guide them through a content flow and finally converts them into paying customers.
While working on it, marketers separate each piece of content for different purposes. In a content funnel, you find three main content stages like the top of the funnel, the middle of the funnel, and the bottom of the funnel.
Why Should You Create a Content Marketing Funnel
Why create a content funnel? First, you should understand this.
Your main motto when producing content is to search for potential customers who can pay for your product or services. Make sure that you always create high-quality content for your business that has to go through an effective marketing funnel. Without it, you can’t survive in this competitive web world.
Content marketing generates 3x more leads than traditional marketing.
Moreover, well-designed content marketing helps you to get more backlinks, page indexing, higher search results and saves valuable time.
Here is a list below that shows why you should use a marketing funnel for your content.
Generate organic search traffic
Increase brand awareness
Drive higher conversion rates
Spend less money on paid ads
Build a Content Marketing Funnel That Converts
Building a content marketing funnel is a smart way to engage new customers and get more leads. When you think about a marketing funnel, you need to focus on the TOFU, MOFU, and BOFU the three stages of your content. You should work on each part of your content individually so that you can produce high-quality content.
Now, it’s time to show how to create a content marketing funnel that converts.
Top of The Funnel (TOFU)
The top of the funnel is the primary stage of the customer journey. Most of your clients do not know your company and are not prepared to take up your product. In this part of the content, your responsibility is to attract their attention and present your brand wisely.
To create awareness, you answer the queries of your customers, talk about their problem, and finally, create possibilities to solve their problem.
You prepare content like below to grab users’ interest.
Blog Posts: At the top of the funnel of your content, you put a blog post and try to inform your customers about your business. A smart blog post also helps to create leads.
Comprehensive Guides: People love guideline posts or tutorials. It helps to learn a matter properly. And you can design your top of the funnel with comprehensive guides.
Infographics: Photo & infographic tells the visual story of your content. By using infographics, you can catch your customer’s attention.
Podcasts: The podcast is an important topic that you may add to your content marketing funnel. Using a podcast, you able to tell a story of your services, promote business, give a recommendation to your customers.
Remember that your users only move on to the next part of your content if you accurately attract them. Try your best to do this, but you can’t force them to buy your product here at the top of the funnel.
Middle of The Funnel (MOFU)
After creating awareness at the top of the funnel, your next job is to focus on the middle part of your content. In the middle of the funnel, you speak directly to the users to tell how your business can help them.
Here, you highlight your product or services to your customers and convince them that you can solve all the problems. Besides, you also compare your business with others to show why other people engage with your business.
You may add some of the below things in your content.
How-to Articles: In the middle of the funnel, you can teach your customers about your product by writing a how-to article or tutorial. It’ll create a positive impact on the customer’s mind and provoke them toward the next stage of your content.
Demo Videos: You provide a useful demo video for your product. For example, you may add a video about how to use your products, its functions, benefits, and more.
White Papers: A white paper report is an authoritative report or guide that helps readers understand a problem, solve an issue, or make a decision. If you add this to your content, your customers get a better knowledge of your products.
Case Studies: Case studies very useful and always makes a smash on the users’ mind. It also proves that your products can solve other customers’ problems. And new customers freely use your product.
eBooks: You can write an eBook regarding your products or services.
MOFU is the evaluation and consideration stage of your content. You need to give the necessary information about your business and try to educate the customers and earn their trust.
Bottom of The Funnel (BOFU)
It is the final stage of your content where customers decide to buy your product or services. The content at the bottom of the funnel must be personal and to the point. Besides, you need to answer specific questions about your product if your customers ask.
Furthermore, you also show the difference between the free and premium features of your products so that customers can understand the importance of that.
In addition, you must follow the list below so that you can add these in your content.
Add Testimonials to Other Customers: At the bottom of the funnel, you should tell the audience the products you offer are being used already by other people. To do this, you need to add testimonials of your satisfied customers. If you do, it’ll create an impact on your new customers’ minds and helps for conversion.
Put Success Stories: Success story is another way to move your customers towards the lead. Try to put some problem-solving success stories of your clients solve in the last part of your content funnel.
Add Positive Review: Most customers are looking for positive feedback on your products. If you have positive reviews from other customers, you should place this in content to generate more leads.
Offer Free Discount: Most of the customers look for a discount and offer. If you offer a discount on your products, your chances of conversion may increase. So try this strategy in your content.
Allow Free Trails: You also can allow free trials of your product or services. And customers are like to use free trials. If they are happy with these trails, they will purchase your products.
Use the CTA Button: CTA (call to action) is one of the vital parts of the bottom of the funnel. Because customers use the CTA button to start the conversion process. You should always use a CTA at the bottom of your content funnel.
At this point in BOFU, you need to be selfish towards your competitors and just write only a perfect sales copy for your products.
Creating a content marketing funnel is not easy. You need to work hard and spend many hours to produce an effective funnel.
You should remember that only 1-3% of customers move into the bottom of the funnel from the top of the funnel. So you have to focus on the content structure and work on each stage of content.
Besides, you also need to do market research, understand your audience, make content interactive, and focus on SEO optimization, and more. Most importantly, you have to test your content before publishing.
If you do the above things correctly, you will be able to create a content funnel with great ease.