Post Are Missing From the UGC_POST_HISTORY and SHARE_STATISTIC Tables

Issue

The UGC_POST_HISTORY and SHARE_STATISTIC tables should contain data related to all posts and shares. However, some are missing.

Environment

Connector: LinkedIn Company Page

Resolution

To see all posts and shares and their corresponding metadata, include the SHARE_HISTORY table in your query or analysis along with the UGC_POST_HISTORY and SHARE_STATISTIC tables.

Cause

The UGC_POST_HISTORY table contains user-generated content data. However, it doesn't contain shared content data, which we sync to the SHARE_HISTORY table. Therefore, this issue occurs when you attempt to view all data relating to posts and shares by querying only the UGC_POST_HISTORY and SHARE_STATISTIC tables.