Re: geographic_view doesn't return data when segments.geo_target_metro is empty

[Boris DETRY]

*I believe this is the correct behavior but it complicates our programs. *

Downloading multiple reports with/without segment and then merging these 
results could turn into an extremely heavy process.

For example: 
Imagine I have 4 millions search terms and only 1 million has keywords, to 
make one single collection of these two results and *avoiding duplicates* it 
requires a double loop (4M * 1M = 4,000,000,000,000 loops). 
We could also do multiple request to the API using NOT_IN clause in filter 
but API only allows 20k items in IN clauses, so we need to batch, and 
process to remove duplicated results of each batched results could be 
pretty heavy too. 

What other workaround we have? 

*Anyway, one cool solution would be if in the next version of the API you 
allow getting segmented results with segment = null.*


On Monday, October 18, 2021 at 10:50:05 PM UTC+2 adsapi wrote:

> Hi Mario,
>
> In addition to the data that you provided in your last post, can you 
> please privately provide us with your complete request and response logs?
>
>
> Thanks,
> Matt
> Google Ads API Team
>
> [image: Google Logo] 
> Matt 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q275Y42:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/cf8429d2-8c92-47f2-840f-4a931afeeeadn%40googlegroups.com.

Re: geographic_view doesn't return data when segments.geo_target_metro is empty

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

Hi Mario,

In addition to the data that you provided in your last post, can you please 
privately provide us with your complete request and response logs?

Thanks,
Matt
Google Ads API Team

Matt
Google Ads API Team
ref:_00D1U1174p._5004Q275Y42:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/n9f9C0R16XUJ00Mbap0jdLRnGyxDmpNMTq_A%40sfdc.net.

Re: geographic_view doesn't return data when segments.geo_target_metro is empty

[Mario Ochoa]

Hello Anthony, my problem is similar to the one mentioned in this thread. 

Using the AdWords API I'm able to get those records where the *city *has a 
blank/null/empty value (as shown in the file). But when using the Google 
Ads API I can't get records where *segment.city *is blank. What I want is 
to get those records where the city is blank using the Google Ads API to 
get the same information with both API and compare the results and evaluate 
if it is feasible to migrate from AdWords to Google Ads.

On Friday, October 15, 2021 at 11:04:25 AM UTC-5 adsapi wrote:

> Hi Mario,
>
> Can you please try specifying in your WHERE clause that the metro area 
> segment is not equal to a null value? Otherwise, you may try creating 
> multiple reports, using different segments in each report.
>
> Thanks,
> Matt
> Google Ads API Team
>
> [image: Google Logo] 
> Matt 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q275Y42:ref
>

-- 


*
CONFIDENTIALITY NOTICE:* This message and its contents are 
Confidential. If you received this message in error, do not use or rely 
upon it. Instead, please inform the sender and then delete it.

 

*AVISO 
DE CONFIDENCIALIDAD: *Este mensaje y su contenido son de uso Confidencial.  
Si usted ha recibido este mensaje por equivocación no lo use ni confíe en 
su contenido; asimismo, le pedimos notificar al remitente y borrar el 
mensaje.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/dae61b77-f773-43c5-8a1d-0c660832ce6bn%40googlegroups.com.


Missing Report Rows for Barrera Investments - 20211011 + 20211012.csv
Description: MS-Excel spreadsheet

Re: geographic_view doesn't return data when segments.geo_target_metro is empty

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

Hi Mario,

Can you please try specifying in your WHERE clause that the metro area segment 
is not equal to a null value? Otherwise, you may try creating multiple reports, 
using different segments in each report.

Thanks,
Matt
Google Ads API Team

Matt
Google Ads API Team
ref:_00D1U1174p._5004Q275Y42:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/pwEXk0R110MV00J_WEbSjHRg2rI5Hef387bg%40sfdc.net.

Re: geographic_view doesn't return data when segments.geo_target_metro is empty

[Mario Ochoa]

Is there any workaround to get those records where the segment (metro area) 
is null?

On Thursday, November 5, 2020 at 3:32:57 PM UTC-5 Google Ads API Forum 
Advisor Prod wrote:

