Welcome to the Q&A Forum

Browse the forum for helpful insights and fresh discussions about all things SEO.

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Moz Q&A is closed.

After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.

How to create a dynamic visual sitemap using Google sheets?

Content Development

984

peteboyd Subscriber last edited by

Does anyone have a solution where you can use a listing of page names with tiers in a Google spreadsheet and have it dynamically appear in a visual sitemap architecture format within in a Google document?

Thanks in advance Moz community!
1 Reply Last reply
Reply Quote 0

Got a burning SEO question?

Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.

Start my free trial

Browse Questions

View

From

Sorted by

With category

Explore more categories

Related Questions

Best SEO Structure For E-Commerce With Products Using Multiple Categories

site structure seo

Hi all, I am in the process of re-structuring my e-commerce website for better SEO and user experience. I have done some keyword research and would like some advice on how best to structure my site around those keywords. For example, my site (All Things Nature) sells a brand of wooden sculptures (Woodsculp) and I would like to rank for keywords related to that brand, the brand by animal, the brand by collection and the brand by release date.
Examples of keywords could be: Brand by Animal: Woodsculp Dogs, Woodsculp Cats, Woodsculp Elephants
Brand by Collection: Woodsculp Pets, Woodsculp Safari
Brand by Release Date: Woodsculp Christmas 2023, Woodsculp Summer 2022 I would create each of these keywords as a category so that they can be found by a search engine and by users. I would then structure as follows: All Things Nature -> Woodsculp -> Woodsculp by Animal -> Woodsculp Dogs
All Things Nature -> Woodsculp -> Woodsculp by Animal -> Woodsculp Elephants
All Things Nature -> Woodsculp -> Woodsculp by Collection -> Woodsculp Pets
All Things Nature -> Woodsculp -> Woodsculp by Collection -> Woodsculp Safari
All Things Nature -> Woodsculp -> Woodsculp by Release Date -> Woodsculp Christmas 2023
All Things Nature -> Woodsculp -> Woodsculp by Release Date -> Woodsculp Summer 2022 The only problem with this structure is it would take more than 3 clicks (4) for the user to reach a product. How critical is this for good SEO and user experience? Would I be better off getting rid of the ‘Woodsculp by Animal’, ‘Woodsculp by Collection’ and ‘Woodsculp by Release Date’ categories? Structure would look as follows: All Things Nature -> Woodsculp -> Woodsculp Dogs
All Things Nature -> Woodsculp -> Woodsculp Elephants
All Things Nature -> Woodsculp -> Woodsculp Safari
All Things Nature -> Woodsculp -> Woodsculp Christmas 2023 The only thing with this is there would be a lot of categories under the brand name which might make it more difficult for search engines and users to logically follow. Would I be better off getting rid of the brand category and replace them with the keyword categories? Structure would look as follows: All Things Nature -> Woodsculp by Animal -> Woodsculp Dogs
All Things Nature -> Woodsculp by Animal -> Woodsculp Elephants
All Things Nature -> Woodsculp by Collection -> Woodsculp Safari
All Things Nature -> Woodsculp by Release Date -> Woodsculp Christmas 2023 This would organise things more logically but I would then lose the brand category (and the potential of the brand keyword ranking?) Would I be better off choosing one main keyword to use as a category and then use tags for the other categories? Categories: All Things Nature -> Woodsculp -> Woodsculp Dogs
All Things Nature -> Woodsculp -> Woodsculp Elephants Tags: Woodsculp Safari
Woodsculp Christmas 2023 The next issue I have is that I have products which could fall under several different categories. A product called Elijah Elephant, for example could fall under Woodsculp Elephants, Woodsculp Safari and Woodsculp Summer 2022. In previous e-commerce sites I have never assigned multiple categories to one product (I instead have used tags). Is it good practice to organise products under multiple categories for an e-commerce site? Thanks in advance for any help and advice.
Content Development | | nb2e4fg

0
Does Google consider breadcrumbs to be duplicate titles?

duplicate titles multiple titles breadcrumbs google moz

Moz has been flagging a lot of our articles for duplicate titles. I noticed that the website was automatically generating the same words that were used for the titles above the articles and main images. But those are bread crumbs. Does anyone know if Google also considers those duplicate titles? I'm not sure if the screenshot I'm uploading will appear, but this is one of the blog posts the extra wording was showing up on: https://hometowneautorepairandtireofwoodbridge.com/blog/when-why-replace-spark-plugs/
Content Development | | ifixcars

1
I want to use some content that I sent out in a newsletter and post as a blog, but will this count as duplicate content?

I want to use some content that I sent out in a newsletter a while ago - adding it as a blog to my website. The newsletter exists on a http://myemail.constantcontact.com URL and is being indexed by Google. Will this count as duplicate content?
Content Development | | Wagada

0
Using images from Wikipedia, The right way to give credit for them?

Hi, I am writing my first blog post and I have downloaded 9 images from Wikipedia, After reading the confusing legal stuff, I am under the impression that all those images are allowed to be used for other purposes with citing/ giving credit to the owner. At least the ones I download the author said its ok to use them anywhere, for anything So how do i do that? Should I have something like this: Image, underneath-- image credit to xyz (link to Wikipedia page where i downloaded the image) ??? Thanks for you time and explanation.
Content Development | | Davit1985

0
Does Google Dislike Slideshows?

I've noticed a recent drop in organic traffic and a slight dip in rankings. When I looked at who replaced us in the top spots, I noticed text heavy, in depth articles. We produce many articles in the slideshow format. Do you think this is the reason our rankings dropped?
Content Development | | TMI.com

0
Can you use creative commons non-commercial images on a company blog?

Does anyone know if it is okay to use creative commons images on your company blog if they are under the Attribution-NonCommercial-NoDerivs 2.0 Generic license. Technically you are using it on a commercial site, but you are not directly making money from the image or selling it.
Content Development | | ProjectLabs

0
Wordpress Ping List, does pinging Google Help? Could it hurt?

So I was looking at updating my ping list in WP. Some of the lists I have come across have a lot of "blogsearch.google" What does a WP site risk in pinging all of these google properties?
Content Development | | Thos003

0
My WebSite has two sections with overlapping, or redundant articles on the same topics. Google is only listing one or the other article in Search Results. What should I do to have both pages (similiar but unique content ) to be listed?

My Web Site has two sections with overlapping, or redundant articles on the same topics. Google is only listing one or the other article in Search Results. What should I do to have both pages (similar but unique content ) to be listed? Example: http://www.womenshealthcaretopics.com/pregnancy_week_12.htm http://www.womenshealthcaretopics.com/pregnancy_12_weeks.html
Content Development | | docjamesmd

0