Thank you! Your feedback helps us improve.

How do I work with raw data exported from the Analytics page?

Who has access?
- Grammarly Business account owners
- Grammarly Business contributors

The Analytics page allows you to export your team writing statistics in a CSV file. To do this, you may click Export in the top-right corner of the page.

Note: All information below is for a 7-day time range. If you export the data for a 30-day time range, you will need to change all instances of 8 to 31. For example: A8 -> A31.

Assuming you did not make any changes to the downloaded file, the data should be listed in the following cells:

  • Date: A2:A8
  • Active Members: B2:B8
  • Total Sessions: C2:C8
  • Sessions with Issues: D2:D8
  • Sessions Improved: E2:E8
  • Total Words: F2:F8
  • Total Time Using Grammarly (seconds): G2:G8
  • Correctness Suggestions Sent: H2:H8
  • Delivery Suggestions Sent: I2:I8
  • Clarity Suggestions Sent: J2:J8
  • Engagement Suggestions Sent: K2:K8
  • Style Guide Suggestions Sent: L2:L8
  • Correctness Suggestions Addressed: M2:M8
  • Delivery Suggestions Addressed: N2:N8
  • Clarity Suggestions Addressed: O2:O8
  • Engagement Suggestions Addressed: P2:P8
  • Style Guide Suggestions Addressed: Q2:Q8
  • Correctness Suggestions Unresolved: R2:R8
  • Delivery Suggestions Unresolved: S2:S8
  • Clarity Suggestions Unresolved: T2:T8
  • Engagement Suggestions Unresolved: U2:U8
  • Style Guide Suggestions Unresolved: V2:V8
  • Correctness Suggestions Dismissed: W2:W8
  • Delivery Suggestions Dismissed: X2:X8
  • Clarity Suggestions Dismissed: Y2:Y8
  • Engagement Suggestions Dismissed: Z2:Z8
  • Style Guide Suggestions Dismissed: AA2:AA8
  • Percent of Tone 1_Tone_Name: AB2:AB8
  • Percent of Tone 2_Tone_Name: AC2:AC8
  • Percent of Tone 3_Tone_Name: AD2:AD8

