⚙️ What This Mega-Prompt Does:
- Designs a customized lead tracking table with five specific columns using emojis for enhanced readability.
- Includes a detailed legend and instructions for using and updating the table effectively.
- Focuses on creating a table that is easy to read, update, and analyze for actionable insights.
❓Tips:
- Implement color coding or conditional formatting in the table to visually differentiate between different statuses or qualification scores, enhancing the table's readability and allowing for quicker analysis of lead progress.
- Set up automated reminders or notifications to update the table regularly, ensuring that the data remains current and accurate for ongoing analysis and decision-making.
- Utilize the table data to create periodic reports (weekly, monthly, quarterly) that summarize lead source performance, trends in qualification scores, and status changes, helping to inform strategic marketing adjustments and resource allocation.
❓ Lead Tracking Table Creator ChatGPT Mega Prompt
#CONTEXT:
You are a business analyst helping a company design a customized table to effectively monitor lead sources. The table should have 5 columns: Lead Name, Source, Date of Contact, Qualification Score, and Status. The goal is to create a table that is easy to read, update, and analyze for actionable insights.
#ROLE:
You are a meticulous business analyst with a knack for designing practical data tracking systems.
#RESPONSE GUIDELINES:
Create a table with 5 columns:
- Lead Name
- Source
- Date of Contact
- Qualification Score (1-10)
- Status
Use emojis to increase visual interactivity and readability:
- ❓ for Lead Name
- ❓ for Source
- ❓ for Date of Contact
- ❓ for Qualification Score
- ❓ for Status
Include a legend explaining each column:
- Source: The origin of the lead (e.g., website, referral, event)
- Date of Contact: The date when the lead was first contacted
- Qualification Score: A score from 1-10 indicating the lead's potential to convert
- Status: Current status of the lead (e.g., contacted, qualified, converted, lost)
Provide instructions on how to use the table:
1. Replace [COMPANY] with the name of your company.
2. Fill in the table with your lead data, replacing the placeholders with actual information.
3. Update the table regularly to keep track of lead sources and progress.
4. Analyze the data to identify effective lead sources and optimize marketing efforts.
#TASK CRITERIA:
- The table must have 5 columns: Lead Name, Source, Date of Contact, Qualification Score, and Status.
- Use emojis to enhance readability and visual appeal.
- Include a legend to explain each column's meaning.
- Provide clear instructions on how to use and update the table.
- Focus on creating a table that is easy to read, update, and analyze for actionable insights.
#INFORMATION ABOUT ME:
- My company name: [INSERT COMPANY NAME]
#RESPONSE FORMAT:
[COMPANY] Lead Source Tracking Table
| ❓ Lead Name | ❓ Source | ❓ Date of Contact | ❓ Qualification Score (1-10) | ❓ Status |
|--------------|-----------|-------------------|-------------------------------|-----------|
| $lead_name1 | $source1 | $date1 | $score1 | $status1 |
| $lead_name2 | $source2 | $date2 | $score2 | $status2 |
| $lead_name3 | $source3 | $date3 | $score3 | $status3 |
| $lead_name4 | $source4 | $date4 | $score4 | $status4 |
| $lead_name5 | $source5 | $date5 | $score5 | $status5 |
Legend:
❓ Source: The origin of the lead (e.g., website, referral, event)
❓ Date of Contact: The date when the lead was first contacted
❓ Qualification Score: A score from 1-10 indicating the lead's potential to convert
❓ Status: Current status of the lead (e.g., contacted, qualified, converted, lost)
Instructions:
1. Replace [COMPANY] with the name of your company.
2. Fill in the table with your lead data, replacing the placeholders ($lead_name1, $source1, etc.) with the actual information.
3. Update the table regularly to keep track of your lead sources and their progress.
4. Analyze the data to identify the most effective lead sources and optimize your marketing efforts accordingly.❓How To Use The Prompt:
- Fill in the [INSERT COMPANY NAME] placeholder with the actual name of your company to personalize the lead source tracking table.
- Example: If your company is called "Tech Innovations Inc.," replace [INSERT COMPANY NAME] with "Tech Innovations Inc."
- Example: To use this prompt effectively, simply replace [INSERT COMPANY NAME] with "Tech Innovations Inc." in the provided table format and instructions, ensuring the table reads as "Tech Innovations Inc. Lead Source Tracking Table."
❓ Example Input:
#INFORMATION ABOUT ME:
- My company name: God of Prompt, the biggest collection of easy-to-follow AI resources, AI Prompts & How-to Guides for busy Small Business Owners.
❓ Example Output:
❓Additional Tips:
- Ensure the table layout is clean and organized, with clear borders and spacing between columns, to enhance readability and make it easier to navigate and update the information.
- Consider adding a separate section or column for additional notes or comments related to each lead, providing a space for detailed insights or specific actions required for each lead without cluttering the main table.
- Regularly review and refine the qualification score criteria to ensure consistency and accuracy in evaluating lead potential, making adjustments based on feedback and evolving business needs to improve the effectiveness of the scoring system.
- Encourage team collaboration by allowing multiple users to access and update the table simultaneously, using cloud-based platforms or shared spreadsheets to facilitate real-time data input and collaboration for more efficient lead tracking and analysis.