StackPosts guide

AI Templates & Reports

Use this practical guide to complete the task with a clear setup path and an observable result.

Use this guide

1. Open the related workspace area and confirm the intended account or workspace.
2. Follow the detailed instructions below and save each change before moving on.
3. Run a small, observable test so you can confirm the result on the connected service.

Detailed steps

📥 How to Install Default AI Templates

1. Download the File

• Click here to  button.

• The downloaded file will be named:

   

  aitemplates.sql

2. Unzip the File

• If the file comes as a .zip, extract it first.

• Inside, you will find:

   

  aitemplates.sql

3. Import into Database

There are two ways to import the SQL file into your database.

Option 1: Using phpMyAdmin

1. Log in to phpMyAdmin from your hosting or cPanel.

2. Select the database used by Stackposts.

3. Go to the Import tab.

4. Click Choose File and select aitemplates.sql.

5. Click Go to import the file.

 

1. Introduction

The AI Settings section helps admins and users track AI credit usage and manage AI templates.
With these tools, you can:

• Monitor AI token usage by day and model

• Export AI reports for billing or analytics

• Use pre-made AI templates to generate content faster

• Organize templates into categories for easier access

---

2. AI Reports

Navigate to AI Report.
This section provides insights into how AI credits are consumed.

Features:

• Daily AI Credit Usage – Line chart showing daily token usage

• Credit Usage by AI Model – Bar chart showing credits consumed per AI provider (e.g., Claude, Deepseek)

• Export PDF – Export AI usage data for offline analysis or billing

• Date Range Filter – Select a custom time frame for usage reports

👉 Example: You can see if users are consuming more credits with Claude vs Deepseek and adjust pricing accordingly.

---

3. AI Templates

Navigate to AI Templates → View All Templates.
Here you will find pre-made content prompts designed for use with AI.

Features:

• Content List – Displays all available templates (e.g., fitness posts, motivational messages, product descriptions)

• Category – Each template is assigned to a category (e.g., Fitness Trainers, Authors, Ads)

• Status – Templates can be Enabled or Disabled

• Actions – Edit, duplicate, or delete templates

👉 Example Templates:

• “Write a post about the benefits of meditation.”

• “Create a motivational message about self-care.”

• “Generate a product description for your new app.”

---

4. Manage AI Categories

Navigate to AI Templates → Manage Categories.
This section organizes templates into groups for easy navigation.

Example Categories:

• Fitness Trainers – Posts for personal trainers

• Restaurants – Food-related content ideas

• Marketing Agencies – Campaign and promotion prompts

• Business Coaches – Leadership and growth prompts

• Social Platforms – Facebook, TikTok, YouTube, Pinterest templates

• Content Types – Rewrite, Summarize, Explain & Expand, Inspirational

👉 Use categories to help users find relevant templates faster.

---

5. Best Practices

• Use AI Reports regularly to monitor credit consumption

• Disable unused templates to keep the list clean

• Group templates by industry in Categories for better user experience

• Export usage reports monthly to analyze AI cost and performance

• Provide users with both short-form templates (tweets, captions) and long-form templates (blogs, ads, descriptions)

 

Quick check

• The save or publish action completes without an error.
• The visible status, preview, or connected account matches the change.
• If the result differs, capture the exact message and review the troubleshooting guidance before retrying.