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
Solved! Go to Solution.
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"
}
}
}
Views
Replies
Total Likes
Are those custom dimensions eVars or props? Have you tried using their eVar/prop number instead of their friendly name?
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"
}
}
}
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Views
Replies
Total Likes