Categories
Google Google Algorithm Marketing

A History of Major Google Algorithm Updates/Changes Plumbing + HVAC Should Know

Every year, Google makes several changes to search. In 2018, they reported an incredible 3,234 updates — an average of almost 9 per day, and more than eight times the number of updates in 2009. While most of these changes are minor, Google occasionally rolls out a major algorithmic update (such as Panda and Penguin) that affects search results in significant ways.

For business owners and search marketers, knowing when major Google updates happen can help you improve your SEO efforts to increase your organic traffic and also might help explain current changes your seeing in rankings or traffic. 

Here is a list below of the most significant and noteworthy Google algorithm changes that have sculpted the landscape we are currently seeing today in search engine optimization efforts.

Recent Google Changes That Impact SEO

Panda Update – February 2011

Panda launched on February 24, 2011. It was aimed at dealing with quality and optimization issues that the search engine identified in several websites indexed at the time. It assigns a quality score to webpages, which are then used as a ranking factor. The Panda Update is also known as the Farmer Update. When this update was implemented, it had a significant impact on a broad range of companies that operated online. Panda was introduced to improve search quality by eliminating prevailing content farms as well as spam sites that were designed to take advantage of Google’s vulnerabilities.

Panda has done excellent at cleaning up low-quality sites that occupy valuable SERP real estate. The update did not come without its share of problems, especially for companies with e-commerce initiatives. Websites, both big and small, started disappearing from the usual keyword ranks they had previously owned for years. Lots of companies were impacted negatively and were utterly unable to recover traffic.

Numerous updates have been made to the Panda Update, with most of them focusing on eliminating obstructive spam sites. These Panda updates have concentrated on getting advertisers to achieve their maximum search potential.

Penguin Update – April 2012

This was launched on April 24, 2012. This update specifically targeted link spam as well as manipulative link building practices. Matt Cutts, head of the Google webspam team, officially announced the update via Twitter as the Penguin Algorithm Update. It was an extension to the Panda Update and was Google’s response to the increasing practice of black hat search engine optimization techniques, which are used to gain higher search rankings in ways that violate search engine guidelines. Many updates were made to the Penguin algorithm since its launch in 2012 including;

Google Penguin 1.1(March 26, 2012)

Google Penguin 1.2 (October 5, 2012)

Google Penguin 2.0 (May 22, 2013)

Google Penguin 2.1 (October 4, 2013)

Google Penguin3.0 (October 17, 2014)

Google Penguin 4.O (September 23, 2016)

With the last update, Penguin became a part of the core algorithm, meaning it evaluates websites and links in real-time.

Hummingbird Update – August 2013

The Hummingbird Update was launched on August 22, 2013. The name Hummingbird came from the speed and precision of the update. This new algorithm allows Google to understand phrases better, providing precise results to complex search queries. It expands the brand content strategy to have more informational content on their site. Also, it gives substitutions as a user enters the query. It also brings out results far more complex search queries. Google’s knowledge graph also appears more often than it did previously, giving more direct answers in search results.

Hummingbird has improved how users are sent to a specific page and directed to the information they are seeking. Hummingbird has also promoted voice-powered searches, helping to create a smarter search engine that can better decipher user intent. Hummingbird update has been branded “the heart of Google’s search engine” as it can filter billions of pages to find the most relevant search results.

Pigeon Update – July 2014

Google’s Pigeon was released on July 24, 2014. This Google algorithm update, unlike its predecessors, was designed to give more accurate and relevant local search results. Google rewarded local businesses that had a strong organic presence with better visibility in traditional search results. Several updates on Pigeon have been made since 2014.

In many ways, Pigeon can be described as not being punitive; rather, it serves a specific group of users best.

Mobile Update – April 2015

This was launched on April 21, 2015. This update ensures that when users use the search engine on their mobile phones, mobile-friendly pages rank closer to the top. This is to provide optimum usability and speed.

Rank Brain Updates – October 2015

These updates were launched on October 26, 2015. It worked like a refresh to Google’s Hummingbird algorithm. It helped Google to understand user queries better than before.

Possum Updates – September 2016

It was launched on September 1, 2016. It basically helped to ensure that locations given to the users were as accurate to the users’ current location as possible

Fred Update – March 2017

This was launched on March 8, 2017, and is one of the latest of Google’s major confirmed updates. It helps to ensure that Google’s webmaster guidelines are adhered to by targeting violations.

Core Update – June 2019

In a rare move, Google announced they would be releasing a new update prior to rolling it out. The update is thought to have affected low-quality news sites while boosting trusted aggregator sites. It may have also affected video carousels, with many YouTube channels seeing 25% increases in traffic.

Broad Core Algorithm Update – September 2019

Broad updates don’t tend to target anything specific; instead, they improve the overall effectiveness of Google’s systems. This can lead to drops or gains in the ranking, and the main advice from Google is to focus on producing quality content. These updates won’t penalize any websites, but they will reassess any new content featured in search results since the last update, and possibly rank quality content higher. Content improvements can aid recovery from any drop in ranking.

BERT Update – October 2019

Allegedly one of the most significant changes to Google search in the past five years, the BERT update focused on better understanding search queries. Google’s official explanation was:

“These improvements are oriented around improving language understanding, particularly for more natural language/conversational queries, as BERT can help Search better understand the nuance and context of words in Searches and better match those queries with helpful results.

Particularly for longer, more conversational queries, or searches where prepositions like “for” and “to” matter a lot to the meaning, Search will be able to understand the context of the words in your query. You can search in a way that feels natural for you.”

Source link

Categories
GMB Google Google Ads Local Marketing Local SEO Marketing Off-Page SEO On-Page SEO Organic Traffic PPC SEO Website Maintenance

3 Ways To Get Found On The First Page of Google for Plumbing + HVAC

Want your business to be seen on Google? Of course, you do, every company does. But, there are some things that work, and others that won’t work, as it relates to you being seen online. What approach should you take when trying to become a leader on Google and outperform your competitors in Google searches? Well, these are three surefire ways to get found on the first page results of Google, regardless of the size of Plumbing + HVAC company.

1. Pay for Google Search Ads

How to Use Ads to Get to the Top of Google

Yes, getting your page to show up on the first page results of Google organically is free. But, this takes time. And, more often than not, when you want to outrank the competitors in your area, this is not something you have. Therefore, you can purchase ads that Google will place atop the organic search results that show up on the search engine almost instantly. Read on to learn about how they work and how you can use them for your business.

Using a paid search campaign is a great approach you can take as a Plumbing + HVAC business, which works hand in hand with the organic work you’re doing so that your page ranks on the first page results of Google. Paid searches show up on top of the organic results. Google cycles these throughout the day, meaning each time someone searches for an industry-specific Plumbing + HVAC search, they’re likely to see one of the ads you purchased.

Over time, if this pairs up with the organic results from the SEO work you’re doing on your website, it’s going to look great for people who are shopping and looking for the top businesses in Plumbing + HVAC.

What are Google Ads?

Basically, a Google ad is a program you buy into as a business, and you’re paying for pages from your site, to rank atop the organic search results, on the first page results, of a Google search. Algorithms are used by Google to determine where you’re going to rank in ad placement. This is done based upon the keywords you’re paying for, and bidding on, to contest other Plumbing + HVAC companies.

Then, Google compares ads based on relevancy, budget, quality, visitor usefulness, and other factors, to determine where the paid-for ads are going to show up on Google. The reason you’re paying for these ads is that you’re only paying when someone clicks on them. So, even if your paid ad isn’t the first in the first page results, it is still going to be seen regularly by searchers.

How to Succeed with Google Ads

Alright, you are paying for ads each time a visitor clicks on one. But, how do you do well with ad placement to ensure Google places your ads above your competitors paid for ads? There’s plenty you can do to be seen on the first page results, and be one of the top ads on that first page. Some ways to improve your rank and placement are

  • Tracking
  • Adding links
  • A/B testing
  • Keeping track of metrics
  • Negative word use
  • Landing page optimization

