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

Report campaign level performance data for Facebook is not fetching performance data

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: Eris
    • Fix Version/s: Eris
    • Component/s: None
    • Labels:
      None
    • Sprint:
      Sprint 6

      Description

      Steps:

      1.Run the report for campaign level :
      Eg: ./facebookreport.sh -d3 -U 3470 -rt campaign -T 2018-03-16

      2. Check below for performance
      SELECT * FROM staging.facebookCampaignPerformanceReports c WHERE c.campaignid ='d3c76057493943868fa32c414de92ab0';

      Actual Result: Campaign level performance data is not fetching

      Expected Result: Should fetch campaign level performance data

      Query in the log:

      SELECT `campaigns`.`tpid`, `campaigns`.`status`, `campaigns`.`name` FROM `campaigns` WHERE
      `campaigns`.`searchEngineUserId` = 3611 AND `campaigns`.`startDate` <= '08/17/2018 00:00:00.000'
      AND `campaigns`.`endDate` >= '08/17/2018 00:00:00.000'

        Attachments

          Activity

            People

            • Assignee:
              rahul.honakande Rahul Honakande
              Reporter:
              rahul.honakande Rahul Honakande
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: