Discussions
How to remove a set of custom object records from the Salesforce Campaign object
We use Eloqua integrated with Salesforce.com via the Salesforce integration app. Salesforce Campaign members are stored in a custom object. I mention this because this is the only Eloqua instance I've used to date and I don't know if there are other methods that could be in use.
The problem I am trying to solve is that when contacts in Salesforce.com are removed from a Salesforce campaign, they remain in the Eloqua custom object as associated with that campaign. I.e., a segment with the filter "Has Linked Contact in Custom Object"->Campaign Name = to "ABC" will still show people who are no longer in the campaign.
I have a situation now where nearly 400 records were imported into Salesforce by mistake and added to a Saleforce campaign. It was a mistake because those people were already in Salesforce and the import created duplicates. To fix this, the import was reversed - the 400 people were deleted from Salesforce and the Salesforce campaign they had been added to now has no members. But, of course, Eloqua still sees those 400 records in the Salesforce campaign CDO. Is there some way to remove them from the CDO?
Answers
-
The SFDC App does not delete Eloqua records. You can mark those 400 records as deleted, and remove them directly in Eloqua. https://docs.oracle.com/en/cloud/saas/marketing/eloqua-user/Help/CustomObjects/Tasks/DeletingCustomObjectRecords.htm
Does it help?
-
Hi @Nathan Nemirovski-Oracle - Thank you for getting back to me. I read the document you sent the link to and it doesn't help, unfortunately. If there were only a handful of records, I can see how to delete them manually. I have studied the Custom Object Program before but since you can't feed it with a segment - only a Listener - I can't figure out how to add my custom object members to the program in order to delete them. Note that those 400 records were already deleted as contacts in Eloqua. So, come to think of it, I guess there's no way to add them to a Custom Object program even if I could figure out how to get them in via the Listener. So are we stuck?
For the record - how can we get people into a custom object program since we can't use a segment?
Thanks again for any insight!
