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://www.kaizensearch.co.uk//",
 "potentialAction": {
 "@type": "SearchAction",
 "target": "https://query.https://www.kaizensearch.co.uk/search?q={search_term_string}",
 "query-input": "required name=search_term_string"
 }
 "publisher": {
 "@type": "Organization",
 "name": "Kaizen",
 "logo": {
 "@type": "ImageObject",
 "url": "https://www.kaizensearch.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": "http://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": "http://schema.org/",
 "@type": "Product",
 "name": "Executive Anvil",
 "image": "http://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": "http://schema.org/UsedCondition",
 "availability": "http://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

Comments

Related Blog Posts

4 Common PR Challenges and How to Overcome Them

Media outlets are closing, audiences are shifting their loyalties, and journalists are telling stories in different ways. It’s impossible to deny: the media landscape is changing, and PRs are on the front line of its irrepressible evolution. Managing a PR strategy has always been something of a balancing act, combining client expectations with stories journalists … Read more

Is It Worth Paying for Photoshop? Comparing Freeware to Commercial Software

With the uprising of open-source image software, developers around the globe finesse their computer wizardry; to enhance and create what everyone desires – a free image editing software for everyone to use, with no strings attached. But what exactly do you get out of free software? How do they live up to our expectations? And … Read more

Lessons Learnt from Digital Elite Camp 2018

I recently had the pleasure of being invited to speak at Digital Elite Camp 2018 in Estonia. While the majority of talks were specific to conversion rate optimisation (CRO), for this post, I have specifically sought out lessons more applicable across the wider industry. While I’ve excluded any lessons from my own talk (as I … Read more