CM360 API returns error on some reports

[Pavlo Vonorim]

Hello! 
I have successfully used api for the last six months, but today there was an error. 
Everyday I use method run to prepare and then download ready reports. All reports have been created through Campaign Manager Report Building (Offline). 

Url:  https://dfareporting.googleapis.com/dfareporting/v3.5/userprofiles/{profileId}/reports/{reportId}/run

Some of requests still works fine, but some of them returns error:

{

  "error": {

    "code": 400,

    "message": "You must select an attribution model to report on.",

    "errors": [

      {

        "message": "You must select an attribution model to report on.",

        "domain": "global",

        "reason": "required"

      }

    ]

  }

}

Tried through Postman and then with Google API Explorer. 

Successful requests return:

{

  "kind": "dfareporting#file",

  "etag": "\"4snXbx1t8S6AQmUYFJEDGXy6Uxk\"",

  "reportId": "{report_id}",

  "id": "{id}",

  "lastModifiedTime": "1626252882000",

  "status": "PROCESSING",

  "fileName": "{filename}l",

  "dateRange": {

    "kind": "dfareporting#dateRange",

    "startDate": "2021-05-15",

    "endDate": "2021-07-13"

  }

}

What does it mean? I didnt find any additional required params: 
https://developers.google.com/doubleclick-advertisers/rest/v3.5/reports/run

Tried v3.5 and v3.4.

Thanks!

[George Lemanis]

Hello,

I am facing the same issue since this morning. Do we have any update on this?

Thanks in advance,
George

[Chris Baclig]

Discovered the same issue this morning. It appears there was a new "Attribution Model" field added to the CM report builder form: 

I'm not sure what API fields this corresponds to, but I was able to get my API calls to run reports working again by just saving the reports (without making any changes) in the UI. For those without UI access, it is unclear to me whether resaving the reports via API will work as well.

Chris

[Erica Han]

Hi all,

Ran into the same issue this morning. Simply re-saving the reports that you are trying to pull in the offline reports section will do the trick!

Thanks,

Erica

[Andrew Hunt]

Hi Chris,

 

