Report Builder - how to run reports for a list of emails/IDs | Community
Skip to main content
Y
yudel68199236
New Participant
March 29, 2016
Solved

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

  • March 29, 2016
  • 4 replies
  • 1719 views

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

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 ryanpraski

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

4 replies

Y
yudel68199236Author
New Participant
March 31, 2016

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

ryanpraski
ryanpraskiAccepted solution
New Participant
March 31, 2016

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

Y
yudel68199236Author
New Participant
March 31, 2016

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

ryanpraski
ryanpraski
New Participant
March 30, 2016

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

Terms & ConditionsAccessibility statement

Loading footer...