Reporting Process

Requesting

If you have a data question about login.gov data, refer to the Report Request Process Standard Operating Procedure (SOP). Make sure to complete the Report Request Form and include all the required information.

Once that occurs, someone from the Data Analytics team will acknowledge your request and follow the process outlined in the Report Request Process Standard Operating Procedure (SOP).

Examples

• Example data request
• Example data request (data)

Process

When pulling data for a query, follow this process to help us log requests, and track how we answered them so we can build on them in the future.

1. Create a Google Doc in the Data Request Google Drive folder. Optionally, upload supporting data as a spreadsheet in addition to the Google Doc with the same JIRA ticket in the name. Make sure to link to the spreadsheet from the document.

   Use this format for naming the documents:

   • LG-1234: Agency XYZ password resets for the document
   • LG-1234: Agency XYZ password resets (data) for the spreadsheet

2. Make sure to include key information in this document:

   • The JIRA ticket in the title
   • Brief summary of the request
   • Brief summary of the result
   • Any queries (Cloudwatch queries, SQL queries) and any code snippets used to process those results

Example Document Template

LG-1234: Agency XYZ password resets

Request

What is the password reset rate at agency XYZ?

Result

A quick summary of the results in a sentence or two

Agency XYZ’s password reset rate is about the same as the average across all agencies. This trend holds across mobile and desktop devices.

A tabular summary of the data

Event	Overall population	Agency XYZ
Password reset (mobile)	5%	5%
Password reset (desktop)	4%	4%

Queries

All the Cloudwatch queries used to gather the data

fields @message, @timestamp
| filter name = "Password Reset: Password Submitted"