Then you can easily aggregate other SEO metrics, such as links data that you might have in another sheet from a SEMRush export by using a VLOOKUP function and bring the backlinks data in an additional column along the Google search Console ranked pages and queries:
You can do this type of aggregation to identify those pages targeting popular queries, not ranking as well yet, that are not yet attracting many links, to identify opportunities of pages that might need to improve their link popularity.
=IMPORTXML(C2,“//title”)
SEO - Unlock loads of SEO traffic and see real results.
Paid Media - Get better results with the best paid strategies.
Content Marketing - We create content that drives traffic and convert better.
Book a CallIn this case, I use it to validate the first scenario, pages belonging to the Spanish version not ranking in Spanish speaking countries by using the IFS and nested IF functions to first identify if the page belonged to the Spanish or English version:
=arrayformula(iferror(ifs(not(iserror
and then validate if there was a misalignment vs. the identified country of the rankings provided through the Search Analytics Add-on, tagging as “aligned” if it’s a Spanish speaking country and “misaligned” otherwise:
=IF(AND(C2=“Spanish”,OR(D2=“esp”,
Four (4) functions to help you with this include:
UPPER – change all to uppercase
TRIM – remove extra spaces within the data text
NOTE: Instead of “text” in the brackets, you can also insert the cell number, for example (A1). Or you can simply type in =upper() and while your cursor is placed within the empty brackets, you can just click on the desired cell(s). The same principle goes for other Google Sheets Formulas.
=arrayformula(proper(A1:A))
This way you can copy the messy text from column A, correct it and place it nicely formatted in column B.
In order to make your relevant data come to life so it is easier to convey what your SEO efforts are all about, you will want to create and customize graphs (or charts) in Google Sheets.
1. Select the cells you want to include in your graph
If all the data you want to show adds up to 100% – we suggest using a pie chart; if you want to compare data over a certain period of time – use histograms or line graphs, etc.
If you have any further question about SEO, don't hesitate to contact us, we are the best web agency in Montreal.
Select the cells you want to include in your chart then click on "Insert" in the drop-down menu and select "Chart" and finally, once the chart appears, you can customize it using the chart editor located on the right side of the screen.
If all the data you want to display adds up to 100% - we suggest you use a pie chart; if you want to compare data over a certain period of time - use histograms or line charts, etc.
Sawab A, is the co-founder and Managing Partner at OSHARA. He is passionate about Branding and Marketing and he helps businesses grow their brand and reach new heights of success using simple but efficient web technologies and digital marketing. His expertise and ability to listen and execute bring an added value to any team.
Was this article useful?
Laravel is a powerful php framework that allows you to create custom web applications
By definition, a communication agency (marketing) is a company that plans and harmonizes internal and / or external communication on be...
Collecting data from customers is an important marketing strategy since it gives you information on what customers exactly want instead...
Did you already try udpating your joomla website and you got this error : "An error has occurred. 0 Cannot open file for writing log" ...
With the aim of helping companies improve their notoriety through their blogs. Oshara Inc, shares his knowledge about Netlinking in thi...
Like Twitter and Facebook, Instagram offers the possibility for administrators of an Instagram page to certify certain pages. Oshara In...