The Ultimate Template for Structured Data Markup

Are you looking for an easy to use template to help you generate structured data for your website?
Check out our inhouse made (free) Google Spreadsheet, where you can easily create and edit the most common microformats which are currently supported by Google.

screen-shot-2016-11-25-at-11-52-17
The structured data types you can create in this template are:

1. Organization Schema

social-profiles01
Organization schema is the perfect opportunity to enhance the way your company is represented in Google’s search. Here is an example of Organization schema for Kaizen with searchbox:

<script type="application/ld+json">
 {
 "@context": "https://schema.org",
 "@type": "WebSite",
 "url": "https://https://wp2.kaizen.co.uk//",
 "potentialAction": {
 "@type": "SearchAction",
 "target": "https://query.https://wp2.kaizen.co.uk/search?q={search_term_string}",
 "query-input": "required name=search_term_string"
 }
 "publisher": {
 "@type": "Organization",
 "name": "Kaizen",
 "logo": {
 "@type": "ImageObject",
 "url": "https://wp2.kaizen.co.uk/wp-content/kaizen/img/kaizen-logo-amp.jpg",
 "width": 600,
 "height": 60
 }
 }
 </script>

2. Video Object Schema

videos01
Structured data markup for videos can make videos embedded on your site to appear in search results, which can be useful for “how to” or DIY videos.

Example:

<script type="application/ld+json">
 {
 "@context": "https://schema.org",
 "@type": "VideoObject",
 "name": "Title",
 "description": "Video description",
 "thumbnailUrl": "https://www.example.com/thumbnail.jpg",
 "uploadDate": "2015-02-05T08:00:00+08:00",
 "duration": "PT1M33S",
 "publisher": {
 "@type": "Organization",
 "name": "Example Publisher",
 "logo": {
 "@type": "ImageObject",
 "url": "https://example.com/logo.jpg",
 "width": 600,
 "height": 60
 }
 },
 "contentUrl": "https://www.example.com/video123.flv",
 "embedUrl": "https://www.example.com/videoplayer.swf?video=123",
 "interactionCount": "2347"
 }
 </script>

3. Article

articles01
Example for article structured data in microdata HTML format:

<div>
 <h2>Article headline</h2>
 <h3>By John Doe</h3>
 A most wonderful article
 <div>

<img src="https://google.com/thumbnail1.jpg" />

</div>
 <div>
 <div>

<img src="https://google.com/logo.jpg" />

</div>

</div>

</div>

4. Product Rating Schema

search-gallery-products

This markup lets you display product information, such as rating by your customers or its price directly in search results.

<script type="application/ld+json">
{
 "@context": "https://schema.org/",
 "@type": "Product",
 "name": "Executive Anvil",
 "image": "https://www.example.com/anvil_executive.jpg",
 "description": "Sleeker than ACME's Classic Anvil, the Executive Anvil is perfect for the business traveler looking for something to drop from a height.",
 "mpn": "925872",
 "brand": {
 "@type": "Thing",
 "name": "ACME"
 },
 "aggregateRating": {
 "@type": "AggregateRating",
 "ratingValue": "4.4",
 "reviewCount": "89"
 },
 "offers": {
 "@type": "Offer",
 "priceCurrency": "USD",
 "price": "119.99",
 "priceValidUntil": "2020-11-05",
 "itemCondition": "https://schema.org/UsedCondition",
 "availability": "https://schema.org/InStock",
 "seller": {
 "@type": "Organization",
 "name": "Executive Objects"
 }
 }
}
</script>

All of these structured data types can be generated in JSON and microdata (HTML).

How to use this template?

  1. Fill in your data in white cells within respective sheet
  2. Formulas will automatically generate appropriate schema in both JSON and Microdata formats (blue cell)
  3. Copy and paste one of the schemas (JSON or Microdata) and paste it as value only to the white cell with dotted frame
  4. Copy the schema from the FORMULA BAR of the red cell to the Google’s Structured Data Testing tool: https://developers.google.com/structured-data/testing-tool/

If your schema validates, you can now paste it to your source code.
You can access and download the template here.

Get a monthly roundup of our insights in your inbox

Related Blog Posts

We Analysed 2000 Pieces of Travel Content to Find the Best Type for SEO

We Analysed 2000 Pieces of Travel Content to Find the Best Type for SEO

Recently, Kaizen hosted a breakfast roundtable on the future of content in the travel industry.   Featuring SEO, Content and Marketing seniors from high-profile travel brands, the event was chaired by Lee Hayhurst, the editor of B2B Travel publication Travolution.   There was a lively debate surrounding the in-depth research Kaizen conducted into travel content for our … Read more

Bobbi Brant at BrightonSEO: How to Use Live Video in Content Marketing

Bobbi Brant at BrightonSEO: How to Use Live Video in Content Marketing

Today, our Head of Creative Bobbi spoke at BrightonSEO on the best methods of incorporating live video into a content marketing strategy. Speaking on her inspiration from our whitepaper on the Future of Content, to Kaizen’s own experience of live-streaming Q&As on our Twitter, Bobbi covers the key reasons why brands should consider live video … Read more

The 7 Golden Rules of Content for Link Building

The 7 Golden Rules of Content for Link Building

There are hundreds of articles out there about ‘how to create great content’ or ‘how to make linkable content’ – I’ve probably written a few of them myself – but they often leave you with an underwhelming feeling that there were very few concrete, practical tips hiding amongst the buzzwords. At Kaizen, using our combined … Read more