Data Missing for Calculated (Classified) Fields for Google Search Console (GSC) in SM for Data Studio

I use calculated fields to classify URL/Path to managable buckets (Page Type, Segment, etc).  When these fields are used to filter results the GSC data only returns one week (or less) of data, while using the default Google GSC connector returns all.  I've tried using a blend as a dimension table to classify content with no success.


Has anyone encountered this and has a workaround.

Example of my classification rule:

Field Name: Page Type

CASE

 WHEN REGEXP_MATCH (Path, "((?i)/)") THEN 'Home Page'

    WHEN REGEXP_MATCH (Path, "((?i)/index.jsp)") THEN 'Home Page'

    WHEN REGEXP_MATCH (Path, "((?i)/category1/)") THEN 'Category1 Index Page'

    WHEN REGEXP_MATCH (Path, "((?i)/category2)") THEN 'Category2 Index Page'

    WHEN REGEXP_MATCH (LP, "((?i)/category3/)") THEN 'Category3 Index Page' 

    ELSE 'CONTENT' END



1 person has this problem
Login or Signup to post a comment