Below are the formulas you can use to recreate the data available on the Analytics page in Google Sheets. To apply these formulas in Microsoft Excel, simply remove the ARRAYFORMULA component. For example: =ARRAYFORMULA(E2:E8/D2:D8) -> =(E2:E8/D2:D8)

  • Communication overview panel 
    • Percentage of comms improved: =ARRAYFORMULA((E2:E8/D2:D8)*100)
    • Sessions with issues per active user: =ARRAYFORMULA(D2:D8/B2:B8)
    • Sessions improved per active user: =ARRAYFORMULA(E2:E8/B2:B8)
  • Usage summary panel
    • Number of Sessions: C2:C8
    • Total time spent using Grammarly (hours): =ARRAYFORMULA(G2:G8/3600)
    • Total word count: F2:F8
  • Per Active User
    • Number of Sessions: =ARRAYFORMULA(C2:C8/B2:B8)
    • Total time spent using Grammarly: =ARRAYFORMULA(G2:G8/3600/B2:B8)
    • Total word count: =ARRAYFORMULA(F2:F8/B2:B8)
  • Per Session
    • Total time spent using Grammarly: =ARRAYFORMULA(G2:G8/3600/C2:C8)
    • Total word count: =ARRAYFORMULA(F2:F8/C2:C8)
  • Grammarly Efficiency Impact
    • Your time savings with Grammarly are calculated as 10-20% of your time writing: =ARRAYFORMULA(SUM(G2:G8)/3600*{0.1;0.2})
  • Grammarly Suggestions
    • All Suggestions Sent Totals: =ARRAYFORMULA(H2:H8+I2:I8+J2:J8+K2:K8+L2:L8)
    • All Suggestions Addressed Totals: =ARRAYFORMULA(M2:M8+N2:N8+O2:O8+P2:P8+Q2:Q8)
    • All Suggestions Unresolved Totals: =ARRAYFORMULA(R2:R8+S2:S8+T2:T8+U2:U8+V2:V8)
    • All Suggestions Dismissed Totals: =ARRAYFORMULA(W2:W8+X2:X8+Y2:Y8+Z2:Z8+AA2:AA8)
    • All Suggestions Sent per 100 words: =ARRAYFORMULA((H2:H8+I2:I8+J2:J8+K2:K8+L2:L8)*100/F2:F8)
    • All Suggestions Addressed per 100 words: =ARRAYFORMULA((M2:M8+N2:N8+O2:O8+P2:P8+Q2:Q8)*100/F2:F8)
    • All Suggestions Unresolved per 100 words: =ARRAYFORMULA((R2:R8+S2:S8+T2:T8+U2:U8+V2:V8)*100/F2:F8)
    • All Suggestions Dismissed per 100 words: =ARRAYFORMULA((W2:W8+X2:X8+Y2:Y8+Z2:Z8+AA2:AA8)*100/F2:F8)
    • All Suggestions Sent Acceptance Ratio: =ARRAYFORMULA((H2:H8+I2:I8+J2:J8+K2:K8+L2:L8)/(H2:H8+I2:I8+J2:J8+K2:K8+L2:L8)*100)
    • All Suggestions Addressed Acceptance Ratio: =ARRAYFORMULA((M2:M8+N2:N8+O2:O8+P2:P8+Q2:Q8)/(H2:H8+I2:I8+J2:J8+K2:K8+L2:L8)*100)
    • All Suggestions Unresolved Acceptance Ratio: =ARRAYFORMULA((R2:R8+S2:S8+T2:T8+U2:U8+V2:V8)/(H2:H8+I2:I8+J2:J8+K2:K8+L2:L8)*100)
    • All Suggestions Dismissed Acceptance Ratio: =ARRAYFORMULA((W2:W8+X2:X8+Y2:Y8+Z2:Z8+AA2:AA8)/(H2:H8+I2:I8+J2:J8+K2:K8+L2:L8)*100)
    • All Suggestions Sent Per Session: =ARRAYFORMULA((H2:H8+I2:I8+J2:J8+K2:K8+L2:L8)/C2:C8)
    • All Suggestions Addressed Per Session: =ARRAYFORMULA((M2:M8+N2:N8+O2:O8+P2:P8+Q2:Q8)/C2:C8)
    • All Suggestions Unresolved Per Session: =ARRAYFORMULA((R2:R8+S2:S8+T2:T8+U2:U8+V2:V8)/C2:C8)
    • All Suggestions Dismissed Per Session: =ARRAYFORMULA((W2:W8+X2:X8+Y2:Y8+Z2:Z8+AA2:AA8)/C2:C8)
    • All Suggestions Sent Per active user: =ARRAYFORMULA((H2:H8+I2:I8+J2:J8+K2:K8+L2:L8)/B2:B8)
    • All Suggestions Addressed Per active user: =ARRAYFORMULA((M2:M8+N2:N8+O2:O8+P2:P8+Q2:Q8)/B2:B8)
    • All Suggestions Unresolved Per active user: =ARRAYFORMULA((R2:R8+S2:S8+T2:T8+U2:U8+V2:V8)/B2:B8)
    • All Suggestions Dismissed Per active user: =ARRAYFORMULA((W2:W8+X2:X8+Y2:Y8+Z2:Z8+AA2:AA8)/B2:B8)
    • Correctness Sent per 100 words: =ARRAYFORMULA(H2:H8*100/F2:F8)
    • Correctness Addressed per 100 words:  =ARRAYFORMULA(M2:M8*100/F2:F8)
    • Correctness Unresolved per 100 words:  =ARRAYFORMULA(R2:R8*100/F2:F8)
    • Correctness Dismissed per 100 words: =ARRAYFORMULA(W2:W8*100/F2:F8)
    • Correctness Sent Acceptance Ratio: =ARRAYFORMULA(H2:H8/H2:H8*100)
    • Correctness Addressed Acceptance Ratio: =ARRAYFORMULA(M2:M8/H2:H8*100)
    • Correctness Unresolved Acceptance Ratio: =ARRAYFORMULA(R2:R8/H2:H8*100)
    • Correctness Dismissed Acceptance Ratio: =ARRAYFORMULA(W2:W8/H2:H8*100)
    • Correctness Sent Per Session: =ARRAYFORMULA(H2:H8/C2:C8)
    • Correctness Addressed Per Session: =ARRAYFORMULA(M2:M8/C2:C8)
    • Correctness Unresolved Per Session:  =ARRAYFORMULA(R2:R8/C2:C8)
    • Correctness Dismissed Per Session: =ARRAYFORMULA(W2:W8/C2:C8)
    • Correctness Sent Per active user: =ARRAYFORMULA(H2:H8/B2:B8)
    • Correctness Addressed Per active user: =ARRAYFORMULA(M2:M8/B2:B8)
    • Correctness Unresolved Per active user: =ARRAYFORMULA(R2:R8/B2:B8)
    • Correctness Dismissed Per active user: =ARRAYFORMULA(W2:W8/B2:B8)
    • Clarity Sent per 100 words: =ARRAYFORMULA(J2:J8*100/F2:F8)
    • Clarity Addressed per 100 words: =ARRAYFORMULA(O2:O8*100/F2:F8)
    • Clarity Unresolved per 100 words: =ARRAYFORMULA(T2:T8*100/F2:F8)
    • Clarity Dismissed per 100 words: =ARRAYFORMULA(Y2:Y8*100/F2:F8)
    • Clarity Sent Acceptance Ratio: =ARRAYFORMULA(J2:J8/J2:J8*100)
    • Clarity Addressed Acceptance Ratio: =ARRAYFORMULA(O2:O8/J2:J8*100) 
    • Clarity Unresolved Acceptance Ratio: =ARRAYFORMULA(T2:T8/J2:J8*100)
    • Clarity Dismissed Acceptance Ratio: =ARRAYFORMULA(Y2:Y8/J2:J8*100)
    • Clarity Sent Per Session: =ARRAYFORMULA(J2:J8/C2:C8)
    • Clarity Addressed Per Session: =ARRAYFORMULA(O2:O8/C2:C8)
    • Clarity Unresolved Per Session: =ARRAYFORMULA(T2:T8/C2:C8)
    • Clarity Dismissed Per Session: =ARRAYFORMULA(Y2:Y8/C2:C8)
    • Clarity Sent Per active user: =ARRAYFORMULA(J2:J8/B2:B8)
    • Clarity Addressed Per active user: =ARRAYFORMULA(O2:O8/B2:B8)
    • Clarity Unresolved Per active user: =ARRAYFORMULA(T2:T8/B2:B8)
    • Clarity Dismissed Per active user: =ARRAYFORMULA(Y2:Y8/B2:B8)
    • Delivery Sent per 100 words: =ARRAYFORMULA(I2:I8*100/F2:F8)
    • Delivery Addressed per 100 words: =ARRAYFORMULA(N2:N8*100/F2:F8)
    • Delivery Unresolved per 100 words: =ARRAYFORMULA(S2:S8*100/F2:F8)
    • Delivery Dismissed per 100 words: =ARRAYFORMULA(X2:X8*100/F2:F8)
    • Delivery Sent Acceptance Ratio: =ARRAYFORMULA(I2:I8/I2:I8*100)
    • Delivery Addressed Acceptance Ratio: =ARRAYFORMULA(N2:N8/I2:I8*100)
    • Delivery Unresolved Acceptance Ratio: =ARRAYFORMULA(S2:S8/I2:I8*100)
    • Delivery Dismissed Acceptance Ratio: =ARRAYFORMULA(X2:X8/I2:I8*100)
    • Delivery Sent Per Session: =ARRAYFORMULA(I2:I8/C2:C8)
    • Delivery Addressed Per Session: =ARRAYFORMULA(N2:N8/C2:C8)
    • Delivery Unresolved Per Session: =ARRAYFORMULA(S2:S8/C2:C8)
    • Delivery Dismissed Per Session: =ARRAYFORMULA(X2:X8/C2:C8)
    • Delivery Sent Per active user: =ARRAYFORMULA(I2:I8/B2:B8)
    • Delivery Addressed Per active user: =ARRAYFORMULA(N2:N8/B2:B8)
    • Delivery Unresolved Per active user: =ARRAYFORMULA(S2:S8/B2:B8)
    • Delivery Dismissed Per active user: =ARRAYFORMULA(X2:X8/B2:B8)
    • Engagement Sent Acceptance Ratio: =ARRAYFORMULA(K2:K8/K2:K8*100)
    • Engagement Addressed Acceptance Ratio: =ARRAYFORMULA(P2:P8/K2:K8*100)
    • Engagement Unresolved Acceptance Ratio: =ARRAYFORMULA(U2:U8/K2:K8*100) 
    • Engagement Dismissed Acceptance Ratio: =ARRAYFORMULA(Z2:Z8/K2:K8*100)
    • Engagement Sent Per Session: =ARRAYFORMULA(K2:K8/C2:C8)
    • Engagement Addressed Per Session: =ARRAYFORMULA(P2:P8/C2:C8)
    • Engagement Unresolved Per Session: =ARRAYFORMULA(U2:U8/C2:C8)
    • Engagement Dismissed Per Session: =ARRAYFORMULA(Z2:Z8/C2:C8)
    • Engagement Sent Per active user: =ARRAYFORMULA(K2:K8/B2:B8)
    • Engagement Addressed Per active user: =ARRAYFORMULA(P2:P8/B2:B8)
    • Engagement Unresolved Per active user: =ARRAYFORMULA(U2:U8/B2:B8)
    • Engagement Dismissed Per active user:  =ARRAYFORMULA(Z2:Z8/B2:B8)
    • Engagement Sent per 100 words: =ARRAYFORMULA(K2:K8*100/F2:F8)
    • Engagement Addressed per 100 words: =ARRAYFORMULA(P2:P8*100/F2:F8)
    • Engagement Unresolved per 100 words: =ARRAYFORMULA(U2:U8*100/F2:F8)
    • Engagement Dismissed per 100 words: =ARRAYFORMULA(Z2:Z8*100/F2:F8)
    • Style Guide Sent Acceptance Ratio: =ARRAYFORMULA(L2:L8/L2:L8*100)
    • Style Guide Addressed Acceptance Ratio: =ARRAYFORMULA(Q2:Q8/L2:L8*100)
    • Style Guide Unresolved Acceptance Ratio: =ARRAYFORMULA(V2:V8/L2:L8*100)
    • Style Guide Dismissed Acceptance Ratio: =ARRAYFORMULA(AA2:AA8/L2:L8*100)
    • Style Guide Sent Per Session: =ARRAYFORMULA(L2:L8/C2:C8)
    • Style Guide Addressed Per Session: =ARRAYFORMULA(Q2:Q8/C2:C8)
    • Style Guide Unresolved Per Session: =ARRAYFORMULA(V2:V8/C2:C8)
    • Style Guide Dismissed Per Session: =ARRAYFORMULA(AA2:AA8/C2:C8)
    • Style Guide Sent Per active user: =ARRAYFORMULA(L2:L8/B2:B8)
    • Style Guide Addressed Per active user: =ARRAYFORMULA(Q2:Q8/B2:B8)
    • Style Guide Unresolved Per active user: =ARRAYFORMULA(V2:V8/B2:B8)
    • Style Guide Dismissed Per active user: =ARRAYFORMULA(AA2:AA8/B2:B8)
    • Style Guide Sent per 100 words: =ARRAYFORMULA(L2:L8*100/F2:F8)
    • Style Guide Addressed per 100 words: =ARRAYFORMULA(Q2:Q8*100/F2:F8)
    • Style Guide Unresolved per 100 words: =ARRAYFORMULA(V2:V8*100/F2:F8)
    • Style Guide Dismissed per 100 words: =ARRAYFORMULA(AA2:AA8*100/F2:F8)
Was this article helpful?
Tell us what you think. We promise to act on your feedback to make Grammarly's support pages even more helpful.
Have more questions? Submit a request