Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

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

Avatar

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

Avatar

Correct answer by
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

Avatar

Correct answer by
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...

Avatar

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?

Avatar

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.

Avatar

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?

Avatar

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?