How to get the top row of a adobe workspace dashboard in report builder | Community
Skip to main content
harryk4
Level 2
Jun 28, 2023 4:06 PM UTC
Solved

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

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jennifer_Dungan
Jennifer_DunganAccepted solution
Level 2
Jun 28, 2023 5:15 PM UTC

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.

View reply

18 replies

harryk4Author
Level 2
Jul 4, 2023 7:46 AM UTC

Hi Everyone,

Thanks for your responses, I appreciate your time.

After lot of trials, discussions, I found the solution for this which is as below:

 

--Select the dimension(Internal search term(V30)) and date range on first screen of report builder.

--In the next window click on the top 1-10 link of the dimension.

 

 

--Select specific & Click on Add button

 

 

 

-- Add "- All elements -" from left side to right side and click on OK and run the query

 

 

-- Boom you will get only top row with all the desired metrics.

 

Regards,

Harish Kumat

Translate
    Rajeshwari
    New Participant
    Jun 29, 2023 9:28 AM UTC

    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.

    Translate
    harryk4Author
    Level 2
    Jun 29, 2023 9:41 AM UTC

    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.

    Translate
    Rajeshwari
    New Participant
    Jun 29, 2023 3:55 PM UTC

    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. 

    Translate
    kumararajak
    kumararajak
    Level 5
    Jun 28, 2023 4:24 PM UTC

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

     

    1. For Aggregate

    2. Individual line items

     

     

    Translate
      Jennifer_Dungan
      Jennifer_DunganAccepted solution
      Level 2
      Jun 28, 2023 5:15 PM UTC

      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.

      Translate
      harryk4Author
      Level 2
      Jun 29, 2023 9:41 AM UTC

      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.

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...