/datastudio/community?hl=en
This content is likely not relevant anymore. Try searching or browse recent questions.
-
9/17/19
Can you help create a custom dimension to group Google Ads campaigns? 1 Recommended Answer 7 Replies 0 Upvotes
1 Recommended Answer
$0 Recommended Answers
I'm trying to group Google Ads campaigns by location, to create a table which shows performance by location. However, when I use a custom dimension or custom field as the only dimension I get a broken table with "User Configuration Error". 

To get around this I add the "campaign" dimension and the table works. However, that's no good because I then have a table with 100's of rows.

What I want to create is a table with only the locations (custom field/dimension) which would be about 20 rows only.  

Here's a snippet of the formula I'm using:

CASE
WHEN REGEXP_MATCH(Campaign,".*(?i)(London).*") THEN "London"
WHEN REGEXP_MATCH(Campaign,".*(?i)(Birmingham).*") THEN "Birmingham"
WHEN REGEXP_MATCH(Campaign,".*(?i)(Manchester).*") THEN "Manchester"
ELSE "Other"
END
Any ideas?

Thank you
All Replies (7)
9/17/19
Hi Callum,

I believe the formula being used is incorrect. Please use the formula below:

CASE
WHEN REGEXP_MATCH(Campaign,".*(?i:London)") THEN "London"
WHEN REGEXP_MATCH(Campaign,".*(?i:Birmingham)") THEN "Birmingham"
WHEN REGEXP_MATCH(Campaign,".*(?i:Manchester)") THEN "Manchester"
ELSE "Other"
END

Note: The maximum number of WHEN conditions that can be applied is 200.

Regards,
Rishabh
marked this as an answer
Helpful?
-
9/19/19
Hi Rishabh, 

Both formula's work. However neither solves the problem I'm afraid. 

The problem is when I use the custom dimension (with either of the formula) it breaks my table, when I add "campaign" as an additional dimension the table works. However the table then includes every campaign but all I want to show in this table is a location (which combines data from all campaigns in that location, based on the custom dimension formula for locations).
marked this as an answer
Helpful?
9/19/19
I can look into it and help you. I would need sample data or access to your sheet. 

Regards,
Rishabh
https://www.linkedin.com/in/rishabhaimshigh/
marked this as an answer
Helpful?
12/9/19
Hi Rishabh & Callum,

Did you get a fix to this? - I've got exactly the same issue
marked this as an answer
Helpful?
12/9/19
Can you provide the CASE formula you are using as well as a screenshot of the table including the table options that appear on the right side of the screen?
marked this as an answer
Helpful?
1/9/20
Thanks Callum, that's worked for me!
marked this as an answer
Helpful?
This question is locked and replying has been disabled.
Discard post? You will lose what you have written so far.
Write a reply
10 characters required
Failed to attach file, click here to try again.
Discard post?
You will lose what you have written so far.
Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.
Create Reply
Edit Reply
Delete post?
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
Report abuse
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
Report post
Questions about a different Google product are no longer considered off-topic and should be moved to the relevant community.
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
This reply is no longer available.
/datastudio/threads
//accounts.google.com/ServiceLogin
You'll receive email notifications for new posts at
Unable to delete question.
Unable to update vote.
Unable to update subscription.
You have been unsubscribed
Deleted
Unable to delete reply.
Removed from Answers
Marked as Recommended Answer
Removed recommendation
Undo
Unable to update reply.
Unable to update vote.
Thank you. Your response was recorded.
Unable to undo vote.
Thank you. This reply will now display in the answers section.
Link copied
Locked
Unlocked
Unable to lock
Unable to unlock
Pinned
Unpinned
Unable to pin
Unable to unpin
Marked
Unmarked
Unable to mark
Reported as off topic
/datastudio/profile/0?hl=en