🎯 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:
|
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. | |||||
Add Comment