Tracking troubleshooting | ÃÛ¶¹ÊÓÆµ Campaign

Documentation Campaign Campaign Classic v7 Documentation

[Also applies to v8]{class="badge positive" title="Also applies to Campaign v8"}

Tracking troubleshooting tracking-troubleshooting

Last update: Thu Apr 11 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

User

In this section, you will find common questions related to tracking configuration and implementation in ÃÛ¶¹ÊÓÆµ Campaign Classic.

The tracking workflow is failing tracking-workflow-failing

My tracking workflow is failing, how can I detect the corrupted lines in the tracking file?

NOTE

Available for Windows only

The corrupted tracking log file â€¦/nl6/var/<instance_name>/redir/log/0x0000 log can stop the tracking workflow. To easily detect corrupted lines and remove them to resume the tracking workflow, you can use the commands below.

I know in which file the corrupted line is

In that case, corrupted lines can be found in the 0x00000000000A0000.log file but the same process can be applied to a set of files - one by one.

$ cd {install directory}/var/{instance name}/redir/log
$ cat 0x00000000000A0000.log | sed -nE '/^[[:alnum:]]{2}x[[:alnum:]]*\t[0-9T:\.-]*\t[0-9a-fA-F]*\t[0-9a-fA-F]*\t[0-9a-fA-F]*\t[[:alnum:]]*\t[[:alnum:]-]*\t[[:print:]]*\t[[:print:]]*\t[[:print:]]*\t([0-9a-fA-F\.:]*|[0-9a-fA-F\.:]*\t[[:print:]]*|[0-9a-fA-F\.:]*,[[:print:]]*)$/!p'

You can then stop the tracking workflow, delete the corrupted line(s) and restart the workflow.

I do not now in which file the corrupted line is

use the following command line to check in all the tracking files.

code language-none

code language-none
`$ cd {install directory}/var/{instance name}/redir/log $ cat .log \| sed -nE '/^[[:alnum:]]{2}x[[:alnum:]]\t[0-9T:\.-]\t[0-9a-fA-F]\t[0-9a-fA-F]\t[0-9a-fA-F]\t[[:alnum:]]\t[[:alnum:]-]\t[[:print:]]\t[[:print:]]\t[[:print:]]\t([0-9a-fA-F\.:]\|[0-9a-fA-F\.:]\t[[:print:]]\|[0-9a-fA-F\.:],[[:print:]])$/!p'`

$ cd {install directory}/var/{instance name}/redir/log
$ cat *.log | sed -nE '/^[[:alnum:]]{2}x[[:alnum:]]*\t[0-9T:\.-]*\t[0-9a-fA-F]*\t[0-9a-fA-F]*\t[0-9a-fA-F]*\t[[:alnum:]]*\t[[:alnum:]-]*\t[[:print:]]*\t[[:print:]]*\t[[:print:]]*\t([0-9a-fA-F\.:]*|[0-9a-fA-F\.:]*\t[[:print:]]*|[0-9a-fA-F\.:]*,[[:print:]]*)$/!p'

The command lists all the corrupted line(s). For example:

code language-none

code language-none
`50x000000000FD7EC86 2017-06-24T21:00:50.96 1f506d71 1aeab4b6 1af77020 0 e5155671-4ab7-4ce4-a763-3b82dda6d881 h Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.95 Safari/537.36 52.46.20.64`

50x000000000FD7EC86 2017-06-24T21:00:50.96 1f506d71 1aeab4b6 1af77020 0 e5155671-4ab7-4ce4-a763-3b82dda6d881 h
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.95 Safari/537.36 52.46.20.64

note note
NOTE
Carriage return has been added before User Agent to allow better reading and does not reflect effective rendering.

Run a grep command to find the corresponding file.

$ grep -Rn <Log Id>
# for example:
$ grep -Rn 50x000000000FD7EC86

Find the faulty log with the filename and line number. For example:

code language-none

code language-none
`./0x000000000FD7E000.log:3207:50x000000000FD7EC86 2017-06-24T21:00:50.96 1f506d71 1aeab4b6 1af77020 0 e5155671-4ab7-4ce4-a763-3b82dda6d881 h Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.95 Safari/537.36 52.46.20.64`

./0x000000000FD7E000.log:3207:50x000000000FD7EC86 2017-06-24T21:00:50.96 1f506d71 1aeab4b6 1af77020 0 e5155671-4ab7-4ce4-a763-3b82dda6d881 h
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.95 Safari/537.36 52.46.20.64

