All reports have no data but UI shows data

[Erik Lilja]

Hello, we're trying to download data through the API for the client 5334532570(MCC 3271672853). 

The client claims there is data on the account and has provided screenshots showing both impressions and clicks.

I've tried multiple performance reports, but I can't see any data for the account. 

The query I've tried: 

SELECT Clicks, Cost

FROM ACCOUNT_PERFORMANCE_REPORT

DURING 20170101,20190509

Output:

Clicks,Cost
Total,0

[googleadsapi...@google.com]

Hi Erik,

Are you making the report request from the MCC or client account? Reports made from the MCC level will always return with no data.

Regards,

Anthony

Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

[Erik Lilja]

Hey Anthony,

I'm quite sure i'm making requests to the client account. Changing to the MCC ID and I get ReportDefinitionError.CUSTOMER_SERVING_TYPE_REPORT_MISMATCH.

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/3d49fe96-7d3e-4f79-a559-64fb74dcb61b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[googleadsapi...@google.com]

Hi Erik,

I was unable to replicate these results when I tried to run the report. Can you try running it again and let me know if you still see this behavior?

Thanks,

Anthony

Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/3ca75d7d-4e8b-4040-8915-2c043ce202a2%40googlegroups.com.

[Erik Lilja]

Hello,

(sorry if this was a double post)

I ran the query again and did not receive any data. Here's the curl request with censored access token and developer token.

curl -X 'POST' -H 'Accept: */*' -H 'Accept-Encoding: gzip, deflate' -H 'Authorization: Bearer *******' -H 'Connection: keep-alive' -H 'Content-Length: 105' -H 'Content-Type: application/x-www-form-urlencoded' -H 'User-Agent: python-requests/2.21.0' -H 'clientCustomerId: 5334532570' -H 'developerToken: *******' -H 'skipReportHeader: True' -d '__fmt=CSV&__rdquery=SELECT+Clicks%2C+Cost%0AFROM+CAMPAIGN_PERFORMANCE_REPORT%0ADURING+20170101%2C20190509' 'https://adwords.google.com/api/adwords/reportdownload/v201809'

On Friday, May 10, 2019 at 8:24:51 PM UTC+2, googleadsapi-forumadvisor wrote:

Hi Erik,

I was unable to replicate these results when I tried to run the report. Can you try running it again and let me know if you still see this behavior?

Thanks,

Anthony

Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

[googleadsapi...@google.com]

Hello Erik,

I took a look at the account: 5334532570 and found that the account has only 2 UAC campaign in it. Since UAC campaigns won't support CampaignPerformanceReport you are seeing zero values. You could only get the reports specified here for the UAC campaigns. Please give it a try and let me know if you are having any further questions.

Regards,
Sai Teja, Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:

http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/

[Erik Lilja]

Hello Sai,

Aren't you contradicting yourself from versus what's said in the API docs?

Since UAC campaigns won't support CampaignPerformanceReport you are seeing zero values

This is the first row in the Reporting section of the UAC campaigns.

Universal App campaign stats are available through Campaign Performance report

Is it supported or not?

I get the same results when I use the same query as the one in the API documentation, it's completely empty. I made the same query as that page suggested but changed the duration to include 2 years of data to make sure anything will be returned.

curl -X 'POST' -H 'Accept: */*' -H 'Accept-Encoding: gzip, deflate' -H 'Authorization: Bearer ******' -H 'Connection: keep-alive' -H 'Content-Length: 280' -H 'Content-Type: application/x-www-form-urlencoded' -H 'User-Agent: python-requests/2.21.0' -H 'clientCustomerId: 5334532570' -H 'developerToken: ****' -H 'skipReportHeader: True' -d '__fmt=CSV&__rdquery=%0Aselect+CampaignId%2C+CampaignName%2C+Clicks%2C%0A+++Impressions%2C+Cost+from+CAMPAIGN_PERFORMANCE_REPORT+where%0A+++AdvertisingChannelType+%3D+MULTI_CHANNEL+and%0A+++AdvertisingChannelSubType+%3D+UNIVERSAL_APP_CAMPAIGN+%0A+++%0ADURING+20170101%2C20190509%0A' 'https://adwords.google.com/api/adwords/reportdownload/v201809'

[googleadsapi...@google.com]

Hello Erik,

Apologies for the inconvenience. I ran the campaign performance report again, It resulted zero rows for me as well. I took a close look at your account and found that the 2 campaigns you have is of type "Mobile app engagement" which no longer supports via API. Back in 2017 itself AdWords API stopped supporting them and asked all the users to migrate to Universal App Campaigns going forward as per this blog post. So, as mentioned in the blog post if you want to manage or pull reports for those campaigns, create Universal APP campaigns and Once that Universal App campaign is online and serving, remove the mobile app install campaign. You could refer this guide to create Universal App Campaigns(code samples also available on that guide). Please let me know if you have any further questions.

Regards,
Sai Teja, Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

[Erik Lilja]

Hello Sai,

Thanks for your answer. 

Are "Mobile App Engagement" the same thing as "Mobile App Install Campaigns"? Could you please clarify what these two terms are and if they relate to each other?

[Google Ads API Forum Advisor Prod]

Hello Erik,

Mobile APP engagement campaigns also deprecated and no longer supported via API. Hence you can create universal APP campaigns only via API.  While coming to the Mobile APP installs, it is one of the UAC kind Ad which helps you to increase the APP installations for your APP by advertising your APP. You could refer here for more information on mobile APP install Ads

Regards,
Sai Teja, Google Ads API Team

ref:_00D1U1174p._5001UAqVhQ:ref

[Erik Lilja]

Hello Sai,

I'm afraid I'm still very confused. 

This blog post tells users to migrate from Mobile App Install campaigns to UAC. But the answers you've given me would indicate that Mobile App Engagement is the one that is deprecated and no longer supported from the API. 

Are these both deprecated?

[Google Ads API Forum Advisor Prod]

Hello Erik,

Both are deprecated and no longer supports from the API.