.png){kind=logo}
Filtering ChatGPT Results for Competitor Analysis
How do i take a chatgpt encirched result and turn it into a field i can put a filter on ie. Is company a competitor? Answer yes/no But then i cant filter on Yes results only
How do i take a chatgpt encirched result and turn it into a field i can put a filter on ie. Is company a competitor? Answer yes/no But then i cant filter on Yes results only
To turn a ChatGPT-enriched result into a filterable field, you can use the "Define column outputs" feature in the ChatGPT integration. Here's how: 1. In your ChatGPT enrichment, enable the "Define column outputs" option. 2. Add a field named "isCompetitor" and set its type to True/False. 3. In your prompt, instruct ChatGPT to analyze if the company is a competitor and return a boolean value for the "isCompetitor" field. After enrichment, use the "write to table" feature to add this new column to your table. You can then filter on the "isCompetitor" column, selecting only "Yes" or "True" results.
How do i write the result to a column next to it?
To write the ChatGPT-enriched result to a column next to it, you can use our "write to table" feature. Here's how: 1. Click "Add Enrichment" in the top right corner of your page. 2. Search for and select the "Write to Table" integration. 3. Choose the same table you're currently working on as the destination. 4. Enter "/" to skip the list selection. 5. Map the ChatGPT-enriched column to a new column in your table. This method will create a new column next to your original data with the enriched results. Make sure to enable the "Define column outputs" option in your ChatGPT enrichment to structure the response properly.
It wont let me write to the same table
We apologize for the confusion. Our "write to table" feature is designed to write to a different table, not the same one. Here's a workaround: 1. Create a new table in your workbook. 2. Use the "write to table" feature to write your ChatGPT-enriched results to this new table. 3. Then, use a lookup enrichment to bring that data back into your original table. This method allows you to effectively add the enriched data as a new column in your original table. If you need more guidance on this process, please ask for human assistance by clicking on "Talk to a person".
You can use formula to extract the response. Example: if the response says 'Yes/ No' then write a formula to extract this
To extract and filter ChatGPT-enriched responses like 'Yes/No' in your table, you can use an AI formula. Here's how: 1. Click on the column options for your ChatGPT-enriched column. 2. Choose "Ask question about items with AI". 3. In the formula prompt, ask the AI to extract the 'Yes' or 'No' response. For example, you could use a prompt like: "Extract only the 'Yes' or 'No' response from this text. If neither is present, return 'N/A'." The AI will generate the appropriate code to give you the desired output. You can then use this new column to filter your results as needed.