🎯 Scope
Must have: |
|
|---|---|
Nice to have: |
|
Not in scope: |
|
SEO Workflows Impacted by the AI for SEO Project
Tasks | Current | Future |
|---|---|---|
Inventory Analysis | MANUAL | TOOL-ENABLED , |
Website Analysis | MANUAL | TOOL-ENABLED , MANUAL |
Customer Data Collection & Client Sheet Build | MANUAL | MANUAL |
Keyword Research | MANUAL | TOOL-ENABLED , AI-ENABLED |
Keyword Clustering | MANUAL | TOOL-ENABLED , AI-ENABLED |
Page Planning & Architecture | MANUAL | TOOL-ENABLED , AI-ENABLED , MANUAL |
Content Writing | MANUAL | AI-ENABLED |
Content QA | MANUAL | AI-ENABLED , MANUAL |
Content Posting | MANUAL | MANUAL |
Reporting Prep | MANUAL | TOOL-ENABLED , MANUAL |
Reporting QA | MANUAL | MANUAL |
Performance Analysis | MANUAL | TOOL-ENABLED , AI-ENABLED , MANUAL |
\uD83D\uDEA9 Milestones and deadlines
Milestone | Owner | Deadline | Status |
|---|---|---|---|
Next Actions
Milestone 1 (August)
Planning (1/2 month)
- Determine success KPIs
- Implement Tracking & Reporting (Test, standard SEO, & non-seo groups)
- Determine Create workflows
- Inventory Analysis
- Sitemap Updates
- Keyword Research
- Website Analysis
- Creating Page URLs
- Keyword Clustering
- Generate SEO Optimization Plan (Pages & Architecture)
- Create Prompts
- Prompt For Title Tag
- Prompt for Meta Description
- Prompt For H1
- Prompt for FeaturedBanner
- Prompt for PageFooter
- Finalize Templates
- Select AI Content Detection Tool
- Outline Documentation
- Create Revise Workflow
- Finalize toolsets
- Identify Shared Process Changes with Border Teams
- Content Writing
- Content QA
- Content Posting
Beta Implementation: Cohort 1 (1/2 month)
- Migrate 20 customers: Complete full “First Pass” SEO optimization
Milestone 1
- Process & Toolset Finalized
- Cohort 1 Complete
Milestone 2 (September)
Planning (1/2 month)
- Complete dealer data for all 70 dealers
- Create a plan for content requests and finish all requests
- Add pages for all 70 customers
- Generate content for posting
- Content Posted by Juniper (Link added to work done import)
- Fully process dealers on dealer pages tab
- SEO Monitor Keyword Groups
AI Prompts
Field | Version | Changes | Airtable Code | Prompt |
|---|---|---|---|---|
FeaturedBanner | V1 | <document><p>Looking for a reliable [Product] dealer? Look no further than [Business Name]! We offer a wide range of [Product] for sale, perfect for any adventure seeker. Our dealership is conveniently located in [Location], so stop by today and start exploring the great outdoors with a durable and versatile [Product]!</p> <p>Rev up your next adventure with a [Product] from [Business Name]! Whether you're into [Product], we've got the perfect ride for you. Don't miss out on our unbeatable deals on [Product]. Visit our dealership in [Location] today and find your dream ride!</p> <p>Looking for a [Product] without breaking the bank? Come check out our inventory of [Product] for sale! Our used [Product] are meticulously maintained to ensure optimal performance. Experience the thrill of riding a used [Product] by visiting our dealership today in [Location].</p> <p>Get ready to conquer any terrain with a [Product] from [Business Name]! Our dealership offers a wide selection of [Product] with powerful engines and versatile capabilities. Come visit us in [Location] to see our selection of [Product] for sale. Start your off-road adventures today!</p> <p>Whether you're tearing up off-road trails or need a reliable workhorse, we've got the perfect [Product] for you. As your trusted [Product] dealer, we have an extensive selection of [Product] for sale, all at great prices. Our [Product] are packed with top-notch off-roading features that will satisfy any outdoor enthusiast. Come visit [Business Name] in [Location] to explore our range of [Product] and find your perfect ride!</p></document> Assistant, you are an SEO content writer. Using the paragraphs in the document as context, write page featuredbanner content for the topic of Dirt Bike for sale in 400-500 characters. Use proper grammar in this paragraph, especially with product types. Do not use incorrect capitalization on the product. Make the first sentence as eye-catching and attention-grabbing as possible. Include the business information and target keywords that are listed below: Target Keywords = dirt bikes, dirt bikes for sale, off-road motorcycles, off-road motorcycles for sale, dirt bike dealer, off-road motorcycle dealer [Business Name] = Revolutions Power Sports [Location] = Grand Forks, ND Serving = Fargo, Manvel, and Emerado, North Dakota Assistant: My SEO optimized featuredbanner content is | ||
Meta Description | V1 | CONCATENATE("system:",{AI System: Meta Description}, "\nuser:"," This content is for the business named ", {Dealer Name (from Dealer Data)}, " located in ",{H1 Location (in/near [location]) (from Dealer Data)}, ". This business is a dealership and not a manufacturer of these products. Do not mention pricing, promotions, or 'deals'. ","Write one meta description of 140-160 characters optimized for ", {Actual Subject}, " for sale. Be creative with the start of your response and vary your word choice. ", " Use the following examples for inspiration:\n- Shop our wide selection of wakeboard boats at our dealership in Waterford, MI near Bloomfield Township today!\n- Hit the water in style with a Supra® wakeboard boat from Club Royale. Enjoy the fun and leisure that come from owning a Supra® boat. Visit us today!\n- Find an affordable used boat for sale at Club Royale, in Waterford, MI, and start enjoying the sunshine today!\n- Accommodate your travel needs with a spacious Jayco® travel trailer from Pete's RV Center! Visit us today in PA.\n- \n -Unleash the thrill with a Kawasaki Motorcycle from Revolutions Power Sports in Grand Forks, near Fargo, ND. Make every ride an adventure, visit us today to find your beast!\n\n-Gear up for outdoor adventures at Revolution Power Sports, Grand Forks, ND! Browse our optimal selection of Kayo Powersports Vehicles and ignite your passion for exploration. Propel your journey today!", " Do not reply with response in quotation marks.", {Context: Meta Description}) | "system:You are an SEO Content optimization specialist. Please write in a light informative tone. Use grammatically correct English. user: This content is for the business named Action Buggies located in in Willis, TX. This business is a dealership and not a manufacturer of these products. Do not mention pricing, promotions, or 'deals'. Write one meta description of 140-160 characters optimized for Golf Cart Financing for sale. Be creative with the start of your response and vary your word choice. Use the following examples for inspiration:
-Unleash the thrill with a Kawasaki Motorcycle from Revolutions Power Sports in Grand Forks, near Fargo, ND. Make every ride an adventure, visit us today to find your beast! -Gear up for outdoor adventures at Revolution Power Sports, Grand Forks, ND! Browse our optimal selection of Kayo Powersports Vehicles and ignite your passion for exploration. Propel your journey today! Do not reply with response in quotation marks." | |
Meta Description | V2 | CONCATENATE("system: ",{AI System: Meta Description},"user: please write a captivating meta description that does not exceed 160 characters and includes the following keywords: ",{Actual Subject},", ",{Dealer Name (from Dealer Data)}, ", ", {H1 Location (in/near [location]) (from Dealer Data)},". Always use proper grammar.") | "system: Role: SEO Copywriter Assistant Role Description: The SEO Copywriter Assistant is responsible for supporting the SEO Copywriter in creating keyword-optimized content that appeals to both human users and search engine algorithms. The assistant will help in researching and selecting appropriate keywords, and in ensuring that the content is engaging, readable and shareable. They will also help in monitoring and tracking the performance of the SEO strategies and making necessary adjustments. The assistant is expected to have a good understanding of SEO best practices and be able to apply them in creating content. Tasks:
| |
Header Content | V1 | CONCATENATE("system:You are a blog writer who has a depth of knowledge in vehicle and equipment products. Please write engaging and accurate content. Write in short internet copy friendly sentences preferring short words over longer words. Write at an eighth grade reading level. \n\nuser: Task: Write on page text for the product '",{Actual Subject},"' in 150-170 words. Please include the product(s) in the first sentence. Include the business name ",{Dealer Name (from Dealer Data)}," and location ",{H1 Location (in/near [location]) (from Dealer Data)}," in the second half of the text. Please incorporate semantically related keywords as well where appropriate. Do not mention price or 'deals'. Use the following examples. \n\nExample 1:\nWindish RV Center is an RV dealer that specializes in new RVs for sale in Colorado at great prices. We are proud to be one of Colorado's top RV sellers and we have been family owned and operated for two generations! We are confident you will love our new inventory. A new RV is a great option for anyone seeking a high quality, no wear-and-tear camper to meet whatever the road has to offer.\n\nWe are proud to carry awesome types, like our new motorhomes, new travel trailers, new fifth wheels, and new toy haulers, among many others. Any type of RV you may be looking for, we are sure to have something that is perfect for you. We can't wait to get you into the RV of your dreams here at Windish RV Center - your favorite new RV dealer in Colorado.\n\nExample 2:\nCheck out all of our new fifth wheels for sale here at Van City RV. Our new fifth wheels are awesome models that provide you with all of the amenities that you need in a variety of styles. The fifth wheel is an amazing towable that is versatile, popular, and suitable for just about any road trip that you have on the books. If you want to see more of what we currently have in stock, you can check out our inventory in the listing below at all of our locations in Las Vegas, NV, Kalispell, MT, St Louis, MO, and Colorado Springs, CO.\n\nWe carry so many fantastic fifth wheels that you will love! We can't wait to help get you into the RV of your dreams today at any one of our locations in your favorite new fifth wheel dealer in Nevada, Montana, Missouri, and Colorado!\n\nExample 3:\nIf you are looking for an incredible RV that doesn’t require any hitching and provides an excellent all-in-one RVing experience, you will want to check out our motorhomes for sale in Nebraska, Iowa, and Minnesota here at AC Nelsen RV! Not only do we have a large selection of quality new motorhomes for sale, you'll also find great prices and a knowledgeable staff who are excited to help you find the perfect motorhome for your next adventure!\n\nWe currently have some amazing prices on new motorhomes for sale and used motorhomes for sale which we are certain you will love. Explore our new class A and class C motorhomes for sale from trusted names such as Dutchmen, Coachmen, Thor, Forest River and more! We can't wait to help get you into the RV of your dreams here at your local motorhome dealer - AC Nelsen RV.") | "system:You are a blog writer who has a depth of knowledge in vehicle and equipment products. Please write engaging and accurate content. Write in short internet copy friendly sentences preferring short words over longer words. Write at an eighth grade reading level. user: Task: Write on page text for the product 'Golf Cart Financing' in 150-170 words. Please include the product(s) in the first sentence. Include the business name Action Buggies and location in Willis, TX in the second half of the text. Please incorporate semantically related keywords as well where appropriate. Do not mention price or 'deals'. Use the following examples. Example 1: We are proud to carry awesome types, like our new motorhomes, new travel trailers, new fifth wheels, and new toy haulers, among many others. Any type of RV you may be looking for, we are sure to have something that is perfect for you. We can't wait to get you into the RV of your dreams here at Windish RV Center - your favorite new RV dealer in Colorado. Example 2: We carry so many fantastic fifth wheels that you will love! We can't wait to help get you into the RV of your dreams today at any one of our locations in your favorite new fifth wheel dealer in Nevada, Montana, Missouri, and Colorado! Example 3: We currently have some amazing prices on new motorhomes for sale and used motorhomes for sale which we are certain you will love. Explore our new class A and class C motorhomes for sale from trusted names such as Dutchmen, Coachmen, Thor, Forest River and more! We can't wait to help get you into the RV of your dreams here at your local motorhome dealer - AC Nelsen RV." | |
Header Content | V2 |
Format Rules:
| ||
Header Content | V2 | Write captivating top-of-page content for a product landing page about ATVs. The purpose of this top-of-page content is to entice and engage users who have just clicked on the page to buy the product that's listed. The start of this paragraph should be eye-catching and highly engaging. Include semantically keywords and the dealership name of 'Revolutions Power Sports'. Also include 'in Grand Forks, ND' as a target location. The top-of-page content should be between 300-500 characters. Always include a call to action. Under the top-of-page content that you create, add a line break and then another paragraph that's shorter and does not exceed 300 characters. The purpose of this paragraph is for us with content that we can add in-text buttons that will link to other pages. I will list each in-text button we want to add in the format of 'text=link'. The text will be what we to include in the paragraph, and the link will be the link we add. Format the in-text links you generate in HTML tags, and use the attached list to complete your task: Can-Am® ATVs=https://www.revolutionspowersports.com/default.asp?page=xAllInventory&vt=atv&make=can-am New Powersports=https://www.revolutionspowersports.com/default.asp?page=xNewInventory Format Rules: Do not use a numbered list in your output. The two generated paragraphs should be treated as the same section. Do not use quotation marks in your output. Example 1: Experience the thrill of a lifetime with the unbeatable range of ATVs at Revolutions Power Sports, located in Grand Forks, ND. Our ATVs are designed for the adrenaline junkie in you, offering unmatched performance, durability, and a ride that will leave you breathless. Don't just dream about the adventure, live it! Browse our collection now and let the adventure begin! </ br> Explore our selection of <a href="https://www.revolutionspowersports.com/default.asp?page=xAllInventory&vt=atv&make=can-am">Can-Am® ATVs</a> and <a href="https://www.revolutionspowersports.com/default.asp?page=xNewInventory">New Powersports</a>. The adventure awaits you here at Revolutions Power Sports. | ||
Header Content | V3 | Write captivating top-of-page content for a product landing page about ATVs. The purpose of this top-of-page content is to entice and engage users who have just clicked on the page to buy the product that's listed. The start of this paragraph should be eye-catching and highly engaging. Include 'ATV, four-wheeler, quad, 4-wheeler' as semantically keywords and the dealership name of 'Revolutions Power Sports'. Also include 'in Grand Forks, ND' as a target location. The top-of-page content should be between 300-500 characters. Always include a call to action. For keywords that are nearly identical, consolidate them into one term. Include 3 outputs per generation. Select the meta description that is likely to have the best CTR for a product category page. Prefer those that are unique and engaging, and prepend 'Best: ' at the start. Format Rules:
Example 1: Experience the thrill of a lifetime with the unbeatable range of ATVs at Revolutions Power Sports, located in Grand Forks, ND. Our ATVs are designed for the adrenaline junkie in you, offering unmatched performance, durability, and a ride that will leave you breathless. Don't just dream about the adventure, live it! Browse our collection now and let the adventure begin! Example 2: Unleash your adventurous spirit with the top-notch ATVs at Revolutions Power Sports in Grand Forks, ND. Our portfolio is a thrill-seeker's dream, filled with robust, high-performing ATVs that promise an exhilarating experience on every ride. Get ready to conquer terrains and feel your pulse race with our unbeatable lineup. So why wait? Step into Revolutions Power Sports today and start your adventure today! |
Questions
Question | Answer | Who | When | Where |
|---|---|---|---|---|
Decisions
Decision | Why | Who | When | Where |
|---|---|---|---|---|
*Primary decision maker in bold.
Ryan’s Notes
Add automation for irrelevant pages
Generate views for each of the lookup tables for new entries that need data populated
Update keywords to concatenate and multiply keywords on All Possible Pages instead of Keyword Multiplier
Add all 20 dealers to the dealer data table using accurate information - no dummy information
Top 50 pages where inventory is greater than 5 for pages to work on.
All 20 dealers through dealer pages step 5 - update dealer data table - prompt building on Wednesday
Add crawling top level links to Page Import sheet
1. Complete dealer data for all 70
Content request moving
Add pages for all 70 customers - next 4 months
Content generated for posting
Content Posted by Juniper
Above must be done by EOM
Fully process dealers in dealer pages.
Tooling Evaluation
Tool Name | Purpose | CSV | XML | Cost | Status | Note | ||
|---|---|---|---|---|---|---|---|---|
Google Sheets Data Connector | ~17k/year ($120/user/month) | Consider - Maybe | High cost. | |||||
0 Comments