Clay Icon

Getting Estimated Ads Across Platforms and Automating Google Transparency

Β·
Β·

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

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    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."

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·
  • Avatar of Khawaja F.
    Khawaja F.
    Β·
    Β·

    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

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    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.

  • Avatar of Khawaja F.
    Khawaja F.
    Β·
    Β·

    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

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    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.

  • Avatar of Khawaja F.
    Khawaja F.
    Β·
    Β·

    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

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    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.

  • Avatar of Khawaja F.
    Khawaja F.
    Β·
    Β·

    so i have to add another lookup in table 1?

  • Avatar of Khawaja F.
    Khawaja F.
    Β·
    Β·

    you guys should introduce sleep enrichment/action

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    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.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    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.