How to Import Unique Jobs from Clay: Tips for Avoiding Duplicates

Anjan G. · 2024-09-06 14:36:15.583419+00

Hi guys, I'm trying to import Jobs from clay but the problem is this: I'm getting multiple jobs from the same company so how do I remove them while importing. I want to have 1 job per company?

How to Import Unique Jobs from Clay: Tips for Avoiding Duplicates | Clay

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Anjan G.
·
·
another question is this: How do I increase the rate limit of open Ai, I'm getting that message as of now!
Loading attachments
Anjan G.
·
·
I don't even get the Tire 3 so how do I use chatgpt 4 mini with Claygent?
Loading attachments
Anjan G.
·
·
If I put 100 dollars, can I use Claygent + open AI mini 4 together then?
Anjan G.
·
·
Daniela D.
Tanvi R.
·
·
Hi Anjan, thanks for reaching out. To increase the rate limit of your OpenAI API key, you will need to increase your usage tier here: https://platform.openai.com/settings/organization/limits To use GPT 4o with Claygent, you will need at least a Tier 2 usage subscription or above. ChatGPT will work with all tiers of OpenAI. ChatGPT: • Requirement: 30,000 TPM (tokens per minute) • Works with: All tiers of ChatGPT Claygent: • Requirement: 450,000 TPM (tokens per minute) • Works with: • GPT-4o on Tier 2 • GPT-3.5 and GPT-4o Mini on Tier 4 Their support team will always grant you the request if you have prepaid the minimum amount required and they’ll be quick to assist if you need to increase your limits or troubleshoot any issues.
Anjan G.
·
·
You answer me this question: Hi guys, I tried to find companies that are hiring for RN positions from LinkedIn and I scraped 355 companies from LinkedIn using apify actor but after uploading to Clay and dedupe, I left with 45 companies. it's because one company is hiring for multiple RN job positions how do I build a big company list then? im struggling to build a big company list.
Loading attachments
Anjan G.
·
·
Tanvi R.
Anjan G.
·
·
Alos, If I just put $100 bucks in Chatgpt, will I get tire 2 automatically?
Bo (.
·
·
Hey, thanks for reaching out! 😊 If you’re trying to build a big list of companies, why not use our Find Jobs search directly, or consider running the APIFY actor for more days? That way, you’ll gather more data efficiently. As for OpenAI, we can’t guarantee anything since we’re not them, but their support team is usually responsive. If you’ve prepaid the minimum amount required, they tend to approve requests quickly, whether it’s to increase your limits or troubleshoot issues. So add the 100$ and request an upgrade :)
Anjan G.
·
·
I tried apify actor too but still I'm not getting big company lists like most companies are repetitive because one company is hiring for multiple RN positions! I asked this question in the support section. check it out Bo (.
Anjan G.
·
·
you don't understand my USe case I ask the question using Apify actor in the support channel
Bo (.
·
·
Thanks for replying to this ticket to keep things efficient! 😊 It seems like you’re suggesting that there may be a misunderstanding, so I’m curious—what part do you feel I’m not understanding? From what I can tell, you pulled a sample, but it contained many duplicates. The likely cause is the sample size being too small or having too many criteria applied in a short time. Increasing the sample size should give you more diverse results. Let me know if this helps clarify things! 😊
Anjan G.
·
·
I got 4.5k companies that were hiring for RN position using only Clay find job table but after that I got only 454 companies
Bo (.
·
·
Yes, it seems like the search didn’t return more results—this can happen sometimes but if you see that it's wrong and If you’re having issues with Apify not pulling enough results, I’d recommend reaching out to their support team for assistance. They should be able to help resolve any limitations you’re facing. Let me know if you need anything else! 😊

33 comments