Records Returned by the Facebook API Are Missing From the AD_IMAGE_HISTORY Table
Issue
Some ad image records are missing from the AD_IMAGE_HISTORY table. Querying the Facebook API directly using the corresponding image hashes through the /adimages?hashes=["hashID"] endpoint returns valid records.
Environment
Connector: Facebook Ads
Resolution
To troubleshoot this issue, check whether each missing image has a DELETED status in Facebook Ads. For instructions on viewing deleted items, see Delete an ad, ad set or campaign in Meta Ads Manager.
- If the images have a
DELETEDstatus, this is expected behavior and no action is required. - If the images have an
ACTIVEstatus, contact our support team with details of the missing images.
Cause
This issue occurs when an ad image has a DELETED status. The standard Facebook API requests we use to sync ad images return only images with an ACTIVE status. However, a direct API query using a specific image hash returns the corresponding record regardless of its status.