Google analytics filter capabilities

Jim_C
Jim_C Member
in Connectors

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 Coach

    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 Coach

    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

    Circle.png

    John Le

    Let me make you the me of your organization for Domo

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

  • Jim_C
    Jim_C Member

    You rock! thanks John.

Categories