Expand my Community achievements bar.

Join us for our next community Coffee Break on February 28th! Four of our Analytics Champions will be joining us to discuss Summit tips, best practices, and any of your Analytics questions!
SOLVED

Number of records shown in UI and fetch through REST API is different

Avatar

Level 1

We follow the below mentioned steps to get data using Omniture REST API:

  • First we get the Endopint using Company.GetEndpoint, method:

     Endpoint URL: https:\\api5.omniture.com\admin\1.4\rest\

  • We call Report.Queue, method using the following parameters
    • reportSuiteID
    • dateFrom
    • dateGranularity = “day”
    • min_granularity = 1
    • Matrix
      • visitors
      • pageviews
      • uniquevisitors
      • bouncerate
      • totaltimespent
      • visits
      • entries
      • exits
    • Elements
      • geocountry
      • page
  • After getting the ReportId, we call the method Report.Get
  • For this report suite id we get 10 rows from Omniture for date 07/14/2015, but when we login into Omniture Web UI, there are 20 records displays for that specific day.

Please let us know if we are missing anything or any further details.

1 Accepted Solution

Avatar

Correct answer by
Employee

The reason you are getting 10 results is that the when a breakdown is applied (as in your request breakdown for geocountry and page is applied), it returns Top 10 records. You can specify this limit and where to start with fetching the results in your request.

Please refer to the below page for more details on these configuration:

https://marketing.adobe.com/developer/documentation/analytics-reporting-1-4/r-reportdescriptioneleme...

View solution in original post

4 Replies

Avatar

Correct answer by
Employee

The reason you are getting 10 results is that the when a breakdown is applied (as in your request breakdown for geocountry and page is applied), it returns Top 10 records. You can specify this limit and where to start with fetching the results in your request.

Please refer to the below page for more details on these configuration:

https://marketing.adobe.com/developer/documentation/analytics-reporting-1-4/r-reportdescriptioneleme...

Avatar

Level 1

Hi Kaushalendra,

Thanks for the quick reply. I tried applying the top and startingWith but it is not returning more than 10 records, following is the parameter passed in Report.Queue method

reportDescription = new
                        {
                            reportSuiteID = reportSuiteId,
                            dateFrom = fromDate.Value.ToString("yyyy-MM-dd"),
                            dateTo = toDate.Value.ToString("yyyy-MM-dd"),
                            top = 50000,
                            dateGranularity = "day",
                            min_granularity = 1,
                            metrics = array of fields,
                            elements = array of fields,
                        }
                    };
                    request.AddBody(body);

Please let me know if I am missing anything.

Avatar

Employee

Would it be possible for you to provide me the full Request you are sending through and the response received?

Also, it seems that this query might need some of your account specific analysis and hence would suggest you to get in touch with ClientCare team by creating a ticket in name of any of the Supported Users for SiteCatalyst in your company.

 

~ Kaushal

Avatar

Level 1

Hi Kaushalendra,

Thanks for the response. Actually, I applied the top to elements and it works, before that I was applying top to report definition.

Regards,

Manoj