After working with Google My Business support, we discovered that a common "internal error encountered" issue was due to how we we were handling duplicate locations. To address the error, we had to make a change that skips over duplicate locations so that the rest of the query can be processed.
A side-effect of this fix is that the three duplicate location-related dimensions are no longer functional, as we no longer handle duplicate locations. To note, we also discovered that the fields have been not functioning correctly even before this, often returning no data or (unknown) as a value.
Due to the change to need to skip duplicates, we will be deprecating officially these three dimensions:
- Duplicate location ID
- Duplicate place ID
- Duplicate location access
Please remove these fields from your reporting as they will no longer return values after March 10th, 2020.
We will also edit any BigQuery schemas that where using these to remove them as they won't provide any useful data going forward - additional notification about the schema change will come separately.