Missing Pivoted Metrics in the BQ export from Campaign Manager

[Long Pham]

Hi everyone,

I've been using the native BigQuery (BQ) export feature in Campaign Manager for my reports, which has been working smoothly for the most part. However, I noticed that my report's pivoted metrics aren't showing up in the BigQuery table. This seems to limit the direct import functionality for such specific data types.

From what I gather, it looks like utilizing the Campaign Manager API might be the only automated way to import these pivoted metrics into BigQuery. Can anyone confirm if this is the case, or if there have been any recent updates or workarounds that I might have missed?

Additionally, with the migration from offline reporting to instant reporting in the platform, I'm curious if there have been any improvements or new features introduced for exporting pivot data, especially concerning floodlight activities.

I'd appreciate any insights or guidance on this matter!

Thanks in advance!

[DCM API (DoubleClick Campaign Mgr)]

Hi,

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

Upon checking the provided information, I could see that the issue is more related to BigQuery rather than with CM360 API. Kindly note that the concerns related to the BigQuery are out of scope for the CM360 API support team. I would suggest you reach out to the GCP Product Support Team as they are better equipped to assist you on this. I would recommend you refer to this help center article on Offline Reporting and Instant Reporting migration for more information related to updates on migration from offline reporting to instant reporting.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02tOoxK:ref" (ADR-00229736)

Thanks,
 

DCM API Team