LinkedIn Ads and LinkedIn Companies Grand Total Displayed Does Not Match the Sum of the Values in Some Charts

This article will assist with the following problem:

Grand Total lines in LinkedIn Ads and LinkedIn Companies reports do not match the sums of the values.

In LinkedIn reports in Looker Studio, some totals displayed do not appear to be accurate. In the following example, the Grand Total line reads "588" under Clicks, but the values only add up to 230. 

Cause

LinkedIn's API provides incomplete itemizations in order to protect its users' demographics. Therefore, the values displayed in the chart are estimates. The Grand Total is a separate field which is requested without the demographic dimensions and therefore is not subject to the same protections. The Grand Total is a precise and accurate value. It is not an estimate.

• Related Articles

• LinkedIn Ads Data Connector User Guide

  LinkedIn Ads is a powerful platform for B2B marketing, lead generation, brand awareness campaigns, and revenue attribution. This guide will help you connect your LinkedIn Ads account to Power My Analytics, enabling you to create comprehensive reports ...

• Looker Studio: Grand Total Over a Date Range is Less Than Sum of Individual Rows Broken Out By Date

  This page will assist you with the following issue: When reporting individual values by date in Looker Studio, the sum of these individual values over a date range may be less than the grand total of the values over the same date range. For example, ...

• X Ads Grand Total is Greater than the Sum of Values when Reporting by Country

  When using our X Ads connector to report data using geo dimensions (such as Country), you may notice that the grand total (summary row) for a metric shows a higher value than the sum of the report’s data values. This article will explain why this ...

• LinkedIn Companies Data Connector User Guide

  LinkedIn Companies is a powerful data source that provides valuable insights into your company's LinkedIn page performance. This guide will walk you through the process of setting up and using the LinkedIn Companies data source in Power My Analytics, ...

• LinkedIn Companies January 15, 2025 Deprecated Fields

  LinkedIn is deprecating several LinkedIn Companies fields in their API on January 15, 2025. This change will affect reports using these fields and requires action from users of the LinkedIn Companies data connector who currently utilize these fields ...