> Hi Scott,
>
> There is a bit of a difference between the AdWords API and the Google Ads 
> API, but that is because some changes are being made over time to make way 
> for new features. When you segment on a value, segments will consider if 
> the metrics are null. With Google Ads API, if the metrics are null for that 
> value (such as a metro area), then we don't return that value. We don't 
> have any formulas that takes the total and minuses the other values to 
> create 'Other'. There is no 'Other' category since it is not possible with 
> how the data is stored. So, this is the main reason why the reports are 
> differing for you. 
>
>
> Regards,
> Anthony
> Google Ads API Team
>
> [image: Google Logo] 
> Anthony 
> Google Ads API Team 
>   
>
>  
>
> ref:_00D1U1174p._5004Q275Y42:ref
>

-- 


*
CONFIDENTIALITY NOTICE:* This message and its contents are 
Confidential. If you received this message in error, do not use or rely 
upon it. Instead, please inform the sender and then delete it.

 

*AVISO 
DE CONFIDENCIALIDAD: *Este mensaje y su contenido son de uso Confidencial.  
Si usted ha recibido este mensaje por equivocación no lo use ni confíe en 
su contenido; asimismo, le pedimos notificar al remitente y borrar el 
mensaje.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/afb3a028-f6b7-40dd-ac50-8bcd82fdbd43n%40googlegroups.com.

Re: geographic_view doesn't return data when segments.geo_target_metro is empty

[Google Ads API Forum Advisor Prod]

Hi Scott,

There is a bit of a difference between the AdWords API and the Google Ads API, 
but that is because some changes are being made over time to make way for new 
features. When you segment on a value, segments will consider if the metrics 
are null. With Google Ads API, if the metrics are null for that value (such as 
a metro area), then we don't return that value. We don't have any formulas that 
takes the total and minuses the other values to create 'Other'. There is no 
'Other' category since it is not possible with how the data is stored. So, this 
is the main reason why the reports are differing for you.

Regards,
Anthony
Google Ads API Team

Anthony
Google Ads API Team
ref:_00D1U1174p._5004Q275Y42:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/XAcMs0QJCBPX005O5Hiu64Q56zpa-VVx7fGQ%40sfdc.net.

Re: geographic_view doesn't return data when segments.geo_target_metro is empty

[Scott Vaillancourt]

I have this question as well. When I pull a report using the AdWords API 
for a campaign, all of the data returned includes occurrences where no 
metro area is attached. However, when I use the geographic_view in the new 
Ads API, no data is returned if the metro area is blank, causing the 
metrics to be underreported. If I use the campaign view then all of the 
metrics are accurate.

Scott

On Tuesday, November 3, 2020 at 5:27:58 AM UTC-6 e.bar...@gmail.com wrote:

> Hi,
> I was contacting with Google Ads Support and I've got the following reply:
>
> >>>
> Hi Ela,
> thanks for your E-Mail.
> I have double-checked with my Manager and I can't assist you with your 
> Inquiry. This is a Case for the API Team. Therefor I kindly ask you to 
> E-Mail googleadsa...@google.com, and they will happily help you with your 
> inquiry.
> In case you have any further questions, please do not hesitate to contact 
> me. Until then, I wish you a lovely day and stay safe.
>
> Sincerely,
> Jessica
> 
>
> I sent also the email to googleadsa...@google.com, but for now no 
> response. Please let me know, if you can somehow help me with this problem, 
> as it seems like nobody feels responsible for this area.
>
> Thank you!
>
> Regards,
> Ela
> On Friday, 30 October 2020 at 20:25:36 UTC+1 adsapiforumadvisor wrote:
>
>> Hi Ela,
>>
>> Since this behavior is not limited to the API, it doesn't appear to be 
>> API related. I would advise reaching out to the product team to see why 
>> this data is broken down this way. You can contact them though here 
>> .
>>
>>
>> Regards,
>> Anthony
>> Google Ads API Team
>>
>> [image: Google Logo] 
>> Anthony Madrigal 
>> Google Ads API Team 
>>
>>  
>>
>> ref:_00D1U1174p._5004Q275Y42:ref
>>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/33839de3-863b-4ad5-a766-0edc5a8faa67n%40googlegroups.com.

