Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current Restore this Version View Page History

« Previous Version 48 Next »

Summary

Create an Airtable that processes dealer pages into a full-length optimization plan and then generate content for each page using AI tools.

Target release

Priority

HIGH

Project status

IN PROGRESS

Progress

20%

Brand

DS ARI

Owner

Ryan Kelner Lance Shroyer

Team

Status Note

Dealer data has been adding for first 70 dealers. Content Request sheet is also finished and now needs request data input to create request cards with. Once requests cards are made, Juniper will add the request to Trello and submit it.

Status Notes - Old

 Move old status notes here

Key Dates

Resources

Learning AI and Prompting Resources

Tools

AI for SEO Proposal

LeadVenture Generative AI Policy

Expected impact

Actual impact

🎯 Scope

Must have:

  • Inventory feed to pages to optimize analysis.

Nice to have:

  • Competitor analysis of SERPs results to inform content creation on a per page basis.
  • Inventory feed parse directly to Google Sheets
  • Inventory Feed automated refresh
  • Inventory Feed Changes Alerts

Not in scope:

  • Development

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

(tick) 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
  • Fully process dealers on dealer pages tab

AI Prompts

Field

Version

Changes

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

(question) 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

  1. Content request moving

  2. Add pages for all 70 customers - next 4 months

  3. Content generated for posting

  4. Content Posted by Juniper

Above must be done by EOM

  1. Fully process dealers in dealer pages.

Tooling Evaluation

Tool Name

Purpose

CSV

XML

Cost

Status

Note

Coefficient

Google Sheets Data Connector

~17k/year ($120/user/month)

Consider - Maybe

High cost.