Duplicate campaigns for king.com and O&O

Email thread for tracking:

Looks like we are also seeing this with O&O - Schools & Reunions. There
are several sources with campaignID 13 ("Unknown Campaign") and a valid
searchEngineAccountID.

Jen noticed this on report ID 297489 (in prod) where 'Cities + Reunion'
campaign was showing up twice.

Dave

Dave Costantino wrote:
> I was able to replicate this problem in dev. It does seem that the
> sources with both campaign ID 13 and a searchEngineAccountID
> (essentially, sources in 2 campaigns at once?) are causing this.
>
> I was able to make it go away on dev by first removing campaign 13
> from the king.com sources where there was an seAcctID:
>
> update sources set campaignID=0 where accountID=475 and campaignID =
> 13 and searchEngineAccountID > 0;
>
> Then deleting all the data from the warehouse, then resummarizing.
>
> If I didn't delete the data, I'd still see duplicate dates due to
> there being rows with all zeros. Fortunately the account is fairly
> small so resummarizing did not take long, even on dev.
>
> Phej, do you want to verify that this is not a valid case, and if so,
> investigate the issue with the seupdater to see why the "unknown
> campaign" (campaign ID 13) is not getting cleared?
>
> Also, I can put things back the way they were before I fixed the
> problem on dev, if you prefer.
>
> Thanks,
> Dave
>
>
>
> Jeff Theroux wrote:
>>
>> cool, thanks dave!
>>
>>
>> ----Original Message----
>> From: David Costantino
>> Sent: Fri 12/19/2008 9:32 AM
>> To: Jeff Theroux
>> Cc: Jennifer Clarke; Bill Duffy
>> Subject: Re: King.com Data issues
>>
>> Jeff,
>> Thanks.. That explanation makes sense. I am going to work on bringing
>> down King.com's december data and see if we can recreate this in dev.
>>
>> Dave
>>
>> Jeff Theroux wrote:
>> > I looked into this. It doesn't seem like it should be a valid case,
>> but
>> > I'm not 100% sure...
>> >
>> > The StUtil.makeUnknownSource() method sets the campaignID to
>> unknown. I
>> > think what happened is they started using pixels before we ran
>> SEUpdate,
>> > so a source was created by pixels initially with an unknown
>> campaign id.
>> >
>> > Then SearchEngineUpdater ran and SearchEngineUtils.getSource() took
>> over
>> > the source and replaced it at that time with a searchEngineAccountID,
>> > distributionId, etc. But it didn't overwrite the campaignID.
>> >
>> > I think we could fix it by overwriting the campaignID with 0, but we
>> > would need to set it up and reproduce it in dev to verify that it
>> would
>> > actually fix the problem and we would need to make sure that rerunning
>> > stuff worked.
>> >
>> > On Thu, 2008-12-18 at 17:11 -0500, Dave Costantino wrote:
>> >
>> >> There seems to be a bug where things are not being aggregated
>> properly
>> >> in the campaign level reports. I believe this is related to
>> >> http://bugs.ri.thesearchagency.com/show_bug.cgi?id=2553
>> >>
>> >> You can see this in R-294-921 (campaign level) and R-294-923 (ad
>> group
>> >> level). The campaign level totals for the campaign "TV Shows Deal
>> or No
>> >> Deal" and "King.com Brand Terms" don't match between both reports,
>> even
>> >> though they should. Also, the ad group level report has an "Unknown"
>> >> that doesn't show up at all in the campaign level, and we see a
>> >> duplicate "King.com Brand Terms".
>> >>
>> >> Phej, I looked into the warehouse data, and I see this:
>> >>
>> >> mysql> select campaignID,searchEngineAccountID,sum(impressions) from
>> >> whDailyGroupPerf
>> >> where accountID=475 and startTime='2008-12-12' group by
>> >> campaignID,searchEngineAccountID;
>> >> -------------------------------------------------
>> >> | campaignID | searchEngineAccountID | sum(impressions) |
>> >> -------------------------------------------------
>> >> | 0 | 29459 | 252 |
>> >> | 0 | 29463 | 19815 |
>> >> | 0 | 29465 | 11943 |
>> >> | 0 | 29478 | 9389 |
>> >> | 0 | 29541 | 0 |
>> >> | 0 | 29672 | 4746 |
>> >> | 13 | 0 | 0 |
>> >> | 13 | 29465 | 0 |
>> >> | 13 | 29672 | 8444 |
>> >> -------------------------------------------------
>> >>
>> >> Basically, we have rows that have campaign ID 13 "unknown" and also a
>> >> valid searchEngineAccountID. Is this supposed to happen?
>> >>
>> >> Bill mentioned this account is using the waypoint API, not regular
>> >> pixels, so perhaps there is some strange data coming in there.
>> >>
>> >> Jen, are we seeing this type of discrepancy with any other accounts?
>> >> What's the priority on this issue?
>> >>
>> >> Dave
>> >>
>> >>
>> >> Jennifer Clarke wrote:
>> >>
>> >>> Dave can you take a look at this?
>> >>> R - 294-909 – Campaign level summary report for 12/12 - 12/17, and
>> >>> has 5 convs for 'Unknown Campaign'
>> >>> R - 294-908 – Campaign level report by day for 12/12 - 12/17,
>> and has
>> >>> 1 convs for 'Unknown Campaign' on 12/14
>> >>> R - 294-913 – Campaign level report by day for 12/7 - 12/17, and
>> has
>> >>> 2 convs for 'Unknown Campaign', one on 12/14 and one on 12/16
>> >>> Thanks!
>> >>> Jennifer Clarke *| *Quality Assurance Engineer
>> >>> The Search Agency, Inc.* */- Results Driven Search Marketing and
>> >>> Optimization
>> >>> /Phone: 310-582-5774* | *Mobile: 978-430-6333
>> >>> www.thesearchagency.com <http://www.thesearchagency.com/>
>> >>> /:: Named a Rising Star on Deloitte's Technology Fast 500 :: /
>> >>>
>> >>> Please consider the environment before printing this e-mail.
>> >>>
>> >>
>> >
>> >
>> >
>>
>>
>> –
>> Dave Costantino | Software Team Lead
>> The Search Agency, Inc. - Results Driven Search Marketing and
>> Optimization
>> Phone: 310-582-5773 | Cell: 401-556-5272 | Fax: 401-364-2022
>> www.thesearchagency.com
>>
>> Please consider the environment before printing this e-mail.
>>
>>
>>
>
>

–
Dave Costantino | Software Team Lead
The Search Agency, Inc. – Results Driven Search Marketing and Optimization
Phone: 310-582-5773 | Cell: 401-556-5272 | Fax: 401-364-2022
www.thesearchagency.com

Please consider the environment before printing this e-mail.