TSA Tracking: Conv is appearing as Organic when expected Paid

The pixel log file scenario:

1)Entry on Paid Search Link (any hit limit/window)

2)Close Session (by clearing ONLY the session cookie, not the visitor cookie or by waiting 4 hours for the session cookie to expire)

3)Re-enter on Organic Link

Convert

Here is the log file I created based on above:

1303055990 tsas560:usid291bb8d9fb3f13313aa43d97fb2cc45f|tsav560:uvid291bb8d9fb3f13313aa43d97fb2cc45f HTTP_USER_AGENT:jenBot-Google%20%28%2Bhttp%3A%2F%2Fwww.google.com%2Fadsbot.html%29|REMOTE_ADDR:172.14.199.90|HTTP_REFERER: siteid:560|wayid:2035|dest:http%3A%2F%2Fmartiantourism.com%2F|refcd:go0000006_%E0%A4%AE%E0%A4%82%E0%A4%97%E0%A4%B2%20%E0%A4%97%E0%A5%8D%E0%A4%B0%E0%A4%B9s|tsacr:go3322899598 37

1303055997 tsas560:usid291bb8d9fb3f13313aa43d97fb2cc45a|tsav560:uvid291bb8d9fb3f13313aa43d97fb2cc45f HTTP_USER_AGENT:Mozilla%2F5.0%20%28X11%3B%20U%3B%20Linux%20x86_64%3B%20en-US%3B%20rv%3A1.9.2.16%29%20Gecko%2F20110323%20Ubuntu%2F10.04%20%28lucid%29%20Firefox%2F3.6.16|REMOTE_ADDR:70.168.200.180|HTTP_REFERER: siteid:560|wayid:2045 65

I then ran:

1) ./v2pixel_playback.sh -a 541 -d 3 -lfh 2> /tmp/May16_pixplayback11

2) ./lastpaidhitsummarizer.sh -a 541 -d3 -T 2011-04-17 2> /tmp/May16_lastpaid11

3) ./v2whsumm.sh -a541 -d4 --pixels --highgran -T 2011-04-17 -dsrt 0 2> /tmp/May16_whsumm11 (log attached)

4) Ran AdMax report R-319-870

In the report I expected to see a conv in paid search. Instead, I see one in organic bookmarks.

Looking at waypoint last hit in the db, it seems to be attributing the 2nd row to the 1st as expected.

SELECT * FROM spike_v2.waypointLogLastPaidHit where siteID=560 LIMIT 0,1000;

------------------------------------------------------------------------------------------------------------------------+

------------------------------------------------------------------------------------------------------------------------+

------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.01 sec)

and looking at the warehouse, the 'cart' is showing the correct productID:

SELECT * FROM warehouse_1.whDailySourceConv where accountID=541 and startTime= '2011-04-17' LIMIT 0,1000;

----------------------------------------------------------------------------------------------------------------------------------------------------------------+

----------------------------------------------------------------------------------------------------------------------------------------------------------------+

----------------------------------------------------------------------------------------------------------------------------------------------------------------+

This shows the distribution ID being 128 instead of 3:

SELECT * FROM whDailySourcePerf where id=3773352 LIMIT 0,1000;

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------