Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: Mercury
-
Fix Version/s: Mercury
-
Component/s: Reporting (Outbound Datafeeds)
-
Labels:None
-
Environment:
Ops Script #886
-
Sprint:Sprint 16
Description
Carryover is doubled in Account-level-carryover-data reports
Ran the following script to generate Account level carryover data reports
./report-account-level-carryover-data.sh -h aml-qa4-mysql1 -u spike -p tar63t -o /var/local/tsa/reports/
One of the report that got generated with the one that i ran few days back
[amlops@aml-qa4-monman1 reports]$ cat googlebing-account-level-carryover-data-2016-01-15.csv
Merchant UUID,Sum of Account Carryover,Current Status,Distribution
13a590db-da1a-4d08-8d14-7f7e2336cbf3,0.25806400179862976,ACTIVE,Google
1f4c45eb-49bc-4ba6-b6b5-97eefe945082,8,ACTIVE,Google
1f4c45eb-49bc-4ba6-b6b5-97eefe945082,6,ACTIVE,Bing
29a9cc9c-3044-4392-ab4c-28f09cc86b53,0,DELETED,Google
3c02257d-56e2-47fd-ab97-46ad8b70f318,-0.11999999731779099,ACTIVE,Bing
7066bb76-49df-4f64-a170-6c4ceee38752,0.2666659951210022,ACTIVE,Bing
7337874b-761b-4c5f-9cba-5d3ab6253bc7,-0.04666660726070404,ACTIVE,Bing
774d2787-fd32-4fdf-bc09-1f12e0f58d00,-0.11333339661359787,ACTIVE,Bing
80304064-d278-40da-af01-1884d8082ac8,0.25806400179862976,ACTIVE,Google
8b1fc22d-447a-46ce-a2f5-a60b2afb8380,0,DELETED,Google
8b1fc22d-447a-46ce-a2f5-a60b2afb8380,0,DELETED,Bing
[amlops@aml-qa4-monman1 reports]$ cat googlebing-account-level-carryover-data-2016-01-05.csv
Merchant UUID,Sum of Account Carryover,Current Status
09bd2350-824a-4efe-84f3-31c74edfdbdc,0,PAUSED
13a590db-da1a-4d08-8d14-7f7e2336cbf3,0.12903200089931488,ACTIVE
1f4c45eb-49bc-4ba6-b6b5-97eefe945082,7,ACTIVE
29a9cc9c-3044-4392-ab4c-28f09cc86b53,0,DELETED
3c02257d-56e2-47fd-ab97-46ad8b70f318,-0.05999999865889549,ACTIVE
5082db11-9467-4248-bd67-00b16117ee54,0,PAUSED
646035f3-0b0d-4d8a-8496-6b70a84c4459,0,PAUSED
7066bb76-49df-4f64-a170-6c4ceee38752,0.1333329975605011,ACTIVE
7337874b-761b-4c5f-9cba-5d3ab6253bc7,-0.02333330363035202,ACTIVE
774d2787-fd32-4fdf-bc09-1f12e0f58d00,-0.056666698306798935,ACTIVE
7f12ba36-eb8b-4010-8426-efd9b3e4f897,0,PAUSED
80304064-d278-40da-af01-1884d8082ac8,0.12903200089931488,ACTIVE
8b1fc22d-447a-46ce-a2f5-a60b2afb8380,0,DELETED
Check
SELECT * FROM `st-tracker`.admaxCampaigns WHERE description LIKE "%80304064-d278-40da-af01-1884d8082ac8%"
SELECT * FROM `st-tracker`.admaxCarryovers WHERE admaxCampaignID IN (1646)
Sum of carryover=dedicated+commom
=0.064516+0.064516=0.129032
The latest file has doubled the amount.
Verified on QA4
