GA4 - newVsReturning = 'returning' filed value not getting filteres

[Farsana]

Team,

I am filtering the data  from  GA4 in Load Editor for the field with value newVsReturning = 'returning', but its not working both in Load editor and in set expression. Can i get some input what changes need to implement for the filtration. Thanks in Advance!!!

Attached Load Editor and output screen for reference.

Note: i tried with new, returning but still not fixed

[igoralcantara]

I believe that is because of the preceding load. I know, this makes no sense. Try to add the where clause in the preceding load.

Before the ; add this:

Where newsVsReturning = 'returning'

[Farsana]

Hi @igoralcantara  ,I am getting error for where statment

 

The following error occurred:

(Connector error: Could not parse SELECT statement.)

[igoralcantara]

Please, paste your new code here for me to take a look.

[Farsana]

Hi @igoralcantara , please find the below screen shot,sql was generated using insert script after selecting the required field, all conditions are applied under properties, so in case if any changes/updated required please let me know your input, not sure how to apply the filtration using where

[igoralcantara]

Instead of the image, can you actually paste the code? It will be easier for me to edited and then you can use it.

[Farsana]

Hi @igoralcantara 

LOAD date as [RunReport.date], 

audienceResourceName as [RunReport.audienceResourceName], 

character as [RunReport.character], 

country as [RunReport.country], 

fullPageUrl as [RunReport.fullPageUrl], 

region as [RunReport.region], 

deviceCategory as [RunReport.deviceCategory], 

newVsReturning as [RunReport.newVsReturning];

SELECT date,

audienceResourceName,

character,

country,

fullPageUrl,

region,

deviceCategory,

newVsReturning

FROM RunReport

WHERE PROPERTIES (

propertyName='properties/315857996',

dimensions='date,audienceResourceName,character,country,fullPageUrl,region,deviceCategory,newVsReturning',

metrics='',

dateRange='7daysAgo,today',

newVsReturning = 'returning'

);

[igoralcantara · Accepted solution]

Try this. If it works, please mark this message as a Solution.

LOAD date as [RunReport.date],
audienceResourceName as [RunReport.audienceResourceName],
character as [RunReport.character],
country as [RunReport.country],
fullPageUrl as [RunReport.fullPageUrl],
region as [RunReport.region],
deviceCategory as [RunReport.deviceCategory],
newVsReturning as [RunReport.newVsReturning]
Where newVsReturning = 'returning'
;
SELECT date,
audienceResourceName,
character,
country,
fullPageUrl,
region,
deviceCategory,
newVsReturning
FROM RunReport
WHERE PROPERTIES (
propertyName='properties/315857996',
dimensions='date,audienceResourceName,character,country,fullPageUrl,region,deviceCategory,newVsReturning',
metrics='',
dateRange='7daysAgo,today',
newVsReturning = 'returning'
);

[Farsana]

Thank you soo much @igoralcantara