Finance_Studio_Social_Media_Competitor_Analysis_Tool.xlsx

	A	B	C
1	Finance Studio \| Social Media Competitor Analysis Tool
2	Updated for 2026 — measures what actually drives competitive advantage today
3
4	HOW TO USE THIS TEMPLATE
5	1	Click "File > Save As" or "Download" and save a copy to your drive.
6	2	Fill in [Your Brand] first across the platforms you actively use.
7	3	Add 3–5 direct competitors. Focus on the platforms that matter for your audience — you don't need every row.
8	4	Use the Claude Prompt (tab 3) to pre-populate competitor data quickly before refining manually.
9	5	Use the Summary tab to score each competitor and spot your gaps at a glance.
10
11	WHAT'S NEW IN THIS VERSION
12	Replaced	Total Followers	Reach Tier + Follower Trend — follower counts without context are misleading; trajectory matters more
13	Replaced	Post Frequency	Content Velocity + Consistency — how often vs. how reliably, and whether AI-friendly long-form is in the mix
14	Replaced	Engagement Rate	Avg. Engagement Rate + Content Quality Score — raw rate plus a qualitative signal: does the content have a POV?
15	Added	Paid Boost Activity	Are they amplifying organic posts? Changes what their engagement numbers mean
16	Added	Newsletter / Long-form	LinkedIn newsletters, Substack, etc. — the content that builds AI citation authority
17	Added	AI Visibility Note	Can you find them in ChatGPT/Perplexity answers for your category? A quick check worth recording
18	Added	Opportunity Flag	Your own read: what gap does this competitor leave open?
19
20	MORE FINANCE STUDIO RESOURCES
21	Run a competitor analysis in 60 minutes with Claude
22	Check the blog
23	Finance Studio Ultimate Creative Brief
24	12 financial advisory website designs & why they work
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100