My Domain and Companny Name and phone columns were mapped to source columns but somehow didn't update, AND no extra columns were sent, so now i dont have the domain in my target table. WHy?
when i wrote to my other table. there was already a column called domain in it, but for some reason the source table's "Domain" column didn't write to the target table's "Domain" column. why?
what syntax do i use to say only run a clay column if job title contains one of ["president","owner","ceo","vice president","vp","gm","general manager"]
coming back to my repeatable process. isn't it messy to create a new workbook for every new subset of accounts?
This is the process i want to. run weekly:
Find local businesses that match criteria >> Filter them according to some pre-arranged fitlers
Use the resulting companies as the base for a people search, using the same filters as i do for every iteration of compan ies
then run some enirchment on a select grroup of people meeting certain criteria
How can i ensure i have one master list of people and companies that i'm targeting in clay that gets updated every 2-7 days?
