How to get TopOfPageCpc, FirstPageCpc?

[cv]

Hi,

I was trying to get TopOfPageCpc, FirstPageCpc using keywordsView, but I was not able to get any value.

SELECT campaign.id, "

. "ad_group.id, "

. "ad_group_criterion.criterion_id, "

. "ad_group_criterion.keyword.text, "

. "ad_group_criterion.keyword.match_type, "

. "ad_group_criterion.position_estimates.top_of_page_cpc_micros, "

. "ad_group_criterion.position_estimates.first_page_cpc_micros, "

. "ad_group_criterion.position_estimates.first_position_cpc_micros, "

. "ad_group_criterion.effective_cpc_bid_micros, "

. "ad_group_criterion.status, "

. "metrics.average_cpc, "

. "metrics.impressions, "

. "metrics.clicks, "

. "metrics.cost_micros, "

. "metrics.conversions, "

. "metrics.all_conversions "

. "FROM keyword_view "

. "WHERE segments.date DURING LAST_7_DAYS "

and was getting value like 

$googleAdsRow->getAdGroupCriterion()->getPositionEstimates()->getTopOfPageCpcMicrosUnwrapped()

$googleAdsRow->getAdGroupCriterion()->getPositionEstimates()->getFirstPageCpcMicrosUnwrapped()

What is the best way to get those data?

Thanks,

[Google Ads API Forum Advisor Prod]

Hi,

When you perform a FROM "keyword_view", only some fields are available. You can see which fields are available here: https://developers.google.com/google-ads/api/fields/v3/keyword_view. From what I understand, there is no workaround for that: you cannot access those fields in the UI for keyword_views either.

Thanks,
Sasha
The Google Ads API Team 

ref:_00D1U1174p._5004Q20WWka:ref

[cv]

Hello Sasha,

I can see that keyword_view can be used with ad_group_criterion

and ad_group_criterion has 

ad_group_criterion.position_estimates.top_of_page_cpc_micros

ad_group_criterion.position_estimates.first_page_cpc_micros

Does this cannot be used with keyword_view?

Also From what I understand, there is no workaround for that: you cannot access those fields in the UI for keyword_views either.

-> I can see that those fields can be there in UI

See attached screenshot.

Thanks,

[Google Ads API Forum Advisor Prod]

Hi,

Thanks for sharing that extra info. Could you please reply with the CID privately so that I can further debug?