I am trying to recreate this view https://goo.gl/kf2224 which includes only the “Default Channel Groupings” (see screenshot)
I was unsure of what the “Default Channel Grouping” (which is the primary Dimension). Again, see screenshot for that).
I was unaware of the api inputs that would generate such a result and found this: https://support.google.com/analytics/answer/3297892?hl=en
I tried the following formula which should match that result (I think). (Note that the “ga:xxxxxxxx” will need to be changed to your own # to test).
=Dump(GoogleAnalytics(“ga:74784227”,“ga:sessions,ga:bounceRate,ga:pageviewsPerSession,ga:sessionDuration”,“2017-09-01”,“2017-11-30”,“ga:Medium”,“gaid::-1”,“ga:source==direct;ga:medium==(not set),ga:medium==(none),ga:medium==organic,ga:hasSocialSourceReferral==Yes,ga:medium=~^(social|social-network|social-media|sm|social network|social media)$,ga:medium==email,ga:medium==affiliate,ga:medium==referral,ga:mediu”&“m=~^(cpc|ppc|paidsearch)$;ga:adDistributionNetwork!=Content,ga:medium=~^(cpv|cpa|cpp|content-text)$,ga:medium=~^(display|cpm|banner)$,ga:adDistributionNetwork==Content”,"-ga:sessions",25,FALSE,FALSE,“DEFAULT”))
The above filter settings generate an empty result: (note that in the above filter components the AND options are designated by a semi-colon, and or is designated by a single comma)
If I change all “ANDs” to “Ors” (change the semicolons to commas) I get the following.
Can you please help me with the correct formula to generate the result with only
as in the actual google analytics screenshot with the items listed above?
Thanks very much!