This template allows you to product programmatic blog posts following the “5 Best [use case] tools for [persona] “ keyword pattern.
Use instructions:
- Make a copy of the file to your Google Drive.
- Fill in all the use cases you want to produce posts for in the first column of the “use case” database, the personas in the “persona” database, and the respective tools in the “tool database” tabs:
- Add content about each tool, use case and persona in the respective rows of their databases- 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 template itself (the “5 Best [use case] tools for [persona] “ tab)
- Fill in the use cases and personas you will be producing posts about in columns E & F (! The use cases have to match the ones you filled in in the use case database!). Change the author of the post in column “S”.
- 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.
English