8 Replies Latest reply on Dec 9, 2016 10:22 AM by Grégoire Michel

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

    Iryna Zhuravel

      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?

        • Re: Is there a reliable way to track new account names vs new leads?
          Brent Levi

          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.

          • Re: Is there a reliable way to track new account names vs new leads?
            Josh Hill

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

            1 of 1 people found this helpful
            • Re: Is there a reliable way to track new account names vs new leads?
              Iryna Zhuravel

              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.

                • Re: Is there a reliable way to track new account names vs new leads?
                  Grégoire Michel

                  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

                  1 of 1 people found this helpful
                    • Re: Is there a reliable way to track new account names vs new leads?
                      Iryna Zhuravel

                      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