Keyword Performance Report Approval Status

[xtcsuk]

Hello,

What I need is to download all the keywords with these fields (id, adgroupid, campaignid, approvalstatus) for a given campaign.  How would I go about it?

I tried it with these fields for a given date range and campaign, it returns no rows.  If a metric field is added to the field list then it does return n rows.  But I would like to get all the keywords with their approval status.

Thanks

[Anthony Madrigal]

Hi,

You can run a Keywords Performance Report and include the fields id, AdGroupId, CampaignId and ApprovalStatus. You will need to include a metric field, like you mentioned, to get back "n" rows. 

If you want to specify which campaigns to check, then you can use a predicate to indicate which campaigns to look at. 

Regards,

Anthony

AdWords API Team 

[xtcsuk]

Thanks for your response,

As you said, this is exactly what I did.  Including a metric field will only return the rows pertaining to that metric, so I then used the includeZeroImpression = true flag, this is what I want all the keywords with their ApprovalStatuses.  However, this flag includes duplicate entries (including null) for a given keyword.  So, based on the set of fields (id, AdgroupId, CampaignId and ApprovalStatus), one cannot tell which status is the latest, this is where I am struggling, may be I am on the wrong path in achieving this, so a bit of more help is appreciated.

thanks.

[Anthony Madrigal]

Hey,

You could include the field Date along with the other fields I mentioned so that you can see your statistics broken down by date. 

Cheers,

Anthony

AdWords API Team

[xtcsuk]

Thanks again, yup it seems to be behaving now.

Just one last thing, the literature explains 3 statuses for Keyword 'ApprovalStatus' column, I get null values for some, which is kind of puzzling, what could cause this, would you know?

thanks

[xtcsuk]

Right, the null entries are negative keywords, they do not have an approval status associated with.

thanks.

[Anthony Madrigal]

Hello,

Yes, negative keywords do not have a value for the ApprovalStatus.