Query dimension + date + minute in 1 API call | Community
Skip to main content
alv123456
Level 5
Aug 9, 2019 11:24 AM UTC
Solved

Query dimension + date + minute in 1 API call

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/reporting-multiple-breakdowns.md​

?

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Asheesh_Pandey
    Asheesh_PandeyAccepted solution
    New Participant
    Aug 13, 2019 1:31 AM UTC

    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 reply

    3 replies

    Asheesh_Pandey
    Asheesh_Pandey
    New Participant
    Aug 13, 2019 12:08 PM UTC

    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.

    Translate
    alv123456Author
    Level 5
    Aug 13, 2019 6:58 AM UTC

    Thank you, very useful.

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

    Translate
    Asheesh_Pandey
    Asheesh_PandeyAccepted solution
    New Participant
    Aug 13, 2019 1:31 AM UTC

    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

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...