Of course, this isn’t an inclusive list of ways that your page is going to increase in ad rank. However, the more of these factors you take into account when creating your ads, and choosing which keywords to bid on, the higher you’re going to see your ads rank atop the search engines and first page results on Google.

Can I just run a Google campaign myself? It is possible, it doesn’t mean it is going to work well. Hiring an expert to do it for you is the best approach. Not only do professionals know what search engines are crawling for, but they also know what the algorithms are looking for. A professional ad company will help ensure your rank increases, your ads are seen, and that your paid for ads are going to work well with the organic work you’re doing on your site, to ensure you’re on the first page results for all Google keywords you are targeting as a Plumbing + HVAC business.

2. Get Listed in Google My Business

Your company’s not listed as a business? This is hurting your rank immensely. So, how do you go about getting your company listed as a business?

How to Get Your Plumbing + HVAC Business Listings on the First Page

You want your website to show up on the first page results. However, your business listing on Google can also turn up on the first page results. That is if you are listed as a Google business.

Google My Business isn’t only a powerful tool for companies, it is a free tool you should be using in your Plumbing + HVAC industry. Google searches and maps pull up results from business listings, and your rank is going to be affected if you’re not listed as a business. Once you list your Plumbing + HVAC company as a Google Business, you’re also going to have to verify the account. This allows you to monitor progress, keep track of changes, and see how you’re ranking on the first page results as a business listing.

Optimizing Your Business Listing –

Optimization is critical to ensure your business listing is seen. Anyone can create a Google My Business, but if you don’t optimize it, what good is it going to do for your ranking? Not much.

Make sure you complete every step of the profile setup.

Businesses with more information get seven times as many clicks as those without the information searchers are looking for.

Consistency is key.

If you use Co. in one place, stick with Co. in others. Don’t go back and forth from Comp. to Co. to Company. It confuses Google, it confuses your searchers, and it is going to lead to a lower ranking on Google as a business listing.

Update information regularly.

Make sure your address, phone number, and relevant business information are correct. Do so regularly and make sure you keep the information up to date. People can’t find you if your Google Business listing says you’re closed. The more relevant and accurate your information is, the higher you’re going to rank on the first page results of a Google Business listing.

Reviews are a must.

Ask customers to write reviews, use Yelp, BBB, and other rating sites. The more positive information there is about your Plumbing + HVAC company in the industry, the more relevant you’re going to be for searchers. Google is going to promote your business listing business of this, and it’ll rank higher in the first page results.

Add photos.

Including photos of your listing, the storefront, employees, and other relevant information, will put a face to the name. If people can see and know what your business looks like, they are more likely to want to visit and do business with you. This is also going to lead to Google including your business listing higher up in the first page results than they would a competitor’s business that doesn’t include images in their listing.

Utilize other directories.

Yes, Google is still a leader in search engines. But, there are other business directories you can add your business to. The more places your Plumbing + HVAC audience can find you, the more credence it gives to your business. People are more likely to trust your company if they can easily find it through multiple platforms, so you’re going to see your business listing jump up on the first-page results when you have it listed on multiple directories, as opposed to being listed only in one place.

Just like you’re going to do with your Google listing, make sure the information on other directories is accurate as well. And, make sure it is consistent on Google and all other directories that you are listed on. People want to know who they are dealing with and want to know what your Plumbing + HVAC business does. When you can provide more information about your company, where it is located, and why your customer should want to shop with you, you’re going to realize an increase in rank in the search engines. And, you’re also going to see more visibility on other databases and listing directories as well, which will help increase revenues and customer base.

3. Optimize Your Website: Ranking Organically

How to Use Your Website to Get on the First Page of Google

SEO is imperative for your website to be found by the searcher. Therefore, you’re going to want to use search engine optimization tools, to help your website get atop the first-page results on Google organically, not only through paid searches.

Determine Your Keywords

When you are in a specific area, you’ll want to know exactly what people are searching for. Not only for specific words but also for phrases that your searcher is entering when they’re looking for a company in your area in Google. Some examples are

  • “Plumbing + HVAC near me”
  • “Best local Plumbing + HVAC service”
  • “YOUR CITY + Plumbing + HVAC “
  • “Plumbing + HVAC in YOUR CITY”

