Clay Icon

Tips to Speed Up Column Processing: Seeking Suggestions

ยท
ยท

these columns have been queued for a couple hours now, not much movement. Is there anything I can do to speed this up ?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Here are several options to help speed up processing of queued columns: 1. Try running specific portions of your data: โ€ข Use "Run First 10 Columns" to test and verify the setup โ€ข Select "Run All Rows that haven't run or have errors" โ€ข Choose to run from a specific row with a defined number of rows โ€ข Use "Force Run All Rows" if needed 2. To optimize processing: โ€ข Make your search queries more specific โ€ข Break your data into smaller batches โ€ข Check your usage limits and API quotas โ€ข Verify your network connection is stable Source: Run Options

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!

  • Avatar of Tanvi R.
    Tanvi R.
    ยท
    ยท

    Hi Silver, thanks for reaching out! Could you direct me to which columns specifically have been stuck on queued for you?

  • Avatar of Harkin
    Harkin
    ยท
    ยท

    its in this table : https://app.clay.com/workspaces/16336/workbooks/wb_yCZqF8s4ZK3V/tables/t_u6gw7K3XcteP/views/gv_HrTai9WJFNFR All of the find contacts at company columns near the end of the table

  • Avatar of Harkin
    Harkin
    ยท
    ยท

    Its a bit of an emergency if this could be sped up

  • Avatar of Harkin
    Harkin
    ยท
    ยท

    Hey were you able to find for reason on this ?

  • Avatar of Tanvi R.
    Tanvi R.
    ยท
    ยท

    Hey there, your enrichment columns are working correctly as I see the results are updating in your cell. It appears that just running 4 separate find contacts at company columns on 7.5K rows (~29,000 cells) is just causing slow run time. How long did you say these rows have been queued?

  • Avatar of Harkin
    Harkin
    ยท
    ยท

    probally 3 hours now

  • Avatar of Harkin
    Harkin
    ยท
    ยท

    would running them one by one be better ?

  • Avatar of Tanvi R.
    Tanvi R.
    ยท
    ยท

    You could combine all of the job titles into one column so it's only running the same search once instead of multiple times

  • Avatar of Harkin
    Harkin
    ยท
    ยท

    yea but then the limit is 10 people per search so if i combined all it would probally give me more than 10 which then i would be missing out on leads

  • Avatar of Harkin
    Harkin
    ยท
    ยท

    I guess I'll just try it one by one

  • Avatar of Harkin
    Harkin
    ยท
    ยท

    column by column

  • Avatar of Tanvi R.
    Tanvi R.
    ยท
    ยท

    The best way to do this is actually through creating a new find people table entirely that references the companies in your list. To do this, you can select Actions in the top right > select Find people at these companies

  • Avatar of Tanvi R.
    Tanvi R.
    ยท
    ยท

    From here, you can select all of the job title filters you'd like to apply to your search. The results will load automatically into your new find people table

  • Avatar of Tanvi R.
    Tanvi R.
    ยท
    ยท

    Here's a tutorial on how to use our find people table source: https://www.clay.com/university/lesson/find-people-clay-101

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • 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 Harkin! This thread was recently closed by our Support team. If you have a moment, please share your feedback: