Clay Icon

How to Build a ClayAgent: Finding Fiscal Year of Companies

·
·

Anyone have an idea for how to build a clayagent to find the fiscal year of a list of companies?

  • Avatar of Greg C.
    Greg C.
    ·
    ·

    Tried DUNs but didn't really have all i wanted, lots of missing data.

  • Avatar of Tenzin R.
    Tenzin R.
    ·
    ·

    Greg C. You could do a web search "fiscal year for {company}" scrape the first 2 results then extract out the answer using gpt-3.5

  • Avatar of Greg C.
    Greg C.
    ·
    ·

    interesting idea

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Greg, thanks for reaching out! Yep, a simple prompt like Tenzin R. recommends could probably help achieve this, if a few results don't return it should display its reasoning for it and you could refine the prompt to consider that too.

  • Avatar of Greg C.
    Greg C.
    ·
    ·

    got it, i'll try it out!

  • Avatar of Tenzin R.
    Tenzin R.
    ·
    ·

    With the integration in ScrapeMagic set "fiscal year" as one of the properties, do that after a google search. I tested a couple searches on public companies and it usually returns their investor pages which should have the available info in there

  • Avatar of Greg C.
    Greg C.
    ·
    ·

    It was actually easier, there's a clayagent built into ClearBit that had it. Just ran it all. That was insane!

  • Avatar of Adam E.
    Adam E.
    ·
    ·

    Greg C. Just out of curiosity, how did Claygent perform at this? Could you elaborate on the clayagent built into clearbit?

  • Avatar of Greg C.
    Greg C.
    ·
    ·

    Adam E. I used the "enrich data" feature and used "clearbit" as the data provider. Use the Enrich Company feature and within the field options there's a fiscalYearEnd that you can pull.