Enhancing Clay AI Prompt for Empty Values and Social Media Likes

Loh Y.

Can someone advise me on how to adjust this Clay AI prompt in this workbook here?

I want the prompt to return empty value every time it found nothing, but the AI sometimes still return Not Found for me.
I want the AI to return the number of likes of the social media profile they found, but sometimes they can find the profile URL, but not the likes. May I know why and if there is a way to improve the prompt for this?
Do suggest other ways to if you have to find social media profile URLs

8 comments

Loh Y.
·
·
Do suggest the prompt to use as well if I want the AI to search for facebook + company name, if nothing is found then facebook + domain name do note that the domain name is optional

Loh Y.

#CONTEXT#

You are tasked with finding official social media profiles for companies, using available company data.



#OBJECTIVE#

Find and return the official Facebook & TikTok profile URLs for the company, along with the number of likes for each platform.



#INPUT VARIABLES#

- Company Name: /f_0swz4zqFionkWZkhnkP 

- Country: /f_0sxs03m2QaQ4QUk5MZP 

- Company Domain: /f_0sxs09wraVzSyCwKXHA

- LinkedIn URL: /f_0sxs04gct6cDpK6ieme 





#INSTRUCTIONS#

1. Use the Company Name: /f_0swz4zqFionkWZkhnkP as the main search key.

2. Use the Country: /f_0sxs03m2QaQ4QUk5MZP, Company Domain: /f_0sxs09wraVzSyCwKXHA, and LinkedIn URL: /f_0sxs04gct6cDpK6ieme (if available) to cross-verify results.

3. Search for official company profiles on the following platforms:

- facebook.com

- tiktok.com

4. For each platform:

- Return the full profile URL

- Return the number of likes

5. Only return profiles that are official and confidently matched to the company. 

6. Exclude personal accounts, fan pages or unrelated profiles.

6. If no profile is found for a platform, return empty values.



#OUTPUT FORMAT#

- Facebook: \https://www.facebook.com/example | 12,345 likes\

- TikTok: \https://www.tiktok.com/@example | 67,890 likes\



If a profile is not found for a platform, return:  

Facebook: \ | \  

TikTok: \ | \

Loh Y.
·
·
Attaching my current prompt for now, as I'll be making modification to it soon before the team get to reply

Loh Y.

I managed to make it work with this prompt:

#CONTEXT#

You are tasked with finding official social media profiles for companies, using available company data.



#OBJECTIVE#

Find the official Facebook and TikTok page URLs for the company, along with the number of likes for Facebook and TikTok.



#INPUT VARIABLES#

- Company Name: /f_0swz4zqFionkWZkhnkP 

- Country: /f_0sxs03m2QaQ4QUk5MZP 

- Company Domain: /f_0sxs09wraVzSyCwKXHA

- LinkedIn URL: /f_0sxs04gct6cDpK6ieme 





#INSTRUCTIONS#

1. Start by searching for the official Facebook and TikTok pages using the company name as your primary search input.

2. If no clearly relevant result is found using just the company name, try using:

- The Company Domain (if available) as a secondary search term. 

- The Country or LinkedIn URL to help refine or validate the match. 

3. Use your best judgment to ensure that the profile truly belongs to the company. Do not include unrelated, fan-made, or personal pages.

4. Return only pages that clearly match the company identity — skip unrelated or personal pages.

5. If the profile URL is found, return it.

6. Extract the number of likes for Facebook or TikTok if visibly shown on the page.

   - If the count is missing or not shown, return a blank.

7. If no confident profile match is found, return a blank for both the URL and like count.

8. Do not return "Not Found", "Unknown", or similar text. Use blanks instead.



#OUTPUT FORMAT#

Facebook: \[Facebook URL] | [likes]\  

TikTok: \[TikTok URL] | [followers]\  



Example:  

Facebook: \https://www.facebook.com/example | 12,345 likes\  

TikTok: \https://www.tiktok.com/@example | 67,890 likes\  



If a profile is not found for a platform, return:  

Facebook: \ | \  

TikTok: \ | \

Loh Y.
·
·
How about resolving this:
I want the AI to return the number of likes of the social media profile they found, but sometimes they can find the profile URL, but not the likes. May I know why and if there is a way to improve the prompt for this?
Also if you refer to the row 11, i can see the AI finally first cralwed the company name, then used the company domain to finally found the facebook url, which is correct. But how do i know if the other information such as country and linkedin url given is being used by the AI too for their search?
Loh Y.
·
·
Hi again, I managed to make it work again by splitting the prompt into 3 instead combining them all into one, which will return inconsistent results.
Loh Y.
·
·
My last question is that I want to ensure the AI prompt does uses my country and LinkedIn URL to validate their findings or find more information. How can i do that, as far as I know, the AI is only using the company name and domain now.
Loh Y.
·
·
Hello any follow up?