How to use the 3 Google Spreadsheet Formulas to find and Display Values that are Equal to our Goal Value in specific spreadsheet cell
In Short the Google Spreadsheet Formula combination with the following formulas:
- INDEX
- FILTER
- REGEXMATCH
The Combination of these 3 Google Spreadsheet Formulas will search in specific Columns and Look for Columns Data to be Equal to the latest Cell from the formula E2 for example
For Example if you have 4 Columns with Data from Column A1 to Column D
The FILTER formula will look in All Columns and Rows from A1 to C20 for values in their Cells and Match the REGEXMATCH wich is our main Value to Search for and will Make MAtch equal to our Column E1 Value
If there is a Match from D1:D20 with our Goal in E1 the Related Row from Columns A1:D20 will be Displayed next to E1 and all the Values we are looking for
The Formula you can test and use for your Google Spreadsheet Tables and Needs
Get the formula below to test is with your Google Spreadsheet
=INDEX(FILTER($A$1:$C$20,REGEXMATCH($D$1:$D$20,$E1)))
26/08/2022 by SEO Book Pro
HTML <abbr> Tag
Article Details and Information
SEO Book Pro Headline Feed
rss_feedDo you have content that you want on SEO Book Pro?
Here are a few ways to submit it to us.
Subscribe to Our Newsletter 
Definition and Usage
The <abbr> tag defines an abbreviation or an acronym, like “HTML”, “CSS”, “Mr.”, “Dr.”, “ASAP”, “ATM”.
Tip: Use the global title attribute to show the description for the abbreviation/acronym when you mouse over the element.
Global Attributes
The <abbr> tag supports the Global Attributes in HTML.
Event Attributes
The <abbr> tag supports the Event Attributes in HTML.
04/07/2022 by SEO Book Pro
HTML <a> Tag
Article Details and Information
SEO Book Pro Headline Feed
rss_feedDo you have content that you want on SEO Book Pro?
Here are a few ways to submit it to us.
Subscribe to Our Newsletter
The <a> tag defines a hyperlink, which is used to link from one page to another. The most important attribute of the </a><a> element is the href attribute, which indicates the link’s destination.</a>
By default, links will appear as follows in all browsers:
- An unvisited link is underlined and blue
- A visited link is underlined and purple
- An active link is underlined and red
Tips and Notes
Tip: If the <a> tag has no href attribute, it is only a placeholder for a hyperlink.</a>
Tip: A linked page is normally displayed in the current browser window, unless you specify another target.
04/07/2022 by SEO Book Pro
Advanced Master Guide for Technical SEO Dashboard
Article Details and Information
SEO Book Pro Headline Feed
rss_feedDo you have content that you want on SEO Book Pro?
Here are a few ways to submit it to us.
Subscribe to Our Newsletter
Pro Audit Dashboard for Web Developers and SEO Webmasters with Google Stack
This Step by Step Advanced Guide is for Web Developers and Technical SEO’s to learn and build a Pro Technical SEO and Website Audit Dashboard from Scratch with Google Products to run Live Audits for Website and Pages.
Pros and Cons or Good Points and Bad Points of Building your Custom Audit Dashboard with Google
This is not an a recommendation, this is a Out of the Box Professional Tool ( Workplace Build with Love and stored ideas from 20 years of Experience Web Developer and SEO Webmaster – meet the developer on LinkedIn )
This is an advanced tool that is not for everyone and need a good technical and programming knowledge and skills to setup and build your own Audit Dashboard to use it on a daily basis without need of the most common and well known tools on the market ( Check the top 10 Paid Website and SEO Audit Tools )
There are 3 Main Key Elements to Start think about and Draw your Future Website and SEO Audit Dashboard Architecture
- Tools you need to start
- Programs you need to start
- Skills and Knowledge you need to start
05/06/2022 by SEO Book Pro
WordPress Lazy Load Functions – Enable Lazy Load for your WordPress Site
Article Details and Information
SEO Book Pro Headline Feed
rss_feedDo you have content that you want on SEO Book Pro?
Here are a few ways to submit it to us.
Subscribe to Our Newsletter
WordPress Default Lazy Load Functions
No Plugin to Enable Lazy Load for your WordPress Site. Add the Following snippet code in your WordPress Template Root Folder in the functions.php file at the end of your code.
// WordPress Lazy Load Functions – Enable Lazy Load for your WordPress Site
add_theme_support( ‘lazy-load’ );
16/04/2022 by SEO Book Pro
What are the Prices by domain ending on Google
Article Details and Information
SEO Book Pro Headline Feed
rss_feedDo you have content that you want on SEO Book Pro?
Here are a few ways to submit it to us.
Subscribe to Our Newsletter
Google Domains supports the following top-level domains (TLDs)
| .academy | $30 USD |
| .accountant | $30 USD |
| .accountants | $120 USD |
| .actor | $40 USD |
| .agency | $20 USD |
| .airforce | $30 USD |
| .apartments | $60 USD |
| .app | $14 USD |
| .army | $30 USD |
| .art | $14 USD |
| .associates | $30 USD |
| .attorney | $40 USD |
| .auction | $30 USD |
| .autos | $15 USD |
| .band | $20 USD |
| .bar | $80 USD |
| .bargains | $30 USD |
| .best | $20 USD |
| .bid | $30 USD |
| .bike | $30 USD |
| .bingo | $50 USD |
| .bio | $70 USD |
| .biz | $15 USD |
| .black | $60 USD |
| .blog | $30 USD |
| .blue | $20 USD |
| .boats | $15 USD |
| .boutique | $30 USD |
| .builders | $30 USD |
| .business | $12 USD |
| .buzz | $40 USD |
| .ca | $12 USD |
| .cab | $30 USD |
| .cafe | $40 USD |
| .camera | $40 USD |
| .camp | $40 USD |
| .capital | $50 USD |
| .cards | $30 USD |
| .care | $30 USD |
| .careers | $50 USD |
| .cash | $30 USD |
| .casino | $130 USD |
| .catering | $30 USD |
| .cc | $20 USD |
| .center | $20 USD |
| .ceo | $100 USD |
| .charity | $30 USD |
| .chat | $40 USD |
| .cheap | $30 USD |
| .church | $40 USD |
| .city | $20 USD |
| .claims | $60 USD |
| .cleaning | $40 USD |
| .clinic | $50 USD |
| .clothing | $30 USD |
| .cloud | $20 USD |
| .club | $13 USD |
| .co | $30 USD |
| .co.in | $11 USD |
| .co.nz | $19 USD |
| .co.uk | $12 USD |
| .coach | $60 USD |
| .codes | $50 USD |
| .coffee | $30 USD |
| .com | $12 USD |
| .com.au | $12 USD |
| .com.mx | $20 USD |
| .community | $30 USD |
| .company | $14 USD |
| .computer | $30 USD |
| .condos | $50 USD |
| .construction | $30 USD |
| .consulting | $30 USD |
| .contact | $12 USD |
| .contractors | $30 USD |
| .cool | $30 USD |
| .coupons | $60 USD |
| .credit | $120 USD |
| .creditcard | $130 USD |
| .cricket | $12 USD |
| .cruises | $50 USD |
| .dance | $20 USD |
| .date | $30 USD |
| .dating | $50 USD |
| .day | $12 USD |
| .de | $7 USD |
| .deals | $40 USD |
| .degree | $40 USD |
| .delivery | $60 USD |
| .democrat | $30 USD |
| .dental | $50 USD |
| .dentist | $40 USD |
| .design | $40 USD |
| .dev | $12 USD |
| .diamonds | $50 USD |
| .digital | $40 USD |
| .direct | $40 USD |
| .directory | $20 USD |
| .discount | $30 USD |
| .doctor | $100 USD |
| .dog | $40 USD |
| .domains | $30 USD |
| .download | $30 USD |
| .earth | $20 USD |
| .eco | $80 USD |
| .education | $20 USD |
| $20 USD | |
| .energy | $120 USD |
| .engineer | $30 USD |
| .engineering | $50 USD |
| .enterprises | $30 USD |
| .equipment | $20 USD |
| .estate | $30 USD |
| .events | $30 USD |
| .exchange | $30 USD |
| .expert | $50 USD |
| .exposed | $20 USD |
| .express | $30 USD |
| .fail | $30 USD |
| .faith | $30 USD |
| .family | $20 USD |
| .fan | $40 USD |
| .fans | $12 USD |
| .farm | $30 USD |
| .finance | $60 USD |
| .financial | $50 USD |
| .fish | $30 USD |
| .fitness | $30 USD |
| .flights | $50 USD |
| .florist | $30 USD |
| .football | $30 USD |
| .forsale | $30 USD |
| .foundation | $30 USD |
| .fr | $10 USD |
| .fun | $20 USD |
| .fund | $50 USD |
| .furniture | $50 USD |
| .futbol | $13 USD |
| .fyi | $20 USD |
| .gallery | $20 USD |
| .games | $20 USD |
| .gifts | $40 USD |
| .gives | $30 USD |
| .glass | $40 USD |
| .global | $80 USD |
| .gmbh | $30 USD |
| .gold | $120 USD |
| .golf | $60 USD |
| .graphics | $20 USD |
| .gratis | $20 USD |
| .green | $80 USD |
| .gripe | $30 USD |
| .group | $20 USD |
| .guide | $40 USD |
| .guru | $28 USD |
| .haus | $28 USD |
| .health | $80 USD |
| .healthcare | $60 USD |
| .hockey | $60 USD |
| .holdings | $50 USD |
| .holiday | $50 USD |
| .homes | $15 USD |
| .hospital | $50 USD |
| .host | $120 USD |
| .house | $30 USD |
| .how | $30 USD |
| .icu | $12 USD |
| .immo | $40 USD |
| .immobilien | $30 USD |
| .in | $12 USD |
| .industries | $30 USD |
| .info | $12 USD |
| .ink | $28 USD |
| .institute | $20 USD |
| .insure | $60 USD |
| .international | $20 USD |
| .investments | $80 USD |
| .io | $60 USD |
| .irish | $14 USD |
| .it | $12 USD |
| .jetzt | $20 USD |
| .jewelry | $60 USD |
| .jp | $40 USD |
| .kaufen | $30 USD |
| .kitchen | $40 USD |
| .land | $30 USD |
| .lawyer | $40 USD |
| .lease | $50 USD |
| .legal | $60 USD |
| .life | $40 USD |
| .lighting | $20 USD |
| .limited | $30 USD |
| .limo | $50 USD |
| .live | $20 USD |
| .llc | $30 USD |
| .loan | $30 USD |
| .loans | $120 USD |
| .love | $30 USD |
| .ltd | $20 USD |
| .luxury | $40 USD |
| .maison | $50 USD |
| .management | $20 USD |
| .market | $40 USD |
| .marketing | $30 USD |
| .mba | $40 USD |
| .me | $20 USD |
| .media | $30 USD |
| .memorial | $60 USD |
| .men | $30 USD |
| .mobi | $20 USD |
| .moda | $30 USD |
| .money | $40 USD |
| .mortgage | $40 USD |
| .movie | $320 USD |
| .mx | $40 USD |
| .navy | $30 USD |
| .net | $12 USD |
| .network | $20 USD |
| .new | $500 USD |
| .news | $30 USD |
| .ninja | $19 USD |
| .nl | $8 USD |
| .one | $12 USD |
| .online | $30 USD |
| .ooo | $30 USD |
| .org | $12 USD |
| .page | $10 USD |
| .partners | $50 USD |
| .parts | $30 USD |
| .party | $30 USD |
| .photography | $20 USD |
| .photos | $20 USD |
| .pictures | $11 USD |
| .pizza | $60 USD |
| .place | $15 USD |
| .plumbing | $40 USD |
| .plus | $40 USD |
| .press | $60 USD |
| .pro | $20 USD |
| .productions | $30 USD |
| .promo | $20 USD |
| .properties | $30 USD |
| .pub | $30 USD |
| .pw | $9 USD |
| .racing | $30 USD |
| .realty | $400 USD |
| .recipes | $50 USD |
| .red | $20 USD |
| .rehab | $30 USD |
| .reise | $120 USD |
| .reisen | $20 USD |
| .rentals | $30 USD |
| .repair | $30 USD |
| .report | $20 USD |
| .republican | $30 USD |
| .rest | $40 USD |
| .restaurant | $60 USD |
| .review | $30 USD |
| .reviews | $20 USD |
| .rip | $20 USD |
| .rocks | $13 USD |
| .run | $20 USD |
| .sale | $30 USD |
| .salon | $50 USD |
| .sarl | $40 USD |
| .school | $40 USD |
| .schule | $20 USD |
| .science | $30 USD |
| .services | $30 USD |
| .shoes | $40 USD |
| .shopping | $30 USD |
| .show | $40 USD |
| .singles | $30 USD |
| .site | $20 USD |
| .ski | $50 USD |
| .soccer | $20 USD |
| .social | $30 USD |
| .software | $40 USD |
| .solar | $40 USD |
| .solutions | $20 USD |
| .soy | $20 USD |
| .space | $20 USD |
| .store | $50 USD |
| .stream | $30 USD |
| .studio | $20 USD |
| .style | $40 USD |
| .supplies | $20 USD |
| .supply | $20 USD |
| .support | $20 USD |
| .surgery | $50 USD |
| .systems | $20 USD |
| .tax | $50 USD |
| .taxi | $60 USD |
| .team | $40 USD |
| .tech | $40 USD |
| .technology | $20 USD |
| .tennis | $60 USD |
| .theater | $60 USD |
| .tienda | $50 USD |
| .tips | $20 USD |
| .tires | $120 USD |
| .today | $20 USD |
| .tools | $30 USD |
| .tours | $60 USD |
| .town | $30 USD |
| .toys | $40 USD |
| .trade | $30 USD |
| .training | $30 USD |
| .tube | $30 USD |
| .uk | $12 USD |
| .university | $50 USD |
| .uno | $20 USD |
| .us | $12 USD |
| .vacations | $30 USD |
| .vegas | $60 USD |
| .ventures | $50 USD |
| .vet | $30 USD |
| .viajes | $50 USD |
| .video | $20 USD |
| .villas | $50 USD |
| .vin | $60 USD |
| .vision | $30 USD |
| .vote | $80 USD |
| .voyage | $50 USD |
| .watch | $30 USD |
| .webcam | $30 USD |
| .website | $20 USD |
| .wiki | $28 USD |
| .win | $30 USD |
| .wine | $60 USD |
| .works | $30 USD |
| .world | $40 USD |
| .wtf | $30 USD |
| .xyz | $12 USD |
| .zone | $30 USD |
04/04/2022 by SEO Book Pro
How to create tree lines icon for your mobile nav for FREE?
Article Details and Information
SEO Book Pro Headline Feed
rss_feedDo you have content that you want on SEO Book Pro?
Here are a few ways to submit it to us.
Subscribe to Our Newsletter
The Code to implement you tree line nav menu icon
Example HTML Code how to Implement you can find in the SEO Book Pro website below
#SEO – 3 Line Icon for #Mobile Nav – Create a #SVG Icon in less than 2min. #google #slide #gslide
A hamburger menu in less than 5 minutes without any Graphic Design Skills
Learn how to create an FREE .svg Hamburger Menu Icon for your Mobile Website Menu Navigation. Yes is true you can do different Hamburger Menu Icons and test them quickly in less than a 2 minutes without any Graphic Design or Design Tools, Programs. Watch the Video Lesson and Start Making your own FREE .svh Mobile Menu Icons – thee tree line men icon for mobile and responsive menu navigations.
FREE .svg Hamburger Menu Icons Explained
The easies way and top recommendation is to us an Image. Your tree line navigation icon will be very small size less than 30kb and will work like a charm for any mobile navigations and also mobile menus or responsive sites.
- Start 00:00
- Step 1 – Open Gmail in your Browser 00:05
- Step 2 – Go to Google Drive 00:09
- Step 3 – Open Google Slides 00:11
- Step 4 – Create new Slide and Setup Size 500×500 in settings menu 00:13
- Step 5 – Start Drawing your 3 Line Nav Menu 00:20
- Step 6 – Add Background for Every Single Line 00:40
- Step 7 – Download you SVG icon 00:50
- Step 8 – Save you file on you computer 01:00
- Step 9 – if you like this Trick Subscribe for more Tricks – 01:05
- Step 10 – Thanks for your Subscription – now Share it 01:10
20/03/2022 by SEO Book Pro
Analyze top 100 SERP Results for Query include “Technical SEO”
Article Details and Information
SEO Book Pro Headline Feed
rss_feedDo you have content that you want on SEO Book Pro?
Here are a few ways to submit it to us.
Subscribe to Our Newsletter
We are going to do quick Analyze of the first 100 search queries SERP Page Results for a single and combination of related to the main keyword long tail combination based on just simple method to find keyworsds that are ranking in the SERP and use them to write new content or to increase the current pages for your website/s with new keyword combination that will answer to the user search queries after they First Visit your website and all future possible search they will do to find what they looking for.
Note: Technical SEO or SEO are just Internet Terminology used by Companies to have a Team members Ranking systems and some kind of responsibility in the company hierarchy. This doesn’t mean everyone with SEO in the Title have the right skills, knowledge, tool/s and experience to do quality SEO and Technical SEO audits.
for the long tail search query keyword related to Technical SEO
The Search Query is Combination of the followed Single Words that this Page Will Rank a few Days after this Page for Technical SEO is published and submited in Google
What to Include in the Post/Page to Increase thc Chance to Rank on Better Position in the SERP
First Thing First There are 10 Rules every Technical SEO need to Follow to do Professional SEO and TEchnical SEO Audits to increase the client positions, ranking, impressions, clicks and Lead Generated from the Organic Search.
Look at the SERP Heading MetaTT in your Search Query List and What and How Many Single or Combined Keywords They Have. In Our Case We have 3 Exact Match Keywords and All Possible Keyword Combinations of them That The Google User can do to find what they looking for. For Example we are using our Domain name and the slug/s after the root domain like “seo”, “book”,”pro” these are keywords that answer exact match on the user query and can be used and include as part of the factors which search engines have to display websites on their SERP pages for different search queries.
So Lets make our first Featured Snippet for the Search Engines and SERP to have a chance to get featured on the SERP just adding basic Structured Data in the Content That Doesn’t Need any Coding or Scripts for usage. Read in the FAQ’s Section Below What is the Most Common and Basic Featured Snippet that Everyone Can use to update the Page Content and the way the content is Shown.
Analyze top 100 SERP Results for Query include “Technical SEO”
The Search Query is Combnination of the followed Single Words that this Page Will Rank a few Days after the Page is Published
What to looking on the SERP for my keywords i want to find and rank my pages for?
Look at the SERP Heading MetaTT in your Search Query List and What and How Many Single or Combined Keywords They Have. In Our Case We have 3 Exact Match Keywords and All Possible Keyword Combinations of them That The Google User can do to find what they looking for. For Example we are using our Domain name and the slug/s after the root domain like “seo”, “book”,”pro” these are keywrods that answer exact match on the user query and can be useed andd include as part of the R
What is the Most Common and Basic Featured Snippet
Bulleted Lists include Ordered and NonOrdered lists
13/03/2022 by SEO Book Pro
Why duplicate content might cause an issue with ranking your website on the SERP’s?
Article Details and Information
SEO Book Pro Headline Feed
rss_feedDo you have content that you want on SEO Book Pro?
Here are a few ways to submit it to us.
Subscribe to Our Newsletter
Search Engine Optimization (SEO) Assessment
Looking for answer from this Linked In SEO Assessment Random Question. Search Engine Optimization (SEO) Assessment
Random FAQ’s Examples and Answers
- It makes it difficult for a search engine to determine the original and authoritative content source
- It creates an inability to use canonical URLs, which dramatically reduces crawl effectiveness
- It requires using a 302 redirect, which dilutes PageRank
- It triggers an immediate manual action penalty, which delists an entire domain until the duplicate content is removed
Looking for answer from this Linked In SEO Assessment Random Question
The Correct answer is on this article and is at Above The Fold Section of This Page
Guess Where this Answer for the SEO Assessment
Lean SEO With Examples from SEO Book Pro
06/03/2022 by SEO Book Pro
How to Embed Google Form in HTML Website
Article Details and Information
SEO Book Pro Headline Feed
rss_feedDo you have content that you want on SEO Book Pro?
Here are a few ways to submit it to us.
Subscribe to Our Newsletter
Learn how to add Embedded Google Form Specific Input Fields only for your Website
Add your website information below to register your interest in our SEO Book Pro Tools Library and Functionality
12/09/2021 by SEO Book Pro
SEO Index Experiment 2560 x 1440px – What is the YouTube Channel Recommended Image Size for the Channel art Cover?
Article Details and Information
SEO Book Pro Headline Feed
rss_feedDo you have content that you want on SEO Book Pro?
Here are a few ways to submit it to us.
Subscribe to Our Newsletter
What the default YouTube Channel Cover Image/Media are optimal for Good YouTube Channel Cover?
WorkAround SEO Task you need to Check when you do Basic or Advanced SEO and WebSite/s Audits – Video and Step by Step Guidance to learn how to find, create, update and manage your YouTube Channel Art Cover Image.
What i Need to Do to Customize the banner art for my YouTube Channel?
5 steps to Customize the banner art for my YouTube Channel
What you will need to and how to find best practices for YouTube Channel Art Cover Image?
Image Editing Software/App like
- Photoshop
- Gimp
- to create your awesome cover for your YouTube Channel you can use any Image Editing Software
For Best View you need to triple the size of your Cover Image up to 3 when adding the content and once you are ready to resize your Cover Image for Your YouTube Channel with the Tool from the YouTube Video Editor for your Channel and Editing your channel cover For the best results, use an image that’s at least 2560 x 1440 pixels
- 1x
- 2x
- 3x
Part 1 – Draft 1 for the SERP Index Experiment Article 2560 x 1440px – What is the YouTube Channel Recommended Image Size for the Channel art Cover?
Continue to Draft 2 – Channel customisation
Video spotlight
04/08/2021 by SEO Book Pro
How to Add .html Extension to WordPress Post URLs (Permalinks)?
Article Details and Information
SEO Book Pro Headline Feed
rss_feedDo you have content that you want on SEO Book Pro?
Here are a few ways to submit it to us.
Subscribe to Our Newsletter
Do you want to add .html to all your posts URL in WordPress website? For instance, you want to have a URL like https://seobookpro.com/page-permalink.html instead of the default one. So, how to change the permalink URL for posts in WordPress blog or website?
Within the settings panel. WordPress allows you to easily modify the permalink, or permanent links, to the posts. You can choose to have a post URL with just an ugly search query or make it prettier with date, month, year, post slug, post ID, etc. For this, you need to access the Permalinks settings.
Log in to your WordPress site dashboard
Go to Settings > Permalinks settings page
Choose the desired permalink URL structure
For adding .html to the end of URLs, simply add “.html” at the end of the URL structure.
Suggested URL structures for adding .html at the end
/%post_id%-%postname%.html
/%postname%.html
It is highly recommend that your WordPress peermalink URL structure has the POST ID in the beginning or at the end of the URL. Why? Post IDs are unique to each post, which means the post article that needs to be displayed can be picked from the database easily without having to search. If the post URL structure is limited to the post name, the right post can be displayed only after searching for the match from the list of post titles. Now, this can be a hassle if the website has thousands of posts.
24/05/2021 by SEO Book Pro
