Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: unspecified
-
Fix Version/s: None
-
Component/s: xOther
-
Labels:None
-
Environment:
Operating System: Linux
Platform: PC
-
Bugzilla Id:3288
Description
If look at the pixel hits for the IP address below you see:
tsaapp@xml-03:~/directories/wplogs/done$ grep 24.103.149.164 0910*-494.txt
09101223-494.txt:1255417157
tsas494:usid1a3c7dcbd88cec073479f22969cfe10c|tsav494:uvidb7331394a09b5c761874c12f294fb286
HTTP_USER_AGENT:Mozilla%2F4.0%20%28compatible%3B%20MSIE%207.0%3B%20Windows%20NT%205.1%3B%20Trident%2F4.0%3B%20SIMBAR%3D%7BF42D7332-7FC3-4303-AAF3-844EF3196D62%7D%3B%20.NET%20CLR%202.0.50727%3B%20.NET%20CLR%201.1.4322%3B%20.NET%20CLR%203.0.4506.2152%3B%20.NET%20CLR%203.5.30729%3B%20WinNT-PAI%2013.08.2009%29|REMOTE_ADDR:24.103.149.164|HTTP_REFERER:http%3A%2F%2Fsearch.yahoo.com%2Fsearch%3Fei%3Dutf-8%26fr%3Dslv8-cclean%26p%3Dwww.kings.com%26type%3D
siteid:494|wayid:1115|refcd:YH245118211012a_game_at_king.com|tsacr:YH38609048012|dest:http%3A%2F%2Fwww.king.com%2Fpartnerpages%2Fmidas.us%2Ftsa.jsp%3Frefcd%3DYH245118211012a_game_at_king.com%26tsacr%3DYH38609048012%26url%3Dhttp%253A%252F%252Fwww.king.com%252Fpartnerpages%252Flandingpages%252Fmidas.us%252FLP_cashMessage.jsp%253Fcountry%253DUS|OVRAW:www.kings.com|OVKEY:game%20at%20king.com|OVMTC:advanced|OVADID:38609048012|OVKWID:245118211012
10
09101223-494.txt:1255417160
tsas494:usid1a3c7dcbd88cec073479f22969cfe10c|tsav494:uvidb7331394a09b5c761874c12f294fb286
HTTP_USER_AGENT:Mozilla%2F4.0%20%28compatible%3B%20MSIE%207.0%3B%20Windows%20NT%205.1%3B%20Trident%2F4.0%3B%20SIMBAR%3D%7BF42D7332-7FC3-4303-AAF3-844EF3196D62%7D%3B%20.NET%20CLR%202.0.50727%3B%20.NET%20CLR%201.1.4322%3B%20.NET%20CLR%203.0.4506.2152%3B%20.NET%20CLR%203.5.30729%3B%20WinNT-PAI%2013.08.2009%29|REMOTE_ADDR:24.103.149.164|HTTP_REFERER:http%3A%2F%2Fwww.king.com%2Fpartnerpages%2Flandingpages%2Fmidas.us%2FLP_cashMessage.jsp%3Fcountry%3DUS
tsatime:1255417164118|uref:http%3A%2F%2Fsearch.yahoo.com%2Fsearch%3Fei%3Dutf-8%26fr%3Dslv8-cclean%26p%3Dwww.kings.com%26type%3D|pageQs:country%3DUS|siteid:494|wayid:1115|tsa1v494:uvidb7331394a09b5c761874c12f294fb28678868|tsa1s494:usid1a3c7dcbd88cec073479f22969cfe10c64118
10
I cannot see any cost in the log. If you look in the database you see this in
waypointHits:
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- 4894. row ***************************
id: 394383905
siteID: 494
sessionID: 225999395
waypointID: 1115
time: 2009-10-12 23:59:17
cost: 30
value: 0
units: 1
params:
OVKEY=game+at+king.com&OVKWID=245118211012&OVMTC=advanced&OVADID=38609048012&OVRAW=www.kings.com&tsacr=YH38609048012&dest=http%3A%2F%2Fwww.king.com%2Fpartnerpages%2Fmidas.us%2Ftsa.jsp%3Frefcd%3DYH245118211012a_game_at_king.com%26tsacr%3DYH38609048012%26u
remoteAddr: 24.103.149.164
referer:
http://search.yahoo.com/search?ei=utf-8&fr=slv8-cclean&p=www.kings.com&type=
ultimateReferer:
productID:
productCosts:
productValues:
userAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0;
SIMBAR= {F42D7332-7FC3-4303-AAF3-844EF3196D62}; .NET CLR 2.0.50
4894 rows in set (3.28 sec)
- 4894. row ***************************
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
with a cost of 30 cents. If you go to sources you see:
mysql> select * from sources where altkey='YH245118211012a_game_at_king.com'\G
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- 1. row ***************************
id: 234363705
altKey: yh245118211012a_game_at_king.com
accountID: 475
siteID: 0
searchEngineAccountID: 29541
keywordID: 0
distributionID: 164
searchEngineIdentifier: 245118211012
searchEngineGroupIdentifier: 11440436900
searchEngineMatchType: advanced
searchEngineGroupID: 2541585
isBiddable: true
campaignID: 0
description: Keyword: [game at king.com] advanced
type: 1
keyword: game at king.com
sourceURL:
cost: 0.3
maxCost: 0.3
waypointID: NULL
landingURL:
http://thesearchagency.net/tsaredir.php?siteid=494&wayid=1115&refcd=YH {ysmkwid}{ysmmtc:e:a:c}_game_at_king.com&tsacr=YH{ysmadid}&dest=http%3A%2F%2Fwww.king.com%2Fpartnerpages%2Fmidas.us%2Ftsa.jsp%3Frefcd%3DYH{ysmkwid} {ysmmtc:e:a:c}_game_at_king.com%26tsacr%3DYH
{ysmadid}%26url%3Dhttp%253A%252F%252Fwww.king.com%252Fpartnerpages%252Flandingpages%252Fmidas.us%252FLP_cashMessage.jsp%253Fcountry%253DUS
passParams:
trackPerformance: true
searchEngineStatus: ok
searchEngineStatusText: ON
lastChecked: 0000-00-00 00:00:00
- 1. row ***************************
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
whihc shows that same cost but Ffej says is search engine cost?
THe real bug underlying this though is for October 12th I see 2.10 in
fulfillment cost for King.com for this refcd with no apparent source. Ffej
suggested there may be some confusion between search engine cost and fulfillment
cost underlying this issue. For October 12th there is a total of 2.10 of
fulfillment cost associated with this refcd (report attached). Pixel register
product shows 7 conversions which would mean fulfillment cost could be being
calculated as pixel registrations times the cost to get this number?