note note
NOTE
A carriage return has been added before User Agent to allow better reading and does not reflect effective rendering.

You can then stop the tracking workflow, delete the corrupted line(s) and restart the workflow.

Tracking links fail intermittently tracking-links-fail-intermittently

When trying to access the tracking links, the following message displays:

Requested URL '/r/ id=h787bc0,281a4d8,281a4da&p1=1' cannot be found

Access <redirection_server>/r/test URL and check if the build number and localhost were returned by the request.

Check the spareServer configuration in the serverConf.xml file for the tracking server. This configuration should be in redirection mode.

code language-none

code language-none
`<redirection> <spareServer _operation="update" enabledIf="$(hostname)!='test-rt1'" id="1" url="http://test-rt1:8080"/> <spareServer _operation="insert" enabledIf="$(hostname)!='test-rt4'" id="4" url="http://test-rt4:8080"/> <spareServer _operation="insert" enabledIf="$(hostname)!='test-rt3'" id="3" url="http://test-rt3:8080"/> <spareServer _operation="insert" enabledIf="$(hostname)!=test-rt2'" id="2" url="http://test-rt2:8080"/> </redirection>`

<redirection>
   <spareServer _operation="update" enabledIf="$(hostname)!='test-rt1'" id="1"
   url="http://test-rt1:8080"/>
   <spareServer _operation="insert" enabledIf="$(hostname)!='test-rt4'" id="4"
   url="http://test-rt4:8080"/>
   <spareServer _operation="insert" enabledIf="$(hostname)!='test-rt3'" id="3"
   url="http://test-rt3:8080"/>
   <spareServer _operation="insert" enabledIf="$(hostname)!=test-rt2'" id="2"
   url="http://test-rt2:8080"/>
</redirection>

Check manually whether the <deliveryID>.xml file exists on the machine in â€¦/nl6/var/<instance_name>/redir/url/<YYYY> directory (YYYY represents delivery year).
Check manually whether <trackingUrlId> can be found in the <deliveryID>.xml file.
Check manually existence of broadlogID in related deliveryID delivery.
Check <deliveryID>.xml files permissions in â€¦/nl6/var/<instance_name>/redir/url/year directory.

They should have at least 644 permission so that Apache can read tracking urls to redirect requested link.

Updating the NmsTracking_Pointer option? updating-option

Follow these steps when updating the NmsTracking_Pointer option:

Stop the tracking workflow.
Stop the trackinglogd service.
Update the NmsTracking_Pointer option to the desired value.
Restart the trackinglogd service.
Restart the tracking workflow.

Tracking does not seem to work with some WebMail webmail

You can customize click tracking formula and specify a custom ÃÛ¶¹ÊÓÆµ Analytics tracking formula.

That kind of customization needs to be done with caution to avoid adding extra linefeed characters. All linefeed characters present outside of the JavaScript expression will be present in the final formula.

This kind of extra linefeed character in the tracking URL will lead to issue in some webMail (AOL, GMail, etc.).

First example:

Incorrect syntax

code language-none

code language-none
`<%@ include option='NmsTracking_ClickFormula' %><% // Parameters expected by ÃÛ¶¹ÊÓÆµ Analytics var pattern = new RegExp("(nl611\.test15\|google\.com)", 'i') if( $(urlstring).match(pattern) && delivery.FCP == false ) { %> &cid=<%= message.delivery.internalName %>&bid=<%= message.id.toString().toLowerCase() %><% } %>`

<%@ include option='NmsTracking_ClickFormula' %><% // Parameters expected by ÃÛ¶¹ÊÓÆµ Analytics
var pattern = new RegExp("(nl611\.test15|google\.com)", 'i')
if( $(urlstring).match(pattern) && delivery.FCP == false )
{
%>
&cid=<%= message.delivery.internalName %>&bid=<%= message.id.toString().toLowerCase() %><% } %>

Correct syntax

code language-none

code language-none
`<%@ include option='NmsTracking_ClickFormula' %><% // Parameters expected by ÃÛ¶¹ÊÓÆµ Analytics var pattern = new RegExp("(nl611\.test15\|google\.com)", 'i') if( $(urlstring).match(pattern) && delivery.FCP == false ) { %>&cid=<%= message.delivery.internalName %>&bid=<%= message.id.toString().toLowerCase() %><% } %>`

