Eloqua Bulk API - Add "Date Modified" field to activity export records

jecolema

In the Bulk API, for Contact and CDO objects, it is possible to filter on "Date Modified". This is helpful for Eloqua customer ETL processes, as you capture both new records and anything that has changed.

For Activity records, however, this is not an option. Because activity records are transactional, this is usually not an issue as the records will not be updated. But, "PageView" and "WebVisit" records can be updated post-creation (contact ID added due to unknown visitor conversion).

Adding a "Date Modified" would help any client processes keep up-to-date with the data available in the API (and would make certain of our internal customers very happy!).

This idea is tracked in EMCS-79029.

jecolema

There is one possible workaround: since this really only seems to affect WebVisit and Pageview, and revolves around contact/visitor associations, maybe we could just feed in when that visitor record was last modified?

Christopher Campbell-Oracle

There is one possible workaround: since this really only seems to affect WebVisit and Pageview, and revolves around contact/visitor associations, maybe we could just feed in when that visitor record was last modified?

Activities are not modifiable directly.  We are looking at ways to address the linking of contacts to webvisit and page view activities as noted in the referenced jira ticket - EMCS-79029.

Lou Patrick

We are currently working on adding a "Linked To Contact Date" field to PageView and WebVisit activity exports.

Lou Patrick

LinkedToContactDate activity field added to page view and web visit activity exports in release 19A.

Changelog note:

We've added a new activity field that enables you to filter on the date and time a visitor was linked to a contact. This activity field is available when creating an activity export definition for page view or web visit activity types. Activity records are only returned when linked to a contact. Previously, to export all newly linked activity records, an export as far back as an activity is meaningful would need to be performed to capture newly linked records. With LinkedToContactDate, newly linked activity records can efficiently be exported without exporting activities that have already been exported.The syntax for the new LinkedToContactDate activity field is: {{Activity.Field(LinkedToContactDate)}}When export data is retrieved, the LinkedToContactDate will be populated with the date and time the contact was linked to a visitor.