How I programmatically created 100+ pages using Webflow for SEO
Wanted to share a quick workflow I used to create 100+ pages for SEO for No Code MBA programmatically.
The pages are comparison pages (ie. Bubble vs. Webflow).
-
I already have individual tool pages in my Webflow CMS as well as an in-depth no-code tool guide with benefits/drawbacks/recommendation of 17 different no-code tools.
-
I added those benefits, drawbacks, etc as fields in the individual tools on their CMS pages.
-
I created a new CMS Collection called "Compare" which has two reference fields: Tool 1 and Tool 2. This way I'm able to pull in all the information (including the benefits, drawbacks, etc) from each Tool's CMS item.
-
I used a formula in Google Sheets to create 100+ unique pairs so every combination of tools is covered.
-
I used Make (formerly integromat) to create all the CMS items of comparisons.
-
Once all the data was in place in my Webflow CMS, I designed the page.
Still have some more work to do to optimize the page and improve the copy, but here's a comparison of Webflow vs. Squarespace
Let me know if you have any questions!
That's awesome! A big time saver and easy to add to going forward
Thanks!
Very cool, well done Seth. Keep us posted on your traffic explosion! 🔥
Nice. We did a similar thing on webflow for bank integrations. We saw an initial uptick in impressions and ranked keywords, but that quickly faded. Does Google's algo penalise things like this? Especially if the keywords are not semantically related to your core offering.
Hmm, not sure! I do think if the keywords aren't related to the core offering then it might not be useful to users searching and then they'll drop off, which would hurt the ranking
What was the Google formula you've used to create the pairs? How did you handle the other direction? When you have page Tool1 vs Tool2 what will happen to Tool2 vs Tool1? Or Google is smart enough to know this?
I did some searching on Stack Overflow that only gave me Tool 1 vs Tool 2 (and not also Tool 2 vs Tool 1).
Below is the formula - just have your list in column A :)
=ARRAYFORMULA(SPLIT(SORT(
TRANSPOSE(SPLIT(CONCATENATE(REPT(UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),",")))&","&
TRANSPOSE(UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),",")))), (
UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),",")))<=
TRANSPOSE(UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),",")))))*
REGEXMATCH(CONCATENATE(","&SUBSTITUTE(TEXTJOIN(",",1,A2:A),",",",,")&","&CHAR(9)),"(,"&
UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),",")))&",[^\t],"&
TRANSPOSE(UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),","))))&",)|(,"&
TRANSPOSE(UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),","))))&",[^\t],"&
UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),",")))&",)"))&CHAR(9)),CHAR(9)))),","))
what's the formula??
I did some searching on Stack Overflow to find a formula that worked!
Below is the formula - just have your list in column A :)
=ARRAYFORMULA(SPLIT(SORT(
TRANSPOSE(SPLIT(CONCATENATE(REPT(UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),",")))&","&
TRANSPOSE(UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),",")))), (
UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),",")))<=
TRANSPOSE(UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),",")))))*
REGEXMATCH(CONCATENATE(","&SUBSTITUTE(TEXTJOIN(",",1,A2:A),",",",,")&","&CHAR(9)),"(,"&
UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),",")))&",[^\t],"&
TRANSPOSE(UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),","))))&",)|(,"&
TRANSPOSE(UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),","))))&",[^\t],"&
UNIQUE(TRANSPOSE(SPLIT(JOIN(",",TEXTJOIN(",",1,A2:A)),",")))&",)"))&CHAR(9)),CHAR(9)))),","))
Very cool, did you run into any issues?
Also for SEO a directory page on https://www.nocode.mba/compare would help a lot I think with all the comparisons.
Also, just added that compare page! :)
https://www.nocode.mba/compare
What kind of issues? Good idea on the directory page! Will def add that
Adding tables, adding symbols with collections anything like that.
So far everything went pretty smoothly!
Cool, did you think about adding a table with all the features you think are important for a website builder and showing cross or tick for each platform?
That's a great idea, I should add that!