keyword_id Column of the KEYWORD_HISTORY Table Does Not Contain Any Value

Issue

The keyword_id column of the KEYWORD_PERFORMANCE_DAILY_REPORT and KEYWORD_PERFORMANCE_HOURLY_REPORT reports contain a keyword ID. However, the keyword ID does not appear in Microsoft Advertising and in the keyword_id column of the KEYWORD_HISTORY table.

Environment

Connector: Microsoft Advertising

Answer

This issue occurs if you have deleted the keyword from the KEYWORD_PERFORMANCE_DAILY_REPORT and KEYWORD_PERFORMANCE_HOURLY_REPORT reports. For more information, see Microsoft Advertising's community forum.

The metadata that we fetch using the Bulk API and populate in the _history column does not include the data for deleted entities. However, the reporting data that we fetch using the Reporting services contains the data for deleted entities.

We have added a new column, keyword_status, to the KEYWORD_PERFORMANCE_* tables. If you delete a record, the value in the keyword_status column for the deleted record is Deleted.