Tricky Reporting

[Anonymous]

Hi Community,

i´m pretty new using marketo (Jan 2015) and how to say, i for sure love it! What i was trying to do is to get a Report out of my data with marketable Companies. The thing ist that i can only get marketable Contact Data out of the system cause we have multiple contacts on one Company. Any ideas to tweak the report just show me one "random" contact per companie so that i have just one companie left? (just doesn´t want to rework all the data in Excel to filter duplicates)

To make it more clear, i need a way to show in a report Companies by specific Level. Right now i´m just be able to show contacts by a specific level.

Thanks in Advance!

[Josh_Hill13]

No, you cannot do this. Marketo is lead focused. You could do Company Name=X AND Marketable=T to see at least one lead, if it exists at that company.

You could also do this on the lead analysis report in RCE.