Second Brain: Crafted, Curated, Connected, Compounded on 10月02日 21:08
Obsidian在业务管理中的应用
index_new5.html
../../../zaker_core/zaker_tpl_static/wap/tpl_guoji1.html

 

本文探讨了如何利用Obsidian这款笔记软件进行高效的业务管理。作者分享了其个人经验,包括为每家公司创建独立笔记并使用'Inc'后缀进行区分,以实现CRM笔记与第二大脑内容的分离。文章介绍了Obsidian的模板功能,特别是如何通过标签(如#crmssp)配合Obsidian Projects插件实现项目管理,并展示了表格视图和看板视图(Sales Funnel)的应用。此外,作者强调了使用开放文件格式Markdown的重要性,以确保知识的长期可访问性,并分享了如何利用Dataview插件对Markdown文件中的元数据进行聚合分析,例如统计文章的字数。

📝 **Obsidian作为CRM工具的实践**:作者通过为每家公司创建独立的笔记,并在文件名后添加'Inc'后缀,有效地区分了CRM相关笔记与个人知识库内容,便于管理。同时,利用Obsidian Projects插件和特定的标签(#crmssp),可以实现对业务项目状态的可视化管理,如通过表格视图和看板视图(Sales Funnel)跟踪销售漏斗和项目进度。

💡 **Markdown开放格式的价值**:文章强调了采用开放文件格式Markdown的重要性。作者分享了因OneNote数据导出困难而损失知识的经历,以此说明Markdown格式的持久性,能够确保用户在未来(如5到10年后)仍能轻松访问和读取自己的数据,实现“文件即应用”的理念。

📊 **利用Dataview插件进行数据聚合与分析**:作者展示了如何通过为Markdown文件添加元数据,并结合Dataview插件,在Obsidian内部实现类似电子表格的数据聚合和分析功能。例如,可以方便地统计文章的总字数、平均字数、最大/最小值,以及按月分析保留金(Retainer)等关键业务指标,无需依赖外部工具。

🚀 **Obsidian核心功能与工作流集成**:文章提及了Obsidian自2025年5月22日起新增的核心项目管理功能'Bases',其优势在于将项目元数据集成到YAML扩展名为'.base'的普通文件中,简化了配置。作者还提到了Basecamp用于待办事项和客户协作,但核心业务管理仍集中在Obsidian中,显示了Obsidian在构建个人或团队工作流中的中心地位。

I manage my business mostly with Obsidian. I have a note for each company (I add Inc to each note name “Company Inc”) and add them to my CRM. Inc is helpful because I usually have another note for the company itself or if they have a product, so I have a clear separation between my “notes” and part of the second brain and business-related CRM notes.

My template looks like the one below, whereas #crmssp is the tag that the Plugin Obsidian Projects looks for. I use mainly “table view” and the “sales funnel” (a Kanban board) for checking status.

Bases: Core Plugin

Since 2025-05-22, there is a new core, built-in project management called Bases. The main advantage, the metadata of project-plugin was hidden in setting folders, bases uses a YAML with the extension .base that gets integrated as normal file. Nice.

# Examples

Table View:

Sales Funnel with Kanban Vihttps://www.ssp.sh/brain/Managing%20My%20Business%20with%20Obsidian-20241024114240048.webp1024114240048.webp">

Writing Board whttps://www.ssp.sh/brain/Managing%20My%20Business%20with%20Obsidian-1741271038252.webp20with%20Obsidian-1741271038252.webp">

I have another page where I track income and outcomes. I use Basecamp for Todo’s with a reminder, also I can collaborate with customers, but everything else is in Obsidian.

Template for CRM:

 1 2 3 4 5 6 7 8 9101112131415161718192021222324252627
---Work: BlogsAction: Needs AssessmentType: 2-ProspectHotness: 5-ColdEmail: ""Created: <% tp.date.now("YYYY-MM-DD") %>Origin:Timing: ""Segment: ""Comment: ---# <% tp.file.title %>## Potential Work & Discussions## Log- ## About Company---References: Created <% tp.date.now(&

# Obsidian and File Format

Obsidian is not for everyone, but what I would encourage everyone, is to use an open file format: Markdown. File Over App.

Just for the simple reason that if you spend time to write things down, that you are sure you can read it in 5 years, 10 years still. I’m not sure if Notion will be there or Obsidian, but I know for a fact that text files will still be a thing. As someone who used OneNote for 10 years, I lost a good amount of knowledge while trying to export the data out of it…

# Spreadsheet like Aggregation bases on Markdown

I wanted to have a simple average word count of my articles. As I write them all in Obsidian, I thought about how I could have a nice overview.

Instead of creating an external spreadsheet, I added the metadata to each blog article and query them with Dataview.

And it works!

This is how it looks in Obsidian. See thehttps://www.ssp.sh/brain/Managing%20My%20Business%20with%20Obsidian-1742235646022.webpg%20My%20Business%20with%20Obsidian-1742235646022.webp">

These are the Obsidian Dataview queries:

Retainer written:

12345678
```dataviewTABLE     word_count AS "Word Count",    retainer AS "Retainer-Month",    date AS "Date Created"FROM "path-to-folder"WHERE customer = "XXX" AND retainerSORT retainer ASC

Retainer

 1 2 3 4 5 6 7 8 91011121314151617
```dataviewTABLE WITHOUT ID     Count AS "Articles Count",     Total AS "Total Words",     round(Average) AS "Average Words",     3000 AS "Submitted Words",    round(3000 - (Average - 3000)) AS "Next Month Target",    Minimum AS "Min",     Maximum AS "Max"FROM "path-to folder"WHERE customer = "XXX" AND retainer AND word_countGROUP BY ""FLATTEN length(rows) as CountFLATTEN sum(rows.word_count) as TotalFLATTEN Total / Count as AverageFLATTEN min(rows.word_count) as MinimumFLATTEN max(rows.word_count) as Maximum

# Further Reads


Origin: Does anyone use Obsidian to manage their business : r/ObsidianMD
References: Freelancing SSP DATA, Obsidian
Created 2024-10-24

Fish AI Reader

Fish AI Reader

AI辅助创作,多种专业模板,深度分析,高质量内容生成。从观点提取到深度思考,FishAI为您提供全方位的创作支持。新版本引入自定义参数,让您的创作更加个性化和精准。

FishAI

FishAI

鱼阅,AI 时代的下一个智能信息助手,助你摆脱信息焦虑

联系邮箱 441953276@qq.com

相关标签

Obsidian CRM Markdown Dataview Project Management Second Brain Knowledge Management Business Management Obsidian Projects Bases
相关文章