We have a report that is populated by different platforms (Salesforce, DB etc.) and now we are going to add Analytics data to that.
In our report for Spain, we use 'Province' values (Madrid, Barcelona, Málaga).
When I am getting data from Google Analytics, there are dimensions: Region and City but the problem is, values of Region are Autonomous Communities+Cities and values of City are Municipalities.
Is there any field/dimension I can use to group my data by Provinces?
There's no built-in dimension for that. All you can do is to build an almost 100% matching table using Google Ads geo targets table from here https://developers.google.com/adwords/api/docs/appendix/geotargeting the underlying table (consider checking for proper language version)