Re: geographic_view doesn't return data when segments.geo_target_metro is empty

[Elżbieta Jakubska]

Hi,
I was contacting with Google Ads Support and I've got the following reply:

>>>
Hi Ela,
thanks for your E-Mail.
I have double-checked with my Manager and I can't assist you with your 
Inquiry. This is a Case for the API Team. Therefor I kindly ask you to 
E-Mail googleadsapi-supp...@google.com, and they will happily help you with 
your inquiry.
In case you have any further questions, please do not hesitate to contact 
me. Until then, I wish you a lovely day and stay safe.

Sincerely,
Jessica


I sent also the email to googleadsapi-supp...@google.com, but for now no 
response. Please let me know, if you can somehow help me with this problem, 
as it seems like nobody feels responsible for this area.

Thank you!

Regards,
Ela
On Friday, 30 October 2020 at 20:25:36 UTC+1 adsapiforumadvisor wrote:

> Hi Ela,
>
> Since this behavior is not limited to the API, it doesn't appear to be API 
> related. I would advise reaching out to the product team to see why this 
> data is broken down this way. You can contact them though here 
> .
>
>
> Regards,
> Anthony
> Google Ads API Team
>
> [image: Google Logo] 
> Anthony Madrigal 
> Google Ads API Team 
>
>  
>
> ref:_00D1U1174p._5004Q275Y42:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/23e06ab6-5124-4404-bcf9-c4c2119f1f42n%40googlegroups.com.

Re: geographic_view doesn't return data when segments.geo_target_metro is empty

[Google Ads API Forum Advisor Prod]

Hi Ela,

Since this behavior is not limited to the API, it doesn't appear to be API 
related. I would advise reaching out to the product team to see why this data 
is broken down this way. You can contact them though here.

Regards,
Anthony
Google Ads API Team

Anthony Madrigal
Google Ads API Team
ref:_00D1U1174p._5004Q275Y42:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/cDEgj0QJ14LZ00Hm_3101oTUivQ6KckYVHuw%40sfdc.net.

Re: geographic_view doesn't return data when segments.geo_target_metro is empty

[Elżbieta Jakubska]

Hi,
I do not have permissions to reply to the author only.

I'm not an expert in your UI, but if I enter 
Reports->Custom->Table->Location
and I'm taking dimensions + metrics like:
(I'm looking on different customer than before)  
Country + Impressions => 1279 impressions 
Country + Regions + Impressions => 1244 impressions
Country + Regions + Cities + Impressions => 1082 impressions
When I select "Metro area" => I'm getting message "No statistics match your 
filters"

And I checked also requests via API and I'm getting exactly the same 
through API. 

I do not see a word about this behavior of geographic_view in the 
documentation, so I'm guess it is a bug. I guess it should be union, not 
intersection of results for all dimensions, like it was in old AdWords API.

>From AdWords API I'm getting 1279 impressions no matter what dimensions I'm 
requesting, and I understand this is the correct behavior.

Thank you for the reply and your help.

Best,
Ela
On Thursday, 29 October 2020 at 20:47:35 UTC+1 adsapiforumadvisor wrote:

> Hello,
>
> Do the numbers for these reports match what you see in the UI? What is 
> your CID? Please share these details through *reply privately to author *so 
> I can take a closer look.
>
> Regards,
> Anthony
> Google Ads API Team
>
> [image: Google Logo] 
> Anthony 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q275Y42:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/f89c56da-d698-455f-8c11-d9798796edc9n%40googlegroups.com.

RE: geographic_view doesn't return data when segments.geo_target_metro is empty

[Google Ads API Forum Advisor Prod]

Hello,

Do the numbers for these reports match what you see in the UI? What is your 
CID? Please share these details through reply privately to author so I can take 
a closer look.

Regards,
Anthony
Google Ads API Team

Anthony
Google Ads API Team
ref:_00D1U1174p._5004Q275Y42:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/Etnix0QIZAYL00OLf3MOT8QkmNkdL0ED6IEA%40sfdc.net.

Re: geographic_view doesn't return data when segments.geo_target_metro is empty

[Elżbieta Jakubska]

To illustrate the differences depending on dimensions:

1.when using the following set of dimensions:

geographic_view.country_criterion_id,
geographic_view.location_type,
campaign.id,campaign.name,
ad_group.id,ad_group.name,
customer.currency_code,customer.descriptive_name,
segments.device,
segments.date,segments.year,segments.day_of_week,segments.month,segments.quarter,segments.week,

I'm getting 2033 views - exactly the same number as from AdWords API
2. + segments.geo_target_region  => I'm getting 1840 views (missing rows 
are those with no geo_target_region)
3. +segments.geo_target_city => I'm getting 1732 views
4. +segments.geo_target_metro => I'm getting 1791 views

