Conversation
supportA lot of affiliate and ad suppliers want to know your 30 day downloads on each show. Right now, I can get a chart of downloads over a certain timeframe, but not the total. I have to either count each datapoint in the chart over thirty days (time consuming) or run a SQL query (tedious). Is there a way to do this or can we add it to a future release? Thanks!
This would be great, I also have to add manually to know the total for each month. It would be very easy to simply know the total per month or 30 days.
So, here’s how I do it from the SQL. This is not recommended for those unfamiliar with working in databases. But if you can access phpMyAdmin on your host, it’s not too bad. I take no responsibility if you foul something up in your database. SELECT COUNT(*) FROM 'ssp_stats' where post_id = [PostID] AND date > [START_DATE_IN_UNIX] AND date < [END_DATE_IN_UNIX] Notes: Your table name will probably be something different as WP randomizes a prefix onto table names. The PostID is the ID that WP gives the post attached to the podcast episode in question. You can find this by mousing over the post name in the list of posts in your dashboard. Date/Time has to be in UNIX time (milliseconds since Jan 1, 1970). This is a pain, but there are websites to convert it for you (or use an Excel sheet, like me). Again, I really wish this was built-in functionality. This reply was modified 4 years, 12 months ago by thevoicesofbrian . This reply was modified 4 years, 12 months ago by thevoicesofbrian .
Thank you very much Brian, I’ll give it a try, I’m familiar with databases, greetings.
This would be great, I also have to add manually to know the total for each month. It would be very easy to simply know the total per month or 30 days.
So, here’s how I do it from the SQL. This is not recommended for those unfamiliar with working in databases. But if you can access phpMyAdmin on your host, it’s not too bad. I take no responsibility if you foul something up in your database. SELECT COUNT(*) FROM 'ssp_stats' where post_id = [PostID] AND date > [START_DATE_IN_UNIX] AND date < [END_DATE_IN_UNIX] Notes: Your table name will probably be something different as WP randomizes a prefix onto table names. The PostID is the ID that WP gives the post attached to the podcast episode in question. You can find this by mousing over the post name in the list of posts in your dashboard. Date/Time has to be in UNIX time (milliseconds since Jan 1, 1970). This is a pain, but there are websites to convert it for you (or use an Excel sheet, like me). Again, I really wish this was built-in functionality. This reply was modified 4 years, 12 months ago by thevoicesofbrian . This reply was modified 4 years, 12 months ago by thevoicesofbrian .
Thank you very much Brian, I’ll give it a try, I’m familiar with databases, greetings.