File Format Macros file-format-macros

Macro

Description

A non-printing ASCII character. It indicates the start of a row or a section of content. It can also be used to separate data columns in a file.

Target Data Provider ID.

User ID Key Data Provider ID.

Order / destination ID.

An alias for an order / destination ID.

The value for this alias is set in the Foreign Account ID field for a destination (in the Basic Settings section).

Indicates synchronization type. Accepts the following optional variables:

• full: Full synchronization.
• iter: Incremental synchronization.

Indicates data transfer method. Accepts the following optional variables:

• ftp
• http
• s3

A 10-digit, UTC, Unix timestamp.

It can also be formatted as YYYYMMDDhhmmss following Java date/timestamp formatting rules.

Macro

Description

Used as a separator, this macro inserts a tab between fields.

Macro

Description

Inserts a closed curly bracket } character.

Inserts a comma.

Data Partner Unique User Identifier . Returns the ID you've assigned to a user/site visitor if that ID has already been synchronized with an Audience Manager device ID.

If the DPID is 0, this macro will return the Audience Manager ID instead of your ID for the user.

Returns a list that contains multiple IDs for a data partner. This is useful if you have a large organization with multiple subdivisions or other organizational groups you're allowed to share data with. This macro returns a list of the IDs for those subordinate groups.

The output of this macro maps the data provider ID (DPID) to related unique user IDs (DPUUID). This macro must have a formatting string to control its output. Sample output would look similar to the following:

"dpids=dpid1,dpid2,...dpid n|maxMappings= n|format=json"

The maxMappings setting determines how many mappings you want the macro to return. When maxMappings=0, this macro returns all the mappings for each specified DPID. Data is sorted by timestamp (most recent first) and returns results with the largest timestamp first.

Required when using the conditional if and the SEGMENT_LIST and REMOVED_SEGMENT_LIST macros.

This combination of macros creates a conditional statement that lists the segments users belong to and have been removed from. It returns an empty string if both conditions are not met or there's no data.

Adobe Experience Cloud ID.

Inserts an open curly bracket { character.

Deprecated. Do not use.

Deprecated. Do not use.

Returns 1 as a static, hardcoded value.

Partner ID (PID). The PID appears under the Profile tab in the admin UI.

Returns a list of segments, if any, that have been removed.

Returns a list of segments in a list. Accepts the following optional variables:

• segmentId: Legacy ID. Deprecated. Use sid (lower case only).
• csegid: Legacy ID. Deprecated. Use sid (lower case only).
• sid: Segment ID.
• type: Returns 5, a static, hardcoded value that identifies data as segment data.
• alias: Mapping of the segment. Deprecated. Use sid (lower case only).
• lastUpdateTime: A Unix time stamp that indicates the last time a segment was realized.

Put these variables in curly brackets after the macro. For example, this code separates results with a pipe "|" character: <SEGMENT_LIST:{seg|<seg.type>,<seg.sid>}; separator="|">

Returns 1 as a static, hardcoded value.

Inserts a tab separator.

Returns a list of traits. Accepts the following optional arguments:

• type: Trait types identified by a numeric ID. This variable returns:

  • 10 which identifies a DPM trait (offline, onboarded by an inbound job).
  • 3 which identifies a rules-based trait (realtime,; onboarded through the DCS ).

• traitId: Trait ID.

• lastRealized: Last time the trait was realized. Unix timestamp.

Put these variables in curly brackets after the macro. For example, this code separates the results with a pipe "|" character: TRAIT_LIST{type|traitId};separator="|"

Audience Manager user ID.