Reports returning with a job status of FAILED (AD_EXCHANGE metrics & dimensions)

[Selene Solis]

I'm having an issue when I request a DFP reporting via googleads-php-lib/30.0.0. The issue started on Oct 09

[Selene Solis]

I don't know if this is related but pulling a report on DFP console I realized that the Invoiced impressions number for the last day that I was able to pull via API is the same as AD_EXCHANGE_IMPRESSIONS. I created this new thread because my issue was not related to this forum entry let me know if is the same Issue

[Donovan McMurray (DFP API Team)]

Hi, Selene.

Thanks for creating a new thread for this. Your report failed with an error saying your network does not have Ad Exchange features enabled. Because of that, when I go into the DFP UI to try generating this report on your network, there is no "Ad Exchange Historical" option at all, so this isn't just an API issue.

I will need to do some further investigation on your account to see why this is happening. I will respond back here once I figure it out.

Thanks,

Donovan McMurray, DFP API Team

[Selene Solis]

Donovan,

I would like to know why we were able to use the API before Oct 09, we implemented the DFP API on Sep 28. Per image attached you can see that the Historical checkbox is available on my account UI. Thank you in advance 

[Donovan McMurray (DFP API Team)]

Hi, Selene.

I am still looking into this for you. At this time, I don't know why your account has entered this state. Our expectation is that all accounts have been migrated, and thus Ad Exchange features should be enabled. 

Regarding your screenshot, "Historical" and "Ad Exchange Historical" are two distinct report types. Due to the state of your account, it is "Ad Exchange Historical" that's missing.

Thanks,

Donovan McMurray, DFP API Team

[Selene Solis]

Hello Donovan,

We used the same API call since we implemented DFP API, It did work until Oct 09 then it stopped working. 

Here is more background info we have another account that has an Ad Exchange historical report type this account is linked to 21861615 which has Dynamic allocation line Items where we have a Line item type AD_EXCHANGE on those line items we have a creative for each size. What we need to report is the earnings for each creative . For this reason we created an API filter LINE_ITEM_TYPE = AD_EXCHANGE and request as dimension Date, Creative, Creative name and Country these are combined with AD_EXCHANGE_AD_REQUESTS, AD_EXCHANGE_IMPRESSIONS, AD_EXCHANGE_CLICKS, AD_EXCHANGE_ESTIMATED_REVENUE.

This an example of what we need to generate via API this was pulled on the DFP UI account 21861615

Let me know if you have any question

On Wed, Oct 18, 2017 at 7:10 AM, <google-doubleclick...@googlegroups.com> wrote:

Hi, Selene.

Can you verify that you were using Ad Exchange Historical reports before Oct 9? From the UI, that involves selecting the radio button labelled "Ad Exchange Historical". From the API, that involves using dimensions/columns that start with AD_EXCHANGE_. 

I was under the impression that this type of report was working for you and then stopped, but it looks like your account wasn't ever linked to Ad Exchange, so this report type is unavailable to you.

Thanks,

Donovan McMurray, DFP API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 An important reminder: v201611 has been deprecated.

 Give us your feedback:
     Feedback Survey

 Also find us on our blog and discussion group:
     http://googleadsdeveloper.blogspot.com/search/label/dfp_api
     https://developers.google.com/doubleclick-publishers/community
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

--
You received this message because you are subscribed to the Google Groups "Google's DoubleClick for Publishers API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-doubleclick-for-publishers-api+unsubscribe@googlegroups.com.
To post to this group, send email to google-doubleclick-for-publishers...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-doubleclick-for-publishers-api.
For more options, visit https://groups.google.com/d/optout.

[Selene Solis]

Donovan,

Thank you! 

Is there a way that allow us to pull the report that we used prior to Oct 9? What I mean is can we have "Ad Exchange Historical" enabled? 

Column::AD_EXCHANGE_AD_REQUESTS

Column::AD_EXCHANGE_IMPRESSIONS

Column::AD_EXCHANGE_CLICKS

Column::AD_EXCHANGE_ESTIMATED_REVENUE

We follow the ADX -DFP migration mapping listed here adx_reporting_migration and we would like to have the ad_requests column on the report

On Thu, Oct 19, 2017 at 8:21 AM, <google-doubleclick...@googlegroups.com> wrote:

Hi, Selene.

Thanks for providing me with that additional information. I have recreated the report you generated from the UI with the following reportQuery:

      'reportQuery': {

          'dimensions': ['DATE', 'CREATIVE_NAME', 'CREATIVE_ID'],

          'columns': ['AD_EXCHANGE_LINE_ITEM_LEVEL_IMPRESSIONS', 'AD_EXCHANGE_LINE_ITEM_LEVEL_CLICKS', 'AD_EXCHANGE_LINE_ITEM_LEVEL_REVENUE'],

          'dateRangeType': 'CUSTOM_DATE',

          'startDate': {'year': 2017, 'month': 10, 'day': 16},

          'endDate': {'year': 2017, 'month': 10, 'day': 16}

      }

I have attached the API generated report for you to compare. 

