Acquia CDP

Transaction feed

Transaction feed structure

Field nameImportanceData typeReferential integrityDescription
SourceTransactionNumber (key)RequiredStringTransactionItem:SourceTransactionNumber, Webtag:SourceTransactionNumberThe unique identifier of the transaction in your data.
SourceOrganizationNumberRequiredStringOrganization:SourceOrganizationNumberThe identifier of the organization where the transaction was placed. For example, San Francisco store or ecommerce website.
TotalOptionalFloat The total revenue of this transaction. Customer Data Platform (CDP) uses the revenue at the TransactionItem level and does not leverage Transaction-level information to spread it across TransactionItems.
CurrencyOptionalString The currency for this transaction’s revenue, costs, discounts, and other monetary amounts.
DiscountOptionalFloat The total discount used by the customer for this transaction. Customer Data Platform uses the discount at the TransactionItem level and does not leverage Transaction-level information to spread it across TransactionItems.
TaxOptionalFloat The total tax paid by the customer for this transaction. Customer Data Platform uses the tax at the TransactionItem level and does not leverage Transaction-level information to spread it across TransactionItems.
TypeOptionalString The type of transaction, typically “Purchase”.
TransactionTimeStampRequiredDatetime The date the transaction was placed.
SourceCustomerNumberRequiredStringCustomer:SourceCustomerNumber, TransactionItem:SourceCustomerNumber, Webtag:SourceCustomerNumberThe identifier of the customer billed for the transaction.
DateCreatedOptionalDatetime The date the record was created in the client’s system.
Custom attributesOptionalAny (float, datetime, string, boolean) The custom attributes that you want to use inside the CDP application. This customization is not self-service. You must engage with your CDP Customer Value Manager and it involves deployment effort.

You can also find examples and use cases for this feed in Transaction Item feeds.

Did not find what you were looking for?

If this content did not answer your questions, try searching or contacting our support team for further assistance.

Acquia Help

Filter by product:

Acquia CDP common questions