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
BedrockMission!

Learn More

View all

Sign in to view all badges

Omniture API 1.4 - Data Warehouse

Avatar

Avatar
Validate 1
Level 1
webbrowsingdata
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
webbrowsingdata
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
webbrowsingdata
Level 1

08-02-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 1
webbrowsingdata
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
webbrowsingdata
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
webbrowsingdata
Level 1

19-02-2019

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"

    }

  }

}

Answers (2)

Answers (2)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

15-02-2019

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

Avatar

Avatar
Validate 1
Level 1
webbrowsingdata
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
webbrowsingdata
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
webbrowsingdata
Level 1

06-03-2019

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.