Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Query dimension + date + minute in 1 API call

alv123456
Level 6
Level 6

I'd like to query a specific evar and get the hour and time for the metric. How do I do that? Do I need to apply breakdowns as discussed here: https://www.adobe.io/apis/experiencecloud/analytics/docs.html#!AdobeDocs/analytics-2.0-apis/master/r...

?

Second question: Is there a way to query server side timestamp of each call? (We do not send the timestamp in the tracking calls)

1 Accepted Solution
Asheesh_Pandey
Correct answer by
Community Advisor
Community Advisor

1.  Yes! please use something like this:

{

    "rsid": "your report suite id",

    "globalFilters": [

        {

            "type": "dateRange",

            "dateRange": "2019-02-01T00:00:00.000/2019-03-01T00:00:00.000"

        }

    ],

    "metricContainer": {

        "metrics": [

            {

                "columnId": "0",

                "id": "metrics/occurrences",  

                "filters": [

                    "0",

                    "1",

                    "2"

                ]

            }

        ],

        "metricFilters": [

            {

                "id": "0",

                "type": "breakdown",

                "dimension": "variables/evar15",

                "itemId": "3186428516"

            },

            {

                "id": "1",

                "type": "breakdown",

                "dimension": "variables/daterangeday",

                "itemId": "1190101"

            },

            {

                "id": "2",

                "type": "breakdown",

                "dimension": "variables/daterangehour",

                "itemId": "119010100"

            }

        ]

    },

    "dimension": "variables/daterangeminute",

    "settings": {

        "countRepeatInstances": true,

        "limit": 400,

        "page": 0,

        "dimensionSort": "asc"

    },

    "statistics": {

        "functions": [

            "col-max",

            "col-min"

        ]

    }

}

2. Workspace usage client browser time converted to time zone set in report suite. I don't think you can use server timestamp.

Thanks,

Asheesh

View solution in original post

3 Replies
Asheesh_Pandey
Correct answer by
Community Advisor
Community Advisor

1.  Yes! please use something like this:

{

    "rsid": "your report suite id",

    "globalFilters": [

        {

            "type": "dateRange",

            "dateRange": "2019-02-01T00:00:00.000/2019-03-01T00:00:00.000"

        }

    ],

    "metricContainer": {

        "metrics": [

            {

                "columnId": "0",

                "id": "metrics/occurrences",  

                "filters": [

                    "0",

                    "1",

                    "2"

                ]

            }

        ],

        "metricFilters": [

            {

                "id": "0",

                "type": "breakdown",

                "dimension": "variables/evar15",

                "itemId": "3186428516"

            },

            {

                "id": "1",

                "type": "breakdown",

                "dimension": "variables/daterangeday",

                "itemId": "1190101"

            },

            {

                "id": "2",

                "type": "breakdown",

                "dimension": "variables/daterangehour",

                "itemId": "119010100"

            }

        ]

    },

    "dimension": "variables/daterangeminute",

    "settings": {

        "countRepeatInstances": true,

        "limit": 400,

        "page": 0,

        "dimensionSort": "asc"

    },

    "statistics": {

        "functions": [

            "col-max",

            "col-min"

        ]

    }

}

2. Workspace usage client browser time converted to time zone set in report suite. I don't think you can use server timestamp.

Thanks,

Asheesh

View solution in original post

alv123456
Level 6
Level 6

Thank you, very useful.

How can I query the client browser time? (Even if we do not send it in the tracking calls?)

Asheesh_Pandey
Community Advisor
Community Advisor

In workspace you can get client browser time converted to your report suite time zone. i.e. ime variables day, month, minutes etc. to get time in any other tools in adobe you will need to implement plugin.