Skip to main content
Iryna_Zhuravel4
Iryna_Zhuravel4
Level 6
December 7, 2016
Question

Is there a reliable way to track new account names vs new leads?

  • December 7, 2016
  • 3 replies
  • 4384 views

I am looking for a way to track not just new lead names in the database, but new account names that enter the system. In our B2B business a lot of form requests come from new names from existing accounts, I am planning to get a third party tool to route and attach folks like this directly to their respective accounts, this should clean things up a bit with the new leads. However, even once that is done I still don't see a straightforward way to put together a report for the number of net new account names that entered the system within a certain period of time, but I am sure there is an app for that

Has anyone done something like this? What tools did you use?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

A
Anonymous
December 7, 2016

Have you tried doing anything using RCE? It may not be the most elegant solution in the world but it may get the job done. You could do something with the Month and Company Name count. Then again, you may have better luck doing this directly out of your CRM.

Josh_Hill13
Josh_Hill13
Level 10
December 7, 2016

Totally depends on how you process and create Accounts. Account Create Date and Source would help here without fancy tools.

Iryna_Zhuravel4
Iryna_Zhuravel4Author
Level 6
December 8, 2016

I guess I didn't explain it well enough.

I can very easily pull a list of accounts created within a certain period of time of course. What I need to track is how many new company names entered the system before leads from these companies are even converted to accounts.

Say if john.smith@abc.com is acquired by a form, and we do not have an ABC account nor do we have anyone else in the database with the @abc.com email, then ABC will count as 1 new company name. However, if we already had a lead steve.smith@abc.com in the system at the time John filled in the form, then ABC won't count as a new company name.

Our management is adamant that we need to get this metric, and I can't think of a way to do it without having to spend my days buried in spreadsheets.

    Grégoire_Miche2
    Grégoire_Miche2
    Level 10
    December 8, 2016

    Hi Iryna,

    This a trickier question than it seems. Accounts are frequently mispelled on new leads, leading to "false" new names that, once corrected, appear to already be known.

    Marketo standard will not allow you to do this, and you would have to extract the lead DB, including old and new leads, and create some pivot table on account name, keeping the oldest "created" date for each account.

    RCE, might also be a solution.

    Without RCE, If I had to guess, I would probably do the count on the CRM side, at the end. In SFDC, I would add all my leads and contact to a campaign, create a mechanic to save in a field the lead original creation date", add this field to a formula field on campaign members that brings the lead or account creation date and create a report on campaign members, grouped by account name.

    -Greg

      Iryna_Zhuravel4
      Iryna_Zhuravel4Author
      Level 6
      December 8, 2016

      Thanks Greg, exactly!

      We are global as well, so we might have different spellings and divisions of the same company called something different in different locations (e.g. Gmbh vs Inc vs LLC).

      The only way I could think of would be a spreadsheet, but we have 1M+ leads in our database, it is a little problematic to dump them all into one spreadsheet.

      That's why I was thinking of looking for a third party tool that could may be do something like this. ABM is a hot topic now and tracking new company names somewhat is related to ABM, so I was hoping there is something out there

        Terms & ConditionsAccessibility statement

        Loading footer...