Find out how your primary marketing channels are performing.
For example, you could visualize visits from paid and non-paid traffic. Based on this example, your conditions are the paid channels in Google Analytics:
- Paid Search Affiliates
- Paid Social (custom).
Non-paid channels are the rest.
In the main menu, go to Resource > Manage added data sources > Edit > + Add a Field to make the dimension to be available throughout the dataset.
If you need the dimension only at the table or graph level, then click + Create New Field at the end of the Fields picker. Or, in the selected dimension area, click + Add dimension.
For the example of paid and non-paid ads, this can be written in at least two ways, with or without regular expressions:
CASE WHEN Default Channel Grouping in ('Paid Social','Paid Search','Display','Affiliates') THEN 'Paid' ELSE 'Not Paid' END OR CASE WHEN REGEXP_MATCH (Default Channel Grouping, '(Paid Social|Paid Search|Display|Affiliates)') THEN 'Paid' ELSE 'Not Paid' END