Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

How do I pull data on a CSV list of specific URL's from Adobe Analytics?

maddisonr
Level 2
Level 2

I have a CSV of specific URL's I need to pull usage data on in Adobe Analytics. How can I upload this CSV into Adobe Analytics? I know how to pull Page URL, but I need about 200 specific URL's and I shouldn't have to do that manually.

1 Accepted Solution
Urs_Boller
Correct answer by
Community Advisor
Community Advisor

make a classification "selected" on the URL, upload any value for the desired URL's (eg. "usageData").

example for the upload file:

-----

key      selected

URL1   usageData

URL2

URL3   usageData

-----

now you can create a segment for the classified value ("selected" equals "usageData") and run a DataWarehouse request...

View solution in original post

5 Replies
Urs_Boller
Correct answer by
Community Advisor
Community Advisor

make a classification "selected" on the URL, upload any value for the desired URL's (eg. "usageData").

example for the upload file:

-----

key      selected

URL1   usageData

URL2

URL3   usageData

-----

now you can create a segment for the classified value ("selected" equals "usageData") and run a DataWarehouse request...

View solution in original post

RMadd
Level 1
Level 1

I'm sorry, but this doesn't make sense. I have 250 URLs I need data on. And where is the CSV imported? Would you mind outlining this step by step from start to finish, please?

KristiB1
Level 4
Level 4

I agree with  ursboller creating a SAINT classification on the URL variable will allow you to run reports on the 250 specific URLS.  This makes perfect sense for the use case that you have described

If you are not familiar with SAINT Classifications, here is a good overview - Overview of Classifications in Adobe Analytics - YouTube

As ursboller said, the steps are (at a high level)

1. Create a new classification against your URL (Admin > Report Suite Manager > Edit Settings > Traffic > Traffic Classifications

2. Download the Saint template for the URL variable. You can also download the template with all URLs captured by Adobe so far. (Admin > Classification importer > Browser Export)

3. Use excel to Add a value (e.g. usageData" ) against the list of URLs you want to track and save the file.  (make sure the extension stays .tab)

4. Upload the file into Adobe Analytics (Admin > Classification importer > Import File)

You can then run a report using the classification.

rkverma
Level 1
Level 1
Would this method work if the URLs within a prop are NOT exact matches? For example, if a URL with in a prop contained query parameters at the end of the URL, would it still classify?
jantzen_belliston-Adobe
Level 10
Level 10
Do any of the answers below answer your initial question? If so, can you select one of them as the correct answer? If none of the answers already provided answer your question, can you provide additional information to better help the community solve your question?