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

983

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
Does google penalize you if you post content in french and english on a website

I'm trying to encourage content editors to only post content in either English or French. For example we have a French press release but the team are wanting it on our site in French and English. I thought this would fall under duplicate content rules. Does google penalize you if you post content in French and English on a website?
Content Development | | EstherBrice

0
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
Do you think its better to have a published date AND a last updated date ? Does google even look if you updated but left the published date old

Do you think its better to have a published date AND a last updated date on Posts ? Does google even look if you updated but left the published date old I was thinking of adding a "last updated" field to my articles. But is it worth it? or should I just keep it uncluttered and leave only the last published date? I would think that Google would not notice if I updated a last updated meta field since their is a published date field already.
Content Development | | ianizaguirre

1
Using Product Descriptions in Meta Description

Hi All We have over 10000 Products and a while ago we spent some time adding Product Descriptions to the Product Pages, For Example we have Product - Black Snazaroo Face Paint Product Description - Great for Childrens parties, fundraising events, Halloween or other festive faces. An easy makeup to apply and remove. All Snazaroo face paints are Non toxic, Fragrance free and Skin friendly. Snazaroo is suitable for all skin types, however it is always recommended you do a skin patch test on a small area before full application. Unfortuantly our Meta Descriptions really need some work, for example this same page contains the following meta descriptions We realise this could be holding our site back. Is it ok to use the same Product Description inside the Meta Description Tags also, for example can we use the Meta Description for this Page - Thanks
Content Development | | AMG100

0
How do I properly sitemap a site with static pages + Wordpress in it's own directory?

I apologize for the awkward wording in the headline. No to the issue, I have a site with static pages that are created as follows: url.com, url.com/page1, url.com/page2, etc. I then have WordPress install at url.com/blog. What is the proper method for creating a comprehensive sitemap for my entire domain. I like the sitemap feature provided by Yoast SEO plugin but I assume it will only index the wordpress directory (url.com/blog). Any help would be greatly appreciated!
Content Development | | Qcmny

0
Is there a way to repost content (with permission) to another site without being penalized by Google?

I write a monthly Social Media Marketing column for a local Business Journal and the column is printed in their paper as well as posted on their website. Is there any way I can repost these articles on my website's blog without being penalized by Google for "duplicate content"?
Content Development | | vyki

0