Analytics Canvas trumps the end of sampling

BI tool from Analytics Canvas finalises the untold truth about Universal Google Analytics reports: they should be unsampled.

After API configuration, you are more than welcome to connect Google Analytics, Google Search Console, Data Studio and other data sources together with pre-calculated fields or/and filters & segments.

To convert DataStudio filter into Analytics Canvas filter, check nested IF OR statements for multiple text conditions:

Excel syntax for nested IF OR statements:

=IF(OR(ISNUMBER(FIND({“fries”,”ribs”,”.wings.“,”.brownie.“},A3))),”not so healthy”,IF(ISNUMBER(FIND({“bananas”,”potato salad”},A3)),”healthy”,”very healthy”))

DataStudio Create field CASE with IF statement:

CASE

WHEN REGEX_MATCH(Lunches I ate,”.*fries.*”)

OR REGEX_MATCH(Lunches I ate,”.*wings.*”)

THEN”not so healthy”

WHEN REGEX_MATCH(Lunches I ate,”.*bananas.*)

OR REGEX_MATCH(Lunches I ate,”.potato salad.”)

THEN”healthy”

ELSE”very healthy”

END

Analytic Canvas IF OR statements:

IF(Regex([Lunches I ate],”.*fries.*|.*wings.*”),”not so healthy”,IF(Regex([Lunches I ate],”.*bananas.*|.*potato salad.*”),”healthy”,”very healthy”))

Happy analysing!