Request for customized reporting fields in CM360

[Kamesh Manikonda]

Our goal is to access all these set of dimensions and metrics available in one report, what we identified that obtaining our desired data requires multiple report extractions, this can cause multiple api calls to potential increase in complexity.

Could you provide any guidance on customizing report extractions to include our needed fields(Dimensions and metrics) in a more streamlined way? Any recommendations on best practices for data aggregation within CM360 framework?

Thank you 

Fields:

{
  "kind": "dfareporting#report",
  "type": "STANDARD",
  "name": "Example Report",
  "criteria": {
    "dateRange": {
       "startDate": "2024-02-26",
       "endDate": "2024-02-26"
     },

    "dimensions": [
      {"name": "advertiser"},
      {"name": "advertiserId"},
      {"name": "vertical"},
      {"name": "site"},
      {"name": "siteId"},
      {"name": "campaign"},
      {"name": "campaignid"},
      {"name": "campaignStartDate"},
      {"name": "campaignEndDate"},
      {"name":"mediaType"},
      {"name":"packageRoadblockId"},
      {"name":"packageRoadblock"},
      {"name":"placementCostStructure"},
      {"name":"placementId"},
      {"name":"placement"},
      {"name":"placementStartDate"},
      {"name":"placementEndDate"},
      {"name":"placementCompatibility"},
      {"name":"placementSize"},
      {"name": "ad"},
      {"name": "adId"},
      {"name": "adType"},
      {"name": "creativeSize"},
      {"name": "richMediaVideoLength"},  
      {"name": "environment"},
      {"name": "browserPlatform"},
      {"name": "operatingSystemVersion"},
      {"name": "platformType"},
      {"name": "operatingSystem"},
      {"name": "country"},
      {"name": "state"},
      {"name": "city"},
      {"name": "dmaRegion"},
      {"name": "zipCode"},
      {"name": "date"},
      {"name": "videoContinuousPlay"}
    ],
    "metricNames": [
      "impressions",
      "clicks",
      "invalidClicks",
      "invalidImpressions",
      "richMediaAverageFullScreenViewTime",
      "richMediaFullScreenVideoCompletes",
      "richMediaVideoMutes",
      "richMediaVideoPauses",
      "richMediaVideoCompletions",
      "richMediaVideoFirstQuartileCompletes",
      "richMediaVideoMidpoints",
      "richMediaVideoThirdQuartileCompletes",
      "richMediaAverageVideoViewTime",
      "activeViewPercentPlayTimeAudibleAndVisible",
      "richMediaVideoReplays",
      "richMediaVideoSkips",
      "richMediaVideoUnmutes",
      "activeViewViewableImpressions",
      "invalidActiveViewViewableImpressions",
      "richMediaInteractiveImpressions",
      "richMediaVideoPlays",
      "videoContinousPlay",
      "clickRate",
      "dv360Cost"
    ]
  }
}

[DCM API (DoubleClick Campaign Mgr)]

Hello,

Thank you for reaching out to the DCM API support team.

I would like to inform you that all dimensions and metrics won't be compatible while generating the report. You can use the reports.compatibleFields.query method, to verify the fields that are compatible to be selected in the respective sections of a report criteria. No, it is not possible to customize report dimensions and metrics where these patterns are already defined on the DCM product side so that we can only generate available combinations of it. You may use multiple API calls to generate different report based on your requirements and then, you can do some post processing to combine them.

Hope this helps. For any other assistance you may get back to us.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02rzeDD:ref"

Thanks,
 

DCM API Team