This template allows you to produce programmatic blog posts following the following keyword patterns:
- “[Persona1] vs [Persona2] – what’s the difference?” keyword pattern.
- “Best tools for [Use Case]” keyword pattern
- “Best tools for [Use Case]” keyword pattern
- “[competitor1] vs [competitor2]” keyword pattern
+ more templates coming SOON!
Use instructions:
- Make a copy of the file to your Google Drive.
- Fill in all the tools, use cases, and personas you want to produce posts for in the first column of the “use case”, “tools” and “NEWpersona” databases – in the respective tabs of the sheet:
- Add content about each tool/use case/persona in the respective rows – following the instructions in the columns.
- 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 selected template you want to produce posts from itself (e.g. the “Best tools for [Use Case]” tab)
- Fill in the use cases you will be producing posts about in column A (! The use cases have to match the ones you filled in in the use case 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.
- Repeat the same steps for other templates in the Sheet.
English