Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

Extending the Interaction History table for the CaptureResponse service

Updated on August 3, 2022

Extend the Interaction History table to support custom properties for the CaptureResponse service.

  1. In Dev Studio, create the properties that you want to add in the appropriate interaction history class (Fact or Dimension).
    For example: Create an AccountID property in the Data-Decision-IH-Fact class.
  2. Create matching columns in the appropriate interaction table (Fact or Dimension).
    Note: If you use a database editor to add the columns, verify that they have been properly created.
    For example: Create an AccountID column in the pr_data_ih_fact table.
  3. Copy the Data-Decision-IH-Configuration.pyInteractionHistoryConfiguration data transform to your Artifacts ruleset and update it to add the new properties that you created in step 1.
  4. Click DecisioningDecisionsProposition ManagementHierarchy.
  5. Create the matching properties, for example, AccountID.
    Note: By default, this creates columns with a length of 32 characters. If required, edit the property and set the Max Length to a higher value.
  6. Copy the Data-Decision-IH-Configuration.MKTInteractionHistoryExtension data transform to your Artifacts rule set and update it to add the new properties that you created in step 1.
    Tip: Follow the pattern documented in the Comment field.
  7. Re-save the corresponding Database Table rule for the interaction class where you added the properties.
    For example: Re-save the Data-Decision-IH-Fact database table.
  • Previous topic Making custom Strategy Result properties available for real-time container data flows
  • Next topic Setting the custom property in a real-time container response

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us