This template allows you to product programmatic blog posts following the “[competitor1] vs [competitor2]” keyword pattern.
Use instructions:
- Make a copy of the file to your Google Drive.
- Fill in all the tools you want to produce posts for in the first column of the “tool database” tab:
- Add content about each tool in the respective rows – following the
- The content you add needs to be in HTML! You can use your CMS’s (WordPress) visual editor to write the content, and then just copy the content in HTML from the “Code editor”.
- After adding all the content on your different tool to the database, go to the template itself (the “[[competitor1] vs [competitor2]” tab)
- Fill in the tools you will be comparing in columns E, F & G and then the use cases for the comparison in columns K, O, & S: (! The use cases have to match the ones you filled in in the tools database!)
- Your template should have prepopulated with data now. Now, download the template file as CSV:
- Upload the CSV file to your WordPress using the Import WP orWP Import Export plugin.
- Map the metacolumns (slug, author, metadescription etc.) to the respective metacolumns in the plugin, and the “Content Output Column” (column “CX”) into the “body” of the post:
- Select in the plugin settings whether you want to publish the post live or leave them in drafts. Proceed with the upload according to the plugin wizard instructions.