Lists the macros you can use to create FTP-based data files. Some macros can be used for all data file fields and rows. Other macros are specific to header and data rows only.
These macros can be used in any format field. For examples, see File Format Macro Examples.
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:
|
|
Indicates data transfer method. Accepts the following optional variables:
|
|
A 10-digit, UTC, Unix timestamp. It can also be formatted as |
Macros used in header fields only. For examples, see File Format Macro Examples.
Macro | Description |
---|---|
|
Used as a separator, this macro inserts a tab between fields. |
Macros used in data rows only. For examples, see File Format Macro Examples.
Macro | Description |
---|---|
|
Inserts a closed curly bracket |
|
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: The |
|
Required when using the conditional |
|
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 |
|
Deprecated. Do not use. |
|
Deprecated. Do not use. |
|
Returns |
|
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:
Put these variables in curly brackets after the macro. For example, this code separates results with a pipe "|" character: |
|
Returns |
|
Inserts a tab separator. |
|
Returns a list of traits. Accepts the following optional arguments:
Put these variables in curly brackets after the macro. For example, this code separates the results with a pipe "|" character: |
|
Audience Manager user ID. |