There’s no limit to what you can choose as your keywords or phrases. But, you’re going to want to make sure it is specific to your niche and your searcher. Targeting the right keywords will do wonders for your organic ranking, and will help get your website on the first page results for numerous keywords and phrases as well.

Let Google Know What Your Keywords Are

If Google doesn’t know why you want to rank, how is it going to improve your rank organically? The answer is, it won’t. Crawling is the manner in which Google and other search engines go about determining organic rank.

Some ways to inform Google what your keywords are includes

  • Titles: You have to include them for each page on your website, blogs, and other content you add
  • Meta Description: This is the short blurb that appears below results in Google, the description should describe your company within Plumbing + HVAC to your audience/searcher
  • URL: This is what people see when they click on your site. Keep it short, concise, and easy to remember
  • Alt tags: These are descriptions of images, and should include keywords and phrases that describe what visitors are seeing on your site.

The more you optimize your page, the easier it is for Google to crawl through it. In turn, it is going to end up ranking higher on the first page results, and over time, it is going to jump the ranks in organic searches.

You’re Writing for Humans

Don’t write for search engines. What does this mean? You want to write for a human reader. Remember, people are looking for your Plumbing + HVAC company, not Google. You want the content to be fresh and engaging. Make sure it adds value, teaches, or gives your reader something they can use.

Don’t inundate content with keywords and phrases, trying to make it rank on the first page results. Google can see through this and will penalize you. Add value and deliver something of value to your reader.

Mobile Site Optimization

Remember that people today are searching on smartphones, tablets, laptops, and other devices. Make sure your site loads quickly on mobile devices, is easy to navigate, and searchers can find what they’re looking for. The more optimized it is, for multiple mobile devices, the better.

Make a Great Experience

People want a seamless experience. A friendly interface, great content, useful content, and a site that looks great. Make your site mobile-friendly, easy on the eyes, and one which visitors want to come back to. The greater their experience, the higher up you’ll end up ranking organically on the first page results.

To Conclude

Increasing site rank on Google is doable. It will, however, take work and time. If you don’t have much time, paid ads are a great start. And, if you don’t have experience in algorithms, design, and creating a user-friendly site, work with a professional company to help.

The more time you put into building a great site, the higher it’ll rank, and the better it’ll end up doing for the right keywords within your Plumbing + HVAC business.

Source link

Categories
AdWords Business CTA Google Google Ads Local Marketing Local SEO Marketing Off-Page SEO On-Page SEO Organic Traffic Search Engine Optimization SEO

Why is the First Page of Google so Important for Plumbing + HVAC?

Google trumps all search engines, it crawls the web to determine which sites offer the greatest value to searchers, based upon specific keywords. We utilize Google daily, and we rely on the results they deliver to help us find items we purchase, to find businesses, and other relevant content online. Since there’s so much power in the search, as a Plumbing + HVAC business, you want your Plumbing + HVAC site to rank on the first page of Google, if you want to ensure searchers will reach it.

Why Being at the Top Matters

Local results, panels, answer boxes, and so many other tools are available through Google today, that it’s one of the most robust tools a searcher has to utilize today. You have many ways you can stand out as a Plumbing + HVAC business on the platform, so you obviously want to rank at the top. See our article about getting to first of Google.

The Higher the Rank, the Higher the Clickthrough Rate

A majority of the traffic to websites comes from Google; and, it’s a well-known fact that searchers are usually going to click on the top results (usually the first page results) on Google. A study conducted by SmartInsights highlights this point with the following findings

– There’s a 36.4% clickthrough rate for the first result
– 12.5% for the second result
– 9.5% for the third result

This trend continues to decline, and the tenth result on the first page only has a 2.2% clickthrough rate. Understanding why it’s so important to rank at the top of Google, for the specific keywords you’re targeting as a Plumbing + HVAC business? With local results, ad boxes, and other results at the top of the page, there are even fewer than ten slots that are going to gain a majority of the traffic on Google today.

