Abnormal result of in report

[Adlogix]

When i am run the report , for example for csv report , I am creating
report query as below ,

ReportQuery reportQuery = new ReportQuery();
reportQuery.setStatement(filterStatement);
reportQuery.setDateRangeType(DateRangeType.CUSTOM_DATE);
reportQuery.setStartDate(lineItem.getStartDateTime().getDate());
reportQuery.setEndDate(lineItem.getEndDateTime().getDate());
reportQuery.setDimensions(new Dimension[] { Dimension.DATE });
reportQuery.setColumns(new Column[] { Column.AD_SERVER_IMPRESSIONS,
Column.AD_SERVER_CLICKS });

After ran the query I am getting the report which consist the below
text,

Date,Impressions,Clicks
Totals,0,0

I am still wondering how this Totals came and why Date is not there ?

Please appreciating if you can help me soon.

[DFP Advisor]

Hi Adlogix:

  The reports don't contain data rows when metrics aren't present for your dimension combinations. In your case you only specified date as a dimension and the date period you ran the report for did not have any metric values. Total rows show on some higher level reports such as these.

Thanks,

Paul, The DFP API Team

[Adlogix]

Hi Paul,

Thanks for your reply.

I am still in a concern that , I dont really have an idea of whats the
dimension and column in the report context. But my requirement is , i
need to create report like , I want total delivered impression or
clicks and its date for a given order ID. Can you please advice me
that how my report query should be .

Please help me out . Many thanks for you

Siva

[DFP Advisor]

HI Siva:

  You would want to add the ORDER_ID and ORDER_NAME dimensions to your report and it should give you the information you're requesting when there is serving data available for the date ranges you specify.

Thanks,

Paul, The DFP API Team

[Adlogix]

Hi Paul,

Cant we get the report in doubleclick Sandbox api environment?

Thanks
Siva

[DFP Advisor]

Hello Siva:

  The Reports are not available in the test networks. If you have an AdSense-Id approved you can go through the normal process to get a network and test your reports there. Also, if you're still using the sandbox environment I would encourage you to move over to our new test networks as described here. The sandbox environment will be shut off very shortly.

https://developers.google.com/doubleclick-publishers/docs/signup

Thanks,

Paul, The DFP API Team