如何从 AI Chatbot 中获得最佳效果

为确保您的 AI 聊天机器人提供最准确、最有帮助的回复，请遵循以下指导原则：

1. 在回复中嵌入标题

在 text（答案）中嵌入 heading（问题）有助于 AI 更好地理解上下文，并提供更相关的回复。

例如：

• Heading: What is your price?

• Text: What is your price?, SME AI Pro Package USD 99 / Month. SME AI Premium Package USD 249 / Month.

通过在答案中重复问题，AI 可以更好地将用户查询与正确信息相匹配。

替代工具

此外，Excel 还提供了一个功能，使您无需将问题逐一插入答案中。请按照以下指南操作：

1. 打开 Excel 文件

2. File -> Option -> Custom ribbon

3. 勾选右侧面板上的 "Developer"

4. 点击 "OK" 按钮

5. Developer tab -> Visual Basic (Alt + F11)

6. Insert -> Module

7. 粘贴准备好的代码

8. 替换工作表名称

9. 关闭

10. Macros (Alt + F8)

11. 选择创建的模块

12. 运行

13. Heading 将添加到 text 中

Visual Basic's code:

Sub MoveHeadingToText()
Dim ws As Worksheet
Dim lastRow As Long
Dim i As Long
Dim heading As String
Dim text As String

' Set the worksheet
Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to the name of your sheet

' Find the last row with data in column B (Heading)
lastRow = ws.Cells(ws.Rows.Count, "B").End(xlUp).Row

' Loop through each row and update the Text column
For i = 2 To lastRow ' Assuming the data starts from row 2
    heading = ws.Cells(i, 2).Value
    text = ws.Cells(i, 3).Value

    ' Trim any leading/trailing spaces or line breaks from the Heading
    heading = Trim(Replace(Replace(Replace(heading, vbCrLf, " "), vbLf, " "), vbCr, " "))

    ' Prepend the Heading to the Text with a comma and a space
    ws.Cells(i, 3).Value = heading & ", " & text
Next i

End Sub

2. 使用简洁明了的语言

语言要简单直接。避免行话或过于复杂的句子。

• 效果较差："We provide a plethora of options for your perusal."

• 更有效："We offer many options for you to choose from."

3. 构建信息结构

用标题、要点和编号列表来组织内容，使 AI 更容易解析。

• 非结构化："Our services include web development, mobile app development, and digital marketing."

• 结构化：

  • Services:

    • Web development

    • Mobile app development

    • Digital marketing

4. 提供全面的答案

确保您的答案全面，涵盖问题的所有方面。

• 不全面："Our office hours are 9 AM to 5 PM."

• 完整："Our office hours are 9 AM to 5 PM, Monday to Friday. We are closed on weekends and public holidays."

5. 使用相关关键词

在文本中自然融入相关关键词，帮助 AI 更有效地匹配问题和答案。

• 不使用关键词："Our support team is available 24/7."

• 有关键词："Our customer support team is available 24/7 to assist with any queries or issues you may have."