Any recommendation on how I can get the estimated ad sent across different platforms ? Also how do i automate google transparency ? it is different for every company. TIA
We have a template that can help you get ad data across different platforms for various companies. Here's how it works: 1. Import companies based on your criteria using Clay's company search. 2. Use Adyntel, an ad API, to pull ads from those companies into Clay through our HTTP API. 3. Get links to ads on Facebook, LinkedIn, and Google platforms. This workflow allows you to: ** See if companies are running ads on different platforms ** Retrieve ad data to analyze advertising strategies and performance * Scale this process for multiple companies To get started, you can copy our template and follow the steps to set up the Adyntel API integration. This will help automate the process of gathering ad data and Google transparency information for different companies. If you need further assistance, you can request human help by clicking on "Talk to a person."
the problem is I'm writing stuff from table 1 to table 2, enriching some data there in table 2 and then looking up again in table . and i want to add a pause in between so table 2 get's enriched and then it's get looked up again
Unfortunately, Clay doesn't have a built-in pause feature between table operations. However, you can achieve a similar effect by using conditional runs. Here's a workaround: 1. Use "write to table" to transfer data from table 1 to table 2. 2. In table 2, set up your enrichment column with a conditional run. Use the "Only run if" setting to create a condition that checks if the data from table 1 is present. 3. For the lookup in table 2, set another conditional run that checks if the enrichment is complete. This approach ensures each step only runs when the previous one is finished, creating a pseudo-pause between operations.
not geting my point i have data in table 1 from different sources, that have similar ccompanies most of the times but there are new as well so i am writing companies in table two, enriching them there and using AI to scrape websites aswell than in table 1 i lookup for companies in table 2 if they are already there they gets populated in table 1 if not they gets written in table 2 enriched there and using the lookup again in table 1 they gets populated in table 1 i have three columns in table 1 lookup companies in table 2, if not found write these comanpies to table 2,lookup again for new written companies
To set up this workflow in Clay, you can use the "Write to Other Table" feature. Here's how: 1. In table 1, set up a "Write to Other Table" enrichment for new companies: • Select the destination (table 2) • Map the relevant columns from table 1 to table 2 • Configure run settings (e.g., auto-update for new rows) 2. In table 2, set up your enrichment columns for the new companies. 3. Back in table 1, use "Lookup Multiple Rows in Other Table" to fetch the enriched data: • Select table 2 as the source • Map the matching columns (e.g., company name or domain) • Choose which enriched data to pull back This setup allows you to write new companies to table 2, enrich them there, and then populate table 1 with the enriched data.
it takes almost 10-15 seconds to enrich data in table 2 but the lookup in table 1 starts running after 2-3 second and no enriched data is fetched
To ensure the lookup in table 1 waits for data in table 2 to be fully enriched, you can use a boolean formula and conditional runs. Here's how:
1. In table 2, create a boolean column that checks if the enrichment is complete.
2. In table 1, use this boolean column in a conditional formula for your "write to table" and lookup operations.
For example:
1. Table 2: Create a column "Enrichment_Complete" that's true when enrichment finishes.
2. Table 1: Set up conditional runs for your lookup using a formula like:
=LOOKUP("Table2", "Enrichment_Complete") = true
This way, the lookup in table 1 will only run when the data in table 2 is fully enriched.
so i have to add another lookup in table 1?
you guys should introduce sleep enrichment/action
Yes, you'll need to add another lookup in table 1 to ensure it waits for data in table 2 to be fully enriched. Here's how you can do it: 1. In table 2, create a boolean column that indicates when enrichment is complete. 2. In table 1, add a new lookup column that checks this boolean value in table 2. 3. Use this new lookup column in a conditional formula for your existing lookup operation. This approach allows you to control when the main lookup runs, ensuring it only happens after the data in table 2 is fully enriched. If you need more detailed guidance on setting this up, feel free to ask for further clarification.
We understand your need for a delay between table operations. While we don't currently have a specific "sleep" feature, we've recently introduced Scheduling, which might help address your workflow needs. Scheduled columns allow you to automatically re-run specific columns or entire tables on a recurring basis. This feature can help manage the timing of your operations, ensuring data is processed in the desired order. For more precise control, you can use conditional formulas to create dependencies between operations. This approach can help ensure that one process completes before another begins. If you need further assistance with implementing these features for your specific workflow, please click on "Talk to a person" for more detailed guidance.