I'm trying to recreate the values that Pardot/Account Engagement is generating from the Landing Page Statistics report through their API but I can't figure out the best way to do it with tables available. I know there is a Salesforce object called "LandingPage" but we need to be able to get dates of views which lies SOMEWHERE in the API. I just can't figure out how to build datasets so it would produce the same value as the LandingPage object.
I have tried to do it in CRM Analytics and I'm somewhat close but it's obvious that there are some fields that are not available in the API but are in CRM Analytics (i.e. stats_date).
Has anyone been able to successfully do this? #CRMA #Pardot #AccountEngagement #API
were you able to do this?
there is an endpoint that gives statistics but it seems to only work on a per-id basis.
https://developer.salesforce.com/docs/marketing/pardot/guide/emails-v4.html#email-statistics
what i dont like about using visitor activity is that its a huge data set to then aggregate