Update:
adding ad_group_criterion.labels return the labelIds.
Thats a start. Instead of Id how can i get label values?
$query = 'SELECT
ad_group_criterion.criterion_id,
ad_group_criterion.keyword.text,
ad_group_criterion.labels,
ad_group.name,
ad_group.id,
campaign.name,
campaign.id,
metrics.impressions,
metrics.conversions,
metrics.cost_per_conversion,
ad_group_criterion.effective_cpc_bid_micros,
metrics.clicks,
metrics.ctr,
metrics.average_cpc
FROM keyword_view
Thanks
On Monday, February 7, 2022 at 12:57:19 PM UTC FMore wrote:
> Hi
>
> i am trying to get a keyword report that includes labels
> I am following this link with mappings:
>
>
> https://developers.google.com/google-ads/api/docs/migration/mapping#keywords_performance
>
> LabelIds == Select label.resource_name from the resource ad_group_label
> how can I combine these 2 resources in one query?
>
> Here is my GAQL that returns an error:
>
> SELECT
> ad_group_criterion.criterion_id,
> ad_group_criterion.keyword.text,
> ad_group_criterion.labels,
> *(Select label.name <http://label.name> from the resource
> ad_group_label),*
> ad_group.name,
> ad_group.id,
> campaign.name,
> label.id,
> label.name,
> campaign.id,
> metrics.impressions,
> metrics.conversions,
> metrics.cost_per_conversion,
> ad_group_criterion.effective_cpc_bid_micros,
> metrics.clicks,
> metrics.ctr,
> metrics.average_cpc
> FROM keyword_view
>
>
> Thanks
>
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/a581c597-1920-4927-9af5-747b976127e3n%40googlegroups.com.
