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

Campaign Service returns 0 budget as sellable

    Details

    • Sprint:
      Sprint 13, Sprint 14

      Description

      I have created an order for 'Spa Resorts in Auburn (Alabama)'. I took a sellable BA and BL, and deleted all the keywords but 1 neg keyword. This gave me a BES response of $0.00. The UI is not listing this as unsellable.

      mysql> SELECT * FROM mms_common.businessAreas where id=10001;
      ------------------------

      id description status

      ------------------------

      10001 Spa Resorts active

      ------------------------
      1 row in set (0.37 sec)

      mysql> SELECT * FROM mms_common.businessLocations where description like '%Auburn, Alabama%';
      --------------------------------------------------------------------------------------------------------------------+

      id description shortDescription status businessLocationTypeID useSEDefinedTargets usePointRadiusTargets isSellable

      --------------------------------------------------------------------------------------------------------------------+

      12015 Auburn, Alabama Auburn active 5 0 1 1

      --------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.37 sec)

      mysql> SELECT * FROM biz_function_location.keywords where keywordListID=2595;
      ------------------------------------------------------------------------------------

      id keywordListID keyword matchType isGeoMod isGeoTarget isMobile isNegative subGroupID

      ------------------------------------------------------------------------------------

      195291 2595 what to phrase 0 1 1 1 0

      ------------------------------------------------------------------------------------
      1 row in set (0.01 sec)

      http://optus.aq-qa-tomcat1:8080/sapi/rest/campaign/estimates

      Response:
      {"status":"VALID","criteria":"campaigns (services in ('GOOGLE') and businessAreaId in ('10001') and locationId in ('12015'))","minimumPrice":0.0,"maximumPrice":0.0,"minimumClicks":0.0,"maximumClicks":0.0,"components":[{"status":"VALID","criteria":"campaigns (businessAreaId in ('10001') and locationId in ('12015') and services in ('GOOGLE'))","minimumPrice":0.0,"maximumPrice":0.0,"minimumClicks":0.0,"maximumClicks":0.0,"components":[

      {"status":"UNSELLABLE_BUSINESS_AREA","criteria":"campaigns (businessAreaId in ('10001') and locationId in ('12015') and services in ('GOOGLE'))","minimumPrice":0.0,"maximumPrice":0.0,"minimumClicks":0.0,"maximumClicks":0.0,"components":null}

      ]}]}

        Attachments

          Activity

            People

            • Assignee:
              gavin.nicol Gavin Nicol (Inactive)
              Reporter:
              jelliott Jen Clarke (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: