This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
1 Day Left! - The Alteryx Community will be temporarily unavailable for a few hours due to implementation of the new SSO experience starting tomorrow at 5pm MDT. Please plan accordingly. For more information, read the blog.
I've been going crazy trying to figure out how I can place filters on either a metric or dimension within the Google Analytics connector itself so when the API call is made to google analytics, it will only return what is specified in the request.
For example, I'm pulling Sessions by LandingPagePath by Date for a client. The connector outputs about 2500 different landing pages per day from this request. Doing this for months or years worth of data takes forever (even after creating this into an iterative macro) so how could I set the GA connector to pull either only landing pages where sessions > 1, or exclude 'checkout' landing pages?
I did find some documentation HERE that shows filters for dimensions and metrics but cant seem to get those to work. Returns an error saying "invalid dimension/metric" (ie.. ga:sessions>1 OR ga:landingPagePath!=checkout).
I'd rather not have to pull all data and filter after the connector, rather just filter within the API call. Has anyone been able to crack this?