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 occurs and how reporting by Country can affect these values.

Issue

When reporting by a geo dimension such as Country, an X Ads report shows a grand total for a metric as:

• Greater than the sum of values in that report (in Looker Studio).
• Lower than the sum of values in that report as shown in the X Ads platform (using the Spreadsheets add-on).

Cause

Summary rows are a separate API call from the rest of the data in Looker Studio, but not in the Spreadsheets add-on. This discrepancy occurs due to the inclusion of geo dimensions (Country) in the report.

• Geo data is not available for all rows, and only rows with geo data will appear in reports using a geo dimension.
• However, the summary row (grand total) in Looker Studio is a total of all row values, whether they are associated with geo data or not.

In Looker Studio:

The summary row will display the true value of the total, accurate to the total as reported by the X Ads platform.

In Spreadsheets reports:

Not all rows will be included, only those associated with geo data. A simple sum of these rows will produce a value that is lower than the true value of the total.

This is an expected behavior, and can be resolved by removing the geo dimension (Country) from your X Ads report.

Additional Information

• X Ads Data Connector User Guide
  
• Basic Troubleshooting
  

If you need further assistance, please submit a ticket.

• Related Articles

• 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, ...

• 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 ...

• Looker Studio Summary Row Errors When Using Filters

  Issue When a Looker Studio query includes both a filter and a summary row, the summary row displays incorrect data or no data. Instead of showing totals, it may report the first result from the data source for each column. Cause This error occurs ...

• X Ads (Twitter) Data Connector User Guide

  X Ads (formerly Twitter Ads) is a powerful advertising platform that allows marketers to reach their target audience on one of the world's most popular social media networks. This guide will walk you through the process of connecting your X Ads ...

• 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 ...