Hi,I believe you can have only one wildcard char and it has to be at the end of the file name prefix. This means, you will need to reformat the naming of your data files (Source system to ACS).Thanks.
Remember that batch campaign (adhoc or recurring) are stored in the BroadLogRcp table. RT triggers/messages are stored in different set of tables in Adobe ACC mart.
Dusan,I believe ACC doesn't have monitoring service for customer's responses to emails for keyword like "remove me", "unsubscribe me", "opt me out", etc. All unsubscribe requests/optouts are made using the unsubscribe link which means the such data is stored somewhere in your database.Since email un...
Hi,Most likely you have a mapping issue in either the Query activity node or the enrichment activity node due to the resolution levels (targeting dimension) of your query and the output. Review these nodes again and make the proper adjustment. Remember that the relationship is 1:M between recipients...
Hi,Option #1 is the recommended approach since it will include large data (promotion history/send history data). We have implemented a similar approach and it works well.There is option #3, if you have a hybrid ACC implementation, the ACC system tables (mart) will reside in a relational DB on your s...
Hi,You can use data modeling tool (e.g., ERwin) to reverse engineering the ACC system DB (mart tables) and it will produce the physical data model. As Ramon said, if the PK-FK relationships are not enforced in the DB by ACC, the physical model will not reflect such relationships. However, it should ...
I believe this can be done part of campaign segmentation based on device type for SMS delivery but not at the time of message open.It will be interesting to see how to do it in real time (if possible)