Result Count Differs with Same Segments

[Harathi]

Hello,

I have two queries where the segments match, but they differ only in terms 
of metrics, and the result counts are different. I am attaching both 
queries. Please let me know if you need any additional information. 

Thanks,
Harathi




-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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+unsubscr...@googlegroups.com.
To view this discussion visit 
https://groups.google.com/d/msgid/adwords-api/85f4ca13-899f-4eca-ac1b-f0ad30ab2c78n%40googlegroups.com.

SELECT 
       campaign.id,
       campaign.name,
       ad_group.id,
       ad_group.name,
       campaign.advertising_channel_type,
       metrics.cost_micros,
       segments.date,
       segments.device
FROM
       ad_group
WHERE
       campaign.status IN('ENABLED','PAUSED') AND
       ad_group.status IN ('ENABLED', 'PAUSED') AND
       segments.device IN ('DESKTOP', 'MOBILE', 'TABLET', 'CONNECTED_TV', 
'OTHER') AND
       segments.date BETWEEN '2025-02-03' AND '2025-02-03'
SELECT                                                                
      ad_group.id,
      ad_group.name,
      ad_group.status,
      campaign.id,
      campaign.name,
      campaign.status,
      campaign.advertising_channel_type,
      metrics.clicks,
      metrics.impressions,
      metrics.cost_micros,
      metrics.video_views,
      metrics.video_quartile_p25_rate,
      metrics.video_quartile_p50_rate,
      metrics.video_quartile_p75_rate,
      metrics.video_quartile_p100_rate,
      segments.date,
      segments.device                                                           
        
FROM
      ad_group
WHERE
      campaign.status IN ('ENABLED', 'PAUSED') AND
      ad_group.status IN ('ENABLED', 'PAUSED') AND
      segments.device IN ('DESKTOP', 'MOBILE', 'TABLET', 'CONNECTED_TV', 
'OTHER') AND
      segments.date BETWEEN '2025-02-03' AND '2025-02-03'