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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Omniture API 1.4 - Data Warehouse

webbrowsingdata
Level 1
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
webbrowsingdata
Correct answer by
Level 1
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

0 Replies
Gigazelle
Employee
Employee

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

webbrowsingdata
Correct answer by
Level 1
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

webbrowsingdata
Level 1
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.

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