Discussions
Custom object services
Custom data objects (CDO) can be helpfull containers of data.
One of its most simple use would be to use contact related information for which you don't want to create contact fields.
Another one would be to store all responses in your Eloqua instance (could be accomplished using a master hidden form too).
More advanced usage would be integration with external platforms.
CDO setup examples
We need to distinguish between 2 different custom objects setup:
- with primary key (usually email address): once an entry is submitted, any additional submits from the same contact will update the initial entry (can depend on form processing steps setup);
- without primary key: each new submit will create a new entry in the CDO.
Contact mapping
You can check the mapping of your CDO to contact records by going into the Reporting menu on the upper right side after opening the CDO. Just pick "Custom Object Records Mapped to Contacts Breakdown".
The window which will pop up will let you know how many unmapped entries you have. Let's say that out of 6.5 mil custom object entries (we asume we have a custom object with no PK) you have 1 mil unmapped entries. This means that the data in those unmapped entries cannot be found with filters(or segment filters) because filters check if contacts have linked records in custom objects but in this case those responses are unmapped.
One of the reasons for having unmapped entries in an CDO is that the "map to contact" box was not selected at upload.
Services
The services can be accessed once the CDO is opened, from the upper right menu, click Custom Object --> Custom Object Record Services.
Basically you will be able to set some processing steps, similar to the program builder steps (or let's say forms processing steps for those less familiar with programs).
There are 2 options for when to run the steps: for new data, or for modified data. What this means is pretty self explanatory, but also described in the screenshot below.
When addding a processing step upder any of the categories above the available options are below.
Most commonly used option would be to add to a Program Builder or adding to a specific list. You can also run an Integration Rule if you do this from a CDO level. Most of the steps can be conditional.
Comments
-
Any idea on the frequency for the CDO Services to be executed? Let's say every 30min or each hour?
Thanks!
@Justina Allen-Oracle, @Adrian Chang-Oracle, @TJ Fields-Oracle, @eloquasupport, @eloqua_support
-
Any idea on the frequency for the CDO Services to be executed? Let's say every 30min or each hour?
Thanks!
@Justina Allen-Oracle, @Adrian Chang-Oracle, @TJ Fields-Oracle, @eloquasupport, @eloqua_support
Thoughts? @Brigitte Li-Oracle
-
They are typically executed every 15 minutes.
-
Thoughts? @Brigitte Li-Oracle
Yep - Rohit is correct, the services run once every 15 minutes. Shoot me an email if you have anything specific you'd like to confirm.
-
Any idea on the frequency for the CDO Services to be executed? Let's say every 30min or each hour?
Thanks!
@Justina Allen-Oracle, @Adrian Chang-Oracle, @TJ Fields-Oracle, @eloquasupport, @eloqua_support
Every 15 minutes. Sad part is like it end up in executing same records again and again. For example, Modified records, even the record gets modified only one time, this service will consider that record for every 15 mins schedule.
-
Every 15 minutes. Sad part is like it end up in executing same records again and again. For example, Modified records, even the record gets modified only one time, this service will consider that record for every 15 mins schedule.
@Sekar R I'm not sure how your process is set up, but that doesn't sound like the expected behavior, nor the behavior I typically see. Are you modifying the modified Custom Object record, thus it's included again in the next run?
-
Is there a way to map all the unmapped CDO records?
-
Is there a way to map all the unmapped CDO records?
Hi @2929690,
Yeah you can able to do that process in couple of ways. First you export out the unmapped CDO records from custom object. Now take the email address from these records and upload them as contacts in Eloqua database. Then upload back the records to CDO (in upload actions wizard, you need to check Map data cards and then to choose email address as the field to map)
This process will update the mapping for existing records. For do the same for future records, just create a custom object service for both new and modified data with the processing step as "Save to contact table".
Fore more details, mail ([email protected]) or ring me (+6584203703)
Thanks,
Sekar.
-
How do we speed up the CDO record services for specific CDOs? 15 minutes is just too slow for our use case (ie. some of the data from the CDO is being used to populate field-merges on an email, but first the CDO needs to run through a program canvas). Right now there is a 15-30 min delay from form submission to email sent because of the CDO record services taking too long.
I get that this is probably a "system limitation" due to processing constraints, but there must be a way to custom override it for low-volume CDOs, no? (by low volume I mean we'll probably get a few dozen a day).
-
How do we speed up the CDO record services for specific CDOs? 15 minutes is just too slow for our use case (ie. some of the data from the CDO is being used to populate field-merges on an email, but first the CDO needs to run through a program canvas). Right now there is a 15-30 min delay from form submission to email sent because of the CDO record services taking too long.
I get that this is probably a "system limitation" due to processing constraints, but there must be a way to custom override it for low-volume CDOs, no? (by low volume I mean we'll probably get a few dozen a day).
Nope - a system limit on the 15 minutes - CDO Services essentially uses the 'program builder' engine.
At form submit, add to the CDO and to the program/campaign at the same time to eliminate the time lag.
Nathan
-
Anybody remembers what was the number of processed records every 15 min? Was it 5000 ?
-
sadly yes @Codrin Teiu, it's just 5,000 CDO records per 15 mins for an entire Eloqua account. But it behaves very unpredictably.
we have a CDO with about a million record and after we update something in even half of our customers / leads in salesforce, the CDO services are chocked for other CDOs as well for days. No clear idea why it takes so long even though in a day about half a million records should be processed.
:(
