How to get the top row of a adobe workspace dashboard in report builder

Forum|Forum|2 years ago
June 28, 2023
3 replies
3714 views

I need to get the top row of my dashboard in excel using report builder. How to get it?
I am doing this for internal search term.
Please see the attached screen shot.

Analytics

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Jennifer_Dungan

Yes, @kumararajak beat me to it 🙂

When building Report Builder reports, you have to make multiple requests to pull out data at different levels... Totals, in order properly de-duplicate values, must be pulled as a separate item or items depending on if you need to make adjustments to individual columns.

My rule of thumb for Report Builder, is to pull the data into a hidden "Raw Data" sheet, then build out a pretty report in a separate sheet using Excel cell references to pull the data from the hidden sheet to the "pretty" report.

kumararajak

Level 5

In a simple way, create two data blocks in the report builder.

1. For Aggregate

2. Individual line items

Jennifer_Dungan

Accepted solution

Community Advisor and Adobe Champion

Yes, @kumararajak beat me to it 🙂

When building Report Builder reports, you have to make multiple requests to pull out data at different levels... Totals, in order properly de-duplicate values, must be pulled as a separate item or items depending on if you need to make adjustments to individual columns.

My rule of thumb for Report Builder, is to pull the data into a hidden "Raw Data" sheet, then build out a pretty report in a separate sheet using Excel cell references to pull the data from the hidden sheet to the "pretty" report.

H

harryk4Author

Level 2

Hi Jennifer,

I guess you have not seen the attachment i have added in the question.

I have 114863 rows for Internal Search Term(evar30) but i need to overall number in report builder which is highlighted in the blue box of attachment.

Thanks.

R

Rajeshwari

Community Advisor

Hello harry,

Follow the below steps in report builder

1. Once RB wizard expand the 'custom conversion' on left hand side

2. Select eVar30 which is 'internal Search term (eVar30)

3. go to Site metrics and select the metrics which you want to see i.e. event2, visits, order, revenue and revenue per search.

Hope this will help.

H

harryk4Author

Level 2

Hi Rajeshwari,

I guess you have not seen the attachment i have added in the question.

I have 114863 rows for Internal Search Term but i need to overall number in report builder which is highlighted in the blue box of attachment.

Thanks.

R

Rajeshwari

Community Advisor

In that case just add the date range along with the metrics highlighted instead of eVar30 dimension. Also solution provided above by Jenni will also work and you will get the aggregated numbers.