discrepancy between API and UI

[Xiaoyun Yang]

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:

What could be the problem? Thanks!

--

Think Beyond the Click Win the Customer with PureCars www.PureCars.com Google Premier Partner Bing Elite SMB Partner

Xiaoyun Yang Data Science Analyst Direct 404-951-8991 Email xiao...@purecars.com

[Michael Cloonan (AdWords API Team)]

Hello,

Can you include a screenshot that has more context, including column names and filters, to help us investigate? You can reply privately to me rather than post publicly by using the drop-down arrow at the top-right of my post.

Regards,

Mike, AdWords API Team

[Xiaoyun Yang]

I just sent a screenshot to you. Thanks very much for taking a look!

[Michael Cloonan (AdWords API Team)]

Hello,

Thanks for the screenshot! I am going to investigate and get in touch with the team in charge of this column to try to figure out why it's showing in the web interface but not in the API. I will let you know when I have any information to share.

Regards,

Mike, AdWords API Team

[Xiaoyun Yang]

That would be greatly appreciated. Thank you!

[Xiaoyun Yang]

Hello,

Just want to follow up to see what's the status for this issue -

Thanks

[Michael Cloonan (AdWords API Team)]

Hello,

I'm sorry for the slow response time here. I've reached out again to try to get a status update, and will let you know as soon as I find out anything.

Regards,

Mike, AdWords API Team

[Xiaoyun Yang]

ok. cool. Thanks you!

[Xiaoyun Yang]

Hey, just wanted to follow up. Is there any update on this issue?

[Michael Cloonan (AdWords API Team)]

Hello,

I apologize for the slow response again. The team seems to have identified the underlying issue but we're still working on exactly how we want to handle it. I will update here when I have more information to share.

Regards,

Mike, AdWords API Team