DCM/DFA Reporting and Trafficking API-Campaign Performance data needed in json/xml format

[bmcanalytics help]

Hi Team,

 

We need to use DCM/DFA Reporting and Trafficking API to pull Campaign tracking metrics(visits,clicks,impression etc.).

When I have gone through the API documentation, I found that the ‘get file’ method of the API returns the campaign tracking data in csv/excel downloadable format.

But we need the data in json/xml format, so that we can parse the data  and write into SQL databases.

Can you help us with any API endpoints, that returns the data in json/xml format?

[Paul Stemmet]

Our technology does this and writes directly into sql database. www.yapengine.io

Paul Stemmet

CEO 

---

From: google-doubleclick-...@googlegroups.com <google-doubleclick-...@googlegroups.com> on behalf of bmcanalytics help <bmcanaly...@eyg.ey.com>
Sent: Friday, 02 August 2019 08:03
To: Google's DoubleClick Campaign Manager API Forum <google-doubleclick-...@googlegroups.com>
Subject: DCM/DFA Reporting and Trafficking API-Campaign Performance data needed in json/xml format

 

--
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/bb8232ff-27be-458b-ae34-0a1c8729a59a%40googlegroups.com.

[DCM API (DoubleClick Campaign Mgr)]

Hi,

In DCM API, you can get the data in the CSV/EXCEL file, but not in JSON/XML format. I will forward your request as a feature request to the team.

Reporting guide:
https://developers.google.com/doubleclick-advertisers/guides/download_reports

Thanks,
Lakshmi, DCM API Team

ref:_00D1U1174p._5001UEHbbq:ref

[Paul Stemmet]

Sorry www.yapengine.com 

Get Outlook for iOS

---

From: Vishnu Mohan KV <Vishnu...@gds.ey.com>
Sent: Tuesday, August 6, 2019 9:34:43 AM
To: Paul Stemmet <pa...@shinka.sh>; google-doubleclick-...@googlegroups.com <google-doubleclick-...@googlegroups.com>
Cc: Prashant N Hirebidari Kumar <Prashan...@gds.ey.com>; BMC Analytics Help <bmcanaly...@eyg.ey.com>
Subject: RE: DCM/DFA Reporting and Trafficking API-Campaign Performance data needed in json/xml format

 

Hi Paul/Team,

 

The link you have shared www.yapengine.io is not working for me.

Could you please let me  know how can we write directly into sql database from API?

 

Thanks & Regards   Vishnu Mohan K V | Associate|  Enablement Decision Sciences   Ernst & Young LLP Global Talent Hub Division, Leela Infopark, Kochi, Kerala 682030, GSS - India Mobile: +919400601776 | Vishnu...@xe04.ey.com Website: http://www.ey.com

 

From: Prashant N Hirebidari Kumar
Sent: Monday, August 5, 2019 1:30 PM
To: Vishnu Mohan KV <Vishnu...@gds.ey.com>
Subject: FW: DCM/DFA Reporting and Trafficking API-Campaign Performance data needed in json/xml format

 

FYI

 

Prashant Kumar | Analytics Supervising Associate | Brand, Marketing and Communications

EYGBS (India) Private Limited

Mobile: 91-9742095256

Office: 080-63545702|prashan...@xe02.ey.com

 

 

From: BMC Analytics Help
Sent: Monday, August 5, 2019 1:20 PM
To: Prashant N Hirebidari Kumar <Prashan...@gds.ey.com>
Subject: FW: DCM/DFA Reporting and Trafficking API-Campaign Performance data needed in json/xml format

 

FYI

___________________________________
The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. EY is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.

[bmcanalytics help]

Hi Lakshmi,

Do you have any update on our request?

Thanks & Regards,

Vishnu Mohan K V

[DCM API (DoubleClick Campaign Mgr)]

Hi Vishnu,

I am Nikisha from DCM API Team. Lakshmi is OOO today. I will update this thread once I have more information from the internal team regarding this feature.

Regards,
Nikisha Patel, DCM API Team

ref:_00D1U1174p._5001UEHbbq:ref

[bmcanalytics help]

Hi Nikisha,

Please could you help us with a call and help us in getting API connection.

Regards,

Prashant.

[DCM API (DoubleClick Campaign Mgr)]

Hi Prashant,

Email is the preferred communication on this forum. For setting up APIs, you need to follow the getting started guide. 
Helpful links:

1. Getting started guide: https://developers.google.com/doubleclick-advertisers/getting_started
2. GitHub Samples: https://github.com/googleads/googleads-dfa-reporting-samples

Please start a new thread for a new question.

Thanks,
Lakshmi, DCM API Team

ref:_00D1U1174p._5001UEHbbq:ref

[bmcanalytics help]

Hi Team,

Do we have any update on this?

[DCM API (DoubleClick Campaign Mgr)]

Hi,

Are you asking update for getting the report in JSON format or setting up APIs? If it is for the report in JSON format I filed a feature request. I don't have an ETA on this.  If it is for setting up APIs, then I sent my response on Sept 5th which I am copy pasting here:

Hi Prashant,

Email is the preferred communication on this forum. For setting up APIs, you need to follow the getting started guide. 
Helpful links:

1. Getting started guide: https://developers.google.com/doubleclick-advertisers/getting_started
2. GitHub Samples: https://github.com/googleads/googleads-dfa-reporting-samples

Please start a new thread for a new question.

Thanks,

Lakshmi, DCM API Team

ref:_00D1U1174p._5001UEHbbq:ref