Hi All,
I'm using the Ads API to pull performance data (e.g., impressions, clicks,
cost, etc.). When I retrieve the data using the keyword_view the
impressions and cost metrics in particular are greater than what is
returned using the search_term_view for the same time period. I've included
the query language and a portion of the data in the samples below. Any
insights would be appreciated. Thanks.
Scott
*Keyword View*
SELECT
campaign.name,
ad_group.name,
ad_group_criterion.keyword.text,
ad_group_criterion.keyword.match_type,
metrics.impressions,
metrics.clicks,
metrics.cost_micros,
metrics.conversions,
metrics.conversions_value,
ad_group_criterion.quality_info.quality_score,
ad_group_criterion.quality_info.search_predicted_ctr,
ad_group_criterion.quality_info.post_click_quality_score,
ad_group_criterion.quality_info.creative_quality_score
FROM keyword_view
WHERE
segments.date BETWEEN "{:s}" AND "{:s}"'''.format(start, end)
Campaign Ad Group Impressions Clicks Cost
Conversions
Search - Predictive Group 1 67 5 54.15
0.0
Search - Predictive Group 2 109 3 47.40
1.0
Search - Predictive Group 3 159 7 55.84
4.0
Search - Predictive Group 4 33 0 0.00
0.0
Search Term View
SELECT
search_term_view.search_term,
segments.keyword.info.text,
metrics.impressions,
metrics.clicks,
metrics.cost_micros,
metrics.conversions,
metrics.conversions_value,
campaign.name,
campaign.advertising_channel_type,
ad_group.name,
search_term_view.status
FROM search_term_view
WHERE
segments.date BETWEEN "{:s}" AND "{:s}"'''.format(first, last)
Campaign Ad Group Impressions Clicks Cost Conversions
Search - Predictive Group 1 19 2 30.68
0.0 0.0
Search - Predictive Group 2 40 1 24.78
0.0 0.0
Search - Predictive Group 3 75 6 47.73
2.0 200.0
Search - Predictive Group 4 11 0 0.00
0.0 0.0
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
"AdWords API and Google Ads 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/b0e259cd-6068-49e7-a4b1-74682b4975een%40googlegroups.com.