Plumbing + HVAC Companies that aren’t at the top of that list, are missing out on numerous clicks. And, this means you’re missing out on potential new Plumbing + HVAC clients as a result. Obviously, this isn’t what you want to happen when you’re building your website and hoping to grow your Plumbing + HVAC business.

Top Position Traffic Share

Chitika conducted another study on Google search results; in this study, they found that Google captures 33% of all search traffic. This means one-third of people who are searching for a product, service, or business, are reaching that page from Google. They aren’t typing in the website directly into their browser.

Therefore, the higher up you rank on Google, the easier it is going to be for you to receive those clicks, and up to 33% of your traffic, from Google. The higher your search presence, the greater your brand authority is going to be seen by searchers.

How do you Rank? There are Numerous Options You Can Utilize to Increase Google Ranking

Most Plumbing + HVAC business owners make it a primary goal to reach the top ranking spots on Google. And, the good thing is that it is a feasible goal, as long as the Plumbing + HVAC business owner is taking the right approach in order to get there of course.

Google doesn’t focus on the quantity it prefers quality content in determining position rank for a website through search engine results. That’s why having a larger budget or the biggest marketing department, doesn’t necessarily mean a Plumbing + HVAC company is going to be the featured search result on Google. Google utilizes a number of factors to determine where a site ranks in its algorithm. And, this algorithm is constantly changing, so businesses have to keep up with the latest trends in SEO to ensure they’re keeping up with Google’s metrics.

To obtain the first-page status, businesses can utilize various tools in their arsenal which include

  • Organic ranking, which can be achieved through blog posts, guest blogging, and website traffic
  • The Google My Business Page, which lists the company address and contact information
  • Paid-for ads, which include landing pages and PPC (pay per click) ads on Google
  • Snippets of the website, which show up in the Google “answer box” for questions people are asking about the industry/business.

The more tools you utilize as a Plumbing + HVAC business, the higher your rank will crawl on Google. So, don’t simply rely on posting blogs or adding new products. Utilize paid ads, organic results, and make sure your site is as useful to your Plumbing + HVAC visitor as possible, to start seeing it climb the ranks in Google search results.

Source link

Categories
GMB Google Local SEO Off-Page SEO On-Page SEO SEO

A History of Major Google Algorithm Updates/Changes

latest google algorithm update 2020 latest google algorithm update 2020latest google algorithm update 2020

Every year, Google makes several changes to search. In 2018, they reported an incredible 3,234 updates — an average of almost 9 per day, and more than eight times the number of updates in 2009. While most of these changes are minor, Google occasionally rolls out a major algorithmic update (such as Panda and Penguin) that affects search results in significant ways.
For search marketers, knowing when major Google updates happened can help explain changes in rankings and organic website traffic and ultimately improve search engine optimization.
Below, we’ve listed the significant algorithmic changes that have had the biggest impact on Search.

Recent Google Changes That Impact SEO

Panda Update – February 2011

Panda launched on February 24, 2011. It was aimed at dealing with quality and optimization issues that the search engine identified in several websites indexed at the time. It assigns a quality score to webpages, which are then used as a ranking factor. The Panda Update is also known as the Farmer Update. When this update was implemented, it had a significant impact on a broad range of companies that operated online. Panda was introduced to improve search quality by eliminating prevailing content farms as well as spam sites that were designed to take advantage of Google’s vulnerabilities.
Panda has done excellent at cleaning up low-quality sites that occupy valuable SERP real estate. The update did not come without its share of problems, especially for companies with e-commerce initiatives. Websites, both big and small, started disappearing from the usual keyword ranks they had previously owned for years. Lots of companies were impacted negatively and were utterly unable to recover traffic.
Numerous updates have been made to the Panda Update, with most of them focusing on eliminating obstructive spam sites. These Panda updates have concentrated on getting advertisers to achieve their maximum search potential.

Penguin Update – April 2012

