Why Do Some Metrics Contain null Values in the AD_ANALYTICS_BY_CREATIVE Table?

Question

Why do some metrics contain null values in the AD_ANALYTICS_BY_CREATIVE table?

Environment

Connector: LinkedIn Ad Analytics

Answer

The LinkedIn Ad Analytics API returns empty values for metrics when there's no activity or when access is restricted. As a result, a null value in the AD_ANALYTICS_BY_CREATIVE table means the metric had no recorded value and should be considered 0.

For more information, see the LinkedIn documentation on reporting restrictions.