Why are the query conditions of the old and new interfaces consistent, but the results are different

[xmarcle]

Hi,

    I use Adwords API interface and Google ads API interface to query the advertising series report on the same date, but the results are inconsistent

Adwords API:

["awqlString":"Google\AdsApi\AdWords\Query\v201809\ReportQuery":private]=> string(334) "SELECT CampaignStatus, CampaignName, ServingStatus, Clicks, Impressions, InteractionRate, AverageCpc, Cost, AveragePosition, Conversions, ConversionRate, CostPerConversion, BounceRate, AveragePageviews, AverageTimeOnSite, Amount, CampaignId, AdvertisingChannelType, VideoViews FROM CAMPAIGN_PERFORMANCE_REPORT DURING 20220308,20220314"

There are six series in the results.(Consistent with the UI list of Google Advertising background advertising series)

-----------------------------------------------------------------------------------

Google Ads API:

Request:
{"customerId":"2560584800","query":"SELECT campaign.status, campaign.name, campaign.serving_status, metrics.clicks, metrics.impressions, metrics.interaction_rate, metrics.average_cpc, metrics.cost_micros, metrics.conversions, metrics.conversions_from_interactions_rate, metrics.cost_per_conversion, metrics.bounce_rate, metrics.average_page_views, metrics.average_time_on_site, campaign.id, campaign.advertising_channel_type, metrics.video_views, metrics.active_view_ctr, segments.date FROM keyword_view WHERE segments.date >= '20220308' AND segments.date <= '20220314' "}

There are four series in the results.(Only part of the content is the same as that in the UI list of background advertising series)

I don't know how to solve this problem, can you help me ?

[Google Ads API Forum Advisor]

Hi,

Thank you for raising your concern to my team.

Upon checking the details that you provided, I can see that the mapping of the 2 reports is incorrect and this is the reason why you encountered differences between those two. The CAMPAIGN_PERFORMANCE_REPORT will return the data at campaign level while the keyword_view will return the data at keyword level so there is a mismatch in data. With this, the report type that you can map to the CAMPAIGN_PERFORMANCE_REPORT is the campaign report.

I would also suggest referring to this document to know the equivalent AdWords API report types in Google Ads API. 

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2YlOT1:ref

[xmarcle]

Hi, 

     I think the query object I used is correct, because I use other customer IDs to query separately and get the same result. If KEYWORD_VIEW should not be used, which query object should I use.

[Google Ads API Forum Advisor]

Hi,

Thank you for raising your concern. I am also a member of the Google Ads API team and let me provide support to your concern.

I am afraid that even though you are using the same customer ID, the data will not be aligned to each other as you are comparing reports at different levels. With this, as mentioned by my colleague, you need to use the campaign to be compared with the CAMPAIGN_PERFORMANCE_REPORT.

Let me know if you have further questions.

Best regards,

Jinky Google Ads API Team

ref:_00D1U1174p._5004Q2YlOT1:ref

[Ngon Nguyen]

Chào mừng bạn đến với bảng nhớ tạm của Gboard, bất kỳ văn bản nào bạn sao chép sẽ được lưu tại đây.Sử dụng biểu tượng chỉnh sửa để ghim, thêm hoặc xóa đoạn.Nhấn vào một đoạn để dán vào hộp văn bản.Chạm và giữ một đoạn để ghim đoạn đó. Các đoạn đã bỏ ghim sẽ bị xóa sau 1 giờ.

Vào 15:14, Th 3, 15 thg 3, 2022 xmarcle <xmarc...@gmail.com> đã viết:

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/f76915b7-ed07-46e1-9958-6496c588650cn%40googlegroups.com.