<%@ include option='NmsTracking_ClickFormula' %><% // Parameters expected by ÃÛ¶¹ÊÓÆµ Analytics
var pattern = new RegExp("(nl611\.test15|google\.com)", 'i')
if( $(urlstring).match(pattern) && delivery.FCP == false )
{
%>&cid=<%= message.delivery.internalName %>&bid=<%= message.id.toString().toLowerCase() %><% } %>

To understand where the extra linefeed is you can replace JavaScript expression by a fixed string STRING.

// Incorrect
STRING1
&cid=STRING2&bid=STRING3

// Correct
STRING1&cid=STRING2&bid=STRING3

Second example

Incorrect syntax

code language-none

code language-none
`<%@ include option='NmsTracking_ClickFormula' %> <% // Parameters expected by ÃÛ¶¹ÊÓÆµ Analytics var pattern = new RegExp("(vistaprint\|entryUrl)", 'i') if( $(urlstring).match(pattern) && delivery.FCP == false ) {%>&cid=<%= message.delivery.internalName%>&bid=<%= message.id.toString().toLowerCase()%>&SHPID=<%= message.recipient.factShopper.shopper_id %><% } %>`

<%@ include option='NmsTracking_ClickFormula' %>
<% // Parameters expected by ÃÛ¶¹ÊÓÆµ Analytics
var pattern = new RegExp("(vistaprint|entryUrl)", 'i')
if( $(urlstring).match(pattern) && delivery.FCP == false )
{%>&cid=<%= message.delivery.internalName%>&bid=<%= message.id.toString().toLowerCase()%>&SHPID=<%= message.recipient.factShopper.shopper_id %><% }

%>

Correct syntax

code language-none

code language-none
`<%@ include option='NmsTracking_ClickFormula' %><% // Parameters expected by ÃÛ¶¹ÊÓÆµ Analytics var pattern = new RegExp("(vistaprint\|entryUrl)", 'i') if( $(urlstring).match(pattern) && delivery.FCP == false ) {%>&cid=<%= message.delivery.internalName%>&bid=<%= message.id.toString().toLowerCase()%>&SHPID=<%= message.recipient.factShopper.shopper_id %><% } %>`

<%@ include option='NmsTracking_ClickFormula' %><% // Parameters expected by ÃÛ¶¹ÊÓÆµ Analytics
var pattern = new RegExp("(vistaprint|entryUrl)", 'i')
if( $(urlstring).match(pattern) && delivery.FCP == false )
{%>&cid=<%= message.delivery.internalName%>&bid=<%= message.id.toString().toLowerCase()%>&SHPID=<%= message.recipient.factShopper.shopper_id %><% }

%>

To understand where the extra linefeed is you can replace JavaScript expression by a fixed string STRING.

// Incorrect
STRING1&cid=STRING2&bid=STRING3&SHPID=STRING4

// Correct
STRING1&cid=STRING2&bid=STRING3&SHPID=STRING4

Tracking logs retrieval is too slow slow-retrieval

When the instance does not retrieve directly tracking logs but from a distant ÃÛ¶¹ÊÓÆµ Campaign Classic server, the logs are retrieved through the GetTrackingLogs SOAP call which is defined in the remoteTracking schema.

An option in the serverConf.xml file enables you to set the number of logs that are retrieved at once through this method: logCountPerRequest.

The default value of logCountPerRequest being 1000, it may prove in some case to be too small. The accepted values must be between 0 and 10.000.

Tracking logs could not be linked to recipients link-recipients

In ÃÛ¶¹ÊÓÆµ Campaign Classic, a target mapping is supposed to be unique in term of recipient schema vs broadlog / trackinglog schemas.

It is not possible to use multiple targeting schemas with the same trackinglog schema since tracking workflow will be unable to reconciliate data with targeting id.

If you do not want to use the out-of-the-box target mapping with nms:recipient, we recommend the following approaches:

If you want to use custom targeting dimension, you need to create custom broadLog/trackingLog schema using nms:broadlog as template (e.g. nms:broadLogRcp, nms:broadLogSvc,etc.).
If you want to use OOB trackingLogRcp/broadLogRcp, the targeting dimension needs to be nms:recipient and filtering dimenstion could be a custom schema.

recommendation-more-help

601d79c3-e613-4db3-889a-ae959cd9e3e1