This was launched on April 24, 2012. This update specifically targeted link spam as well as manipulative link building practices. Matt Cutts, head of the Google webspam team, officially announced the update via Twitter as the Penguin Algorithm Update. It was an extension to the Panda Update and was Google’s response to the increasing practice of black hat search engine optimization techniques, which are used to gain higher search rankings in ways that violate search engine guidelines. Many updates were made to the Penguin algorithm since its launch in 2012 including;
Google Penguin 1.1(March 26, 2012)
Google Penguin 1.2 (October 5, 2012)
Google Penguin 2.0 (May 22, 2013)
Google Penguin 2.1 (October 4, 2013)
Google Penguin3.0 (October 17, 2014)
Google Penguin 4.O (September 23, 2016)
With the last update, Penguin became a part of the core algorithm, meaning it evaluates websites and links in real-time.

Hummingbird Update – August 2013

The Hummingbird Update was launched on August 22, 2013. The name Hummingbird came from the speed and precision of the update. This new algorithm allows Google to understand phrases better, providing precise results to complex search queries. It expands the brand content strategy to have more informational content on their site. Also, it gives substitutions as a user enters the query. It also brings out results far more complex search queries. Google’s knowledge graph also appears more often than it did previously, giving more direct answers in search results.
Hummingbird has improved how users are sent to a specific page and directed to the information they are seeking. Hummingbird has also promoted voice-powered searches, helping to create a smarter search engine that can better decipher user intent. Hummingbird update has been branded “the heart of Google’s search engine” as it can filter billions of pages to find the most relevant search results.

Pigeon Update – July 2014

Google’s Pigeon was released on July 24, 2014. This Google algorithm update, unlike its predecessors, was designed to give more accurate and relevant local search results. Google rewarded local businesses that had a strong organic presence with better visibility in traditional search results. Several updates on Pigeon have been made since 2014.
In many ways, Pigeon can be described as not being punitive; rather, it serves a specific group of users best.

Mobile Update – April 2015

This was launched on April 21, 2015. This update ensures that when users use the search engine on their mobile phones, mobile-friendly pages rank closer to the top. This is to provide optimum usability and speed.

Rank Brain Updates – October 2015

These updates were launched on October 26, 2015. It worked like a refresh to Google’s Hummingbird algorithm. It helped Google to understand user queries better than before.

Possum Updates – September 2016

It was launched on September 1, 2016. It basically helped to ensure that locations given to the users were as accurate to the users’ current location as possible

Fred Update – March 2017

This was launched on March 8, 2017, and is one of the latest of Google’s major confirmed updates. It helps to ensure that Google’s webmaster guidelines are adhered to by targeting violations.

Core Update – June 2019

In a rare move, Google announced they would be releasing a new update prior to rolling it out. The update is thought to have affected low-quality news sites while boosting trusted aggregator sites. It may have also affected video carousels, with many YouTube channels seeing 25% increases in traffic.

Broad Core Algorithm Update – September 2019

Broad updates don’t tend to target anything specific; instead, they improve the overall effectiveness of Google’s systems. This can lead to drops or gains in the ranking, and the main advice from Google is to focus on producing quality content. These updates won’t penalize any websites, but they will reassess any new content featured in search results since the last update, and possibly rank quality content higher. Content improvements can aid recovery from any drop in ranking.

BERT Update – October 2019

Allegedly one of the most significant changes to Google search in the past five years, the BERT update focused on better understanding search queries. Google’s official explanation was:
“These improvements are oriented around improving language understanding, particularly for more natural language/conversational queries, as BERT can help Search better understand the nuance and context of words in Searches and better match those queries with helpful results.
Particularly for longer, more conversational queries, or searches where prepositions like “for” and “to” matter a lot to the meaning, Search will be able to understand the context of the words in your query. You can search in a way that feels natural for you.”
For more info check out- source

Categories
Digital Marketing Google

How to Upload a File to Google Drive Through Google Sheets

I recently switched from our agency using Trello as our project management system to actually using Google Sheets instead and the transition as been amazing except one thing… We weren’t able to easily upload files directly to a task as we could with Trello. So I knew you could do a lot through app scripts in Google Sheets so I looked for a couple of solutions and yes the theory was proven in 2014 but the code was out of date and not working, so I had my developer updated the code and now it works flawlessly. Here are instructions if you want to have the capabilities of uploading a file directly to a google sheet and only display the Google Drive URL in the cell.

