[AML-4087] AdWords v201601 Upgrade - Bidmgr - Admax Local

Details

Type: Task
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: Gingersnap
Component/s: None
Labels:
None

Story Points:
3

Description

The AdWords v201506 API sunsets on April 11, 2016

Wiki page: v201509/v201601 Upgrade https://admaxlocal.atlassian.net/wiki/pages/viewpage.action?pageId=3244596

Dev

Update report parsing in SEUpdater to handle JSON lists for the CreativeFinalUrls column. The final URL goes in sync_google.googleAds.creativeDestURL
Replace the 'ConversionsManyPerClick' column with 'Conversions' - this column is downloaded as part of the campaign performance report for the data checker and as part of the ad performance report during the daily performance report downloads

Testing

1. Deployments

Tail the listener log after an order has been submitted for deployment. Verify that the SOAP request/responses are for v201601

2016-03-24 02:30:30,858 [pool-139-thread-2] INFO  c.g.a.a.a.l.c.A.soapXmlLogger - SOAP Request:
<?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Header>
        <ns1:RequestHeader xmlns:ns1="https://adwords.google.com/api/adwords/cm/v201601" soapenv:mustUnderstand="0">
            <ns1:clientCustomerId>2793353269</ns1:clientCustomerId>
            <ns1:developerToken>ojCnjZaM6RD1h0yt_DOJZg</ns1:developerToken>
            <ns1:userAgent>AdMaxLocal AdWords Software TSA DEV (AwApi-Java, AdWords-Axis/2.11.0, Common-Java/2.11.0, Axis/1.4, Java/1.8.0_65, maven)</ns1:userAgent>
            <ns1:validateOnly>false</ns1:validateOnly>
            <ns1:partialFailure>true</ns1:partialFailure>
        </ns1:RequestHeader>
    </soapenv:Header>
    <soapenv:Body>
        <mutate xmlns="https://adwords.google.com/api/adwords/cm/v201601">
            <operations>
                <operator>ADD</operator>
                <operand>
                    <adGroupId>27156136476</adGroupId>
                    <ad xmlns:ns2="https://adwords.google.com/api/adwords/cm/v201601" xsi:type="ns2:TextAd">
                        <ns2:displayUrl>www.martiantourism.com</ns2:displayUrl>
                        <ns2:finalUrls>http://www.martiantourism.com</ns2:finalUrls>
                        <ns2:headline>{KeyWord:Luxury Bed &amp; Breakfast}</ns2:headline>
                        <ns2:description1>You'll Be Glad You Stayed With Us.</ns2:description1>
                        <ns2:description2>Half Moon Bay Guest Rooms.</ns2:description2>
                    </ad>
                    <status>ENABLED</status>
                </operand>
            </operations>

            <operations>
                <operator>ADD</operator>
                <operand>
                    <adGroupId>27156136476</adGroupId>
                    <ad xmlns:ns3="https://adwords.google.com/api/adwords/cm/v201601" xsi:type="ns3:TextAd">
                        <ns3:displayUrl>www.martiantourism.com</ns3:displayUrl>
                        <ns3:finalUrls>http://www.martiantourism.com</ns3:finalUrls>
                        <ns3:headline>Luxury Bed &amp; Breakfast</ns3:headline>
                        <ns3:description1>Half Moon Bay Guest Rooms.</ns3:description1>
                        <ns3:description2>You'll Be Glad You Stayed With Us.</ns3:description2>
                    </ad>
                    <status>ENABLED</status>
                </operand>
            </operations>
            <operations>
                <operator>ADD</operator>
                <operand>
                    <adGroupId>27156136476</adGroupId>
                    <ad xmlns:ns4="https://adwords.google.com/api/adwords/cm/v201601" xsi:type="ns4:TextAd">
                        <ns4:displayUrl>www.martiantourism.com</ns4:displayUrl>
                        <ns4:finalUrls>http://www.martiantourism.com</ns4:finalUrls>
                        <ns4:headline>Your Bed &amp; Breakfast</ns4:headline>
                        <ns4:description1>Half Moon Bay B&amp;B.</ns4:description1>
                        <ns4:description2>Accommodation the Way it Should Be.</ns4:description2>
                    </ad>
                    <status>ENABLED</status>
                </operand>
            </operations>
            <operations>
                <operator>ADD</operator>
                <operand>
                    <adGroupId>27156136476</adGroupId>
                    <ad xmlns:ns5="https://adwords.google.com/api/adwords/cm/v201601" xsi:type="ns5:TextAd">
                        <ns5:displayUrl>www.martiantourism.com</ns5:displayUrl>
                        <ns5:finalUrls>http://www.martiantourism.com</ns5:finalUrls>
                        <ns5:headline>{KeyWord:Your Bed &amp; Breakfast}</ns5:headline>
                        <ns5:description1>Accommodation the Way it Should Be.</ns5:description1>
                        <ns5:description2>Half Moon Bay B&amp;B.</ns5:description2>
                    </ad>
                    <status>ENABLED</status>
                </operand>
            </operations>
        </mutate>
    </soapenv:Body>
</soapenv:Envelope>


