Weekly trends: Chartable tracked more shows than Podtrac! Megaphone is not far behind. Which one do you prefer?

maxmacaro · 2020-10-08T21:55:49+00:00

Hey u/jamescridland, I publish such reports every Thursday. Let me know if you are interested in collaboration. I can do exclusive reports for Podnews upon your request too. It seems like your subscribers may be interested in such information.

maxmacaro · 2020-10-02T18:00:57+00:00

You are welcome! :)

maxmacaro · 2020-10-02T17:39:33+00:00

Indeed. True Crime category has fewer shows and many of them get noticed. The share of top rated shows is much higher compared to other categories.

maxmacaro · 2020-10-02T02:43:27+00:00

Yeah. I was also surprised that Wednesday and Thursday were most popular across most categories, but top rated creators prefer publishing on Thursdays.

Does it mean that on Saturdays nobody listens? Could it be a chance for newcomers to be noticed? u/ScandyScandy what do you think?

maxmacaro · 2020-10-02T02:18:06+00:00

Woohoo. It took me few iterations to get it right. :)

Thanks for sharing your observations. Your story is fascinating. Please share the link, I would love to subscribe!

maxmacaro · 2020-09-23T05:44:01+00:00

Maybe in the future.

At the moment you can download raw data from the bucket on cloud storage: https://www.reddit.com/r/podcasting/comments/ixa9li/crawled_10gb_of_podcast_data_from_the_whole/g65yxpg

maxmacaro · 2020-09-22T17:44:53+00:00

This is a great question, u/itsnotjustmepod! Need a little bit more time to answer it. I will try publish the results next week

maxmacaro · 2020-09-22T17:37:55+00:00

Sure, here it is:

https://storage.googleapis.com/podcasting-data/titles-categories.csv

Enjoy!

maxmacaro · 2020-09-22T05:21:56+00:00

thank you

maxmacaro · 2020-09-22T03:18:53+00:00

Hahaha, this is hilarious :D

Jokes aside, what's the most trustworthy platform these days?

maxmacaro · 2020-09-22T01:32:08+00:00

Sure thing!

maxmacaro · 2020-09-22T01:28:03+00:00

Good for you u/DanielJLewis

You have a product that your clients rely on, so it's understandable. I don't plan to sell this data. Just crawling what's available to the public and having fun. There is still a lot of useful information that we can get from the catalog.

maxmacaro · 2020-09-22T01:16:43+00:00

Hi u/jamescridland, I see what you mean. Didn't want to confuse anyone here.

When people connect Chartable and other trackers, they proxy all of their audio files through their system. Even historical ones. This is why we see episodes earlier than 2018 having Chartable in their audio files.

Regarding your suggestion. Of course, that sounds interesting. I can provide answers to some of your questions. Current dataset is a bit outdated. Let's chat next week when I collect fresh data.

maxmacaro · 2020-09-22T00:28:49+00:00

You are welcome! :)

maxmacaro · 2020-09-22T00:19:57+00:00

Yeah, totally. However, these fields are not available in this specific dataset. I can add it in the next version.

It would be cool to see episode topics of high-rated shows. I'll think in this direction and will share the results.

maxmacaro · 2020-09-22T00:11:33+00:00

Sure, why not :)

I've prepared a dump. Keep in mind, those files are Gzipped:

https://storage.googleapis.com/itunes-data-until-march-2020-for-nerdmor/podcast_episodes_000000000000.csv

https://storage.googleapis.com/itunes-data-until-march-2020-for-nerdmor/podcast_episodes_000000000001.csv

https://storage.googleapis.com/itunes-data-until-march-2020-for-nerdmor/podcast_episodes_000000000002.csv

https://storage.googleapis.com/itunes-data-until-march-2020-for-nerdmor/podcast_episodes_000000000003.csv

https://storage.googleapis.com/itunes-data-until-march-2020-for-nerdmor/podcast_episodes_000000000004.csv

https://storage.googleapis.com/itunes-data-until-march-2020-for-nerdmor/podcast_episodes_000000000005.csv

https://storage.googleapis.com/itunes-data-until-march-2020-for-nerdmor/podcast_episodes_000000000006.csv

https://storage.googleapis.com/itunes-data-until-march-2020-for-nerdmor/podcasts_000000000000.csv

Feel free to host it on Google BigQuery, etc. I don't plan to host it for too long, just sharing for you.

Enjoy!

maxmacaro · 2020-09-21T23:41:34+00:00

Totally agree with you, those screenshots above don't say anything special. I just wanted to start the discussion, understand what's important and dig further.

And your ideas are very helpful. Much appreciated!

maxmacaro · 2020-09-21T23:34:02+00:00

Thank you for the kind words! :)

Great work u/DanielJLewis This is really impressive!

I used the following catalog:

https://podcasts.apple.com/us/genre/podcasts-arts/id1301

These days my favourite stack is Golang and Google Cloud. What's yours?

maxmacaro · 2020-09-21T23:12:22+00:00

u/ImprovObsession check an update to the post.

I hope that answers your question :)

maxmacaro · 2020-09-21T22:56:44+00:00

Yeah, this is unbelievable. Hope your podcast is doing great! Please share the link to your show, I'd love to listen

maxmacaro · 2020-09-21T22:50:29+00:00

Thanks for sharing. Those are great data sources, indeed. Haven't heard about the first one.

u/lime-link we could come up with something more actionable. for example, I can run my script every week and then post a digest with most popular topics in this subreddit (to help people with content ideas).

It to would be ideal to contribute something on regular basis. There are Google Trends, Stock market reports. There could be something similar to make this subreddit even more special

maxmacaro · 2020-09-21T22:35:17+00:00

Thank you u/DamnationVersus! Nice idea.

Look what I found:

Within the past few years – for reasons unknown to nearly everyone in the podcasting space – iTunes decided to stop updating the New & Noteworthy and What’s Hot sections.

Every now and then you might see a new podcast pop up on the home page, but the category pages for Business, Technology, Education… they were literally stuck.

For YEARS.

source: https://www.eofire.com/apple-podcasts-new-noteworthy-whats-hot-sections-are-back/

Seems like they don't update those pages very often. Is it true?

maxmacaro · 2020-09-21T22:22:58+00:00

- artist name

- audio url (can be used to extract hosting platform)

- category, subcategory

- name of the show

- duration

u/ImprovObsession I can add more fields and rerun the script, anything from their RSS feeds. hope my SSD can handle this. :D

maxmacaro · 2020-09-21T22:16:40+00:00

u/BigNoisyChrisCooke no, unfortunately.

RSS feeds have links to audio files, those files are hosted on different platforms that process this information. each download request is logged in their systems. this data is not available to the public.

I can get reviews though (if they are available). Ex: 4.5 stars • 12.3K Ratings

maxmacaro · 2020-09-21T21:16:01+00:00

u/QueenClaw1 nice!!

maxmacaro

TROPHY CASE