Strategy Article for Deleting Assets in ADM

Removing Assets from Eloqua – Recommendations

Key features for Asset Dependency Manager

  1. Identify or View dependencies of Eloqua Assets.
  2. Export dependencies report of Eloqua Assets
  3. Remove dependencies from Eloqua Assets
  4. Replace dependencies from an Eloqua Asset to another
  5. Deleting Assets by clearing out the dependencies
  6. Cruise Control for clearing or deleting dependencies

Best Practices and Recommendations

This section provides recommendations on how to proceed with cleaning up your Eloqua instance by considering the types of dependencies that the Eloqua assets can possess and the complexity of clearing out the dependencies.

As a framework to remove dependencies so that assets can be deleted from your Eloqua instance, dependencies get removed by dependent asset type. For example, if you remove dependencies for Contact Fields, these dependencies can exist in Segments, Contact Views, Campaigns, BULK Import/Export definitions, etc. The table below recommends that you remove the dependencies of Contact Fields from Bulk Import/Export definitions, then Contact Views, then Segments/Shared Filters, etc.

Eloqua asset dependency manager to clear unwanted dependencies

Identification criteria for assets to be removed from Oracle Eloqua

The below outlines the benchmark recommendations based on Oracle Eloqua data retention policy. However, this recommendation should be evaluated for each instance to ensure that it does not have a negative impact to the use of an Oracle Eloqua’s specific instance


Qualification Analysis

* Completed campaigns with an end date of more than 25 months
* Campaigns with no responses

Contact Segments

Qualification Analysis

* Segments are only used in Campaigns with an end date of more than 25 months
* Segments “last accessed” in last 25 months
* Segment “last calculated” in last 25 months
How To
Execute a script that extracts the dependencies for each segment. Filter the dependencies to identify the Campaigns in which the dependencies appear in and match with the above qualification analysis for Campaigns.


Qualification Analysis

* Emails with “no activity” (send/open/click through) with the last 25 months
How To
Combine Email Open, Email Send, Email Click through report where the Activity date for each of these reports is less than or equal to TIMESTAMPADD(SQL_TSI_MONTH, -25, CURRENT_DATE).

Below is a sample configuration of an Email Open report that can be replicated across the other Email Activity Types.


Qualification Analysis

* Forms with “no submissions” with the last 25 months

Landing Pages

Qualification Analysis

* No page visits with the last 25 months (Primary Condition)
* Only included in Campaigns older than 25 months
* Only included in Emails older than 25 months
How To
Extract a list of all landing page assets (through PortQii Workbench).

Exclude all returned landing-pages in the below Insight report from the list returned from PortQii Workbench

NOTE: PortQii Workbench is a free application that is capable of extracting a full list of assets from an Eloqua instance.
Eloqua asset dependency manager to clear unwanted dependency


Qualification Analysis

* Picklists with no dependencies in EloquaHow To
How To

Extract list of Picklist using PortQii Workbench. Use the list to run a custom script that calls the dependencies endpoint for each Picklist ID returned to check if dependencies exist for that Picklist.

NOTE: PortQii Workbench is a free application that is capable of extracting a full list of assets from an Eloqua instance.
No items found.

Email alerts on product updates, new product announcements, special promotions and more!