Identify new companies??

[Shelly_Wilson]

Does anyone know how to create an alert, filter a smart list, or create a report to show NEW companies that were acquired by a campaign, or a given period? Company names not previously present in Marketo? I can't figure it out. I tried a list with the following filters:

• Company name is not empty
• Acquisition program is A, B, or C
• SFDC Account number is empty.

Also tried:

• Company name is not empty
• Acquisition program is A, B, or C
• SFDC Status is not [and then included all of our status options].

No joy. List reports people, but they include companies I know are in Salesforce. I think this is because the names are of leads who have not yet been converted to contacts and tied to saleforce accounts/opportunities.

Any ideas?

[Floyd_Alvares2]

Hi Shelly,

Marketo is all about "Person" or Leads. I believe there is no filter/trigger to identify new companies created. You would need to leverage that reporting in SFDC.

Thanks

Floyd

[Grégoire_Miche2]

Floyd is right, there is no possibility to query companies if there is not at least one contact in the database for them.

Once this is done, the company update date is not available either. If you want to search on this field, the simpler is to create a formula field copying this update field. This formula field will sync to Marketo and you will be able to use it in filters.

-Greg

[SanfordWhiteman]

FWIW, you can use a webhook to alert on new companies pretty easily (well, "easily" once you're used to the webhook realm).

The unique company list can just be another form of counter, like counting event registrations, etc.

[bcarp-palisade]

I'd like to piggyback on this discussion. What about creating notifications for new leads from new companies? 

Something like:

Lead is Created

-> If company is Known, Do Nothing

-> If company is Unknown, Send Alert, then Add to Known Company List

Is it possible? (I started to build something out but I have 90,000+ companies in my database and Marketo's Company Name filter didn't appreciate me pasting them all in🤣)

[SanfordWhiteman]

Basically the same answer as in the earlier posts: you need a webhook to know that the company info is net new.