Clay Icon

Effective Claygent Prompt for Categorizing Leads in Close CRM

ยท
ยท

whats a good claygent prompt to use, i want to enrich leads in Close CRM with sectors and having claygent research each lead and categorise them into one or more of the below sectors. My issue is I want it to return each one that applies separately and put them in separate columns. Attached is what I'm getting currently Agriculture; Apparel & Fashion; Aviation & Aerospace; Banking; Bar; Biotechnology; Building Materials Production; Chemicals Production; Civic & Social Organisation; Civil Engineering; Commercial Real Estate; Computer & Network Security; Computer Games; Computer Hardware; Computer Networking; Computer Software; Construction; Consumer Electronics; Cosmetics; Dairy Production; Defence & Space; E-Learning; Education Management; Electrical/Electronic Manufacturing; Environmental Services; Facilities Management; Farming; Financial Services; Fine Art; Food & Beverages; Food Production; Fundraising; Furniture Production; Gambling & Casinos; Government Administration; Government Relations; Graphic Design; Gymnasium; Health, Wellness and Fitness; Higher Education; Hospital & Health Care; Hospitality; Hotel & Accommodation Services; Industrial Automation; Information Services; Information Technology and Services; Insurance; International Trade and Development; Internet Service Provider; Investment Banking; Investment Management; Journalism; Law Enforcement; Law Practice; Legal Services; Leisure, Travel & Tourism; Libraries; Logistics and Supply Chain; Luxury Goods & Jewellery; Management Consulting; Manufacturing of Machinery; Maritime; Market Research; Marketing and Advertising; Mechanical or Industrial Engineering; Media Production; Medical Devices Production; Mental Health Care; Mining & Metals; Motion Pictures and Film; Music Production; Nanotechnology; Non-profit Organisation Management; Oil & Energy; Online Media; Outsourcing/Offshoring; Package/Freight Delivery; Packaging and Containers; Performing Arts; Pharmaceuticals; Philanthropy; Photography; Plastics; Primary/Secondary Education; Professional Training & Coaching; Program Development; Property Development; Public Policy; Public Safety; Publishing; Railroad Manufacture; Ranching; Real Estate; Recreational Facilities and Services; Religious Institution; Research Services; Restaurant; Retail; Shipping; Sporting Goods; Sports; Staffing and Recruiting; Supermarket; Sustainability, Renewables & Environment; Telecommunications; Textiles; Think Tanks; Transportation/Trucking/Railroad; Utilities; Venture Capital & Private Equity; Veterinary; Warehousing; Wholesale; Wine, Alcohol and Spirits Production

  • Avatar of Rubi S.
    Rubi S.
    ยท
    ยท
    1. 1.

      Make sure you have the same format on all the results - separated by semicolon.

    2. 2.

      export your results to a CSV

    3. 3.

      Split the results of the company sector response column in Google sheets/Excel with the semicolon+space pattern

  • Avatar of Stefano
    Stefano
    ยท
    ยท

    Hi Eugene, Thanks for reaching out! A more efficient way to handle this would be to use Claygent directly. You can instruct it to return each response field separately and then parse the response into different columns. There's no need to involve Google Sheets โ€“ just one Claygent prompt can return a JSON object, which you can easily parse into separate columns. Let me know if you need any help setting this up!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Eugene A.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Thank you so much for sharing your feedback Eugene A.!