Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.
SOLVED

Report Builder - how to run reports for a list of emails/IDs

Avatar

Level 2

Hi

I've put a list of emails or webIDs in the Excel sheet in Report Builder. How can you run Adobe reports around them? That is, the reports for all the visits from these emails/webIDs.

I'm not talking to create a classification in Adobe Analytics and then use it to create it a segment. I'm looking for a way that if I need reports for a group of visitors, I can just copy and paste their emails/webIDs to the Excel in Report Builder (in one column) and then run the report I need.

Thanks,

Yude

1 Accepted Solution

Avatar

Correct answer by
Level 4

Hi Yude,

Do you have email captured in an eVar or prop variable?

If yes then create your report builder data block. In Request Wizard: Step 1 of 2 choose the eVar or prop report that has the email addresses then click next. In Request Wizard: Step 2 of 2 find the eVar or prop either (likely in Row Labels) and click where it says "Top 1-10" then click "Filter" see screen shot below:

Then click on the "Specific" radio button below the "Most Popular" radio button on the left side of the window and choose your range of cells as I showed in my previous reply.

Best,

Ryan Praskievicz

@ryanpraski

www.ryanpraski.com

View solution in original post

4 Replies

Avatar

Level 4

Hi,

Say you've captured your visitor id or visitor email in eVar13. You can enter the visitor ids or emails you'd like to report on in a column in excel then you can select the cells using a filter and "From range of cells" then selected the range that the visitor ids or emails are located in your Excel sheet. See the screen shot below.

Best,

Ryan Praskievicz

@ryanpraski

www.ryanpraski.com

Avatar

Level 2

Ryan:

Thanks for getting back. Could you provide step by step details on how to get to the screen you showed me? I can't find anywhere to let me choose email or any related eVar.

I logged into Report Builder, copied and pasted my email list to Column A in the Excel, then clicked "Create" tab. When I clicked the "filter" button in "Request Wizard Step 1 of 2", it only let me choose Segment, Tags, Owners and Other Filters. In "Request Wizard Step 2 of 2", I had nothing under "Dimensions" tab, and if I chose "Pivot Layout" or "Custom Layout", basically I can change on date range. From where you can choose a eVar and then put a filter and "From range of cells"?

Thanks again.

Yude

Avatar

Correct answer by
Level 4

Hi Yude,

Do you have email captured in an eVar or prop variable?

If yes then create your report builder data block. In Request Wizard: Step 1 of 2 choose the eVar or prop report that has the email addresses then click next. In Request Wizard: Step 2 of 2 find the eVar or prop either (likely in Row Labels) and click where it says "Top 1-10" then click "Filter" see screen shot below:

Then click on the "Specific" radio button below the "Most Popular" radio button on the left side of the window and choose your range of cells as I showed in my previous reply.

Best,

Ryan Praskievicz

@ryanpraski

www.ryanpraski.com

Avatar

Level 2

Ryan:

Thanks, just made it work. I need to choose that eVar (email unhashed in my case) first in Step 1 from the Report list (that's why I was confused).

Also looked at your web site and it seems some interesting blogs there. I'll check them out later.

Thanks again for your help!

 

Yude