keyword_id Column of the
KEYWORD_HISTORY Table Does Not Contain Any Valuelink
Updated 13 days ago
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
Connector: Microsoft Advertising
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