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

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.