Just to clarify the problem, your network cannot run "Ad Exchange Historical" reports. Some dimensions (but not all) that begin with "AD_EXCHANGE_" trigger a report to be of type "Ad Exchange Historical". Here is a list of the dimensions that trigger "Ad Exchange Historical" reports:

          Dimension.AD_EXCHANGE_AD_PRIMARY_VERTICAL_NAME_LOCAL,

          Dimension.AD_EXCHANGE_ADVERTISER_NAME,

          Dimension.AD_EXCHANGE_AD_FORMAT_NAME,

          Dimension.AD_EXCHANGE_AD_LOCATION,

          Dimension.AD_EXCHANGE_AD_SIZE_NAME,

          Dimension.AD_EXCHANGE_AGENCY,

          Dimension.AD_EXCHANGE_BID_RANGE,

          Dimension.AD_EXCHANGE_BID_RESULT,

          Dimension.AD_EXCHANGE_BID_TYPE,

          Dimension.AD_EXCHANGE_BRANDING_TYPE_LOCAL,

          Dimension.AD_EXCHANGE_BRAND_NAME,

          Dimension.AD_EXCHANGE_BUYER_NETWORK_NAME,

          Dimension.AD_EXCHANGE_CHANNEL_NAME,

          Dimension.AD_EXCHANGE_COUNTRY_NAME,

          Dimension.AD_EXCHANGE_CREATIVE_SIZES,

          Dimension.AD_EXCHANGE_DATE,

          Dimension.AD_EXCHANGE_DEAL_ID,

          Dimension.AD_EXCHANGE_DEAL_NAME,

          Dimension.AD_EXCHANGE_DEAL_TYPE,

          Dimension.AD_EXCHANGE_DFP_AD_UNIT_TOP_LEVEL,

          Dimension.AD_EXCHANGE_DFP_WATERFALL_TYPE,

          Dimension.AD_EXCHANGE_DSP_BUYER_NETWORK_NAME,

          Dimension.AD_EXCHANGE_EXPANSION_TYPE,

          Dimension.AD_EXCHANGE_GFP_INVENTORY_UNIT_NAME,

          Dimension.AD_EXCHANGE_GFP_PLACEMENT_NAME,

          Dimension.AD_EXCHANGE_INVENTORY_OWNERSHIP,

          Dimension.AD_EXCHANGE_INVENTORY_SETTINGS_RULE,

          Dimension.AD_EXCHANGE_LANDING_PAGE_DOMAIN,

          Dimension.AD_EXCHANGE_MOBILE_APP_NAME,

          Dimension.AD_EXCHANGE_MOBILE_CARRIER_NAME,

          Dimension.AD_EXCHANGE_MOBILE_DEVICE_NAME,

          Dimension.AD_EXCHANGE_MOBILE_INVENTORY_TYPE,

          Dimension.AD_EXCHANGE_MONTH,

          Dimension.AD_EXCHANGE_NETWORK_PARTNER_NAME,

          Dimension.AD_EXCHANGE_OPTIMIZATION_TYPE,

          Dimension.AD_EXCHANGE_OS_VERSION_NAME,

          Dimension.AD_EXCHANGE_PLATFORM_TYPE_NAME,

          Dimension.AD_EXCHANGE_PRICING_RULE_NAME,

          Dimension.AD_EXCHANGE_PRODUCT_NAME,

          Dimension.AD_EXCHANGE_REQUEST_SOURCES,

          Dimension.AD_EXCHANGE_SITE_NAME,

          Dimension.AD_EXCHANGE_TAG_NAME,

          Dimension.AD_EXCHANGE_TARGETING_TYPE_LOCAL,

          Dimension.AD_EXCHANGE_THIRD_PARTY_BUYER_ACCOUNT_NAME,

          Dimension.AD_EXCHANGE_THIRD_PARTY_NETWORK_TAG_CURRENCY,

          Dimension.AD_EXCHANGE_THIRD_PARTY_NETWORK_TAG_NAME,

          Dimension.AD_EXCHANGE_TRANSACTION_TYPE_NAME,

          Dimension.AD_EXCHANGE_URL_CHANNEL_NAME,

          Dimension.AD_EXCHANGE_USER_BANDWIDTH_NAME,

          Dimension.AD_EXCHANGE_VIDEO_AD_DURATION_RAW,

          Dimension.AD_EXCHANGE_VIDEO_AD_FORMAT,

          Dimension.AD_EXCHANGE_WEEK

This is not very well documented on our part, and we are actually working right now to improve our documentation on this. Keep an eye on our blog for an update.

However, I still do not understand how you could have successfully run the same query that generated the failed report with id=10047054788 prior to Oct 9, when your account should have never been able to run "Ad Exchange Historical" reports. If you need any other assistance in generating a reportQuery to run a report that you can run from the UI, let me know, and I'll be happy to help.

Thanks,

Donovan McMurray, DFP API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 An important reminder: v201611 has been deprecated.

 Give us your feedback:
     Feedback Survey

 Also find us on our blog and discussion group:
     http://googleadsdeveloper.blogspot.com/search/label/dfp_api
     https://developers.google.com/doubleclick-publishers/community
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

[Selene Solis]

Hi Donovan,

DFP SRAX AdX Monetization (142848461)

