Details
-
Type:
Task
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: Gollum
-
Fix Version/s: All Time Backlog
-
Component/s: None
-
Labels:None
-
Story Points:8
Description
As of 2016-08-10 AdWords shows "6/10" for keywords that have no quality score while the API returns "--". Not sure if this task is still valid if it causes a discrepancy with the AdWords UI.
In the v201607 API upgrade AdWords began returning "--" instead of 6 for keywords that have no quality score. If there is no quality score available we should set the value to NULL in the database. In Gollum code was added to convert the double dashes to 6.
To test:
1. Run googlemcc.sh for a campaign that has impressions and at least one keyword that doesn't have a quality score. Verify that the quality score is null in staging.googlemcc.
2. Run the whsummarizer. Verify the quality score in the sources table.
3. Generate the following reports that use quality score:
- keyword leads report https://admaxlocal.atlassian.net/wiki/display/OPS/AML+Support+FASQA+as+of+Mercury+v.+3.0.0#AMLSupportFASQAasofMercuryv.3.0.0-KeywordLeadsReport
- YPG tier 1 daily performance report https://admaxlocal.atlassian.net/wiki/display/OPS/YPG+Specific+Reports
- YPG campaign metrics report https://admaxlocal.atlassian.net/wiki/display/OPS/YPG+Specific+Reports
- YJ keyword leads report https://admaxlocal.atlassian.net/wiki/display/OPS/Yahoo%21+Japan+Specific+Reports