Here is a Google Sheet SAMPLE, just make a copy and edit.

Instructions

  • Go to > Tools > Script editor
    • Provide a name for the Script (we used Upload_Files)
    • Copy and paste the below code in the “Code.gs” file
      • NOTE: Be sure to insert your Google Drive folder id

Folder_Id = '1dsUl22eeCPSE7-Lpa7VGkR3Jx5TaLc5z'
function onOpen(e){
  var ss = SpreadsheetApp.getActiveSpreadsheet()
  var menuEntries = [];
  menuEntries.push({name: "File", functionName: "doGet"});
  ss.addMenu("Attach", menuEntries);
}
function upload(obj) {
  var file = DriveApp.getFolderById(Folder_Id).createFile(obj.upload);
  var activeSheet = SpreadsheetApp.getActiveSheet();
  var File_name = file.getName()
  var value = 'hyperlink("' + file.getUrl() + '";"' + File_name + '")'
  var activeSheet = SpreadsheetApp.getActiveSheet();
  var selection = activeSheet.getSelection();
  var cell = selection.getCurrentCell()
  cell.setFormula(value)
  return {
    fileId: file.getId(),
    mimeType: file.getMimeType(),
    fileName: file.getName(),
  };
}
function doGet(e) {
  var activeSheet = SpreadsheetApp.getActiveSheet();
  var selection = activeSheet.getSelection();
  var cell = selection.getCurrentCell();
  var html = HtmlService.createHtmlOutputFromFile('upload');
  SpreadsheetApp.getUi().showModalDialog(html, 'Upload File');
}

 

    • Still in the Script Editor click on File > New > HTML script
      • Insert the following code in that file between the two body tags

<!DOCTYPE html>
<html>
<head>
<base target="_top">
<link rel="stylesheet" href="https://ssl.gstatic.com/docs/script/css/add-ons1.css">
</head>
<body>
<form> <!-- Modified -->
<div id="progress" ></div>
<input type="file" name="upload" id="file">
<input type="button" value="Submit" class="action" onclick="form_data(this.parentNode)" >
<input type="button" value="Close" onclick="google.script.host.close()" />
</form>
<script>
function form_data(obj){ // Modified
google.script.run.withSuccessHandler(closeIt).upload(obj);
};
function closeIt(e){ // Modified
console.log(e);
google.script.host.close();
};
</script>
</body>
</html>
  • Go back to your google sheet and refresh that page, then you should now see an “attach” button in the menu
    • Select a cell and hit attach and upload a file and watch the cell populate with a google drive attachment URL
Categories
Google Google Algorithm Off-Page SEO On-Page SEO Organic Traffic SEO

Improve Your Rankings by Gaining Google’s Trust Algorithm

You’ve been there. You designed a beautiful website, filled it with engaging content, and optimized it for SEO but then the moment of truth arrived.
You typed your keyword into Google, sure that your new website would at least make it to page one or even the top spot. But to your disappointment, it was nowhere in sight, not even on page two.
What went wrong?
Why did your site not rank as highly as you expected?
Does Google hate you?
No, it has nothing against you. It just doesn’t trust you, at least not yet…

How Google Works

But why doesn’t Google trust you? To know the reason ‘why’ you must first understand how it works. In the past, keywords were the main ranking factor. So with a high keyword density, your site was sure to rank highly.
Today, however, the algorithms prefer relevance to keywords. A relevant website provides value, gains people’s trust, and attracts more visitors. And in turn, Google rewards it with a high ranking.
Which brings us to the next question: How do you gain Google’s trust? Here are a few ways how.

Proper Indexing

When your website launches, Google’s robots crawl over it, searching for key data. At the top of their search list are keywords, domain age, domain authority, and content quality – all key ranking factors. Shortly after, the bots send the data back to the search engine for indexing and ranking.
Now, what happens when they fail to crawl over your site properly? Two things.
One, insufficient data makes it back to Google, which then considers your site less trustworthy than it really is. For this reason, confirm through Google Analytics or domain.com whether your page is properly indexed. If it isn’t, request to have the bots crawl over it again.
Two, no data at all finds its way to Google. Your site remains unindexed and, therefore, invisible to internet users. In such cases, take another look at your robots.txt file. It tells the bots which pages to crawl and not to crawl. If it’s poorly coded, it stops them from reading your entire site. So read its contents carefully and correct any errors you find.