On Thursday, 29 October 2020 at 07:09:06 UTC+1 Elżbieta Jakubska wrote:

> Hi,
> I am trying to migrate geo targeting reports from AdWords API to Ads API. 
> I am doing the following query:
>
> my $query = q{ SELECT
> geographic_view.country_criterion_id,
> geographic_view.location_type,
> segments.geo_target_region,
> segments.geo_target_city,
> segments.geo_target_metro,
> campaign.id,campaign.name,
> ad_group.id,ad_group.name,
> customer.currency_code,
> customer.descriptive_name,
> segments.device,  
> segments.date,
> segments.year,
> segments.day_of_week,
> segments.month,
> segments.quarter,
> segments.week,
> metrics.clicks,
> metrics.cost_micros,
> metrics.impressions,
> metrics.conversions,
> metrics.conversions_value,
> metrics.all_conversions,
> metrics.all_conversions_value,
> metrics.interactions 
> FROM
> geographic_view
> WHERE segments.date BETWEEN 20201027 AND 20201027
> and campaign.id in (1234) 
> };
> I'm getting empty report. When I remove segments.geo_target_metro - I'm 
> getting the similar data as from AdWords API. I can see, that in data from 
> adwords API this dimension (geo_target_metro) is always empty for this case.
> Also I noticed, that I'm not getting rows for empty city, etc, so the 
> metrics numbers are a little different depending on dimensions.
>
> I'm using python libs in version 7.0. Am I doing something wrong?
>
> Thank you for your feedback,
>
> Regards,
> Ela
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/cf9ee1e3-65c5-4f67-9117-49dbe30acad2n%40googlegroups.com.

Re: geographic_view doesn't return data when segments.geo_target_metro is empty

[Elżbieta Jakubska]

To illustrate the differences depending on dimensions:

1.when using the following set of dimensions:

geographic_view.country_criterion_id,
geographic_view.location_type,
campaign.id,campaign.name,
ad_group.id,ad_group.name,
customer.currency_code,customer.descriptive_name,
segments.device,
segments.date,segments.year,segments.day_of_week,segments.month,segments.quarter,segments.week,

I'm getting 2033 views - exactly the same number as from AdWords API
2. + segments.geo_target_region  => I'm getting 1840 views (missing rows 
are those with no geo_target_region)
3. +segments.geo_target_city => I'm getting 1732 views
4. +segments.geo_target_metro => I'm getting 1791 views

On Thursday, 29 October 2020 at 10:49:52 UTC+1 Elżbieta Jakubska wrote:

