Jo_Pitts1

@abhishek_c ,who is the 'you' you are referring to? Neither Sanford nor I work for Adobe. Like all of those who contribute, we are people who use Marketo on a day to day basis and volunteer our time to the community to help people with issues.You've achieved something quite remarkable - namely, yo...

@abhishek_c ,I think you need to step back a little. If replies aren't forthcoming, maybe it is the nature of the question - which you can always expand on within your original thread (and I often do when I realise my original question didn't have enough detail, was unclear, or just poorly phrased)...

@abhishek_c , to a large extent, how data is stored in Marketo is immaterial. It is what it is what it is. I think you need to define your requirements a lot more clearly. Is it to get all new/changed leads out on a regular basis, along with their activities, and all ancillary campaign details, an...

@michellechopin ,It might pay to be a bit clearer about 'first activity'.Do you mean from when they become known, or all time?Do you want to correct this retroactively?What do you mean by first activity. Arguably, to have become a known lead they must have an activity (albeit potentially outside of...

Sanford,that was where I think I'd gotten myself to as well 🙂As always, cheers for validating my slightly meandering thinking 🙂

@SanfordWhiteman ,That makes a measure of sense (and is heading down the path I expected). I'll convert this into a fully worked example, and post it back here when done (although it'll probably involve a few more questions before I get there). CheersJo