2016-03-24 02:30:30,858 [pool-139-thread-2] INFO  c.g.a.a.a.l.c.A.soapXmlLogger - SOAP Response:
<?xml version="1.0" encoding="UTF-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
    <soap:Header>
        <ResponseHeader xmlns="https://adwords.google.com/api/adwords/cm/v201601">
            <requestId>00052ec23950ebf80a4c0ac4aa06380b</requestId>
            <serviceName>AdGroupAdService</serviceName>
            <methodName>mutate</methodName>
            <operations>4</operations>
            <responseTime>491</responseTime>
        </ResponseHeader>
    </soap:Header>
    <soap:Body>
        <mutateResponse xmlns="https://adwords.google.com/api/adwords/cm/v201601">
            <rval>
                <ListReturnValue.Type>AdGroupAdReturnValue</ListReturnValue.Type>
                <value>
                    <adGroupId>27156136476</adGroupId>
                    <ad xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="TextAd">
                        <id>87418109556</id>
                        <displayUrl>www.martiantourism.com</displayUrl>
                        <finalUrls>http://www.martiantourism.com</finalUrls>
                        <type>TEXT_AD</type>
                        <Ad.Type>TextAd</Ad.Type>
                        <headline>{KeyWord:Luxury Bed &amp; Breakfast}</headline>
                        <description1>You'll Be Glad You Stayed With Us.</description1>
                        <description2>Half Moon Bay Guest Rooms.</description2>
                    </ad>
                    <status>ENABLED</status>
                    <approvalStatus>UNCHECKED</approvalStatus>
                </value>
 
               <value>
                    <adGroupId>27156136476</adGroupId>
                    <ad xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="TextAd">
                        <id>87418109676</id>
                        <displayUrl>www.martiantourism.com</displayUrl>
                        <finalUrls>http://www.martiantourism.com</finalUrls>
                        <type>TEXT_AD</type>
                        <Ad.Type>TextAd</Ad.Type>
                        <headline>Luxury Bed &amp; Breakfast</headline>
                        <description1>Half Moon Bay Guest Rooms.</description1>
                        <description2>You'll Be Glad You Stayed With Us.</description2>
                    </ad>
                    <status>ENABLED</status>
                    <approvalStatus>UNCHECKED</approvalStatus>
                </value>
                <value>
                    <adGroupId>27156136476</adGroupId>
                    <ad xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="TextAd">
                        <id>87418109796</id>
                        <displayUrl>www.martiantourism.com</displayUrl>
                        <finalUrls>http://www.martiantourism.com</finalUrls>
                        <type>TEXT_AD</type>
                        <Ad.Type>TextAd</Ad.Type>
                        <headline>Your Bed &amp; Breakfast</headline>
                        <description1>Half Moon Bay B&amp;B.</description1>
                        <description2>Accommodation the Way it Should Be.</description2>
                    </ad>
                    <status>ENABLED</status>
                    <approvalStatus>UNCHECKED</approvalStatus>
                </value>
                <value>
                    <adGroupId>27156136476</adGroupId>
                    <ad xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="TextAd">
                        <id>87418109916</id>
                        <displayUrl>www.martiantourism.com</displayUrl>
                        <finalUrls>http://www.martiantourism.com</finalUrls>
                        <type>TEXT_AD</type>
                        <Ad.Type>TextAd</Ad.Type>
                        <headline>{KeyWord:Your Bed &amp; Breakfast}</headline>
                        <description1>Accommodation the Way it Should Be.</description1>
                        <description2>Half Moon Bay B&amp;B.</description2>
                    </ad>
                    <status>ENABLED</status>
                    <approvalStatus>UNCHECKED</approvalStatus>
                </value>
            </rval>
        </mutateResponse>
    </soap:Body>
</soap:Envelope>

2016-03-24 02:30:30.859 (4) [pool-139-thread-2]: sesystem: SQL->[select 1]
2016-03-24 02:30:30.860 (4) [pool-139-thread-2]: time=0.001
2016-03-24 02:30:30.860 (4) [pool-139-thread-2]: Query executed in 0.001s
2016-03-24 02:30:30.860 (4) [pool-139-thread-2]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `inUse`="false",`holderIdentifier`="",`timeStamp`="2016-03-24 02:30:30",`holder`="" where ((`sesystem`.`searchEngineConnection
s`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`holder`="AddAdList") and (`sesystem`.`searchEngineConnections`.`holderIdentifier`="2793353269") and (`sesystem`.`se
archEngineConnections`.`searchEngineUserID`=12)) limit 1], genflags=no

You can also grep the current listener log to make sure there are no occurrences of v201506:

grep --color=always 'v201506' /var/local/tsa/log/tsa-admax-jmslistener/tsa-admax-jmslistener.log

2. SEUpdater

Deploy an order. After it has deployed the listener will run the SEUpdater. Verify that the entries added to sync_google.googleAds.creativeDestURL are correct.

3. Ad Performance Report with googlemcc.sh

Run the googlemcc.sh script for an account (do not use the --admax option) and verify that the conversions in staging.googleMcc.conv are correct.

./googlemcc.sh -T 2015-09-22 -d3 -U 2

Attachments

Activity

People

Assignee:

Sanjay Kumar Biswal

Reporter:

Stacie Waleyko (Inactive)

Votes:

0 Vote for this issue

Watchers:

3 Start watching this issue

Dates

Created:

16/Mar/16 12:17 PM

Updated:

12/May/16 6:44 PM

Resolved:

23/Mar/16 10:42 PM