DFP Reporting API

[Rafal]

I'm using the v201502 version of the DFP reporting API to generate daily reports.

I query with the following dimensions: 'AD_UNIT_ID', 'LINE_ITEM_ID', 'LINE_ITEM_NAME', 'CREATIVE_ID', the following columns: 'AD_SERVER_IMPRESSIONS','AD_SERVER_CLICKS','AD_SERVER_CPM_AND_CPC_REVENUE',

and with a HIERARCHICAL adUnitView.

The reports generated always only contained 2 ad unit levels: 

Ad Unit ID 1, Ad Unit ID 2 , ... , Ad unit 1, Ad unit 2, ... 

As of today, There are three ad unit levels in my report:

Ad Unit ID 1, Ad Unit ID 2 , Ad Unit ID 3 ... , Ad unit 1, Ad unit 2, Ad Unit ID 3, ... 

Is there any way to restrict the report to only two ad units without manually modifying it after it is generated?

This is how my CSV header looks:

Ad unit ID 1,Ad unit ID 2,Ad unit ID 3,Dimension.LINE_ITEM_ID,Dimension.LINE_ITEM_NAME,Dimension.CREATIVE_ID,Ad unit 1,Ad unit 2,Ad unit 3,Column.AD_SERVER_IMPRESSIONS,Column.AD_SERVER_CLICKS,Column.AD_SERVER_CTR,Column.AD_SERVER_CPM_AND_CPC_REVENUE

This is how I want it to look:

Ad unit ID 1,Ad unit ID 2,Dimension.LINE_ITEM_ID,Dimension.LINE_ITEM_NAME,Dimension.CREATIVE_ID,Ad unit 1,Ad unit 2,Column.AD_SERVER_IMPRESSIONS,Column.AD_SERVER_CLICKS,Column.AD_SERVER_CTR,Column.AD_SERVER_CPM_AND_CPC_REVENUE

thanks

[Tesfamichael Hailegeorgis]

Hi,

AdUnitView HIERARCHICAL displays as many ad unit columns as levels of ad units in the generated report. What you got here is in agreement. Currently, it looks like there is no way to restrict the report to the level you wanted. You will have to manually modify it after it is generated. Hope this helps.

Thanks,

Tesfamichael Hailegeorgis, DFP API Team

[Rafal]

Hi Tesfamichael, 

Thanks for the reply.

If HIERARCHICAL displays as many ad unit columns as levels of ad units in the report, what explains the sudden increase in ad unit columns? 

For the last 3 years, it has been only two columns. 

Moreover - so far the third column contains no data (for the last two days), so it appears that the third column is not necessary.

Is it possible that some configuration changes were made in DFP that would cause reports to generate three columns in stead of two?

If so, what kind of change would cause this issue? How can I search for this change using the API or the Web UI?

Thanks.

[Tesfamichael Hailegeorgis]

Hi,

Can you please send the SOAP logs and network code to dig into this a bit more?

Thanks,

Tesfamichael Hailegeorgis, DFP API Team

[Tesfamichael Hailegeorgis]

Hi Rafal,

Thanks for the response.

I could not reproduce this issue based on the request SOAP log you sent, I got the report for two levels, AD Unit ID 1 and Ad Unit ID 2 as you mentioned. AdUnitView HIERARCHICAL displays as many ad unit columns as levels of ad units in the generated report.  AdUnitView is specified through the API. There was an issue from our side causing an extra blank ad unit that's now fixed. Let me know if this issue exists.

Thanks,

Tesfamichael Hailegeorgis, DFP API Team

[Chris Johnson]

On this same subject, because the number of columns returned via the API differs by day, it become difficult to automate pulling of report into a database table without much post-processing.  Is there any way to specify the number of AD_UNIT_* columns to be returned?

[Tesfamichael Hailegeorgis]

Hi,

Please  send the request/response SOAP logs and network code. Alternatively, you can also send the report break down with the dimensions, columns and date range you were using. 

Thanks,

Tesfamichael Hailegeorgis, DFP API Team