How to get Twitch Drops Campaigns
Live streams (not a private campaign inventory) whose tags say Drops are on. A run saves one row per result.
One row per result
A row has Stream Id, Title, Viewers Count, Channel Login. The columns are listed in the schema on this page.
The next run
Put the run on a schedule and the next file is the latest rows.
Twitch Drops Campaigns in Excel, Sheets, or Power BI
The rows are the same in each of those tools. The guide for the one you already use starts with a free Apify account and finishes with the file.
Schema
Examples come from the actor sample, not a live result.
| Name | Description | Example |
|---|---|---|
streamId | Stream Id | empty |
title | Title | empty |
viewersCount | Viewers Count | empty |
channelLogin | Channel Login | example |
channelDisplayName | Channel Display Name | empty |
channelUrl | Channel Url | empty |
gameName | Game Name | Fortnite |
gameSlug | Game Slug | empty |
dropsTags | Drops Tags | ["DropsEnabled"] |
allTags | All Tags | empty |
source | Source | live_directory_freeform_tags |
streamIdStream IdemptytitleTitleemptyviewersCountViewers CountemptychannelLoginChannel LoginexamplechannelDisplayNameChannel Display NameemptychannelUrlChannel UrlemptygameNameGame NameFortnitegameSlugGame SlugemptydropsTagsDrops Tags["DropsEnabled"]allTagsAll TagsemptysourceSourcelive_directory_freeform_tags