ETM
E-Commerce Item#
Occurence: An item has been selected and bought as a 'symbolic gift'.
Key Data: One row is produced for each item in an order. Additionally, the transaction notes what type of notification was requested 'EMAIL/POSTCARD/NONE' for the item, and stores the shipping details for fulfillment.
Export file columns#
Account ID#
Identifies the subaccount this item belongs to
Example: 94
Supporter ID#
The unique numerical database identifier for a supporter.
Example: 212200
Default: 0
Supporter Email#
The primary email address of a supporter, which will typically be used as the basis for identifying a unique supporter to which any transactions will be associated.
<= 500 characters
Example: otto.nv@example.com
Date Created#
The date a supporter was created. [ISO 8601 format date]
Example: 2024-12-01
Date Modified#
The date a supporter was last modified. [ISO 8601 format date]
Example: 2024-12-01
Campaign Number#
A unique database identifier used to refer to a page, particularly in transactional data.
Where records in transactional data originate outside of a page structure, for example as a result of dashboard actions or imports, this will hold a value of 0, indicating that the transaction outcome should not be associated with a particular page. Default: 0
Example: 10122
Campaign Type#
ETMThe Campaign Type is used to determine the layout of the data columns in the output stream.
Campaign ID#
The name given to this product.
Example: Umbrella
Campaign Date#
The recorded date [YYYY-MM-DD] of this transaction. If left blank during transactional import, the service will apply the import date. The reference timezone for this service is US/Eastern.
Example: 2024-12-01
Campaign Time#
The recorded time [HH:MM:SS] of this transaction. The reference timezone for this service is US/Eastern.
Example: 13:53:02
Default: 00:00:00
Campaign Status#
The user assigned Stock Keeping Unit for this product variant.
Example: TP3L
Campaign Data 1#
No output for this transaction type.
Campaign Data 2#
The internal reference name given to a page.
<= 160 characters
Campaign Data 3#
The transaction identifier as provided by a payment gateway. If the current transaction is a refund, then this identifier points back to the transaction being refunded. The specific formatting of the identifier will be dependent on the gateway.
Example: ND8390T284740397745210972__cus_O20rrZCTq8iTpw__ch_3NFwqEHh8CrK50QS1uUEXjck
Campaign Data 4#
The price or value of this product.
Campaign Data 5#
Applicable if Shipping Enabled is set to 'Y' on submission, and describes the entry for Title to use for shipping purposes. If shipping is not enabled for this transaction, then this value will typically reflect the value on the supporter's record for the tagged field for Title.
<= 50 characters
Example: Dr
Campaign Data 6#
Applicable if Shipping Enabled is set to 'Y' on submission, and describes the entry for First Name to use for shipping purposes. If shipping is not enabled for this transaction, then this value will typically reflect the value on the supporter's record for the tagged field for First Name.
<= 100 characters
Example: Otto
Campaign Data 7#
Applicable if Shipping Enabled is set to 'Y' on submission, and describes the entry for Last Name to use for shipping purposes. If shipping is not enabled for this transaction, then this value will typically reflect the value on the supporter's record for the tagged field for Last Name.
<= 100 characters
Example: Normalverbraucher
Campaign Data 8#
Applicable if Shipping Enabled is set to 'Y' on submission, and describes the entry for Email to use for shipping purposes. If shipping is not enabled for this transaction, then this value will typically reflect the value on the supporter's record for the tagged field for Email Address.
<= 100 characters
Example: otto@example.com
Campaign Data 9#
Applicable if Shipping Enabled is set to 'Y' on submission, and describes the entry for Address 1 to use for shipping purposes. If shipping is not enabled for this transaction, then this value will typically reflect the value on the supporter's record for the tagged field for Address 1.
<= 200 characters
Campaign Data 10#
Applicable if Shipping Enabled is set to 'Y' on submission, and describes the entry for Address 2 to use for shipping purposes. If shipping is not enabled for this transaction, then this value will typically reflect the value on the supporter's record for the tagged field Address 2.
<= 200 characters
Campaign Data 11#
Applicable if Shipping Enabled is set to 'Y' on submission, and describes the entry for City to use for shipping purposes. If shipping is not enabled for this transaction, then this value will typically reflect the value on the supporter's record for the tagged field for City.
<= 100 characters
Example: Musterstadt
Campaign Data 12#
Applicable if Shipping Enabled is set to 'Y' on submission, and describes the entry for Region to use for shipping purposes. If shipping is not enabled for this transaction, then this value will typically reflect the value on the supporter's record for the tagged field for Region.
<= 100 characters
Example: Musterregion
Campaign Data 13#
Applicable if Shipping Enabled is set to 'Y' on submission, and describes the entry for Post or ZIP Code to use for shipping purposes. If shipping is not enabled for this transaction, then this value will typically reflect the value on the supporter's record for the tagged field for Postcode.
<= 50 characters
Example: 12345
Campaign Data 14#
Applicable if Shipping Enabled is set to 'Y' on submission, and describes the entry for Country to use for shipping purposes. If shipping is not enabled for this transaction, then this value will typically reflect the value on the supporter's record for the tagged field for Country.
<= 100 characters
Example: DE
Campaign Data 15#
The Phone Number as supplied on the supporter record, to be used for shipping purposes. This value will reflect the value stored on the supporter's record for the tagged field Phone Number.
<= 100 characters
Campaign Data 16#
Shipping Notes. This may refer to any note added to shipping details, or any personal message added by the supporter to any electronic message or postal card that has been requested to be sent.
<= 2000 characters
Campaign Data 17#
No output for this transaction type.
Campaign Data 18#
The method used to send notification about the symbolic gift. If the supporter requests that no notification be sent, this will be recorded as NONE.
Allowed values:
EMAIL
POSTCARD
NONE
Example: EMAIL
Campaign Data 19#
No output for this transaction type.
Campaign Data 20#
No output for this transaction type.
Campaign Data 21#
No output for this transaction type.
Campaign Data 22#
No output for this transaction type.
Campaign Data 23#
No output for this transaction type.
Campaign Data 24#
No output for this transaction type.
Campaign Data 25#
No output for this transaction type.
Campaign Data 26#
No output for this transaction type.
Campaign Data 27#
No output for this transaction type.
Campaign Data 28#
No output for this transaction type.
Campaign Data 29#
No output for this transaction type.
Campaign Data 30#
No output for this transaction type.
Campaign Data 31#
No output for this transaction type.
Campaign Data 32#
No output for this transaction type.
Campaign Data 33#
No output for this transaction type.
Campaign Data 34#
No output for this transaction type.
Campaign Data 35#
No output for this transaction type.
External Reference 1#
When used outside of API page processing, this field may be populated using the URL parameters utm_source or by the generic parameter en_txn1. Content will be automatically truncated if the maximum length is exceeded, and the last three characters replaced by '...' to indicate that a string has been truncated.
<= 100 characters
External Reference 2#
When used outside of API page processing, this field may be populated using the URL parameters utm_medium or by the generic parameter en_txn2. Content will be automatically truncated if the maximum length is exceeded, and the last three characters replaced by '...' to indicate that a string has been truncated.
<= 100 characters
External Reference 3#
When used outside of API page processing, this field may be populated using the URL parameters utm_campaign or by the generic parameter en_txn3. Note: Content will be automatically truncated if the maximum length is exceeded, and the last three characters replaced by '...' to indicate that a string has been truncated.
<= 100 characters
External Reference 4#
When used outside of API page processing, this field may be populated using the URL parameters utm_content or by the generic parameter en_txn4. Note: Content will be automatically truncated if the maximum length is exceeded, and the last three characters replaced by '...' to indicate that a string has been truncated.
<= 100 characters
External Reference 5#
When used outside of API page processing, this field may be populated using the URL parameters utm_term or by the generic parameter en_txn5. Note: Content will be automatically truncated if the maximum length is exceeded, and the last three characters replaced by '...' to indicate that a string has been truncated.
<= 100 characters
External Reference 6#
When used outside of API page processing, this field may also be populated by a user-defined page property [Page > Admin > Campaign References], or by the url query parameter en_txn6. When added as a page parameter, the field is referred to as Campaign Reference 1 in the dashboard settings.
If a value is presented in both places, the url query parameter will take precedence. Note: Content will be automatically truncated if the maximum length is exceeded, and the last three characters replaced by '...' to indicate that a string has been truncated.
<= 100 characters
External Reference 7#
When used outside of API page processing, this field may also be populated by a user-defined page property [Page > Admin > Campaign References], or by the url query parameter en_txn7. When added as a page parameter, the field is referred to as Campaign Reference 2 in the dashboard settings. If a value is presented in both places, the url query parameter will take precedence. Note: Content will be automatically truncated if the maximum length is exceeded, and the last three characters replaced by '...' to indicate that a string has been truncated.
<= 100 characters
External Reference 8#
When used outside of API page processing, this field may also be populated by a user-defined page property [Page > Admin > Campaign References], or by the url query parameter en_txn8. When added as a page parameter, the field is referred to as Campaign Reference 3 in the dashboard settings. If a value is presented in both places, the url query parameter will take precedence. Note: Content will be automatically truncated if the maximum length is exceeded, and the last three characters replaced by '...' to indicate that a string has been truncated.
<= 100 characters
External Reference 9#
When used outside of API page processing, this field may also be populated by a user-defined page property [Page > Admin > Campaign References], or by the url query parameter en_txn9. When added as a page parameter, the field is referred to as Campaign Reference 4 in the dashboard settings. If a value is presented in both places, the url query parameter will take precedence. Note: Content will be automatically truncated if the maximum length is exceeded, and the last three characters replaced by '...' to indicate that a string has been truncated.
<= 100 characters
External Reference 10#
When used outside of API page processing, this field may also be populated by a user-defined page property [Page > Admin > Campaign References], or by the url query parameter en_txn10. When added as a page parameter, the field is referred to as Campaign Reference 5 in the dashboard settings. If a value is presented in both places, the url query parameter will take precedence. Note: Content will be automatically truncated if the maximum length is exceeded, and the last three characters replaced by '...' to indicate that a string has been truncated.
<= 100 characters
Email Address#
The primary email address of a supporter, which will typically be used as the basis for identifying a unique supporter to which any transactions will be associated.
<= 500 characters
Example: otto.nv@example.com
Title#
A supporter's title to be used in salutations
<= 50 characters
Example: Dr
First Name#
A supporter's first name
<= 500 characters
Example: Otto
Middle Name#
A supporter's middle name
<= 500 characters
Example: Niemand
Last Name#
A supporter's last name
<= 500 characters
Example: Normalverbraucher
Address 1#
The first line of the supporter's address
<= 1000 characters
Address 2#
The second line of the supporter's address
<= 1000 characters
Address 3#
The third line of the supporter's address
<= 1000 characters
City#
The city in a supporter's address
<= 500 characters
Example: Musterstadt
Region#
The supporter's region, state, county, province or similar
<= 500 characters
Example: Musterregion
Country#
The supporter's country
<= 500 characters
Example: DE
Phone Number#
The primary phone number for a supporter
<= 200 characters
Example: +49 4066969123