Proper Website Design

Google trusts well-designed websites for obvious reasons. They’re more engaging and user-friendly. And they all have the following features in common.
For starters, they work on mobile devices, read flash, and contain image captions or alt tags. What’s more, they feature straightforward menus and live links, making them easy to navigate.
If your site fails to meet these requirements, upgrade it. Otherwise, Google will drop its ranking.

High Traffic

Internet users looking to search engines for one thing only – answers. After typing a keyword or question in the search bar, they expect the links in the results page to provide a solution to their problem. So when they click on your link and it provides none, they quickly leave it, never to return.
But if your link answers their queries, they flock to your site in droves. Google then notices the increase in traffic and rightly assumes you provide value to your visitors. And in response, it boosts your trust ranking

Google’s Guidelines

Google frowns upon and even penalizes any site, which violates its guidelines. Is your website guilty of these violations? Let’s find out.
Have you duplicated pages, used spammy links, or written worthless content? And has your site been recently hacked into? If you’ve answered “yes” to any of those questions-fix the violations or Google will continue to distrust you.

Original Content

Have you ever opened a website, only to discover that it’s a carbon copy of the one you’ve just visited? How did that make you feel? Disgusted, most likely.
So why should Google feel any differently? In fact, it hates copied content so much that it has created algorithms not only to detect plagiarism but also to penalize it.

Fresh Content

You created original, useful content years back, and it ranked highly. But since then, its ranking has steadily dropped, yet you’ve not altered the content. What could be the problem?
It’s your doing nothing. Google loves fresh content. But that doesn’t mean you have to write new material every day. A post a week is often enough to maintain high trust rankings. Alternatively, update your current copy regularly.

Keyword Use

Earlier, we saw that Google no longer focuses on keywords as it used to in the past. Should you then ignore them altogether? Absolutely not!
Researched and targeted correctly, keywords drive traffic to your site. After all, they reveal better than anything else what it’s all about. But when using them, focus less on density and more on LSI keywords, which are keywords related to the main keyword.

Anchor Text

It’s common practice to use keywords, both chose and LSI, as anchor text. Unfortunately, keywords sometimes sound unnatural when used in this way. And when they do, Google notices.
Its Penguin algorithm then considers your content spammy and untrustworthy. Even worse, it demotes you from your rankings, the penalty it reserves for all spam.

High-Quality Links

As you’re well aware, links raise your SEO profile. But in your quest to add them to your site, avoid any linking to and from new, low-authority, or banned websites. Google considers such links as questionable and understandably so.
Now, what do you do if you already have them on your site? You have two options. One, remove them and replace them with better ones. Or two, disavow them.

User Experience

Earlier, we saw that Google loves well-designed websites with a focus on user experience. But what exactly is user-experience and how can you apply it to your site? For the answer, think back to your own experience.
Don’t you just love fast-loading sites with easy navigation, few pop-ups, no broken links, and engaging content? So will your site’s visitors.

Engaging Content

To grab your visitor’s attention and keep it, create engaging content. Besides the rules of grammar, also apply the rules of common sense. For instance, write short sentences and paragraphs.
Unlike large blocks of text, they seem less intimidating. Likewise, avoid jargon to make your text readable.

Mobile Compatibility

Rather than use a desktop computer, most internet users now access the web through their mobile devices. Google knows this. So from 2018, it has been prioritizing mobile-friendly websites in its search results and index. To make the most of this change, ensure your site is mobile-compatible.

Social Media Compatibility

As far as Google is concerned, social media is not yet a ranking factor. But make no mistake: The platform directs traffic to your site, which as we saw earlier boosts your rankings. So post regularly on social media and make sure to include social media links in your site.

Conclusion

To rank highly on Google, focus on building trust with both the search engine and your visitors. Fortunately, this is an easy thing to do provided you’re willing to apply yourself.