DCM Campaign Export in to Google Sheets

[Winona Brough]

 Is it possible to get DCM Campaign Export in to Google Sheets using the script editor? 

If so, am looking for guidance on how to do so. 

The programmatic team have been able to write the script to pull SDFs in to google sheets and now we are looking to do the same for DCM

[DCM API (DoubleClick Campaign Mgr)]

Hello Winona,

You can get the list of campaigns that are associated with your profile using Campaigns:list operation via DCM API.You might find this code sample useful that lists all existing campaigns for the specified user profile in JSON format. You need to implement the logic on your end to export this data into the Google Sheets. Feel free to reach out if you have any additional concerns.

Regards,
Nikisha Patel, DCM API Team

ref:_00D1U1174p._5001UODme3:ref

[Winona Brough]

Hi Nikisha,

 

I found the campaign list but that’s not exactly what I am after, I am looking for the campaign export function for each individual campaign.

 

Similar to the SDF download in DV360 that you can export to get the full campaign details.

 

If this is not possible, are you able to guide me through the script for reporting to pull in booked metrics?

 

 

Thanks,

Winona

 

Winona Brough

PHD New Zealand
Main: +64 9 638 1200    Direct: +64 9 638 1256    Mobile: +64 21 808 395

From: google-doubleclick-...@googlegroups.com <google-doubleclick-...@googlegroups.com> On Behalf Of DCM API (DoubleClick Campaign Mgr)
Sent: Thursday, 5 December 2019 4:37 AM
To: google-doubleclick-...@googlegroups.com
Subject: RE: DCM Campaign Export in to Google Sheets

 

CAUTION: This email originated from the Internet. The Original Sender is google-doubleclick-for-advertisers-a...@googlegroups.com

 

--
You received this message because you are subscribed to the Google Groups "Google's DoubleClick Campaign Manager API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-doubleclick-for-ad...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-doubleclick-for-advertisers-api/3l_yT000000000000000000000000000000000000000000000Q1ZVE300SigXpjdpQmuZ0UySY_dPHg%40sfdc.net.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this e-mail or the information herein by anyone other than the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, is prohibited. If you have received this e-mail in error, please delete all copies immediately and notify the sender.

[DCM API (DoubleClick Campaign Mgr)]

Hi Winona,

We do not have functionality similar to SDF download in DV360 to download or export the campaign details via Campaign Manager API. For your script related concern, I'd suggest reaching out to App Scripts support as they are better equipped to assist you with the scripting issues. Feel free to reach out for any API related concerns.

Regards,
Nikisha Patel, DCM API Team

ref:_00D1U1174p._5001UODme3:ref