Query dimension + date + minute in 1 API call

alv123456 09-08-2019

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)

Mark Solution

Are these answers useful?
Help other community members by marking useful answers as accepted.

Accepted Solutions (0)

Answers (3)

Answers (3)

asheeshp
MVP
12-08-2019

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

asheeshp
MVP
13-08-2019

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.