Social Media Influencers In 2022
Top 1000 social media influencers from instagram,youtube and tiktok each in 2022
@kaggle.ramjasmaurya_top_1000_social_media_channels
Top 1000 social media influencers from instagram,youtube and tiktok each in 2022
@kaggle.ramjasmaurya_top_1000_social_media_channels
Influencers are categorized by the number of followers they have on social media. They include celebrities with large followings to niche content creators with a loyal following on social-media platforms such as YouTube, Instagram, Facebook, and Twitter.Their followers range in number from hundreds of millions to 1,000. Influencers may be categorized in tiers (mega-, macro-, micro-, and nano-influencers), based on their number of followers.
Businesses pursue people who aim to lessen their consumption of advertisements, and are willing to pay their influencers more. Targeting influencers is seen as increasing marketing's reach, counteracting a growing tendency by prospective customers to ignore marketing.
Marketing researchers Kapitan and Silvera find that influencer selection extends into product personality. This product and benefit matching is key. For a shampoo, it should use an influencer with good hair. Likewise, a flashy product may use bold colors to convey its brand. If an influencer is not flashy, they will clash with the brand. Matching an influencer with the product's purpose and mood is important.
CREATE TABLE social_media_influencers_instagram (
"influencer_insta_name" VARCHAR,
"instagram_name" VARCHAR,
"category_1" VARCHAR,
"category_2" VARCHAR,
"followers" VARCHAR,
"audience_country_mostly" VARCHAR -- Audience Country(mostly),
"authentic_engagement" VARCHAR,
"engagement_avg" VARCHAR
);CREATE TABLE social_media_influencers_instagram_dec_2022 (
"rank" BIGINT,
"name" VARCHAR,
"instagram_name" VARCHAR,
"category_1" VARCHAR,
"category_2" VARCHAR,
"followers" VARCHAR,
"country" VARCHAR,
"eng_auth" VARCHAR -- Eng. (Auth.),
"eng_avg" VARCHAR -- Eng. (Avg.)
);CREATE TABLE social_media_influencers_instagram_june_2022_june_2022 (
"instagram_name" VARCHAR,
"influencer_name" VARCHAR,
"category_1" VARCHAR,
"category_2" VARCHAR,
"subscribers_count" VARCHAR,
"views_avg" VARCHAR -- Views Avg.,
"likes_avg" VARCHAR,
"comments_avg" VARCHAR -- Comments Avg.
);CREATE TABLE social_media_influencers_instagram_nov_2022 (
"s_no" BIGINT,
"name" VARCHAR,
"instagram_name" VARCHAR,
"category_1" VARCHAR,
"followers" VARCHAR,
"n__country" VARCHAR -- Country,
"eng_auth" VARCHAR -- Eng. (Auth.),
"eng_avg" VARCHAR -- Eng. (Avg.),
"category_2" VARCHAR
);CREATE TABLE social_media_influencers_instagram_sep_2022 (
"s_no" BIGINT,
"instagram_name" VARCHAR,
"n__name" VARCHAR -- Name,
"subscribers" VARCHAR,
"audience_country" VARCHAR,
"authentic_engagement" VARCHAR,
"engagement_average" VARCHAR,
"category_1" VARCHAR,
"category_2" VARCHAR
);CREATE TABLE social_media_influencers_tiktok (
"tiktoker_name" VARCHAR,
"tiktok_name" VARCHAR,
"subscribers_count" VARCHAR,
"views_avg" VARCHAR -- Views Avg.,
"likes_avg" VARCHAR,
"comments_avg" VARCHAR -- Comments Avg.,
"shares_avg" VARCHAR
);CREATE TABLE social_media_influencers_tiktok_dec_2022 (
"rank" BIGINT,
"tiktoker_name" VARCHAR,
"tiktok_name" VARCHAR,
"followers" VARCHAR,
"views_avg" VARCHAR -- Views(avg),
"likes_avg" VARCHAR -- Likes(avg.),
"comments_avg" VARCHAR -- Comments(avg.),
"shares_avg" VARCHAR -- Shares(avg.)
);CREATE TABLE social_media_influencers_tiktok_june_2022_june_2022 (
"tiktoker" VARCHAR,
"influencer_name" VARCHAR,
"subscribers_count" VARCHAR,
"views_avg" VARCHAR -- Views Avg.,
"likes_avg" VARCHAR,
"comments_avg" VARCHAR -- Comments Avg.,
"shares_avg" VARCHAR
);CREATE TABLE social_media_influencers_tiktok_nov_2022 (
"row_cell" DOUBLE,
"tiktoker_name" VARCHAR,
"tiktok_name" VARCHAR,
"n__followers" VARCHAR -- Followers,
"views_avg" VARCHAR -- Views (Avg.),
"likes_avg" VARCHAR -- Likes (Avg.),
"comments_avg" VARCHAR -- Comments (Avg.),
"shares_avg" VARCHAR -- Shares (Avg.)
);CREATE TABLE social_media_influencers_tiktok_sep_2022 (
"s_no" BIGINT,
"tiktoker_name" VARCHAR,
"tiktok_name" VARCHAR,
"subscribers" VARCHAR,
"views_avg" VARCHAR -- Views Avg.,
"likes_avg" VARCHAR -- Likes Avg.,
"comments_avg" VARCHAR -- Comments Avg.,
"shares_avg" VARCHAR -- Shares Avg.
);CREATE TABLE social_media_influencers_youtube (
"youtuber_name" VARCHAR,
"channel_name" VARCHAR,
"category" VARCHAR,
"subscribers" VARCHAR,
"audience_country" VARCHAR,
"avg_views" VARCHAR,
"avg_likes" VARCHAR,
"avg_comments" VARCHAR
);CREATE TABLE social_media_influencers_youtube_dec_2022 (
"s_no" BIGINT,
"youtube_channel" VARCHAR,
"youtuber_name" VARCHAR,
"category" VARCHAR,
"followers" VARCHAR,
"country" VARCHAR,
"n__views_avg" VARCHAR -- Views (Avg.),
"likes_avg" VARCHAR -- Likes (Avg.),
"comments_avg" VARCHAR -- Comments (Avg.),
"category_2" VARCHAR
);CREATE TABLE social_media_influencers_youtube_june_2022_june_2022 (
"channel_name" VARCHAR,
"youtuber" VARCHAR,
"category" VARCHAR,
"category_2" VARCHAR,
"subscribers_count" VARCHAR,
"country" VARCHAR,
"views_avg" VARCHAR -- Views Avg.,
"likes_avg" VARCHAR,
"comments_avg" VARCHAR -- Comments Avg.
);CREATE TABLE social_media_influencers_youtube_nov_2022 (
"s_no" BIGINT,
"youtube_channel" VARCHAR,
"youtuber_name" VARCHAR,
"category" VARCHAR,
"followers" VARCHAR,
"country" VARCHAR,
"n__views_avg" VARCHAR -- Views (Avg.),
"likes_avg" VARCHAR -- Likes (Avg.),
"comments_avg" VARCHAR -- Comments (Avg.),
"category_2" VARCHAR
);CREATE TABLE social_media_influencers_youtube_sep_2022 (
"s_no" BIGINT,
"name" VARCHAR,
"youtuber" VARCHAR,
"country" VARCHAR,
"n__subscribers" VARCHAR -- Subscribers,
"category_2" VARCHAR,
"avg_views" VARCHAR -- Avg. Views,
"avg_likes" VARCHAR -- Avg. Likes,
"avg_comments" VARCHAR,
"category_3" VARCHAR
);Anyone who has the link will be able to view this.