Chatbot System Reporting Table Generator

Main Data Table (Agent > Prompt > Component > Action)

Agent ID	Agent Name	Total Local Session Attributes	Prompt ID	Prompt Name	Prompt Type	LLM Model	LLM Backup Model	Component ID	Component Name	Component Type	Action ID	Action Name	Action Type
A001	Customer Support	5	P001	Welcome Message	Parent	GPT-4	GPT-3.5-Turbo	T001	Greeting Tool	Tool	AC001	Send Welcome	Send Message
								T001	Greeting Tool	Tool	AC002	Log Interaction	Update ERP Value
								C001	Language Detector	Language Detection	AC003	Set Language	Update ERP Session
								C001	Language Detector	Language Detection	AC004	Send Localized Message	Send Message
								C002	Account Checker	ERP Condition	AC005	Verify Account	Send Message To GPT
								C002	Account Checker	ERP Condition	AC006	Route to Agent	Switch Agent
			P002	FAQ Handler	PIM	Claude-3-Sonnet	GPT-3.5-Turbo	C003	FAQ Matcher	Keywords Conditions	AC007	Match FAQ	Prompt In The Middle
											AC008	Send FAQ Response	Send Message
											AC009	Log FAQ Usage	Update ERP Value
								C004	Reply Counter	Reply Count	AC010	Count Replies	Send Last N Messages To GPT
											AC011	Check Threshold	Change Prompt
											AC012	Reset Counter	Reset Chat
A002	Technical Support	7	P003	Troubleshooting Guide	Parent	GPT-4-Turbo	GPT-4	T002	Issue Classifier	Tool	AC013	Classify Issue	Send Message To GPT
								T002	Issue Classifier	Tool	AC014	Log Issue Type	Update ERP Value
								T003	Model Validator	Tool	AC015	Validate Model	Send Message To GPT
											AC016	Fetch Specs	Update ERP Session
											AC017	Display Specs	Send Message
								C005	Escalation Checker	Auto Reply	AC018	Check Escalation	Switch Agent
								C005	Escalation Checker	Auto Reply	AC019	Notify Escalation	Send Message
			P004	Document Scanner	OCR	GPT-4-Vision	Claude-3-Haiku	T004	OCR Scanner	Tool	AC020	Scan Document	OCR Function
											AC021	Extract Text	Send Message To GPT
											AC022	Validate Format	Update ERP Value
											AC023	Store Document	Update ERP Session
								C006	Quality Validator	Keywords Conditions	AC024	Check Quality	Send Message
											AC025	Request Rescan	Send Message
											AC026	Process Complete	Close Local Session
A003	Sales Agent	4	P005	Product Inquiry	Parent	GPT-4	Claude-3-Sonnet	C007	Interest Tracker	Keywords Conditions	AC027	Track Interest	Update ERP Value
											AC028	Send Product Info	Send Message
											AC029	Schedule Demo	Send Message To GPT
								T005	Pricing Calculator	Tool	AC030	Calculate Price	Send Message To GPT
								T005	Pricing Calculator	Tool	AC031	Send Quote	Send Message
								C008	Follow-up Scheduler	Auto Reply	AC032	Schedule Follow-up	Update ERP Session
											AC033	Set Reminder	Update ERP Value
											AC034	Close Lead	Close Conversation

Agent Prompt Parameter Table (Agent > Prompt > Parameter)

Agent ID	Agent Name	Prompt ID	Prompt Name	Parameter ID	Parameter Name	Parameter Type
A001	Customer Support	P001	Welcome Message	PR001	Customer Name	Static
				PR002	Language Preference	Context
				PR003	Account Status	API
		P002	FAQ Handler	PR004	Question Keywords	Context
		P002	FAQ Handler	PR005	Response Count	Static
A002	Technical Support	P003	Troubleshooting Guide	PR006	Issue Category	Context
				PR007	Product Model	API
				PR008	Escalation Required	ERP Conditions
		P004	Document Scanner	PR009	Document Type	Static
		P004	Document Scanner	PR010	OCR Quality Check	Context
A003	Sales Agent	P005	Product Inquiry	PR011	Product Interest	Context
				PR012	Budget Range	API
				PR013	Follow-up Required	ERP Conditions

Agent Local Session Attributes Table

Agent ID	Agent Name	Attribute ID	Attribute Name	Attribute Type	Default Value
A001	Customer Support	LSA001	Customer_ID	String	NULL
		LSA002	Language_Code	String	EN
		LSA003	Session_Start_Time	DateTime	NOW()
		LSA004	Interaction_Count	Integer	0
		LSA005	Account_Type	String	BASIC
A002	Technical Support	LSA006	Ticket_Number	String	NULL
		LSA007	Issue_Category	String	GENERAL
		LSA008	Product_Model	String	NULL
		LSA009	Escalation_Level	Integer	1
		LSA010	Resolution_Status	String	OPEN
		LSA011	OCR_Scan_Count	Integer	0
		LSA012	Last_Document_Type	String	NULL
A003	Sales Agent	LSA013	Lead_Score	Integer	0
		LSA014	Products_Viewed	Array	[]
		LSA015	Quote_Generated	Boolean	FALSE
		LSA016	Follow_Up_Date	Date	NULL

Summary Tables

1. Agent Summary Table

Agent ID	Agent Name	Total Prompts	Total Parameters	Total Action Conditions	Total Tools	Total Actions
A001	Customer Support	2	5	2	1	12
A002	Technical Support	2	5	2	3	14
A003	Sales Agent	1	3	2	1	8
Total		5	13	6	5	34

2. Prompt Type Distribution Table

Agent Name	Parent	PIM	OCR	Total Prompts
Customer Support	1	1	0	2
Technical Support	1	0	1	2
Sales Agent	1	0	0	1
Total	3 (60%)	1 (20%)	1 (20%)	5

3. Parameter Type Distribution Table

Agent Name	Static	Context	API	ERP Conditions	Total Parameters
Customer Support	2	2	1	0	5
Technical Support	1	2	1	1	5
Sales Agent	0	1	1	1	3
Total	3 (23%)	5 (38%)	3 (23%)	2 (16%)	13

4. Component Type Distribution Table

Agent Name	Tools	Conditions					Total Components
Agent Name	Tool	Auto Reply	ERP Condition	Keywords Conditions	Reply Count	Language Detection	Total Components
Customer Support	1	0	1	1	1	1	5
Technical Support	3	1	0	1	0	0	5
Sales Agent	1	1	0	1	0	0	3
Total	5 (38%)	2 (15%)	1 (8%)	3 (23%)	1 (8%)	1 (8%)	13
Category Totals	5 Tools (38%)	8 Conditions (62%)					13

5. Action Type Distribution by Component Table

Action Type	From Tools	From Conditions	Total Count	Percentage
Send Message	2	6	8	23.5%
Send Message To GPT	5	1	6	17.6%
Update ERP Value	3	2	5	14.7%
Update ERP Session	2	1	3	8.8%
Switch Agent	0	2	2	5.9%
OCR Function	1	0	1	2.9%
Prompt In The Middle	0	1	1	2.9%
Change Prompt	0	1	1	2.9%
Reset Chat	0	1	1	2.9%
Send Last N Messages To GPT	0	1	1	2.9%
Close Local Session	0	1	1	2.9%
Close Conversation	0	1	1	2.9%
Total	13	21	34	100%

6. Action Type Distribution Per Agent Table

Action Type	Customer Support	Technical Support	Sales Agent	Total
Send Message	3	3	2	8
Send Message To GPT	1	3	2	6
Update ERP Value	2	2	1	5
Update ERP Session	1	2	1	4
Switch Agent	1	1	0	2
OCR Function	0	1	0	1
Prompt In The Middle	1	0	0	1
Change Prompt	1	0	0	1
Reset Chat	1	0	0	1
Send Last N Messages To GPT	1	0	0	1
Close Local Session	0	1	0	1
Close Conversation	0	0	1	1
Total Actions	12	14	8	34
Percentage	35.3%	41.2%	23.5%	100%

7. Overall System Metrics Table

Metric	Count
Total Agents	3
Total Prompts	5
Total Parameters	13
Total Components	13
Total Actions	34
Avg Actions per Component	2.6
Avg Components per Prompt	2.6
Avg Prompts per Agent	1.7