Hackathon reporting surface
Hackathon reporting dashboard
The shell stays fixed while you switch between BigQuery modeling and direct GA4 property reporting, so it is easier to compare the same hackathon story without reorienting yourself every time.
Reporting source
Generated 25 Mar 2026, 20:06 UTC
Live mode is reading directly from the shared GA4 property through the official Google Analytics Data API client, using the last 30 days including today.
Event count
1,716
Total hackathon analytics events returned in the current reporting window.
Users
40
Distinct users observed on the hackathon reporting surface in the same window.
Persisted votes
297
Authoritative vote rows from the live voting app snapshot that powers the public scoreboard.
Tracked submits
20
GA4 vote_submitted events captured as analytics telemetry for the same window.
GA4 coverage
6.7%
Tracked submits divided by the authoritative persisted vote total.
Manager actions
72
Uploads, round controls, and entry state operations recorded for the manager.
Source reconciliation
Fresh reporting boundaries and discrepancies for this surface.
- Live mode is reading directly from the shared GA4 property through the official Google Analytics Data API client, using the last 30 days including today.
- Warehouse reconciliation: the modeled BigQuery dataset currently has 0 landed rows across 8 tables, and ga4_498363924 currently has 0 landed raw export tables.
- The route is filtered to vote.rajeevg.com so the hackathon app stays separated from rajeevg.com content analytics even though both live on the same property.
- Source of truth: the live voting app currently reports 297 persisted votes across 9 entries and 37 judges at https://vote.rajeevg.com/api/reporting/public-summary.
- Tracked analytics coverage: GA4 currently shows 20 vote_submitted events, a gap of 277 versus the persisted vote total (6.7% coverage).
- The gap is expected because vote_submitted is client-side telemetry behind analytics consent, while the persisted vote total comes from the live competition snapshot that powers the public scoreboard.
Historical event surface
A GA-native view of the hackathon event vocabulary grouped by viewer role and round state.
competition_state_snapshot
judge · open
189
12 users
vote_score_selected
judge · unknown
57
3 users
competition_state_snapshot
judge · preparing
52
20 users
competition_state_snapshot
public · preparing
41
30 users
vote_dialog_viewed
judge · open
27
7 users
judge_auth_dialog_opened
unknown · unknown
26
23 users
judge_auth_dialog_opened
public · preparing
26
24 users
vote_score_selected
manager · (not set)
26
1 users
competition_state_snapshot
unknown · open
24
7 users
competition_state_snapshot
judge · unknown
24
4 users
judge_auth_email_requested
unknown · unknown
22
19 users
scoreboard_view_changed
judge · unknown
22
5 users
Round snapshot surface
GA-exposed averages from the promoted snapshot metrics on competition_state_snapshot.
open
248 snapshotsEntries
7.3
Open entries
3.8
Judges in denominator
22.4
Remaining votes
18.3
preparing
112 snapshotsEntries
4.5
Open entries
3.6
Judges in denominator
0.0
Remaining votes
0.0
unknown
29 snapshotsEntries
7.6
Open entries
3.7
Judges in denominator
26.9
Remaining votes
20.6
(not set)
11 snapshotsEntries
0.7
Open entries
0.6
Judges in denominator
0.1
Remaining votes
0.2
finalized
2 snapshotsEntries
4.0
Open entries
0.0
Judges in denominator
0.0
Remaining votes
0.0
Entry surface
Per-project demand and scoring rows derived from GA event-level dimensions and metrics.
Brief It
brief-it
Dialogs
14
Tracked submits
2
Actual votes
34
Avg score
6.0
Avg aggregate
0.0
Gap
32
Raj test
raj-test
Dialogs
4
Tracked submits
2
Actual votes
Unavailable
Avg score
6.5
Avg aggregate
0.0
Gap
N/A
Trafficker on Steriods
trafficker-on-steriods
Dialogs
5
Tracked submits
2
Actual votes
33
Avg score
6.5
Avg aggregate
0.0
Gap
31
Planet Killer
planet-killer
Dialogs
4
Tracked submits
2
Actual votes
33
Avg score
6.5
Avg aggregate
0.0
Gap
31
Taxo guard
taxo-guard
Dialogs
3
Tracked submits
2
Actual votes
32
Avg score
7.0
Avg aggregate
0.0
Gap
30
What's My Frog
what-s-my-frog
Dialogs
2
Tracked submits
2
Actual votes
36
Avg score
7.0
Avg aggregate
0.0
Gap
34
Aurora Atlas
aurora-atlas
Dialogs
0
Tracked submits
1
Actual votes
Unavailable
Avg score
10.0
Avg aggregate
0.0
Gap
N/A
Autopull Aliance
autopull-aliance
Dialogs
1
Tracked submits
1
Actual votes
32
Avg score
6.0
Avg aggregate
0.0
Gap
31
Harbor Pulse
harbor-pulse
Dialogs
1
Tracked submits
1
Actual votes
Unavailable
Avg score
10.0
Avg aggregate
0.0
Gap
N/A
planet-assisstant
planet-assisstant
Dialogs
1
Tracked submits
1
Actual votes
32
Avg score
7.0
Avg aggregate
0.0
Gap
31
(not set)
signal-bloom
Dialogs
2
Tracked submits
1
Actual votes
Unavailable
Avg score
6.0
Avg aggregate
0.0
Gap
N/A
test 1
test-1
Dialogs
1
Tracked submits
1
Actual votes
Unavailable
Avg score
5.0
Avg aggregate
0.0
Gap
N/A
test-2
test-2
Dialogs
2
Tracked submits
1
Actual votes
Unavailable
Avg score
10.0
Avg aggregate
0.0
Gap
N/A
test-3
test-3
Dialogs
2
Tracked submits
1
Actual votes
Unavailable
Avg score
3.0
Avg aggregate
0.0
Gap
N/A
Audience Insights Generator
audience-insights-generator
Dialogs
4
Tracked submits
0
Actual votes
32
Avg score
0.0
Avg aggregate
0.0
Gap
32
Audience Insights Generator
Dialogs
9
Tracked submits
0
Actual votes
Unavailable
Avg score
0.0
Avg aggregate
0.0
Gap
N/A
Aurora Atlas
(not set)
Dialogs
2
Tracked submits
0
Actual votes
Unavailable
Avg score
0.0
Avg aggregate
0.0
Gap
N/A
Manager operations
The manager-only controls and failure events visible directly in GA reporting.
workbook_picker_opened
6
entry_voting_state_changed
5
workbook_upload_completed
3
workbook_upload_started
3
competition_round_reset
2
competition_round_started
2
competition_round_finalized
1
Promoted hackathon schema
The key hackathon dimensions and metrics promoted on the shared property and used by this GA API surface.
Competition Status
dimensioncustomEvent:competition_status
The active judging-round state when the event fired.
Viewer Role
dimensioncustomEvent:viewer_role
Whether the event came from a public visitor, judge, or the single manager.
Entry Name
dimensioncustomEvent:entry_name
Human-readable project name attached to scoring and voting events.
Entry Slug
dimensioncustomEvent:entry_slug
Stable project identifier used to join per-entry reporting rows.
Entry Voting Open
dimensioncustomEvent:entry_voting_open
Whether a specific project was currently open to new votes.
Viewer Can Vote
dimensioncustomEvent:viewer_can_vote
Whether the current signed-in viewer was eligible to vote on that project.
Viewer Has Vote
dimensioncustomEvent:viewer_has_vote
Whether the viewer had already cast their one locked score for the project.
Analytics Section
dimensioncustomEvent:analytics_section
The product surface that emitted the event, such as scoreboard, judge auth, or manager controls.
Viewport Category
dimensioncustomEvent:viewport_category
Responsive bucket such as mobile, tablet, or desktop.
Upload Method
dimensioncustomEvent:upload_method
How the manager selected the workbook, such as click or drag and drop.
Score
metriccustomEvent:score
The single 0-10 score chosen in a vote event.
Aggregate Score
metriccustomEvent:aggregate_score
The current summed scoreboard total represented by the event payload.
Vote Count
metriccustomEvent:vote_count
The number of votes represented by the event payload or snapshot.
Entry Count
metriccustomEvent:entry_count
How many projects were loaded into the current competition snapshot.
Open Entry Count
metriccustomEvent:open_entry_count
How many projects were accepting new votes at that moment.
Participating Judge Count
metriccustomEvent:participating_judge_count
How many judges had joined the completion denominator by scoring at least one project.
Total Remaining Votes
metriccustomEvent:total_remaining_votes
Outstanding vote obligations still blocking completion or finalization.