Report Schedule and Advertiser Filter

[Eric Braden]

I have been using the DCM/DFA API to get data from reports that I have scheduled in the DDM reporting UI. It has been working wonderfully to pull down data for weekly reports.

Recently I have added new reports through the Report Builder that are specific to certain advertising clients.

I have noticed that if a client does not have data within the date range window it will not allow me to select this advertising client in the DDM reporting UI.

I need to be able to keep these on a weekly schedule, call the API and receive data (possibly null) from a specific advertiser whether they have data in that week or not. Since the UI does not currently allow me to select this advertiser, I cannot keep this on a schedule.

I have seen how you can request a list of dimension values and update the report parameters through the API, but it seems to be a lot of extra code for something so simple when the scheduler UI should be able to do this for me.

Any thoughts? Thanks!

-Eric

[Vu Chau (DCM API Team)]

Hi Eric,

Thanks for getting in touch. Let me explore the possibilities for your use case, and get back to you. In the meantime, let me know whether you'd prefer accomplishing it with the UI or the API.

Vu Chau

DCM API Team

[Eric Braden]

Vu,

Thanks for the quick reply! I would prefer to accomplish it with the UI.

Thanks again,
Eric

[Lakshmi(DCM API Team)]

Hi Eric,

I am picking up this thread from Vu. For UI related questions, I recommend contacting general support team. They will be able to shed some light on how to accomplish your use case in the UI.

Thanks,

Lakshmi, DCM API Team

[Eric Braden]

Hi Lakshmi,

Is the alternative to see if the advertiser is available by running a dimension value query with

StartDate, EndDate and DimensionName = "dfa:advertiser"

and then updating the report if that advertiser is available in the list?

Thanks,
Eric

[Lakshmi(DCM API Team)]

Hi Eric,

In the API you can create and schedule the reports by selecting dfa:advertiser as a dimension and as a dimension filter. Please check the following example for dimension filter:

"dimensionFilters": [

{

"kind": "dfareporting#dimensionValue",

"dimensionName": "dfa:advertiser",

"id": "123456",

If there is no data for that particular advertiser in a given date range then the report will be empty. 

You will find the Create and Update Reports helpful. This guide includes information about dimensions and dimension filters.

Please let me know if you have any further questions on this.

Thanks,

Lakshmi, DCM API Team