Forum |Sermon Browser Plugin for WordPress

Please consider registering
guest

Home

Forum

Sermon Browser Support

Edit Stats

Topic RSS

Edit Stats

18 August, 2010
8:17 pm

Dave1

Enthusiast

Forum Posts: 12

Member Since:
29 January, 2009

Offline

Is there any way to manually edit stats? I know this is a weird request. But here's what happened…

Most of our sermons have around 60-80 listens. But for some reason one of them shot up over 400 listens! There's no good reason that that particular sermon would be hit that much…it wasn't any sort of special occasion. So it's just throwing off our stats in the dashboard and annoying me.

So I just thought I'd see if there's a way to change the number somehow.

Thanks!

19 August, 2010
3:39 am

Ben Miller

Appleton, WI, USA

Moderator

Forum Posts: 386

Member Since:
18 June, 2009

Offline

The stats are stored in the WordPress database. If you are familiar with a tool like phpMyAdmin, you should be able to adjust the number. However, I have to mention that editing your database is very dangerous, and you do so at your own risk.

The stats for each sermon are stored in the "_sb_stuff" table. Find the sermon ID of the sermon you want to edit, then change the value in the "count" field.

Ben Miller
Pathways Church, Appleton, WI, USA

19 August, 2010
5:10 am

Rich Brown

Parkville, MD

Guru

Forum Posts: 306

Member Since:
13 July, 2009

Offline

Dave1 said:

Is there any way to manually edit stats? I know this is a weird request. But here's what happened…

Most of our sermons have around 60-80 listens. But for some reason one of them shot up over 400 listens! There's no good reason that that particular sermon would be hit that much…it wasn't any sort of special occasion. So it's just throwing off our stats in the dashboard and annoying me.

So I just thought I'd see if there's a way to change the number somehow.

Thanks!

Sign into the WP dashboard, navigate to sermons, and change (or delete) the link to the mp3 for that sermon, save it, and then change it back again. This should reset the number to zero.

Rich Brown
Aisquith Presbyterian Church
Parkville, Maryland, USA
sermons.aisquith.org

23 August, 2010
6:18 pm

Dave1

Enthusiast

Forum Posts: 12

Member Since:
29 January, 2009

Offline

Thanks guys. I ended up deleting the link and then modifying the name of the mp3 file which set the count back to zero.

@Ben Miller- thanks for the phpMyAdmin suggestion. I'm not brave or smart enough to do much in there. But it's cool to hear from someone in Appleton…I used to work at Christ The Rock in Menasha!

All RSS

Forum Timezone: Europe/London

Most Users Ever Online: 40

Currently Online:
15 Guest(s)

Currently Browsing this Page:
1 Guest(s)