Re: how to reproduce this ui report with the api?

[Chad Wood]

Awesome resource there. Thanks.

One more follow up question; when the review status of an ad is 
UNDER_APPEAL, what will the APPROVAL_STATUS be? Will it remain DISAPPROVED 
throughout the appeal process, or will it revert to UNKNOWN as it is 
throughout the primary review process? 

On Monday, June 19, 2023 at 9:56:35 AM UTC-7 Google Ads API Forum Advisor 
wrote:

> Hi Chad,
>
> Thank you for getting back to us.
>
> Kindly note that these statuses depend on the entity level (campaign, ad 
> group or ad group ad) you are using. Upon checking the illustration, it 
> appears that your understanding is correct. For your use case, I would 
> suggest retrieving the status in ad_group_ad level (
> https://developers.google.com/google-ads/api/fields/v14/ad_group_ad) 
> since you wanted to get the data for your ads. 
>
> Additionally, if it helps, you may check this guide (
> https://developers.google.com/google-ads/api/docs/reporting/uireports) 
> which maps the concepts and naming conventions for reports in the Google 
> Ads UI to the reports that you can generate using Google Ads Query Language 
> (GAQL) and the Google Ads API. 
>
> Please let us know if you have further questions.
> This message is in relation to case "ref:_00D1U1174p._5004Q2lwDrZ:ref"
>
> Thanks,
>   
> [image: Google Logo] Google Ads API Team 
>
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/bb3e9bbf-95d2-41f6-8d8a-61c77385a6abn%40googlegroups.com.

Re: how to reproduce this ui report with the api?

[Chad Wood]

Hey, Thanks to both Oliver and the Google Team for this.
I see the query you've provided shifts the role of filtration onto Google, 
likely reducing the amount of data significantly.
Nice solution there :)

One follow up question. I find myself confused by all the different 
statuses between ads, adgroups, and campaigns.
Here's what I'm working with:
ad_group_ad.policy_summary.approval_status 

ad_group_ad.policy_summary.review_status 

ad_group_ad.status 

ad_group.status 

campaign.primary_status 

campaign.serving_status 

campaign.status 


I can't seem to figure out how to use these statuses together, which 
statuses are needed and which aren't.
My team wants a report that provides the following information (daily):
# of new ads, 
# of ads under review, 
# of ads reviewed but not approved or disapproved yet,
# of ads approved but paused,
# of ads approved and serving,
# of ads ended,
# of ads disapproved, 
# of removed ads

I can handle tracking the data on my end in a database.
Can you help me decipher those statuses so that I can count the number of 
ads in each stage of the ad lifecycle?
On Tuesday, June 13, 2023 at 1:20:00 AM UTC-7 Google Ads API Forum Advisor 
wrote:

> Hello Chad,
>
> Thanks for getting back to us.
>
> Please note that the API and UI mimic each other’s behavior, if you are 
> unable to find the data in the UI, it would not be available in the API. As 
> Oliver said “The API does not give any historical metadata about statuses. 
> The only way to achieve what you want is exactly what you described in your 
> last message.” With regards to what you described in your previous message 
> on how you’d go about obtaining these data, please refer to this sample 
> GAQL query below.
>
>
> SELECT 
>   segments.date, 
>   ad_group_ad.ad.name, 
>   ad_group_ad.ad.id, 
>   metrics.impressions 
> FROM ad_group_ad 
> WHERE 
>   segments.date BETWEEN 'MMDD' AND 'MMDD' 
>   AND *metrics.impressions > 0 *
>
> The data queried would be segmented by each day and only showing data for 
> impressions that are more than 0.
>
> I hope this information helps you.
> This message is in relation to case "ref:_00D1U1174p._5004Q2lwDrZ:ref"
>
> Thanks,
>   
> [image: Google Logo] Google Ads API Team 
>
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/819a535f-4c6e-4710-a0b3-608907d91483n%40googlegroups.com.

Re: how to reproduce this ui report with the api?

[Oliver]

Hi Chad, I'm not from the API team but can contribute. The answer to your 2 
questions is 'No'.  The API does not give any historical meta data about 
statuses. The only way to achieve what you want is exactly what you 
described in your last message.

Oliver

On Wednesday, June 7, 2023 at 3:37:39 PM UTC+1 Chad Wood wrote:

> I guess I can give my use case. 
>
> We have tens of thousands of ads on your platform. Recently, several 
> hundred were taken offline.
> I want to do an analysis into these, but I can't find an elegant way to 
> isolate them programmatically.
>
> I guess one way would be to query for the number of impressions every ad 
> got on every single day we've had an account in Google Ads, then I can 
> filter those down  to only records where impressions is greater than 1, and 
> finally use the existence of a record as evidence that the ad was active on 
> any given day in the datasets index.
>
> That's a very heavy process though. I'll be working with tens of millions 
> of rows of data (a row per ad per day).
>
> On Wednesday, June 7, 2023 at 7:29:03 AM UTC-7 Chad Wood wrote:
>
>> Hi, I dont have a screenshot of the data in the UI. I'm just wondering if 
>> it's possible to utilize any metric / dimension for the purpose. Right now, 
>> I don't see any way to differentiate between ads that haven't been served 
>> in 10 years versus ads there were served 2 days ago.
>>
>> I checked, and it looks like the answer is no. 
>>
>> On Tuesday, June 6, 2023 at 1:56:42 PM UTC-7 Google Ads API Forum Advisor 
>> wrote:
>>
>>> Hi Chad, 
>>>
>>> Thanks for reaching out to the Google Ads API Team. I hope you are doing 
>>> well today.
>>>
>>> With regards to your 1st concern from your 1st email, thank you for 
>>> confirming that the issue has been resolved on your end. We highly 
>>> appreciate your shared information.
>>>
>>> Moving forward to your another email that concerns *“last serve date, 
>>> last impression date and historic ad states”, *could you please provide 
>>> us with Google Ads UI uncropped screenshot? For us to provide accurate 
>>> information and recommendations.
>>>
>>> *Please note that Google Ads API mirrors the Google Ads UI. Meaning by 
>>> using the Google Ads API, you can get and manage the data that you are 
>>> seeing in the UI.*
>>>
>>> On the other hand, if this is related to the same report type, you may 
>>> use the *ad_group_ad reporting* to check on you end the available 
>>> resources, fields, segments, and metrics (
>>> https://developers.google.com/google-ads/api/fields/v13/ad_group_ad_query_builder
>>> ).
>>>
>>> Have a great day.
>>>  
>>> This message is in relation to case "ref:_00D1U1174p._5004Q2lwDrZ:ref"
>>>
>>> Thanks,
>>>   
>>> [image: Google Logo] Google Ads API Team 
>>>
>>>
>>>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/b72c84e0-9bc9-4886-996c-a2905a9e55f5n%40googlegroups.com.

Re: how to reproduce this ui report with the api?

[Chad Wood]

I guess I can give my use case. 

We have tens of thousands of ads on your platform. Recently, several 
hundred were taken offline.
I want to do an analysis into these, but I can't find an elegant way to 
isolate them programmatically.

I guess one way would be to query for the number of impressions every ad 
got on every single day we've had an account in Google Ads, then I can 
filter those down  to only records where impressions is greater than 1, and 
finally use the existence of a record as evidence that the ad was active on 
any given day in the datasets index.

That's a very heavy process though. I'll be working with tens of millions 
of rows of data (a row per ad per day).

On Wednesday, June 7, 2023 at 7:29:03 AM UTC-7 Chad Wood wrote:

> Hi, I dont have a screenshot of the data in the UI. I'm just wondering if 
> it's possible to utilize any metric / dimension for the purpose. Right now, 
> I don't see any way to differentiate between ads that haven't been served 
> in 10 years versus ads there were served 2 days ago.
>
> I checked, and it looks like the answer is no. 
>
> On Tuesday, June 6, 2023 at 1:56:42 PM UTC-7 Google Ads API Forum Advisor 
> wrote:
>
>> Hi Chad, 
>>
>> Thanks for reaching out to the Google Ads API Team. I hope you are doing 
>> well today.
>>
>> With regards to your 1st concern from your 1st email, thank you for 
>> confirming that the issue has been resolved on your end. We highly 
>> appreciate your shared information.
>>
>> Moving forward to your another email that concerns *“last serve date, 
>> last impression date and historic ad states”, *could you please provide 
>> us with Google Ads UI uncropped screenshot? For us to provide accurate 
>> information and recommendations.
>>
>> *Please note that Google Ads API mirrors the Google Ads UI. Meaning by 
>> using the Google Ads API, you can get and manage the data that you are 
>> seeing in the UI.*
>>
>> On the other hand, if this is related to the same report type, you may 
>> use the *ad_group_ad reporting* to check on you end the available 
>> resources, fields, segments, and metrics (
>> https://developers.google.com/google-ads/api/fields/v13/ad_group_ad_query_builder
>> ).
>>
>> Have a great day.
>>  
>> This message is in relation to case "ref:_00D1U1174p._5004Q2lwDrZ:ref"
>>
>> Thanks,
>>   
>> [image: Google Logo] Google Ads API Team 
>>
>>
>>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/c77cf976-214a-47e9-9006-6741b797f2c0n%40googlegroups.com.

Re: how to reproduce this ui report with the api?

[Chad Wood]

Hi, I dont have a screenshot of the data in the UI. I'm just wondering if 
it's possible to utilize any metric / dimension for the purpose. Right now, 
I don't see any way to differentiate between ads that haven't been served 
in 10 years versus ads there were served 2 days ago.

I checked, and it looks like the answer is no. 

On Tuesday, June 6, 2023 at 1:56:42 PM UTC-7 Google Ads API Forum Advisor 
wrote:

> Hi Chad, 
>
> Thanks for reaching out to the Google Ads API Team. I hope you are doing 
> well today.
>
> With regards to your 1st concern from your 1st email, thank you for 
> confirming that the issue has been resolved on your end. We highly 
> appreciate your shared information.
>
> Moving forward to your another email that concerns *“last serve date, 
> last impression date and historic ad states”, *could you please provide 
> us with Google Ads UI uncropped screenshot? For us to provide accurate 
> information and recommendations.
>
> *Please note that Google Ads API mirrors the Google Ads UI. Meaning by 
> using the Google Ads API, you can get and manage the data that you are 
> seeing in the UI.*
>
> On the other hand, if this is related to the same report type, you may use 
> the *ad_group_ad reporting* to check on you end the available resources, 
> fields, segments, and metrics (
> https://developers.google.com/google-ads/api/fields/v13/ad_group_ad_query_builder
> ).
>
> Have a great day.
>  
> This message is in relation to case "ref:_00D1U1174p._5004Q2lwDrZ:ref"
>
> Thanks,
>   
> [image: Google Logo] Google Ads API Team 
>
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/2e6b280c-46b3-47b1-bf0a-dbf31ff6284dn%40googlegroups.com.

RE: how to reproduce this ui report with the api?

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hi Chad,

Thanks for reaching out to the Google Ads API Team. I hope you are doing well 
today.

With regards to your 1st concern from your 1st email, thank you for confirming 
that the issue has been resolved on your end. We highly appreciate your shared 
information.

Moving forward to your another email that concerns “last serve date, last 
impression date and historic ad states”, could you please provide us with 
Google Ads UI uncropped screenshot? For us to provide accurate information and 
recommendations.

Please note that Google Ads API mirrors the Google Ads UI. Meaning by using the 
Google Ads API, you can get and manage the data that you are seeing in the UI.

On the other hand, if this is related to the same report type, you may use the 
ad_group_ad reporting to check on you end the available resources, fields, 
segments, and metrics 
(https://developers.google.com/google-ads/api/fields/v13/ad_group_ad_query_builder).

Have a great day.

This message is in relation to case "ref:_00D1U1174p._5004Q2lwDrZ:ref"

Thanks,

Google Ads API Team

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/s1O250RVUNHY00OUo4vykmRHOpMbmq0XR16w%40sfdc.net.

Re: How to Reproduce This UI Report With The API?

[Chad Wood]

Hello, just following back up. I'll summarize my questions below:

1. Is there any way to figure out when an ad was last used?(*last serve 
date*, *last impression date*, *...*?)
2. Is there any way to check what previous states of an ad were, at a given 
time? (historic ad states?)

On Friday, June 2, 2023 at 1:54:06 PM UTC-7 Chad Wood wrote:

> Hello, I've made some progress since the last email. Feel free to 
> disregard it and I'll just update the thread.I've moved the questions still 
> in need of help to the bottom of this email.
> For reference, I was able to get the data I wanted with the following 
> query (extra stuff in here too):
>
> SELECT 
>   ad_group_ad.ad.id, 
>   ad_group_ad.ad.name, 
>   ad_group_ad.ad_group, 
>   ad_group_ad.status, 
>   ad_group_ad.policy_summary.review_status, 
>   ad_group_ad.policy_summary.approval_status, 
>   ad_group_ad.policy_summary.policy_topic_entries, 
>   ad_group.id, 
>   ad_group.name, 
>   ad_group.campaign, 
>   ad_group.status, 
>   campaign.id, 
>   campaign.name, 
>   campaign.status, 
>   campaign.serving_status, 
>   campaign.primary_status, 
>   campaign.primary_status_reasons 
> FROM ad_group_ad 
>
> One thing I didn't see that would be nice is something like "last served 
> date" or "last impression date" at the ad level, to get a sense for when 
> the ad was last used.
> Is there another way to figure out when an ad was last used?
>
> Also is there any way to check what previous states of an ad were, at a 
> given time? I'm interested in a time series analysis of statuses at the ad 
> level.
>
> Thanks!
>
> On Friday, June 2, 2023 at 9:41:47 AM UTC-7 Chad Wood wrote:
>
>> Hello, hope all is well
>>
>> I would like to reproduce the following report with the API (screenshot 
>> at bottom).
>> Disregarding the dates, how can I structure my query to receive the 
>> 0. `Ad ID`,
>> 1. `Approval Reasons`, 
>> 2. `Ad State`, and 
>> 3. `Ad Status` ?
>>
>> Second, is there any way to get the historic states/statuses/reasons of 
>> the ads? If an ad is removed today, can I see what its status was 
>> yesterday? Lastly, is there a maximum amount of time before I can no longer 
>> see historic states of ads?
>>
>> Thanks!
>>
>> [image: Report-editor-Google-Ads.png]
>>
>>
>>
>>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/3c64489d-093d-4f5e-bbff-592e01153134n%40googlegroups.com.

Re: How to Reproduce This UI Report With The API?

[Chad Wood]

Hello, I've made some progress since the last email. Feel free to disregard 
it and I'll just update the thread.I've moved the questions still in need 
of help to the bottom of this email.
For reference, I was able to get the data I wanted with the following query 
(extra stuff in here too):

SELECT 
  ad_group_ad.ad.id, 
  ad_group_ad.ad.name, 
  ad_group_ad.ad_group, 
  ad_group_ad.status, 
  ad_group_ad.policy_summary.review_status, 
  ad_group_ad.policy_summary.approval_status, 
  ad_group_ad.policy_summary.policy_topic_entries, 
  ad_group.id, 
  ad_group.name, 
  ad_group.campaign, 
  ad_group.status, 
  campaign.id, 
  campaign.name, 
  campaign.status, 
  campaign.serving_status, 
  campaign.primary_status, 
  campaign.primary_status_reasons 
FROM ad_group_ad 

One thing I didn't see that would be nice is something like "last served 
date" or "last impression date" at the ad level, to get a sense for when 
the ad was last used.
Is there another way to figure out when an ad was last used?

Also is there any way to check what previous states of an ad were, at a 
given time? I'm interested in a time series analysis of statuses at the ad 
level.

Thanks!

On Friday, June 2, 2023 at 9:41:47 AM UTC-7 Chad Wood wrote:

> Hello, hope all is well
>
> I would like to reproduce the following report with the API (screenshot at 
> bottom).
> Disregarding the dates, how can I structure my query to receive the 
> 0. `Ad ID`,
> 1. `Approval Reasons`, 
> 2. `Ad State`, and 
> 3. `Ad Status` ?
>
> Second, is there any way to get the historic states/statuses/reasons of 
> the ads? If an ad is removed today, can I see what its status was 
> yesterday? Lastly, is there a maximum amount of time before I can no longer 
> see historic states of ads?
>
> Thanks!
>
> [image: Report-editor-Google-Ads.png]
>
>
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/9196e6a3-bae9-4b40-869b-b05d17120e7an%40googlegroups.com.