ADX account  pub-2911924646228087

On Thu, Oct 19, 2017 at 12:04 PM, <google-doubleclick...@googlegroups.com> wrote:

Hi, Selene.

Can you give me the network code of the account that is linked to 21861615?

Thanks,

Donovan McMurray, DFP API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 An important reminder: v201611 has been deprecated.

 Give us your feedback:
     Feedback Survey

 Also find us on our blog and discussion group:
     http://googleadsdeveloper.blogspot.com/search/label/dfp_api
     https://developers.google.com/doubleclick-publishers/community
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

[Selene Solis]

Hi Donovan,

In that account we don't have creative dimension (142848461), we also have ADX API implemented on our project however we need to know earnings generated by our tags basis setup (adx account) ad units and DFP Dynamic Allocation setup at the lowest level (creative). Something changed on our 21861615 account on Oct 10 I don't know who can help us to fix it

On Fri, Oct 20, 2017 at 7:34 AM, <google-doubleclick...@googlegroups.com> wrote:

Hi, Selene.

Thanks for those account numbers. I can't access logs older than a week, so I don't know the exact way in which you were able to successfully run an Ad Exchange Historical report prior to Oct 9. However, since I see that account 142848461 is in fact migrated from AdX, and therefore has the ability to run Ad Exchange Historical reports, is it possible that that's the account you used to run those reports? The account is set in the ~/adsapi_php.ini configuration file from the "Set up your client" step of our docs. If the networkCode value changed in this file, then the same script you were running would start using the other account.

Thanks,

Donovan McMurray, DFP API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 An important reminder: v201611 has been deprecated.

 Give us your feedback:
     Feedback Survey

 Also find us on our blog and discussion group:
     http://googleadsdeveloper.blogspot.com/search/label/dfp_api
     https://developers.google.com/doubleclick-publishers/community
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

[Selene Solis]

Hello Donovan,

Do you have any update regarding this issue?

Regards,

Selene

On Fri, Oct 20, 2017 at 1:28 PM, <google-doubleclick...@googlegroups.com> wrote:

Hi, Selene.

Thanks for your patience on this issue. I have reached out to a Product Manager for DFP to see if they know what could have happened to your account on Oct 10. I'll let you know as soon as we figure it out.

Thanks,

Donovan McMurray, DFP API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 An important reminder: v201611 has been deprecated.

 Give us your feedback:
     Feedback Survey

 Also find us on our blog and discussion group:
     http://googleadsdeveloper.blogspot.com/search/label/dfp_api
     https://developers.google.com/doubleclick-publishers/community
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

On 10/20/17 13:17:44 selene...@srax.com wrote:

Hi Donovan,

In that account we don't have creative dimension (142848461), we also have ADX API implemented on our project however we need to know earnings generated by our tags basis setup (adx account) ad units and DFP Dynamic Allocation setup at the lowest level (creative). Something changed on our 21861615 account on Oct 10 I don't know who can help us to fix it

[publ...@gmail.com]

Im experiencing the same issue. Status FAILED, only when trying to pull AD_EXCHANGE metrics.

Any clues about why this could be happening?

On Wednesday, November 1, 2017 at 2:46:27 PM UTC-3, Selene Solis wrote:

Hello Donovan,

Do you have any update regarding this issue?

Regards,

Selene

On Fri, Oct 20, 2017 at 1:28 PM, <google-doubleclick-for-publishers-api@googlegroups.com> wrote:

Hi, Selene.

Thanks for your patience on this issue. I have reached out to a Product Manager for DFP to see if they know what could have happened to your account on Oct 10. I'll let you know as soon as we figure it out.

Thanks,

Donovan McMurray, DFP API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 An important reminder: v201611 has been deprecated.

 Give us your feedback:
     Feedback Survey

 Also find us on our blog and discussion group:
     http://googleadsdeveloper.blogspot.com/search/label/dfp_api
     https://developers.google.com/doubleclick-publishers/community
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

On 10/20/17 13:17:44 selene...@srax.com wrote:

Hi Donovan,

In that account we don't have creative dimension (142848461), we also have ADX API implemented on our project however we need to know earnings generated by our tags basis setup (adx account) ad units and DFP Dynamic Allocation setup at the lowest level (creative). Something changed on our 21861615 account on Oct 10 I don't know who can help us to fix it

[admanagerapi...@google.com]

Hi,

Do you have an AdX account mapped to your Ad Manager account? This account would show up under Admin > Global Settings > Primary Ad Exchange account. If you have a mapped AdX account, you would also see "Ad Exchange historical" as a Report Type when creating a new report query in the UI. Having a mapped AdX account is required to run reports with AD_EXCHANGE dimensions.

If you do have a mapped AdX account and you're still experiencing trouble, could you send me your network code so I can take a look?

Thanks,

Donovan McMurray, Ad Manager API Team
______________________________________________________________________
 An important reminder: v201802 has been deprecated.

 Give us your feedback:
     Feedback Survey

 Also find us on our blog and discussion group:

     http://googleadsdeveloper.blogspot.com/search/label/ad_manager_api
     https://developers.google.com/ad-manager/api/community