---------- Forwarded message ---------
From: Xiaoyun Yang <[email protected]>
Date: Tue, Nov 6, 2018 at 2:58 PM
Subject: Data discrepancy between API and UI
To: <[email protected]>


Trying to get the search lost is (rank) from adgroup performance report;
But most of my ad groups, even high performance groups get undefined search
lost is while the UI shows actual numbers.

The query I am using is:

SELECT CampaignId, AdGroupId, Device, Date, AveragePosition, Impressions,
> SearchRankLostImpressionShare
> FROM ADGROUP_PERFORMANCE_REPORT
> WHERE CampaignStatus IN [ENABLED] AND AdGroupStatus IN [ENABLED]
> DURING 20180907, 20181105


but it returns:

       Campaign ID  Ad group ID               Device         Day  Avg.
> position  Impressions Search Lost IS (rank)
> 11211    868211030  42984184479  Mobile devices w...  2018-10-18
>   2.1           46                   --
> 14951    868211030  42984184479  Mobile devices w...  2018-10-27
>   2.3           46                   --
> 4036     868211030  42984184479  Mobile devices w...  2018-09-17
>   1.6           46                   --
> 11343    868211030  42984184479  Mobile devices w...  2018-10-20
>   1.9           45                   --
> 16476    868211030  42984184479  Mobile devices w...  2018-10-30
>   1.6           44                   --


while in the UI:

[image: Screenshot 2018-11-06 14.27.06.png]

What could be the problem? Thanks!
-- 
[image: PureCars] <http://purecars.com/>

Think Beyond the Click

Win the Customer with PureCars

www.PureCars.com <http://www.purecars.com/>


<http://www.purecars.com/>Google Premier Partner

Bing Elite SMB Partner
*Xiaoyun Yang*

Data Science Analyst

*Direct*
404-951-8991


*Email*
[email protected] <[email protected]>



-- 
[image: PureCars] <http://purecars.com/>

Think Beyond the Click

Win the Customer with PureCars

www.PureCars.com <http://www.purecars.com/>


<http://www.purecars.com/>Google Premier Partner

Bing Elite SMB Partner
*Xiaoyun Yang*

Data Science Analyst

*Direct*
404-951-8991


*Email*
[email protected] <[email protected]>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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].
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/CAK1oraK_%2BTRyWwFhBiHa7ebbiZtV1P%2B%3DEdB-na-sTxO8uuUYmg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to