Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enhance Aggregated Report CSV with URL Column #850

Open
3 tasks
gagan0123 opened this issue Oct 11, 2024 · 2 comments · Fixed by #849
Open
3 tasks

Enhance Aggregated Report CSV with URL Column #850

gagan0123 opened this issue Oct 11, 2024 · 2 comments · Fixed by #849
Assignees
Milestone

Comments

@gagan0123
Copy link
Collaborator

gagan0123 commented Oct 11, 2024

Feature Request

Description:
Enhance the existing aggregated report.csv report generated by the PSAT CLI to include the URL for each row of cookie data.

Motivation:
Currently, the aggregated report.csv file provides a summary of cookie counts across all scanned URLs. However, it lacks the context of which URL each row of data corresponds to. This makes it difficult to analyze and compare cookie usage across different websites directly from the aggregated report.

User Story:
As a PSAT CLI user analyzing aggregated reports, I want to see the corresponding URL for each row of cookie data so that I can easily compare cookie usage across multiple websites within a single view.

Acceptance Criteria:

  • The downloaded aggregated report.csv file includes a "URL" column as the first column.
  • Each row in the report.csv file contains the URL of the website the cookie data belongs to.
  • The order of columns to be
    1. URL
    2. Total Cookies
    3. First Party
    4. Third Party
    5. Analytics
    6. Functional
    7. Marketing
    8. Uncategorized
    9. Cookies Issues
    10. Analytics Issues
    11. Functional Issues
    12. Marketing Issues
    13. Uncategorized Issues

Additional Information:
The current format of the aggregated .csv file is:

Total Cookies, 34
Total First Party Cookies, 32
Total Third Party Cookies, 2
...
Uncategorized Cookies with Issues, 8

The desired format after this feature implementation should be:

URL,Total Cookies,First Party,Third Party,Analytics,Functional,Marketing,Uncategorized,Cookies Issues,Analytics Issues,Functional Issues,Marketing Issues,Uncategorized Issues
"Aggregated",46,36,5,2,4,4,24,8,0,0,0,8
"https://example.com",34,32,2,2,4,4,24,8,0,0,0,8
"https://another-example.com",12,10,2,1,3,1,7,3,0,1,0,2 
...

This change will significantly improve the usability of the aggregated .csv report for analysis and comparison purposes.

@gagan0123
Copy link
Collaborator Author

@amovar18

Just summarizing the changes made to this feature request,

  1. Removed the repeated term "Cookies" from most column titles.
  2. Moved the Aggregated total of all columns for the entire list to the 2nd Row instead of being at the last row.

@gagan0123
Copy link
Collaborator Author

gagan0123 commented Nov 7, 2024

@amovar18

Have these changes been added to the develop branch?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: Release Ready
2 participants