Has anyone run across a problem comprehensively gathering all lead activity for a given activity type? I’m finding gaps in my data even though I’m keeping track of all my datetime cursors.
So I have a script that uses the "Get Lead Activity" REST API call and queries activity type IDs [6, 7, 8, 9, 10, 11, 27]. If I make the call at 2016-02-17 22:15 UTC for all data since 2016-02-17 18:15 UTC, I capture both dates in a database table so that I know the last date range I requested those activity types. So when I next make the API call, my sinceDatetime would then be 2016-02-17 22:15 UTC. I even add a one minute buffer to make sure I don’t miss anything.
However, I’m noticing that the counts of each activity type don’t match with the campaign numbers in the Marketo UI. How else can I ensure that I’m capturing all activity?