readme.md

Search engine optimization (SEO)

conform Google Search and Schema.org in Laravel

This app* gives formatted SEO data for searchengines that use

• Google Search Structured data
• Schema.org Types

For instance this is what it does to your date on Google Search: Explore the search gallery

*This app was inspired by this question and answer: Schema.org + Laravel = way too complicated?

Start app

Import data

mysql -u <user> -p <dbname> < database/data/seo.sql

Client

See the output

chrome view-source: http://seo.localhost/

• Article

  • blog_posting/hackathon-tilburg-groot-succes/schema_org
  • blog_posting/duodeka-official-meteor-partner/schema_org

• Breadcrumb

  • breadcrumb/3/schema_org

• Carousel

  • carousel/1/schema_org
  • carousel_summary/1/schema_org

• Job Posting

  • job_posting/english-frontend-developer-in-tilburg/schema_org
  • job_posting/english-full-stack-developer-in-tilburg/schema_org

• Local Business Listing

  • local_business/1/schema_org
  • organization/2/schema_org

• Sitelinks Searchbox

  • web_site/1/schema_org

• Organization

  • organization/1/schema_org
  • organization/2/schema_org

• Person

  • organization/1/founders/Koen/schema_org
  • organization/1/employees/Koen/schema_org
  • organization/2/employees/Koen/schema_org

• PostalAddress

  • organization/1/postal_address/schema_org

The output can be validated at Google Search Structured data Testing Tool

Code generation

SQL to Entity-Relationship Diagram

chrome view-source:http://seo.localhost/schema-inspector/schema

Entity-Relationship Diagram to Laravel Migrations

chrome view-source:http://seo.localhost/schema

Import Schema 'database/schema/schema.txt'. Generate Database Migrations and extract them to 'database/migrations/'.

Laravel Migrations to SQL

php artisan migrate

SQL to Eloquent Models

php artisan code:models

Structured data and Types used

Google Search Structured data

• Sitelinks Searchbox

Google Search Structured data conform Schema.org

• Article can be
  • Article
  • NewsArticle
  • BlogPosting
• Breadcrumb consists of
  • BreadcrumbList
  • ListItem
• Carousel consists of
  • ItemList
  • ListItem
• Job Posting is
  • JobPosting
• Local Business Listing is
  • LocalBusiness

Schema.org Types

• Thing
  • Action
    • SearchAction
  • CreativeWork
    • Article
      • SocialMediaPosting
        • BlogPosting
    • WebSite
  • Organization
    • LocalBusiness
  • Person
  • Place
    • LocalBusiness
  • Intangible
    • ItemList
      • BreadcrumbList
    • JobPosting
    • ListItem
    • PropertyValueSpecification
    • Role
    • StructuredValue
      • ContactPoint
        • PostalAddress
      • GeoCoordinates
      • MonetaryAmount
      • OpeningHoursSpecification
      • PropertyValue
      • QuantitativeValue

Entity-Relationship Diagram

Build with

React ·