How to get keyword status (eligible, eligible limited, Not Eligible, Paused, Removed) from the Google Ads API?

[ariful Islam]

Hello 
I am using the following query for keyword stats, it ok but I want to keyword status (eligible, eligible limited, Not Eligible, Paused, Removed).

   $query =
            "SELECT campaign.id, "
                . "campaign.name, "
                . "ad_group.id, "
                . "ad_group.name, "
                . "ad_group_criterion.criterion_id, "
                . "ad_group_criterion.keyword.text, "
                . "ad_group_criterion.keyword.match_type, "
                . "metrics.impressions, "
                . "metrics.clicks, "
                . "metrics.cost_micros "
            . "FROM keyword_view "
            . "WHERE segments.date DURING LAST_7_DAYS "
                . "AND campaign.advertising_channel_type = 'SEARCH' "
                . "AND ad_group.status = 'ENABLED' "
                . "AND ad_group_criterion.status IN ('ENABLED', 'PAUSED') "

I did R&D on how to get this status but didn't find any resource or query please help me with it.

Thank you 

[Google Ads API Forum Advisor]

Hi Ariful,

The UI's about keyword status has a list of status states.

'Not eligible' keyword status has to do with the campaign and adGroup status causing this keyword to not serve and there's no field in keyword_view that will combine this information into one. To get this information currently you can use the fields 'campaign.status', 'campaign.serving_status' and 'ad_group.status'.

'Eligible' and 'rarely served' seem to map to the UI's 'Eligible' and 'Eligible limited'.

'ad_group_criterion.status' will get if you paused or removed the keyword, mapping to 'Removed' and 'Paused' in the UI.

Feel free to get back to us.

Thanks,

Nirmita Google Ads API Team

ref:_00D1U1174p._5004Q2ghQ4a:ref

[ariful Islam]

Thank you for your replay.

I have tried your suggestion. the problem is  getting every status are ok  like ( campaign.status= ENABLED, campaign.serving_status=SERVING, ad_group.status= ENABLED) but keyword status is  'Not Eligible' due to  Low search volume.

 
Now I need to know the reason of the status to identify the status 'not eligible',eligible limited'. Status reason like  Low search volume ,Rarely shown (low Quality Score).

Please help me to get status reason in keyword_view query .

Thank you

[Google Ads API Forum Advisor]

Hi Ariful,

Thank you for getting back to us. I am Sherwin from Google Ads API. I work with Nirmita and I hope that you are doing well today.

Moving forward to your concern, I think what you are looking for is the campaign.primary_status and the campaign.primary_status_reasons. However, for us to be able to provide more accurate answers, would you mind if you provide us a full, non-cropped and non-redacted screenshot of the UI report where you are able to see the status reasons like "Low search volume"?

You can provide it via Reply privately to the author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Kind regards,

Sherwin Vincent Google Ads API Team

ref:_00D1U1174p._5004Q2ghQ4a:ref