YOYAO Hsueh - Topical Maps Unlocked

[Satoru Gojo]

Satoru Gojo submitted a new resource:

YOYAO Hsueh - Topical Maps Unlocked - YOYAO Hsueh - Topical Maps Unlocked

What You Get:​

Topical Authority Made Simple​

A topical map is a visual representation of the main topics, subtopics, and supporting content within your industry. It allows you to clearly outline the scope and depth of your knowledge and expertise, and helps you organize and present your content in a logical and easily digestible way.

This course is...

Read more about this resource...

 

[tobbybrocoff]

Thanks

 

[aamir0066]

Thanks

 

[Wallwood]

anyone can share spreeadsheet template as per course material ?

 

[PhD_in_SEO]

thanks

 

[rowopade2000]

Thanks

 

[misterk136]

anyone can share spreeadsheet template as per course material ?

Did you get anything on resources?

 

[neilman]

Topical maps and LSI is becoming super important in SEO. Very many thanks for making this available.

 

[linux3d]

anyone can share spreeadsheet template as per course material ?

I was able to find this:

Please, Log in or Register to view URLs content!

Please, Log in or Register to view URLs content!

Update:

To find the xml use this:

Please, Log in or Register to view URLs content!

Create new Spreadsheet and add this:

SITEMAP URL

URL
=IMPORTXML(A2, "//*[local-name()='loc']")

HTTPs
=IF(ISNUMBER(SEARCH("https", B2)), "HTTPS: OK", "HTTP:")

DOMAIN
=MID(SUBSTITUTE(SUBSTITUTE(B2,"http://",""),"https://",""),1,FIND("/",SUBSTITUTE(SUBSTITUTE(B2,"http://",""),"https://",""))-1)

DIR1
=ARRAYFORMULA(IF(ISBLANK(B2:B), "", REGEXEXTRACT(B2:B, "^https?://[^/]+/([^/]+)"))
)
DIR2
=ARRAYFORMULA(IF(B2<>"", IMPORTXML(B2, "//*[contains(@class,'entry-title')]"), ""))

 

[Kevin1005]

Can anyone share mega or drive link please?