> To illustrate the differences depending on dimensions:
>
> 1.when using the following set of dimensions:
> {code}
> geographic_view.country_criterion_id,
> geographic_view.location_type,
> campaign.id,campaign.name,
> ad_group.id,ad_group.name,
> customer.currency_code,customer.descriptive_name,
> segments.device,
>
> segments.date,segments.year,segments.day_of_week,segments.month,segments.quarter,segments.week,
> {code}
> I'm getting 2033 views - exactly the same number as from AdWords API
> 2. + segments.geo_target_region  => I'm getting 1840 views (missing rows 
> are those with no geo_target_region)
> 3. +segments.geo_target_city => I'm getting 1732 views
> 4. +segments.geo_target_metro => I'm getting 1791 views
> On Thursday, 29 October 2020 at 07:09:06 UTC+1 Elżbieta Jakubska wrote:
>
>> Hi,
>> I am trying to migrate geo targeting reports from AdWords API to Ads API. 
>> I am doing the following query:
>>
>> my $query = q{ SELECT
>> geographic_view.country_criterion_id,
>> geographic_view.location_type,
>> segments.geo_target_region,
>> segments.geo_target_city,
>> segments.geo_target_metro,
>> campaign.id,campaign.name,
>> ad_group.id,ad_group.name,
>> customer.currency_code,
>> customer.descriptive_name,
>> segments.device,  
>> segments.date,
>> segments.year,
>> segments.day_of_week,
>> segments.month,
>> segments.quarter,
>> segments.week,
>> metrics.clicks,
>> metrics.cost_micros,
>> metrics.impressions,
>> metrics.conversions,
>> metrics.conversions_value,
>> metrics.all_conversions,
>> metrics.all_conversions_value,
>> metrics.interactions 
>> FROM
>> geographic_view
>> WHERE segments.date BETWEEN 20201027 AND 20201027
>> and campaign.id in (1234) 
>> };
>> I'm getting empty report. When I remove segments.geo_target_metro - I'm 
>> getting the similar data as from AdWords API. I can see, that in data from 
>> adwords API this dimension (geo_target_metro) is always empty for this case.
>> Also I noticed, that I'm not getting rows for empty city, etc, so the 
>> metrics numbers are a little different depending on dimensions.
>>
>> I'm using python libs in version 7.0. Am I doing something wrong?
>>
>> Thank you for your feedback,
>>
>> Regards,
>> Ela
>>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/5f3ab718-c2ab-4027-8e0a-9ac89aa719adn%40googlegroups.com.

Re: geographic_view doesn't return data when segments.geo_target_metro is empty

[Elżbieta Jakubska]

To illustrate the differences depending on dimensions:

1.when using the following set of dimensions:
{code}
geographic_view.country_criterion_id,
geographic_view.location_type,
campaign.id,campaign.name,
ad_group.id,ad_group.name,
customer.currency_code,customer.descriptive_name,
segments.device,
segments.date,segments.year,segments.day_of_week,segments.month,segments.quarter,segments.week,
{code}
I'm getting 2033 views - exactly the same number as from AdWords API
2. + segments.geo_target_region  => I'm getting 1840 views (missing rows 
are those with no geo_target_region)
3. +segments.geo_target_city => I'm getting 1732 views
4. +segments.geo_target_metro => I'm getting 1791 views
On Thursday, 29 October 2020 at 07:09:06 UTC+1 Elżbieta Jakubska wrote:

> Hi,
> I am trying to migrate geo targeting reports from AdWords API to Ads API. 
> I am doing the following query:
>
> my $query = q{ SELECT
> geographic_view.country_criterion_id,
> geographic_view.location_type,
> segments.geo_target_region,
> segments.geo_target_city,
> segments.geo_target_metro,
> campaign.id,campaign.name,
> ad_group.id,ad_group.name,
> customer.currency_code,
> customer.descriptive_name,
> segments.device,  
> segments.date,
> segments.year,
> segments.day_of_week,
> segments.month,
> segments.quarter,
> segments.week,
> metrics.clicks,
> metrics.cost_micros,
> metrics.impressions,
> metrics.conversions,
> metrics.conversions_value,
> metrics.all_conversions,
> metrics.all_conversions_value,
> metrics.interactions 
> FROM
> geographic_view
> WHERE segments.date BETWEEN 20201027 AND 20201027
> and campaign.id in (1234) 
> };
> I'm getting empty report. When I remove segments.geo_target_metro - I'm 
> getting the similar data as from AdWords API. I can see, that in data from 
> adwords API this dimension (geo_target_metro) is always empty for this case.
> Also I noticed, that I'm not getting rows for empty city, etc, so the 
> metrics numbers are a little different depending on dimensions.
>
> I'm using python libs in version 7.0. Am I doing something wrong?
>
> Thank you for your feedback,
>
> Regards,
> Ela
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/e8fc3a05-fa44-4c5f-a5b8-9d015a980f47n%40googlegroups.com.