Google analytics filter capabilities

Is there a way to see google analytics campaign data filtered by Source or Medium? They are imported as two different data sets and I don't see a common key that I can join the two by.

Answers

  • GrantSmith
    GrantSmith Indiana 🥷

    You can pull a custom defined report in the connector setup with Google Analytics and select the fields you wish to pull in. You can select Source and Medium as two separate fields to include.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • DashboardDude
    DashboardDude Chicago 🟠

    Hi @Jim_C ,


    So you can pull in Source Medium from the GA connector as @GrantSmith mentions. Then if you use Advanced Filters, you can select any filter you want. Domo actually has a filter builder which is WAY COOLER than it used to be. I used to have to write in some gnarly JSON code, but now Domo will do that for you. Here's a video: https://www.loom.com/share/196acf511002496caa4dc3e5dfab862a

    This was that old JSON code I mentioned:

    {

        "dimensionFilterClauses": [

            {

                "filters": [

                    {

                        "dimensionName": "ga:sourceMedium",

                        "operator": "EXACT",

                        "expressions": [

                            "Thing you want to filter"

                        ]

                    }

                ]

            }

        ]

    }

    But honestly don't even both with this if you can use their filter builder instead.


    Good luck to you,

    John Le

    More video solutins at: https://www.dashboarddudes.com/pantry

  • You rock! thanks John.