Clay Icon

Creating an Organized Spreadsheet for Multiple Stakeholders in Enterprise Organizations

ยท
ยท

I'm helping a client build a targeted lists for multiple stake holders within enterprise organizations and have a quick question. Let's say I have a list of 300 enterprise organizations and looking for 5-7 personas within each org. What is the best way to get all of these personas on an organized spreadsheet that's broken down by company? So on the spread sheet the rows would be: Company 1 - persona 1, Company 1 - persona 2, Company 1 -persona 3, etc...extending down the list for all companies. I understand how to "Find Contacts at Company" integration, but how do you then extract all contacts from each company and have them nicely organized on a spreadsheet?

  • Avatar of Frederik H.
    Frederik H.
    ยท
    ยท
  • Avatar of Frederik H.
    Frederik H.
    ยท
    ยท

    Usually I do it like this.

    1. 1.

      Have a Company Table with all of the enrichments I need

    2. 2.

      Usually using the "Find Contacts at Company Enrichment" which retrieves me a list of people for that company. Also can use Keywords for that.

    3. 3.

      Then I create a New Custom Table with ALL of the fields I will need from my previous Company + Contacts Table

    4. 4.

      Choose the "Take Action on List" Option in the List of Contacts in my previous table.

    5. 5.

      Transfer the data to my new table which gives me the desired output format.

  • Avatar of Adam B.
    Adam B.
    ยท
    ยท

    Thanks Frederik H.! Where exactly do I find "Perform Action on List"? I can't seem to find it.

  • Avatar of Frederik H.
    Frederik H.
    ยท
    ยท

    3. Create Custom Table and add fields you need in the new People Table 4. Take Action on List

  • Avatar of Adam B.
    Adam B.
    ยท
    ยท

    Awesome thanks!

  • Avatar of Frederik H.
    Frederik H.
    ยท
    ยท

    In the last step just map the fields you need from the list to the columns created in the custom table and at the bottom the fields you want to get into the new column not from the list. Hope this helps!

  • Avatar of Frederik H.
    Frederik H.
    ยท
    ยท

    Not sure if this is the best way to do it, but it does work for sure ๐Ÿ™‚

  • Avatar of Adam B.
    Adam B.
    ยท
    ยท

    Great thanks! I'll play around with it and let you know if any issues. Last question, I don't have to manually do this for all 300 companies correct? Once I map fields and take action on list, it will run for all companies?

  • Avatar of Frederik H.
    Frederik H.
    ยท
    ยท

    Exactly. Create needed fields once in custom table, map fields and just let it run. Let me know if it worked!

  • Avatar of Adam B.
    Adam B.
    ยท
    ยท

    Perfect thanks and will do!

  • Avatar of Dorothy H.
    Dorothy H.
    ยท
    ยท

    Thanks for asking this question Adam B.. I was wondering the same thing! Frederik H. your answer was super helpful.

  • Avatar of Dorothy H.
    Dorothy H.
    ยท
    ยท

    Charlie C. for your ABM campaigns. A less complicated way than I had suggested for multiple personas.

  • Avatar of Frederik H.
    Frederik H.
    ยท
    ยท

    Dorothy H. Glad to hear! Like I said, I am not sure this is the best way to do it. Maybe someone from Clay can elaborate, but I know it works since I have done it multiple times ๐Ÿ˜„ Let me know if there ary any hickups I can help with, just in case! ๐Ÿ™‚