Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-1776

Pixel playback: pixel playback creating phantom fulfillment cost in CCC

    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)

      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

      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?

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              bduffy Bill Duffy (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: