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

staging.bingClicks table is not updated with click data on running bingreport.sh

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: Kirin
    • Fix Version/s: Pluto
    • Component/s: None
    • Labels:
      None
    • Environment:

      aml-qa4-core1

    • Sprint:
      Sprint 1

      Description

      steps:
      ---------
      1. Select an account that has performance data in Bing Ads, especially clicks.
      2. Run bingreport.sh for the date on which the account has clicks data.

      ./bingreport.sh -d5 -rt performance -T<date> -U<seuid>

      3. check staging.bingClicks after report has executed successfully.

      SELECT * FROM staging.bingClicks WHERE campaignid IN (SELECT searchEngineIdentifier FROM tsacommon.searchEngineAccounts WHERE description LIKE "%<merchant_uuid>%") AND startTime='<date>'

      Expected: staging.bingClicks should get updated with click data after running bingreport.sh

      Actual: staging.bingClicks table was empty.

      See the attached log for bingreport.sh run.

        Attachments

          Activity

            People

            • Assignee:
              anil.kumar Anil Kumar Halmadgi
              Reporter:
              Madhan Madhan Pulipati [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: