Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'
);
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'
Please, paste your new code here for me to take a look.
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
Instead of the image, can you actually paste the code? It will be easier for me to edited and then you can use it.
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'
);
Thank you soo much @igoralcantara