Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Omniture API 1.4 - Data Warehouse

Avatar

Level 1

I am trying to generate a data warehouse report in adobe analytics using Omniture API 1.4  which will land on FTP server , in our data warehouse portal we have some custom data breakdowns and data metrics .  These are as follows :

Data Breakdowns:Customer ID (v24) (eVar24)                Custom

                               Page URL (v43) (eVar43)                     Custom

                               Mobile Device Type                             Standard

                               App or Web (v9) (SAINT)                     Custom

Data Metrics:        Product Impressions (e3)                    Custom

                              Searches (e1)                                         Custom

When I am using standard Metrics like Orders , Revenue i am able to get report , but when I am putting  above variable in JSON , I am getting an error that these variables are not present. The JSON which I am using is

{

   "reportDescription":{

      "reportSuiteID":"tescoukgroceriesprod",

      "dateFrom":"2018-11-30",

      "dateTo":"2018-12-01",

      "dateGranularity":"day",

      "metrics":[

         {

            "id":"Product Impressions"

         },

         {

            "id":"Searches "

         }

      ],

      "elements":[

         {

            "id":"Customer ID"

         },

         {

            "id":"Page URL"

         },

         {

            "id":"Mobile Device Type"

         },

         {

            "id":"App or Web"

         }

      ],

      "source":"warehouse",

      "ftp":{

         "host":"***********",

         "port":"**",

         "directory":"******",

         "username":"***********",

         "password":"************",

         "filename":"myReport.csv"

      }

   }

}

URL : https://api3.omniture.com/admin/1.4/rest/?method=Report.Queue

1 Accepted Solution

Avatar

Correct answer by
Level 1

Hi Gigazelle, Now out off all 4 breakdowns and 2 metrics, I am able to get 2 breakdowns and 2 metrics.The two which are left are as follows :

Data Breakdowns:  Mobile Device Type                          Standard                  

                                  App or Web (v9) (SAINT)                   Custom

when I am trying to get App or Web , which is a SAINT classification of "Site (v9)" , then the report output for this variable is different from the report when I use the portal to generate the report and Secondly I am not able to get the "Mobile Device Type"  breakdown which is a standard breakdown.

This is the below JSON I am using to generate Report

{

  "reportDescription": {

    "reportSuiteID": "tescoukgroceriesprod",

    "dateFrom": "2018-11-30",

    "dateTo": "2018-12-01",

    "dateGranularity": "day",

    "report_name": "Demo",

    "metrics": [

      {

        "id": "event1",

        "name": "Searches (e1)",

        "type": "number",

        "decimals": 0,

        "formula": null

      },

      {

        "id": "event3",

        "name": "Product Impressions (e3)",

        "type": "number",

        "decimals": 0,

        "formula": null

      }

    ],

    "elements": [

      {

        "id": "evar24",

        "name": "Customer ID (v24)",

        "correlation": false,

        "subrelation": true

      },

      {

        "id": "evar43",

        "name": "Page URL (v43)",

        "correlation": false,

        "subrelation": true

      },

      {

        "id": "evar9",

        "name": "Site (v9)",

        "classifications": [

          {

            "name": "App or Web (v9) (SAINT)"

          }

        ],

        "correlation": false,

        "subrelation": true

      }

    ],

    "source": "warehouse",

    "ftp": {

      "host": "**********",

      "port": "**",

      "directory": "**",

      "username": "******",

      "password": "********",

      "filename": "Report.csv"

    }

  }

}

View solution in original post

4 Replies

Avatar

Employee Advisor

Are those custom dimensions eVars or props? Have you tried using their eVar/prop number instead of their friendly name?

Avatar

Correct answer by
Level 1

Hi Gigazelle, Now out off all 4 breakdowns and 2 metrics, I am able to get 2 breakdowns and 2 metrics.The two which are left are as follows :

Data Breakdowns:  Mobile Device Type                          Standard                  

                                  App or Web (v9) (SAINT)                   Custom

when I am trying to get App or Web , which is a SAINT classification of "Site (v9)" , then the report output for this variable is different from the report when I use the portal to generate the report and Secondly I am not able to get the "Mobile Device Type"  breakdown which is a standard breakdown.

This is the below JSON I am using to generate Report

{

  "reportDescription": {

    "reportSuiteID": "tescoukgroceriesprod",

    "dateFrom": "2018-11-30",

    "dateTo": "2018-12-01",

    "dateGranularity": "day",

    "report_name": "Demo",

    "metrics": [

      {

        "id": "event1",

        "name": "Searches (e1)",

        "type": "number",

        "decimals": 0,

        "formula": null

      },

      {

        "id": "event3",

        "name": "Product Impressions (e3)",

        "type": "number",

        "decimals": 0,

        "formula": null

      }

    ],

    "elements": [

      {

        "id": "evar24",

        "name": "Customer ID (v24)",

        "correlation": false,

        "subrelation": true

      },

      {

        "id": "evar43",

        "name": "Page URL (v43)",

        "correlation": false,

        "subrelation": true

      },

      {

        "id": "evar9",

        "name": "Site (v9)",

        "classifications": [

          {

            "name": "App or Web (v9) (SAINT)"

          }

        ],

        "correlation": false,

        "subrelation": true

      }

    ],

    "source": "warehouse",

    "ftp": {

      "host": "**********",

      "port": "**",

      "directory": "**",

      "username": "******",

      "password": "********",

      "filename": "Report.csv"

    }

  }

}

Avatar

Level 1

Hi Gigazelle, I just used the https://api.omniture.com/admin/1.4/rest/?method=ReportSuite.GetClassifications and found out this [     {         "rsid": "tescoukgroceriesprod",         "site_title": "TescoUKGroceries",         "element_classifications": [             {                 "id": "evar9",                 "name": "Site (v9)",                 "classifications": [                     {                         "name": "Platforms (v9) (SAINT)",                         "description": "",                         "type": "text",                         "date_enabled": false                     },                     {                         "name": "Platform Type (v9) (SAINT)",                         "description": "",                         "type": "text",                         "date_enabled": false                     },                     {                         "name": "App or Web (v9) (SAINT)",                         "description": "",                         "type": "text",                         "date_enabled": false                     }                 ]             }         ]     } ] Now can you help me how to make a request to get "App or Web (v9) (SAINT)" variable in warehouse report.

Avatar

Level 1
@webbrowsingdata - did you get a solution to use classified variable as a breakdown via dwh api 1.4?