Skip to main content
  • Home
  • Ideas
  • Export user dashboard as one report into Google Sheets and Excel
Open

Export user dashboard as one report into Google Sheets and Excel

Related products:CC Analytics & Reporting
DannyPancratz
N
timcavey
tom.shaddock
Suvi Lehtovaara
+11
  • DannyPancratz
    DannyPancratz
  • N
    njoury
  • timcavey
    timcavey
  • tom.shaddock
    tom.shaddock
  • Suvi Lehtovaara
    Suvi Lehtovaara
  • Kgastaldo
    Kgastaldo
  • ZapierSteph
    ZapierSteph
  • E
    Emil
  • Tobi
    Tobi
  • B
    becky.scott
  • Gabolino
    Gabolino
  • tiffany.oda
    tiffany.oda
  • Chris Hackett
    Chris Hackett
  • wtempleton
    wtempleton
  • Chelsea Roberts
    Chelsea Roberts
  • Jacinda Espinosa
    Jacinda Espinosa
m4rc
  • m4rc
  • Helper ⭐️
  • 66 replies

I’d very much like to be able to export the user dashboard into a Google Sheet so that I can segment our highly engaged members there, and also so we have a record to keep.

Currently the export option allows for single action analytics only (when choosing export types).

As there already exists a user dashboard showing the member name, rank, posts, topics etc etc at /analyticsV2/members > view more it shouldn’t be too hard to allow us to export this data directly from this page, rather than via the ‘Export’ option 

9 replies

B
  • becky.scott
  • Contributor ⭐️⭐️⭐️
  • 11 replies
  • September 16, 2020

We’d like to be able to export, but the export should include more than just the top users (I’d like to see all). This will help us track contributions over time, and it will help us map a user’s activity for future super user programs.

Either that, or tweak the user export report to have more options, like deciding whether we want it to be all activity or just registrations for the time period selected.

m4rc
  • m4rc
  • Author
  • Helper ⭐️
  • 66 replies
  • September 21, 2020

Yes, this! What @becky.scott said:

We’d like to be able to export, but the export should include more than just the top users (I’d like to see all). This will help us track contributions over time, and it will help us map a user’s activity for future super user programs.

 

:slight_smile:

Gabolino
Forum|alt.badge.img
  • Gabolino
  • Helper ⭐️
  • 163 replies
  • March 9, 2021

Voted this idea - as far as Im aware this is the most important report in a community and should have a CSV version for the reasons listed by @Marc 

L
  • liz-typeform
  • Contributor ⭐️⭐️
  • 7 replies
  • March 9, 2021

Hi @daniel.boon ! Do you happen to know if this still works? I can’t find <table ng-style="dataTableHeight" dir="ltr"> even following the gif, as it looks like they might have updated the styling of the table. :( 

Gabolino
1 person likes this
  • Gabolino
    Gabolino
Gabolino
Forum|alt.badge.img
  • Gabolino
  • Helper ⭐️
  • 163 replies
  • March 17, 2021

Could you lend a helping hand @daniel.boon ? 

 

@m4rc is this still working for you?

Shane1
  • Shane1
  • Helper ⭐️⭐️⭐️
  • 119 replies
  • March 17, 2021

@liz-typeform I just mentioned this in a call with @Gabolino, but the workaround Daniel mentioned was only relevant for our old analytics dashboards as you couldn’t copy and paste any data from them. However, in the new dashboards we released a few months ago you can easily copy and paste data from them into a spreadsheet so this workaround isn’t needed

daniel.boon
Gabolino
2 people like this
  • daniel.boon
    daniel.boon
  • Gabolino
    Gabolino
m4rc
  • m4rc
  • Author
  • Helper ⭐️
  • 66 replies
  • March 17, 2021

@NatTho copy/paste! Gonna make life easier :arrow_up:

Kgastaldo
NatTho
2 people like this
  • Kgastaldo
    Kgastaldo
  • NatTho
    NatTho
Gabolino
Forum|alt.badge.img
  • Gabolino
  • Helper ⭐️
  • 163 replies
  • March 17, 2021

Oh gosh that was easy - why didn’t even try to do it the hard way :sweat_smile:  ?

Hey @NatTho nice to hear from (about) you once again :D

Kgastaldo
NatTho
2 people like this
  • Kgastaldo
    Kgastaldo
  • NatTho
    NatTho
Gabolino
Forum|alt.badge.img
  • Gabolino
  • Helper ⭐️
  • 163 replies
  • March 17, 2021

By the way, what’s the criteria for users to appear on the user dashboard table? Min one post?

 

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings