Edward Zhang

Commented on Recommendations for Web Scraping and Data Accuracy...·Posted in02 Support

Edward Zhang

And here, I'd have personal info, no name... is there anyway to mass merge these?

Commented on Recommendations for Web Scraping and Data Accuracy...·Posted in02 Support

Edward Zhang

in the past example, I'ld be missing a phone nmber in the column with the same facilities.

Commented on Recommendations for Web Scraping and Data Accuracy...·Posted in02 Support

Edward Zhang

the address are in Streets or St. or st. or st; one standard format would be great

Commented on Recommendations for Web Scraping and Data Accuracy...·Posted in02 Support

Edward Zhang

Another issues is is there anyway to normalize the address?

Commented on Recommendations for Web Scraping and Data Accuracy...·Posted in02 Support

Edward Zhang

Hi Clay team, I’m running into a challenge where I have two similar lead lists from different sources, but each contains some unique information that the other doesn’t have. My goal is to merge the data while keeping the most complete and accurate details for each lead. Here’s an example of the issue: List 1 (More Contact Details, But Some Gaps)

Association: BC Care Providers  
Company: Park Place Seniors Living Inc.  
Phone: (604) 796-3886  
Location: Agassiz Seniors Community  
Address: 1525 MacKay Crescent, Agassiz  
Industry: Long-Term Care  
Website: https://parkplaceseniorsliving.com/find-a-location/british-columbia/lower-mainland/agassiz  
Employee: Cindy Zorn  
Title: Site Leader  
Phone: 604-796-3886  
Email: czorn@ppsl.com  
Notes: Left Voicemail (Rep: Xander)

List 2 (Different Contacts & Additional Info, But Missing Some Fields)

Company: Park Place Seniors Living Inc.  
Phone: (604) 796-3886  
Location: Agassiz Seniors Community  
Address: 1525 MacKay Crescent, Agassiz  
Website: www.parkplaceseniorsliving.com/find-a-location/british-columbia/lower-mainland/agassiz  
Employee: Catherine McColl  
Title: Food & Beverage Manager  
Phone: Undefined  
Email: Undefined  
Notes: Catherine McColl, Agassiz Seniors Community

What I Need Help With: ✅ Best way to merge these records into a single complete entry while ensuring that no data is lost. ✅ How to handle duplicate fields intelligently (e.g., when one list has a phone number, but another does not).

Commented on Recommendations for Web Scraping and Data Accuracy...·Posted in02 Support

Edward Zhang

And just curious, if I made a mistake. is there anyway to go back?

Commented on Recommendations for Web Scraping and Data Accuracy...·Posted in02 Support

Edward Zhang

Hi Bo. Regarding the following

1.
Dedupe--I noticed there are first & last names of people who runs multiple facilities; therefore I also combined facility names with formula. This seems to work.
2.
Another thing that came up was how do I mass "reset to original value"? I can do it manually, but theres around 1300 inputs...

Commented on Recommendations for Web Scraping and Data Accuracy...·Posted in02 Support

Edward Zhang

Hey Bo, much appreaciate the help. I have the following questions:

1.
i have 300/1800 contacts that I can find Linkedin for, any other way to enrich their email + phone data?
2.
How does Dedupe work? I used it, but am not quite clear wehter this is working: https://app.clay.com/workspaces/464956/workbooks/wb_FjUdcBWYPoDQ/tables/t_8Skrb3pypgss/views/gv_K5pEiJWkzn9R
3.
Regarding The ideal workflow for Work Email -> Full name, Domain -> Work Email -- does domain mean the company domain? A little tricky is I have the Organization & the Facility. in my database. One organization can own a few facilities. I'm wondering how would you solve for work email and contact in this situation?
4.
Use the "Find Domain" integration from Google—it's free. Once you get the domain, you can pair it with full name to find work emails. -- on myside it's asking for 1 credit, is there something I'm paying attention to?
5.
I want to hide repeated columns (or rows with repeated data) temporarily, enrich the remaining unique rows, and then propagate the enriched data back to all the duplicates. is there a way to do this?

Commented on I’m in the glazing space·Posted in01 Welcome and Intros

Edward Zhang

Btw, found another way: https://www.clay.com/university/guide/write-to-table-integration-overview Array of data by “writing to another table” I want to share this with you incase you ever use it

Commented on Recommendations for Web Scraping and Data Accuracy...·Posted in02 Support

Edward Zhang

Not a lot has came up for the people I’m looking for: https://app.clay.com/workspaces/464956/workbooks/wb_FjUdcBWYPoDQ/tables/t_8Skrb3pypgss/views/gv_K5pEiJWkzn9R Are there other affective ways to find either their emails or phones?

About

Country
My Company Website
Title