That will work, or if you are creating the reports programmatically to run them I’ve found you now need to add an extra filter to the params:

 

 

                params: {

                  filters: [

                    {type: "FILTER_ATTRIBUTION_MODEL", value: "0"},

                    {type: "FILTER_ADVERTISER", value: advertiserId},

                  ],

 

And it just needs to be set to “0” to work.

 

Kind regards,

 

ANDREW HUNT​ HEAD OF SOFTWARE ENGINEERING

31‑41 Worship Street 2nd Floor London  EC2A 2DY United Kingdom andre...@fundamentalmedia.com www.fundamentalmedia.com

For digital advertising and media insights specific to the fund management industry www.fundamentalmonitor.com

Fundamental Media is proud to be recognised by the London Stock Exchange as one of its ‘1000 Companies to Inspire Britain’.

This message may contain confidential, proprietary or legally privileged information and is intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not use, disseminate, copy it in any form or take any action in reliance on it. If you have received this message in error, please delete it and any copies of it and notify us immediately. This email is not a legally binding document, and therefore must not be interpreted as a booking, confirmation or any other form of commitment. Although we have taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments. Fundamental Media Limited is registered in England & Wales, with registered number 5001866, registered office at 31-41 Worship Street, London, EC2A 2DY. Telephone calls may be recorded. For information about how we process personal data please see our Privacy Policy on our website, www.fundamentalmedia.com.

From: google-doubleclick-...@googlegroups.com <google-doubleclick-...@googlegroups.com> On Behalf Of Chris Baclig
Sent: 14 July 2021 18:17
To: Google's Campaign Manager 360 API Forum <google-doubleclick-...@googlegroups.com>
Subject: Re: CM360 API returns error on some reports

 

Discovered the same issue this morning. It appears there was a new "Attribution Model" field added to the CM report builder form: 

 

--
You received this message because you are subscribed to the Google Groups "Google's Campaign Manager 360 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/c632b147-f34f-43a7-a275-a6f6a88e3884n%40googlegroups.com.

[DCM API (DoubleClick Campaign Mgr)]

Hi all,

 

Thank you for reporting this to us.

 

I have raised this issue to the rest of the team since we got a spike in query regarding this. But, could you please share the following in case we would need for further investigation?

• DCM Account ID
• Profile ID used in request inserting the report in question
• Report ID in question
• Request body along with URL of the report in question
• API Response in JSON Format of the report in question 

 

@Pavlo you may disregard the API response since you already shared it.

 

To Note: If "re-saving" the report you are currently working on or "adding the attribution model programatically and setting its value to 0" resolves the issue, please continue to do so while we wait for the result of the investigation.
 

params: {
                  filters: [
                    {type: "FILTER_ATTRIBUTION_MODEL", value: "0"},
                    {type: "FILTER_ADVERTISER", value: advertiserId},
                  ],

Regards,

Michael Angelo Legaspi DCM API Team

ref:_00D1U1174p._5004Q2Kc8Bv:ref

[Pavlo Vonorim]

Hello,

How can I apply

 params: {

                  filters: [

                    {type: "FILTER_ATTRIBUTION_MODEL", value: "0"},

                    {type: "FILTER_ADVERTISER", value: advertiserId},

                  ],

If my POST request don't have a body at all? I just use  https://dfareporting.googleapis.com/dfareporting/v3.5/userprofiles/{profileId}/reports/{reportId}/run with my profileId and reportId. Also I don't want to filter it by advertiserId , is this a required parameter also?

Can u provide proper CURL with "fake" data?

четверг, 15 июля 2021 г. в 09:44:21 UTC+3, dcmapi:

[Pavlo Vonorim]

Also, some of reports disappeared from my cabinet. How is it possible?

четверг, 15 июля 2021 г. в 10:25:42 UTC+3, Pavlo Vonorim:

[DCM API (DoubleClick Campaign Mgr)]

Hi Pavlo,

What do you mean by some of your reports disappeared from your cabinet? And also, the workaround was just a suggestion from another client, you may try the more simple step to just re-save the report builder from the CM UI side, but if any of those does not work for you, it would be best to wait for the official response from our team on how to resolve this issue.

On the other hand, what I am asking from you is the request you made from inserting the report ID you are trying to run and not the request body of where you are getting the error. We may need to check how your report was built, please share the following details:

• DCM Account ID
• Profile ID used in request inserting the report ID in question
• Report ID in question
• Request body along with URL of the report ID in question
• API Response in JSON Format of the report ID in question 

[Andrew Hunt]

Hi Michael,

 

Just as an aside here this seems to be an issue where an update  to your systems not requires that an attribution model is set on all DV360 reports. If you save them from the report builder this will automatically be added but all past saved reports will have been broken by this change.

 

For programmatically built reports you now need to add the FILTER_ATTRIBUTION_MODEL filter when building the report.

 

This seems to have been an unannounced change as there is nothing on the change log referencing it and unlike the change two weeks ago to require an Advertiser ID we did not get any communication through our usual partner channels.

 

Kind regards,

 

ANDREW HUNT​ HEAD OF SOFTWARE ENGINEERING

31‑41 Worship Street 2nd Floor London  EC2A 2DY United Kingdom andre...@fundamentalmedia.com www.fundamentalmedia.com

For digital advertising and media insights specific to the fund management industry www.fundamentalmonitor.com

Fundamental Media is proud to be recognised by the London Stock Exchange as one of its ‘1000 Companies to Inspire Britain’.

This message may contain confidential, proprietary or legally privileged information and is intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not use, disseminate, copy it in any form or take any action in reliance on it. If you have received this message in error, please delete it and any copies of it and notify us immediately. This email is not a legally binding document, and therefore must not be interpreted as a booking, confirmation or any other form of commitment. Although we have taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments. Fundamental Media Limited is registered in England & Wales, with registered number 5001866, registered office at 31-41 Worship Street, London, EC2A 2DY. Telephone calls may be recorded. For information about how we process personal data please see our Privacy Policy on our website, www.fundamentalmedia.com.

From: google-doubleclick-...@googlegroups.com <google-doubleclick-...@googlegroups.com> On Behalf Of DCM API (DoubleClick Campaign Mgr)
Sent: 15 July 2021 11:01
To: mupo...@gmail.com
Cc: google-doubleclick-...@googlegroups.com
Subject: Re: CM360 API returns error on some reports

 

Hi Pavlo,

Michael Angelo Legaspi DCM API Team

ref:_00D1U1174p._5004Q2Kc8Bv:ref

--
You received this message because you are subscribed to the Google Groups "Google's Campaign Manager 360 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/d9kzS000000000000000000000000000000000000000000000QWA6HC000y_J6SJ9TGmOaAvGV4uByg%40sfdc.net.

[DCM API (DoubleClick Campaign Mgr)]

Hi Andrew,

Thank you for proactively giving workaround regarding this issue. I have raised this to the rest of our team and the soonest they provide a result of their investigation, we will provide an update to all of you.

Regards,

Michael Angelo Legaspi DCM API Team

ref:_00D1U1174p._5004Q2Kc8Bv:ref

[DCM API (DoubleClick Campaign Mgr)]

Hi all,

 

Our team circled back on this and discovered that the issue started since 7/13 afternoon, and was fixed 7/15 morning via a roll back.

 

Feel free to get back to us if you still encounter the issue.

Regards,

Michael Angelo Legaspi DCM API Team

ref:_00D1U1174p._5004Q2Kc8Bv:ref