ReportService get Unfilled impressions and fill rate on the line item level

[yotam abt]

Hi,

I'm trying to get a report on the API and I want to get unfilled impressions for the following dimensions:

                        'DATE',
                       'LINE_ITEM_ID' ,
                       'ORDER_ID' ,
                       'CREATIVE_ID' ,
                       'CREATIVE_TYPE' ,
                       'AD_UNIT_NAME',
                       'DEVICE_CATEGORY_NAME' ,
                       'SITE_NAME',
                       'PLACEMENT_NAME',
                       'MOBILE_INVENTORY_TYPE'

the only column that seems to relevant is  'TOTAL_INVENTORY_LEVEL_UNFILLED_IMPRESSIONS'

but i get the following error :

[ReportError.COLUMNS_NOT_SUPPORTED_FOR_REQUESTED_DIMENSIONS @ columns; trigger:'TOTAL_INVENTORY_LEVEL_UNFILLED_IMPRESSIONS']

the same goes for fill rate, 

TOTAL_FILL_RATE is the only column that seems relevant but it triggers the same error.

is there a way to achieve this?

thanks,

Yotam. 

[Ad Manager API Forum Advisor]

Hi Yotam,

 

Thanks for contacting the Ad Manager API support team, this is Yasmin.

 

I'd advise for you to try building the report via UI as it's easier to check for compatibility issues. You may check our Dimension and Column documentation to find the enum values that correspond to the UI when building the report via API.

 

Let me know how it goes and if you have any further questions.

 

Regards,

 

Yasmin Gabrielle Ad Manager API Team

ref:_00D1U1174p._5004Q2YpxMT:ref

[yotam abt]

Hi ,

Thanks for the response I somehow missed it, I don't see any option in the UI to have ORDER ID or LINE ITEM ID  as dimensions , is that possible in the UI?

[Ad Manager API Forum Advisor]

Hi Yotam,

 

Thanks for getting back to us.

 

Including the dimension Order or Line item indeed does not include their respective IDs (just the names), however, a link is included next to the name which redirects to the exact order or line item when clicked. Its ID, along with more details regarding the order or line item, are included.

 

Should you have any further questions, please don't hesitate to reach out to us.

 

Best regards,

[yotam abt]

thanks,  

so if I build the report in the UI and pull it using the API will I also get the Order/Line Item ID?

[yotam abt]

also,

I don't see in the report builder the option to include just line item name,

how might I do that?

[Ad Manager API Forum Advisor]

Hi Yotam,

 

To clarify, when you use the dimension Line item in the UI, the result automatically shows the line item's name as well as a link which redirects you to the line item itself. Furthermore, I can confirm that retrieving the report with an Order or Line item dimension from the UI via API automatically includes the order or the line item's name and ID.

 

Let me know if you have any further questions.

 

Regards,

 

Yasmin Gabrielle Ad Manager API Team

ref:_00D1U1174p._5004Q2YpxMT:ref