Updates with these simple, functions which are time-saving in Google Sheets formulas Prioritize content creation.
To turn your keyword research Google Sheets function and performance of website data into an updated or created content list.
Into URLs with LOWER Turn functions SUBSTITUTE
To your content plan let’s start by adding some new content ideas.
For new pages, if you have a list of keyword targets, with some quick functions you can turn them into URLs.
If your keywords use the function LOWER and are capitalized lowercase you want them to be all,
in as:
(i) =LOWER(A1)
To change any spaces USE SUBSTITUTE to like dashes:
(ii) =SUBSTITUTE(A1,“ ”,“-”)
For SUBSTITUTE is the basic logic:
(i) This string that matches
(ii) This string Into
(iii) In this cell change the content
At once or both do:
(i) =LOWER(SUBSTITUTE(A1,“ ”,“-”))
In your URL and Separate use JOIN to include categories with a slash separate. Add a character JOIN is like CONCATENATE but lets you every cell combing you are.
String or the character include to them spent them at the start, cells to combine then list this list:
(i) =LOWER(SUBSTITUTE(A1,“ ”,“-”))
Folders in your URL use JOIN to include categories them separate slash them. Add a character JOIN but lets between cell each combining you are in.
String to Separate include the character starting at the, combine list the cells then, this like:
(i) =JOIN(“/”,A1,A2)
By itself as your final URL, you might not want to use, starting it easier but then manually pointing spaces.
On Windows Use the shortcut Control + Shift + V Keyboard or you can also do Command + Shift + V to copy on the Mac. URLs use that column use.
Target keywords URL proposed now you have a list to add to your brief content or schedule content.
With CONCATENATE and JOIN functions Change
Which pages let’s say on your website well ist performing updated need to be.
Performance page from Google Analytics you might export start and also Google Search Console.
While your Google Search Console your analytics report reports full URL exports. VLOOKUP you want to use your data to combine one report into.
Your domain uses CONCATENATE to combine the path page with your slug to the URL to get full.
If you have multiple categories JOIN is helpful in your URL. Into column split every folder, and JOIN them combine between them slash.
Use the function and Change URLs with CONCATENATE
To see let’s say you want which pages aren’t performing need and well updated to be.
Google Analytics and Google Search Console you might start
