I want to make a ppt with the content in red in the “STC 444 outline” file and the content in yellow in the file are some websites for you to find the analysis charts and images to explain or describe what you write. The “1” and “2” images are the examples of the analysis charts or images.
The “STC 444 Ford” is an example of the ppt. The most important thing is to find a big amount of analysis charts or images like the two examples i give to you. In my ppt, you do not need to use a lot of words to make a brief summary.
I also need the presentation script for each page. It is better to use some simple words so it is more convinient for me to present.
The previous sections in the last file “Tesla vs Hyundai” are what my team members write for your reference and what i need to write is the fifth part “Sentiment Analysis”. You can open a new ppt file to write and send to me.
Social Media Analytics
STC 444, Spring
2024
Brand & Top Competitor Social Media Profiles:
Potential Presentation & Report Elements
Identify social media profile
Socialmedia platforms:
Pinterest,
Snapchat,
Weibo, WeChat, Bilibili,
Organic & paidsocial
components
Facebook, Twitter, Instagram, YouTube,
TikTok,
Reddit, LinkedIn,
Twitch, Dailymotion, Mixer, Flickr,
Red Book, top influencers/content providers
media activity
Briefly describe the content of each
component and key dimensions
Content categories or sections
Type of content (text,
graphic, photo, carousel,video, reel, short, link)
Top posts
(per interval, e.g., 7 days,
30 days)
Content, post type,
view
of post within social media platform
Selected post metrics, by post type
Total posts
& trends, daily,
hourly, top hours
Post hashtag lists,
activity, engagement
Briefly describe the overall traffic patterns
and analyses for each
component
and key dimensions
Engagement total,
rate
Reactions (likes, dislikes, loves, hahas, wows, sads,
angrys)
Comments,
shares, reshares,
retweets,
saves
Total followers,
page
fans,
subscribers, views, boards, pins,
following
Post/tweet
types (status, reply, photo, video, link, event), Likely Boosted
flag, last update
Word clouds and other content analyses,
sentiment scores (±), sentiment
analyses
Top influencers–total followers,
potential
reach, search by hashtag, handle,
keywords
Use data from
multiple sources
Data differences often
due to method, demographic & time
frame
differences
Compare
and contrast your
brand and top competitor components, content, and
traffic
Implications for strategy
What is driving your
brands success?
What can be improved?
What is missing?
Integrate
below.
and reference
data
sources (e.g.,
mostly dot coms
[*.com]) listed
Integrate
partial screen shots, attach longer material as appendices.
Awario
Brandwatch
RapidMiner
RivalIQ
Socialtracker
Statista (UM)
Brand24
Reviewbolt
Speakrj
Buzzsumo
RStudio & R analytic tools
theEnginuity
Cloutmeter
Reportgarden
Trackalytics
Emplify.io
Similarweb (UM, SRDS)
Tweetreach
Exolyt
SentimentViz
Unionmetrics
Instametrica
SocialBlade
Unmetric
Mention
Social-graph.info
Others, e.g., brand
social
NoxInfluencer
Social-searcher
media
accounts
Octoparse
Socialsearch
Page
Although
data sources are listed alphabetically
above
similarity
of several names, theywill be presented
consistent with
the project components.
1
of
2
due to list size and the
in class
in an order
Be on the lookout for new or additional data services not on this list that may help you
flesh
out your
brand and competitor social media footprint.
See the presentation and report assignment for ideas
on how to organize,
prepare,
and submit your
report, presentation, and supporting material.As noted in the
assignment, case study final
presentations,
reports and confidential peer
evaluation submissions are due before or during the scheduled finalexam
period for the course on Tuesday,
May7, 8:00am 10:30am.
Enjoy!
Page
2
of
2
Social Media Analytics
STC 444, Spring
2024
Brand & Top Competitor Social Media Profiles:
Potential Presentation & Report Elements
Identify social media profile
Socialmedia platforms:
Pinterest,
Snapchat,
Weibo, WeChat, Bilibili,
Organic & paidsocial
components
Facebook, Twitter, Instagram, YouTube,
TikTok,
Reddit, LinkedIn,
Twitch, Dailymotion, Mixer, Flickr,
Red Book, top influencers/content providers
media activity
Briefly describe the content of each
component and key dimensions
Content categories or sections
Type of content (text,
graphic, photo, carousel,video, reel, short, link)
Top posts
(per interval, e.g., 7 days,
30 days)
Content, post type,
view
of post within social media platform
Selected post metrics, by post type
Total posts
& trends, daily,
hourly, top hours
Post hashtag lists,
activity, engagement
Briefly describe the overall traffic patterns
and analyses for each
component
and key dimensions
Engagement total,
rate
Reactions (likes, dislikes, loves, hahas, wows, sads,
angrys)
Comments,
shares, reshares,
retweets,
saves
Total followers,
page
fans,
subscribers, views, boards, pins,
following
Post/tweet
types (status, reply, photo, video, link, event), Likely Boosted
flag, last update
Word clouds and other content analyses,
sentiment scores (±), sentiment
analyses
Top influencers–total followers,
potential
reach, search by hashtag, handle,
keywords
Use data from
multiple sources
Data differences often
due to method, demographic & time
frame
differences
Compare
and contrast your
brand and top competitor components, content, and
traffic
Implications for strategy
What is driving your
brands success?
What can be improved?
What is missing?
Integrate
below.
and reference
data
sources (e.g.,
mostly dot coms
[*.com]) listed
Integrate
partial screen shots, attach longer material as appendices.
Awario
Brandwatch
RapidMiner
RivalIQ
Socialtracker
Statista (UM)
Brand24
Reviewbolt
Speakrj
Buzzsumo
RStudio & R analytic tools
theEnginuity
Cloutmeter
Reportgarden
Trackalytics
Emplify.io
Similarweb (UM, SRDS)
Tweetreach
Exolyt
SentimentViz
Unionmetrics
Instametrica
SocialBlade
Unmetric
Mention
Social-graph.info
Others, e.g., brand
social
NoxInfluencer
Social-searcher
media
accounts
Octoparse
Socialsearch
Page
Although
data sources are listed alphabetically
above
similarity
of several names, theywill be presented
consistent with
the project components.
1
of
2
due to list size and the
in class
in an order
Be on the lookout for new or additional data services not on this list that may help you
flesh
out your
brand and competitor social media footprint.
See the presentation and report assignment for ideas
on how to organize,
prepare,
and submit your
report, presentation, and supporting material.As noted in the
assignment, case study final
presentations,
reports and confidential peer
evaluation submissions are due before or during the scheduled finalexam
period for the course on Tuesday,
May7, 8:00am 10:30am.
Enjoy!
Page
2
of
2
FORD MOTORS
Digital & Social Media Pro?le
Dane Sinks, Morgan Powell, Alessandra Bonadies,
Savannah Yates, Valentina Pope
Table of Contents
Ford Introduction/Background
Ford Summary Diagram
Top Competitor (Honda)
Honda Summary Diagram
Social Media Pro?le
Components Comparison
? Social Media Content
Comparison
? Traf?c Pattern Comparison
? Recommendations
?
?
?
?
?
Introduction & Background
?
?
?
Brand History
? Founded in 1903 by by Henry Ford
? Headquartered in Dearborn,
Michigan
? 186,000 employees
? 5th largest automobile
manufacturer by production
volume
Target Audience
? Variety of different consumers
based on the vehicle being sold
(e.g. adult males for pickup trucks)
Mission Statement/Purpose
? We are here for one purpose, to
help build a better world, where
every person is free to move and
pursue their dreams.
Source: Statistia
Source: All Sources +
Semrush for traf?c
Ford Summary Diagram
Top Competitor: Honda
?
?
?
?
Who is Honda?
Brand History:
?
Founded in 1948 in Hamamatsu,
Japan by Soichiro Honda and Takeo
Fujisawa
?
215,638 employees (2018)
?
7th largest automobile manufacturer
by production volume
Target Audience:
?
Variety of different consumers based
on vehicles being sold with an
emphasis on affordability and
reliability more so than Ford
Vision Statement:
?
Serve people worldwide with the joy
of expanding their lifes potential
?
Lead the advancement of mobility
and enable people everywhere in the
world to improve their daily lives
Source: Britannica,
Honda, Statistia
All sources + Semrush
for traf?c
Honda Summary Diagram
Ford
Main Domain:
?
Ford
Sub Domains:
?
?
?
Global Links
Ford Media Center
Ford Foundation
?
Ford Shareholders
Social Media:
Instagram
Facebook
Twitter
TikTok
Youtube
Overview Social
Media Platforms
Honda
Main Domain:
?
Honda
Sub Domains:
?
?
?
Honda Global
Honda Newsroom
Honda Racing
Social Media:
Instagram
Facebook
Twitter
TikTok
Youtube
Content & Traf?c
Patterns: Ford vs.
Honda
Website Comparison
Source:
SimilarWeb
Website Comparison
Source: SimilarWeb
Engagement &
Traf?c Comparison
Source: SimilarWeb
Engagement & Traf?c
Comparison Social Media
Source: Rival IQ
Organic Search Comparison
Source: SimilarWeb
Paid Search Comparison
Source: SimilarWeb
Comparison across 5 social media
platforms
Source: Unmetric
Post Types Comparison (Ford)
Source: Rival IQ
Post Types Comparison (Honda)
Source: Rival IQ
Source: Rival IQ
Post Times Comparison
Paid & Organic Social Media:
In?uencers (Ford)
Combination
of 3 platforms
American Muscle
Company that carries Ford (mostly Mustang)
parts and accessories
Mike Levin
Director of
Product
Communications
at Ford Motor
Company
Heather Storm
T.V. host and lifestyle
vlogger
Source: Klear
Paid & Organic Social Media:
In?uencer Program (Ford)
Mustang partnered up with actor Idris Elba and 10 social media
in?uencers to get the word out about the new Mustang Mach-E
They used Idris Elba in their
commercial because of his ties
to Ford: in the 80s he worked in
one of their factories and his
father also worked for Ford
The 10 in?uencers were a part of a puzzle of photos that together
formed the silhouette of the Mach-E. They were discoverable using
the hashtag #ElectricAndUntamed
Source: thedrum.com
Paid & Organic Social Media:
In?uencers (Honda)
Source: in?uence.co
Instagram Content Comparison
Ford & Honda
?
?
?
?
?
?
?
Both have a high amount of followers
Both are veri?ed
Product photos
Diverse locations and backgrounds
Combinations of photos and videos grouped
together into posts
Ford has a lot less posts than Honda
Ford is only following 4 people back, while
Honda follows 274
? Follows speci?c car handles
? Ex. @fordbronco
Ford
Honda
Instagram Traf?c Patterns Comparison
(metrics from the last month)
Ford
Avg. engagement: metric used
to assess the average number
of interactions your social
media content receives per
follower
Honda
Source: Unmetric
Source: Social Blade
Instagram: Traf?c Patterns
Comparison (Ford)
Source: Social Blade
Instagram: Traf?c Patterns
Comparison (Honda)
Source: Rival IQ
Followers Comparison: Instagram
Source: Rival IQ
Posts Comparison: Instagram
Hashtag Comparison: Instagram
Source: Rival IQ
Top Posts: Instagram (Ford)
Top Posts: Instagram (Ford)
Top Posts: Instagram (Honda)
Top Posts: Instagram (Honda)
Top Facebook Posts (Ford)
Top Facebook Posts (Honda)
Facebook Traf?c Patterns Comparison
(metrics from the last month)
Ford
Honda
Source: Unmetric
Source: Social Blade
Facebook: Traf?c Patterns Comparison (Ford)
Facebook: Traf?c Patterns Comparison (Honda)
Source: Social Blade
Source: Rival IQ
Facebook: Follower Comparison
Facebook: Posts Comparison
Source: Rival IQ
Facebook: Posts Comparison (Ford = Blue) (Honda = Pink)
Source: SocialBakers
Twitter: Content Comparison
Twitter Traf?c Patterns Comparison
(metrics from the last month)
Ford
Honda
Source: Unmetric
Twitter: Traf?c Patterns Comparison (Ford)
Source: Social Blade
Twitter: Traf?c Patterns Comparison (Honda)
Source: Social Blade
Source: Rival IQ
Twitter: Followers & Tweets Comparison
Source: Rival IQ
Twitter: Posts Comparison (Ford = Pink)
Source: SocialBakers
Top Posts: Twitter (Ford)
Top Posts: Twitter (Ford)
Top Posts: Twitter (Honda)
Tik Tok: Content Comparison
FORD
–
185.9K followers (more
than double the
amount Honda has)
Highest views: 6M
Lowest views: 92.2K
Content: car videos
and some real people
making videos with
their Fords
Last posted: April 12
(not consistent)
Only 11 videos
HONDA
76.6K followers
Lowest views: 2,460
Highest views:
326.8K
Content: some car
videos, some real
people, and some
random content
Last posted April 12
(not consistent)
More videos than
Ford
–
–
Source: TikTok
Source: Social Blade
Tik Tok: Traf?c Patterns Comparison (Ford)
Source: analisa.io
Tik Tok: Traf?c Patterns Comparison (Honda)
Source: Social Blade
Source: analisa.io
Top Tik Tok Videos (Ford)
https://www.tiktok.com/@ford/video/70724479847
84379179?is_copy_url=1&is_from_webapp=v1?=
en
https://www.tiktok.com/@ford/video/708573
2190532799786?is_copy_url=1&is_from_weba
pp=v1?=en
Top Tik Tok Videos (Honda)
@honda The next generation is taking shape…
_source=google&utm_medium=cpc&utm_campaign=smm-nademo-ppc-prospect-competitors-en&utm_content=CompetitorBrand24&utm_term=brand%2024&cq_src=google_ads&cq_cmp=10038065027&cq
_term=brand%2024&cq_plac=&cq_net=g&cq_plt=gp&gad_source=1&gclid=Cj0KCQiAr8eqBhD3ARIsAIe-buNjI
wBc6c47BDovUu5ipFJXReIL-f4ivPm72c4WAd-HeHSF9HlVJ4QaAma_EALw_wcB
https://www.instagram.com/rarebeauty/?hl=en
https://www.instagram.com/fentybeauty/?hl=en
https://hypeauditor.com/instagram/rarebeauty/
https://www.statista.com/statistics/670550/leading-beauty-brands-instagram-engagement/
https://www.jasondavies.com/wordcloud/
https://analisa.io/?ref=njm3owq&gclid=Cj0KCQiAr8eqBhD3ARIsAIe-buMWDNZHoTueVfPXboglPgKk_LgaXGC
HvIL53nf8K4VJk1omxY_jQEwaAiafEALw_wcB
https://socialblade.com/
https://www.glossy.co/beauty/glossy-case-study-how-tarte-kate-spade-and-fenty-paired-influencers-andevents-to-amplify-awareness/#:~:text=Fenty%20Beauty%20sponsored%20Super%20Bowl,%2C%201.7%20m
illion%20TikTok%20followers)
FORD MOTORS
Digital & Social Media Pro?le
Dane Sinks, Morgan Powell, Alessandra Bonadies,
Savannah Yates, Valentina Pope
Table of Contents
Ford Introduction/Background
Ford Summary Diagram
Top Competitor (Honda)
Honda Summary Diagram
Social Media Pro?le
Components Comparison
? Social Media Content
Comparison
? Traf?c Pattern Comparison
? Recommendations
?
?
?
?
?
Introduction & Background
?
?
?
Brand History
? Founded in 1903 by by Henry Ford
? Headquartered in Dearborn,
Michigan
? 186,000 employees
? 5th largest automobile
manufacturer by production
volume
Target Audience
? Variety of different consumers
based on the vehicle being sold
(e.g. adult males for pickup trucks)
Mission Statement/Purpose
? We are here for one purpose, to
help build a better world, where
every person is free to move and
pursue their dreams.
Source: Statistia
Source: All Sources +
Semrush for traf?c
Ford Summary Diagram
Top Competitor: Honda
?
?
?
?
Who is Honda?
Brand History:
?
Founded in 1948 in Hamamatsu,
Japan by Soichiro Honda and Takeo
Fujisawa
?
215,638 employees (2018)
?
7th largest automobile manufacturer
by production volume
Target Audience:
?
Variety of different consumers based
on vehicles being sold with an
emphasis on affordability and
reliability more so than Ford
Vision Statement:
?
Serve people worldwide with the joy
of expanding their lifes potential
?
Lead the advancement of mobility
and enable people everywhere in the
world to improve their daily lives
Source: Britannica,
Honda, Statistia
All sources + Semrush
for traf?c
Honda Summary Diagram
Ford
Main Domain:
?
Ford
Sub Domains:
?
?
?
Global Links
Ford Media Center
Ford Foundation
?
Ford Shareholders
Social Media:
Instagram
Facebook
Twitter
TikTok
Youtube
Overview Social
Media Platforms
Honda
Main Domain:
?
Honda
Sub Domains:
?
?
?
Honda Global
Honda Newsroom
Honda Racing
Social Media:
Instagram
Facebook
Twitter
TikTok
Youtube
Content & Traf?c
Patterns: Ford vs.
Honda
Website Comparison
Source:
SimilarWeb
Website Comparison
Source: SimilarWeb
Engagement &
Traf?c Comparison
Source: SimilarWeb
Engagement & Traf?c
Comparison Social Media
Source: Rival IQ
Organic Search Comparison
Source: SimilarWeb
Paid Search Comparison
Source: SimilarWeb
Comparison across 5 social media
platforms
Source: Unmetric
Post Types Comparison (Ford)
Source: Rival IQ
Post Types Comparison (Honda)
Source: Rival IQ
Source: Rival IQ
Post Times Comparison
Paid & Organic Social Media:
In?uencers (Ford)
Combination
of 3 platforms
American Muscle
Company that carries Ford (mostly Mustang)
parts and accessories
Mike Levin
Director of
Product
Communications
at Ford Motor
Company
Heather Storm
T.V. host and lifestyle
vlogger
Source: Klear
Paid & Organic Social Media:
In?uencer Program (Ford)
Mustang partnered up with actor Idris Elba and 10 social media
in?uencers to get the word out about the new Mustang Mach-E
They used Idris Elba in their
commercial because of his ties
to Ford: in the 80s he worked in
one of their factories and his
father also worked for Ford
The 10 in?uencers were a part of a puzzle of photos that together
formed the silhouette of the Mach-E. They were discoverable using
the hashtag #ElectricAndUntamed
Source: thedrum.com
Paid & Organic Social Media:
In?uencers (Honda)
Source: in?uence.co
Instagram Content Comparison
Ford & Honda
?
?
?
?
?
?
?
Both have a high amount of followers
Both are veri?ed
Product photos
Diverse locations and backgrounds
Combinations of photos and videos grouped
together into posts
Ford has a lot less posts than Honda
Ford is only following 4 people back, while
Honda follows 274
? Follows speci?c car handles
? Ex. @fordbronco
Ford
Honda
Instagram Traf?c Patterns Comparison
(metrics from the last month)
Ford
Avg. engagement: metric used
to assess the average number
of interactions your social
media content receives per
follower
Honda
Source: Unmetric
Source: Social Blade
Instagram: Traf?c Patterns
Comparison (Ford)
Source: Social Blade
Instagram: Traf?c Patterns
Comparison (Honda)
Source: Rival IQ
Followers Comparison: Instagram
Source: Rival IQ
Posts Comparison: Instagram
Hashtag Comparison: Instagram
Source: Rival IQ
Top Posts: Instagram (Ford)
Top Posts: Instagram (Ford)
Top Posts: Instagram (Honda)
Top Posts: Instagram (Honda)
Top Facebook Posts (Ford)
Top Facebook Posts (Honda)
Facebook Traf?c Patterns Comparison
(metrics from the last month)
Ford
Honda
Source: Unmetric
Source: Social Blade
Facebook: Traf?c Patterns Comparison (Ford)
Facebook: Traf?c Patterns Comparison (Honda)
Source: Social Blade
Source: Rival IQ
Facebook: Follower Comparison
Facebook: Posts Comparison
Source: Rival IQ
Facebook: Posts Comparison (Ford = Blue) (Honda = Pink)
Source: SocialBakers
Twitter: Content Comparison
Twitter Traf?c Patterns Comparison
(metrics from the last month)
Ford
Honda
Source: Unmetric
Twitter: Traf?c Patterns Comparison (Ford)
Source: Social Blade
Twitter: Traf?c Patterns Comparison (Honda)
Source: Social Blade
Source: Rival IQ
Twitter: Followers & Tweets Comparison
Source: Rival IQ
Twitter: Posts Comparison (Ford = Pink)
Source: SocialBakers
Top Posts: Twitter (Ford)
Top Posts: Twitter (Ford)
Top Posts: Twitter (Honda)
Tik Tok: Content Comparison
FORD
–
185.9K followers (more
than double the
amount Honda has)
Highest views: 6M
Lowest views: 92.2K
Content: car videos
and some real people
making videos with
their Fords
Last posted: April 12
(not consistent)
Only 11 videos
HONDA
76.6K followers
Lowest views: 2,460
Highest views:
326.8K
Content: some car
videos, some real
people, and some
random content
Last posted April 12
(not consistent)
More videos than
Ford
–
–
Source: TikTok
Source: Social Blade
Tik Tok: Traf?c Patterns Comparison (Ford)
Source: analisa.io
Tik Tok: Traf?c Patterns Comparison (Honda)
Source: Social Blade
Source: analisa.io
Top Tik Tok Videos (Ford)
https://www.tiktok.com/@ford/video/70724479847
84379179?is_copy_url=1&is_from_we
