Powered by ARPEOH
Metrics Key
Program Results
Exit Data · col G, C
Total files provided vs completed interviews. Only candidates with a phone number in col G are counted.
Files Provided = COUNT rows WHERE col G not empty
Completed = COUNT rows WHERE col C = "Completed" AND col G not empty
Market Results
Exit Data · col N, C
Completed interviews grouped by market.
COUNT rows WHERE status = "Completed", grouped by col N
Reason for Leaving
Verbatim Data · col AI
Top 11 reason categories from col AI. All others grouped as "Other".
COUNT col AI values · top 11 shown · rest = "Other"
Average Tenure
Exit Data · col N, O
Average days employed per market from col O.
AVG(col O) grouped by Market (col N)
Average Rating by Market
Ratings · col A, P
Overall average satisfaction rating per market (0-5 scale).
col P (Average) from Ratings sheet grouped by col A
Markets Page — Ratings
Verbatim Data · cols G H J K M N P Q S T V W
Average rating per question for selected market. Scale 1-5.
AVG of numeric values per column, filtered by market (col M, index 12)