Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: unspecified
-
Fix Version/s: None
-
Component/s: Performance Reports
-
Labels:None
-
Environment:
Operating System: Linux
Platform: PC
-
Bugzilla Id:3230
Description
Avalon Bay currently has both a datafeed and a pixel set up. Data feed is for
paid search and pixels are for all other channels. They use the same product
names for ease of analysis. On 9/17 there 7999 hits for the advantage product in
the pixel logs:
tsaapp@xml-03:~/directories/wplogs/done$ grep productID:advantage
090917*-80.txt|grep -c productID:advantage
7999
In the productHits table there are 7999 records for this product
mysql> select productID, count(id) from productHits where accountID=63 and time>
'2009-09-17 00:00:00' and time < "2009-09-18 00:00:00" group by productID;
--------------------+
| productID | count(id) |
--------------------+
| 10491 | 24 |
| 10492 | 7999 |
| 10493 | 646 |
| 10494 | 1849 |
| 10496 | 952 |
| 10526 | 151 |
| 10542 | 20 |
| 19491 | 287 |
| 19501 | 25 |
| 19511 | 132 |
| 19521 | 400 |
| 20241 | 298 |
| 20251 | 13063 |
| 20261 | 283 |
| 20271 | 140 |
| 20291 | 2354 |
| 20301 | 3908 |
| 20311 | 1859 |
--------------------+
18 rows in set (0.11 sec)
In the clientProductSummary table there are:
mysql> select sum(count) from clientProductSummary where accountID=63 and
productID=10492 and starttime="2009-09-17";
------------
| sum(count) |
------------
| 524 |
------------
1 row in set (0.03 sec)
So the bug where data feed overwrites pixel data would appear to effect both
products and conversions if (and only if 
) my analysis is correct. Not sure
what this means for channel remap. I do know Avalon Bay is effected. It might be
good if someone knowing all the steps stepped through this to make sure I know
what I am talking about
