Closed Bug 1266011 Opened 9 years ago Closed 9 years ago

Custom GA report for 28 active users on Hello

Categories

(Hello (Loop) :: Client, defect)

Product:
Hello (Loop)
Component:
Client
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: RT, Unassigned)

References

Details

User Story

Google analytics currently reports 30 active users (unique users who reached a Hello URL).
We need the same reports for 28 day periods since we are being advised to look at 28 day periods by the reporting team.
No description provided.
Blocks: 1248569
User Story: (updated)
Gareth could you please help us with a custom GA report for this?
Flags: needinfo?(garethcull.bugs)
Here's a custom report for 28 days worth of users: https://analytics.google.com/analytics/web/template?uid=eQNT4PdcQpObi0GaKNNR7g Unfortunately, you'll need to update this manually every 28 days since the default is 30 days. I'll see if I can export a 28 day report that auto-updates in Google Sheets. Would that work also?
Flags: needinfo?(garethcull.bugs)
An auto updated Google sheet would be ideal, thanks!
RT: is this done?
Flags: needinfo?(rtestard)
Gareth, have you been able to export the 28 day report to Googlke sheets automatically?
Flags: needinfo?(rtestard) → needinfo?(garethcull.bugs)
Here you go: https://docs.google.com/a/mozilla.com/spreadsheets/d/1AE4-nmK9j9YjiRQeztEFx1qth7iISF6zxfUQTVqXTGc/edit?usp=sharing This report will update everyday with the previous 28 days worth of data. Let me know if this is what you are looking for. Gareth
Flags: needinfo?(garethcull.bugs)
Gareth now updated with a tab removing duplicates. Marking now as FIXED.
Status: NEW → RESOLVED
Closed: 9 years ago
Resolution: --- → FIXED
Gareth, with this report we get just the last day data. We need the last N days for this value (as we currently have for the 30 days period). You can see in https://docs.google.com/spreadsheets/d/1g4l1fXXLM_AJFC52uUPI7eRPLgu1KH2nLN2lM5yLiTM/edit?ts=573307bc#gid=799995910 Could we have something similar?
Flags: needinfo?(garethcull.bugs)
(In reply to jmunuera from comment #8) > Gareth, with this report we get just the last day data. We need the last N > days for this value (as we currently have for the 30 days period). The current query is set up to pull the last 28 days and refreshes everyday. See the report config tab: http://cl.ly/2F3l1G2b0Z1h > You can see in > https://docs.google.com/spreadsheets/d/ > 1g4l1fXXLM_AJFC52uUPI7eRPLgu1KH2nLN2lM5yLiTM/edit?ts=573307bc#gid=799995910 > Could we have something similar? Can you give me access to this spreadsheet?
Flags: needinfo?(garethcull.bugs)
Gareth, you should be able to access now. What we need is a report with a list of the “28 days active” users from the last months. We have now the “30 days active” users list (GA report with dimension=ga:date and metric=ga:30dayUsers). We need this list to be aligned with this other list https://bugzilla.mozilla.org/show_bug.cgi?id=1248569
You need to log in before you can comment on or make changes to this bug.