Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-627

Brand Campaign deployment fails but campaign is active on google

    Details

    • Type: Bug
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 1.3.0
    • Fix Version/s: Web Pages Release
    • Labels:
      None
    • Environment:

      Optus production (odabidding01.syd, odaadbibu01.syd, acctdb-01-write)

      Description

      Failed brand campaign deployments can be left as active in Google because the campaign status defaults to active. The brand campaign status is derived from the status of all other campaigns, so at least one of the campaigns must have been active.

      In this particular case, the deploy failed due to a negative phrase "school" keyword and a positive phrase "school" keyword.

      To fix this, there are 2 options:

      1) start the brand campaign status as paused initially, and then only if it's the deploy succeeds set the campaign status to the derived value of the rest of the campaigns (which most likely would be active).

      2) catch the failure and update the status to paused

      I think the first one would be best.

      Here are a few things that were done to diagnose:

      Campaign name: 81673035000190-0411518014_0_0_81673035000190-0411518014-1_BRAND
      GCE Campaign ID: 1703
      SearchEngineAccountID: 1703
      AccountID: 499

      grep '81673035000190-0411518014_0_0_81673035000190-0411518014-1_BRAND' /var/local/tsa/log/tsa-admax-jmslistener/*

      Found in: /var/local/tsa/log/tsa-admax-jmslistener/tsa-admax-jmslistener.log.2012-09-20-232001

      2012-09-20 16:35:46.320 (2) [pool-3-thread-3]: Error: CampID: 81673035000190-0411518014-1_BRAND Info: [[Google API error, type=Keyword, errorCode=0, errorText=AdGroupCriterionError, reason=AdGroupCriterionError.CANNOT_TARGET_AND_EXCLUDE, field=operations[52].operand]
      2012-09-20 16:35:46.320 (2) [pool-3-thread-3]: 81673035000190-0411518014-1_BRAND has GCE errors.

      Get list of the keywords:
      use content_editor_google;
      select campaignID, adGroupID, g.status, k.id, k.searchEngineIdentifier 'kident', text, keywordType, isNegative, k.status from gce_campaign c join gce_adGroup g on campaignID=c.id join gce_keyword k on adGroupID=g.id where c.ID=1703;

      Attached

      • the listener log file where the deploy failed
      • the discrepancy report which shows the traffic the brand campaign is getting traffic in Google but not being stored in the warehouse (due to sync not running since the brand campaign deploy failed).

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              therouxj Jeff Theroux
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: