AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
1.4K members online now
1.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Max 255 Characters in a GDS Formula Field????

Follower ✭ ✭ ✭
# 1
Follower ✭ ✭ ✭

I've put in a multi stage CASE & REXEXP statement that has gone over 255 characters.

 

 

For example;

 

CASE WHEN REGEXP_MATCH ( field_expression , "" ) Then "Supplier 1" WHEN REGEXP_MATCH ( field_expression , "Something 2") Then "Supplier 2" WHEN REGEXP_MATCH ( field_expression , "Something 3") Then "Supplier 3" WHEN REGEXP_MATCH ( field_expression , "Something 4") Then "Supplier 4" Else "Other" END

 

This works great, however, when you go back in to edit the formula, Google Data Studio crops it down to this;

 

CASE WHEN REGEXP_MATCH ( field_expression , "" ) Then "Supplier 1" WHEN REGEXP_MATCH ( field_expression , "Something 2") Then "Supplier 2" WHEN REGEXP_MATCH ( field_expression , "Something 3") Then "Supplier 3" WHEN REGEXP_MATCH ( field_expression , "Some

 

(255 Characters)

 

This is probably why a lot of users experience formulas that did work but won't let them update the field - it's been cropped!

 

Is there a way to reduce the length of the formula, or can GDS not crop formulas over 255 characters?

Max 255 Characters in a GDS Formula Field????

Follower ✭ ✭ ✭
# 2
Follower ✭ ✭ ✭

The size limit for calculated fields has been increased to 2048 characters - latest release. Thank you google!

Re: Max 255 Characters in a GDS Formula Field????

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
My field need 3500 chars...