Details
-
Type: Bug
-
Status: Closed
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: Mercury
-
Fix Version/s: Mercury
-
Component/s: Reporting (Outbound Datafeeds)
-
Labels:None
-
Environment:
Ops Script #905
-
Sprint:Sprint 18
Description
Data Discrepancy report for Bing and Yahoo displays repetitive accountID values
For Bing
[amlops@aml-qa5-monman1 DataChecker]$ ./AMLGetAllBingDataDiscrepancies.sh -h aml-qa5-mysql1 -T 2016-01-22
Spend Information (Warehouse, bingDailyCheck, bingPerformanceReports, bingAdMax): 2.75:0.12:0.39:0.39
bingDailyCheck - warehouse %: 4.36%
accountIDs that need to resolved for discrepencies (bingDailyCheck - Warehouse):
bingDailyCheck - bingPerformanceReports %: 30.76%
accountIDs that need to resolved for discrepencies (bingDailyCheck - bingPerformanceReports): 925,925,
bingDailyCheck - bingAdMax %: 30.76%
accountIDs that need to resolved for discrepencies (bingDailyCheck - bingAdMax): 925,925,925,
Expected: AccountID is not displayed in case 1.
AccountID should be displayed only once in case 2 and 3.
For Yahoo
./AMLGetAllYJPDataDiscrepancies.sh -h aml18-mysql1 -T 2015-09-14
Spend Information (Warehouse, yahooDailyCheck, yahooJPerformanceReports, yahooJAdMax): 1248:1066:1248:1248
yahooDailyCheck - warehouse %: 85.41%
accountIDs that need to resolved for discrepencies (yahooDailyCheck - Warehouse): 3,
yahooDailyCheck - yahooJPerformanceReports %: 85.41%
accountIDs that need to resolved for discrepencies (yahooDailyCheck - yahooJPerformanceReports): 3,3,
yahooDailyCheck - yahooJAdMax %: 85.41%
accountIDs that need to resolved for discrepencies (yahooDailyCheck - yahooJAdMax): 3,3,3,
searchEngineUID that need to resolved for discrepancy: 177
Expected:
AccountID should be displayed only once in case 2 and 3.