Discord Guild Specific Report

• Basic Guild Data
  • How to count the number of bots on a specific discord guild?
  • How to count the number of authors within a specific discord guild?
  • What is the number of channels within a specific discord guild?
  • What are the channels of a particular discord guild?
  • What is the age of the oldest message in each channel of a specific discord guild?
• Message Count Queries - Discord Message Specific Queries
  • How many messages per channel in a specific discord guild?
  • How many messages per author in a specific discord guild?
  • How many users have posted more than 100 messages in a particular discord guild?
• Message Length Queries - Discord Message Specific Queries
  • What discord user has the longest average message length in a particular guild?
  • What discord channel has the longest average message length of a specific guild?
• Attachment Queries - Discord Attachment Specific Queries
  • How many attachments of a separate file types are in a discord guild?
  • Who sent the most attachments in a specific discord guild?
  • What discord attachment message has the most reactions?
• Reaction Queries - Discord Reaction Specific Queries
  • What discord author got the most reactions to their messages?
  • What discord author got the most distinct reactions to their messages?
• Time Based Queries
  • What is the activity per month of each discord guild measured in messages per month?
  • How much activity for a specific discord guild per day of week?
  • Who is the most consistent poster within a Discord Guild?
  • What discord author has the highest spike in activity in single day from a specific discord guild?
• URL Based Queries - Discord URL Specific Queries
  • How many times was each domain name mentioned in a specific discord guild?
  • How to list the most reacted to URL's from a specific discord guild?
• Author Queries
  • What discord author edits the highest percentage of their messages within a particular discord guild?
  • How many authors posted in each specific channel of a specific discord guild?
  • What discord author was mentioned the most?
  • What authors asked the most questions within a specific discord guild?

Query List

guild_message_per_channel guild_author_message_min_100 guild_channel_message_length guild_attachment_file_type_count guild_attachment_reactions guild_messages_month guild_activity_per_day guild_domain_count guild_author_url_react guild_channel_author_count guild_author_mention_count guild_author_most_question_messages

{
    "query_list" : [
        "guild_bots_count",
        "guild_author_count",
        "guild_channels_count",
        "guild_channels",
        "guild_oldest_message",

        "guild_message_per_channel",
        "guild_author_most_messages",
        "guild_author_message_min_100",

        "user_longest_avg_msg_length",
        "guild_channel_message_length",

        "guild_attachment_file_type_count",
        "guild_author_most_attachments",
        "guild_attachment_reactions",

        "guild_author_most_reactions",
        "guild_author_distinct_reaction_count",

        "guild_messages_month",
        "guild_activity_per_day",
        "guild_author_most_days_with_messages",
        "guild_author_most_messages_single_day",

        "guild_domain_count",
        "guild_author_url_react",

        "guild_author_edit_percentage",
        "guild_channel_author_count",
        "guild_author_mention_count",
        "guild_author_most_question_messages"
    ]
}

Backlinks

• Questions for Discord Data