Google Analytics Query - 120Feet Edition

0 ×

Options

User Metric Aggregation

The component by default returns data for each day in a data range ipacting user metric aggreagation. Tick if you woudl like to switch off and mirror standard GA behaviour (i.e with potential for sampling)

Dimensions

(Optional) %%00010The dimension data to be retrieved from the API. A single request islimited to a maximum of 7 dimensions.

Metrics

The metrics data to be retrieved from the API. Asingle request needs at least one metric and is limited to a maximumof 10 metrics.

Start Date

Select a Start Date. %%00010If passing a flow variable ensure it is called start_date.

End Date

Select an End Date. %%00010If passing a flow variable ensure it is called end_date

Custom Dimension Numbers

If Custom Dimensions selected enter the numbers, one per line

Custom Metric Numbers

If Custom Metrics selected then enter the numbers,one per line

Content Group Index

If Page Group or Landing Page Group is selected enter the numbers, one per line

Goal Index

If any goal index is selected enter the numbers, one per line

Segment

(Optional) %%00010Specifies a subset of visits based on either an expression or a filter. The subset of visits matched happens before dimensions andmetrics are calculated. You can either use the predefinedsegmentations or define your own (for details see Filters orthe Google Core Reporting API documentation).%%00010Note: segmentations that are defined without a scope (e.g."source=~twitter") are interpreted to be user conditions("users::condition::ga:source=~twitter"). %%00010%%00010Example: %%00010users::condition::ga:city==Konstanz

Filter

Optional) %%00010Specifies a subset of all data matched in analytics. Multiple filtersare separated by ,(OR operator) or ;(AND operator). \escapes the special characters , ;and \. %%00010%%00010Dimension operators: %%00010==Exact match %%00010!=Does not match %%00010=@Contains substring %%00010!@Does not contain substring %%00010=~Contains a match for the regular expression %%00010!~Does not match regular expression %%00010%%00010Metric operators: %%00010==Equals %%00010!=Does not equal %%00010>Greater than %%00010=Greater than or equal to %%00010<=Less than or equal to %%00010%%00010Example: %%00010country==Canada %%00010city=~^New.* Sort(Optional) %%00010The order and direction to retrieve the results. Can have multipledimensions and metrics. Prepending a dash will sort in descendingorder. %%00010%%00010Example: %%00010pageLoadTime %%00010-visits

Nodes

• Column Filter29 ×
• Cross Joiner25 ×
• Concatenate12 ×
• String Manipulation12 ×
• Pivoting10 ×
• Show all 42 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Google Cloud Storage Connection
• FeatureKNIME Google Connectors
• FeatureKNIME Javasnippet
• FeatureKNIME Math Expression (JEP)
• Show all 7 modules

Links

• No links available