Suppose you have the following hit data:
Labels | I2 ID-PERSON DEL-PERSON ACC-PERSON |
I2 ID-DEVICE DEL-DEVICE ACC-ALL |
I2 DEL-PERSON ACC-PERSON |
I2 DEL-DEVICE DEL-PERSON ACC-ALL |
I2 ID-DEVICE DEL-DEVICE ACC-ALL |
---|---|---|---|---|---|
Variable Name (Namespace) |
MyProp1 (user) |
Visitor ID (AAID) |
MyEvar1 | MyEvar2 | MyEvar3 (xyz) |
Hit Data | Mary | 77 | A | M | X |
Mary | 88 | B | N | Y | |
Mary | 99 | C | O | Z | |
John | 77 | D | P | W | |
John | 88 | E | N | U | |
John | 44 | F | Q | V | |
John | 55 | G | R | X | |
Alice | 66 | A | N | Z |
If I submit an access request, the summary file will contain the values indicated in the table below. A request may return only a device file, only a person file or one of each. Two summary files are only returned if a person ID is used and expandIds is true.
API Values | API Values | Returned File Type | Data in Summary Access File |
Data in Summary Access File |
Data in Summary Access File |
Data in Summary Access File |
Data in Summary Access File |
---|---|---|---|---|---|---|---|
Namespace/ID | expandIDs | MyProp1 | Visitor ID | MyEvar1 | MyEvar2 | MyEvar3 | |
AAID=77 | false | device | Variable not present | 77 | Variable not present | M, P | X, W |
AAID=77 | true | device | Variable not present | 77 | Variable not present | M, P | X, W |
user=Mary | false | person | Mary | 77, 88, 99 | A, B, C | M, N, O | X, Y, Z |
user=Mary | true | person | Mary | 77, 88, 99 | A, B, C | M, N, O | X, Y, Z |
user=Mary | true | device | not present | 77, 88 | not present | N, P | U, W |
user=Mary AAID=66 | true | person | Mary | 77, 88, 99 | A, B, C | M, N, O | X, Y, Z |
user=Mary AAID=66 | true | device | not present | 66, 77, 88 | not present | N, P | U, W, Z |
xyz=X | false | device | not present | 55, 77 | not present | M, R | X |
xyz=X | true | device | not present | 55, 77 | not present | M, P, R | W, X |
Notice that the setting for expandIDs does not make any difference to the output when a cookie ID is used.
With a delete request using the API values in the first row of the table, the hit table will be updated to look something like this:
AAID=77 expandIDs value does not matter |
AAID=77 expandIDs value does not matter |
AAID=77 expandIDs value does not matter |
AAID=77 expandIDs value does not matter |
AAID=77 expandIDs value does not matter |
---|---|---|---|---|
MyProp1 | AAID | MyEvar1 | MyEvar2 | MyEvar3 |
Mary | 42 | A | Privacy-7398 | Privacy-9152 |
Mary | 88 | B | N | Y |
Mary | 99 | C | O | Z |
John | 42 | D | Privacy-1866 | Privacy-8216 |
John | 88 | E | N | U |
John | 44 | F | Q | V |
John | 55 | G | R | X |
Alice | 66 | A | N | W |
Only cells on rows containing AAID = 77 and a DEL-DEVICE label are impacted.
user=Mary expandIDs=false |
user=Mary expandIDs=false |
user=Mary expandIDs=false |
user=Mary expandIDs=false |
user=Mary expandIDs=false |
---|---|---|---|---|
MyProp1 | AAID | MyEvar1 | MyEvar2 | MyEvar3 |
Privacy-0523 | 77 | Privacy-1866 | Privacy-3681 | X |
Privacy-0523 | 88 | Privacy-2178 | Privacy-1975 | Y |
Privacy-0523 | 99 | Privacy-9045 | Privacy-2864 | Z |
John | 77 | D | P | W |
John | 88 | E | N | U |
John | 44 | F | Q | V |
John | 55 | G | R | X |
Alice | 66 | A | N | W |
Only cells on rows containing user=Mary and a DEL-PERSON label are impacted. Also, in practice the variable containing A_ID would probably be a prop or eVar and its replacement value would be a string starting with “Privacy-”, followed by a random number (GUID), rather than replacing the numeric value with a different, random numeric value.
user=Mary expandIDs=true |
user=Mary expandIDs=true |
user=Mary expandIDs=true |
user=Mary expandIDs=true |
user=Mary expandIDs=true |
---|---|---|---|---|
MyProp1 | AAID | MyEvar1 | MyEvar2 | MyEvar3 |
Privacy-5782 | 09 | Privacy-0859 | Privacy-8183 | Privacy-9152 |
Privacy-5782 | 16 | Privacy-6104 | Privacy-2911 | Privacy-6821 |
Privacy-5782 | 83 | Privacy-2714 | Privacy-0219 | Privacy-4395 |
John | 09 | D | Privacy-8454 | Privacy-8216 |
John | 16 | E | Privacy-2911 | Privacy-2930 |
John | 44 | F | Q | V |
John | 55 | G | R | X |
Alice | 66 | A | N | W |
Note the following:
user=Mary
and a DEL-DEVICE
or DEL-PERSON
label are impacted, as well as cells with a DEL-DEVICE
label on rows containing any Visitor ID that occurred on a row containing user=Mary
.MyEvar2
in the fourth and fifth rows is updated because these rows contain the same Visitor ID values as those on the first and second rows, so ID expansion includes them for device-level deletes.MyEvar2
in rows two and five match both before and after the delete, but after the delete no longer matches the value N that occurs in the last row, because that row was not updated as part of the delete request.MyEvar3
behaves very differently than it did without ID expansion, because without ID expansion, no ID-DEVICES
matched. Now AAID
matches on the first five rows.