Skip to main content
Solved

Advanced Custom Field Reporting

  • June 23, 2026
  • 1 reply
  • 25 views
delston
Forum|alt.badge.img+6

Hi All,

I am trying to extract a single value from the Custom Field JSON for use in Reporting, I have the following:

 

${vw_cases_custom_values.custom_field_json}

 

and want to extract only the field “Case Type”, I have tried various ways but no luck, does anybody have any pointers? 

 

Thanks, Daryll

Best answer by delston

Hi All, 

I managed to figure this out, I needed to Create a Custom Dimension that uses a Nested if statement as follows:

 

if(
  contains(${vw_cases_custom_values.custom_field_json}, "Insider Threat"), "Insider Threat",

if(
      contains(${vw_cases_custom_values.custom_field_json}, "Denial of Service") OR contains(${vw_cases_custom_values.custom_field_json}, "DDoS"), "DDoS / DoS",

 

And then repeat for all the possible values in the JSON

 


 

1 reply

delston
Forum|alt.badge.img+6
  • delstonBronze 2
  • Author
  • Bronze 2
  • Answer
  • June 24, 2026

Hi All, 

I managed to figure this out, I needed to Create a Custom Dimension that uses a Nested if statement as follows:

 

if(
  contains(${vw_cases_custom_values.custom_field_json}, "Insider Threat"), "Insider Threat",

if(
      contains(${vw_cases_custom_values.custom_field_json}, "Denial of Service") OR contains(${vw_cases_custom_values.custom_field_json}, "DDoS"), "DDoS / DoS",

 

And then repeat for all the possible values in the JSON

 


 

    Terms & ConditionsAccessibility statement
    Privacy Policy Terms of Service Gen AI Policy Community Guidelines Cookie Settings

    © 2025 Google. All rights reserved.