digoal
2023-10-08
PostgreSQL , DuckDB , 大平台 , 商业化 , 金主控制 , 流量变现 , 老面孔化 , 活跃度下降 , 广告氛围浓厚 , 中立性下降 , 权威性下降 , 新鲜人群增长下降 , KOL自媒体崛起 , 广告投入产出下降 , 流量分流 , 轻运营 , 回归人本位 , 回归技术 , 回归用户
在大平台老化、KOL自媒体崛起背景下的联盟社区形态分析和运营方法
copy (
select
pgp_sym_decrypt($_$\xc30d04090302eb941e181c003899fdd2cbd801599553621e9dd24319c811fe6b1dbe52f1ee663d4d83aaf02ac4716ddb5a9cf1b1d401841f0b018bae293dced68655e7757e2734207883ce53605174df397930f0c1159028d4c952e392bedc23e72da70b1aa96713da1a96ebc72f67d1716049eec052187b84a5e5ddb7c41ac2a5630cd20580134cbfff363f3a959814999ec44900dc83d5024c57a3749254123c9bc6eb9274a2f5d45ca757f35a85207159418f563b54ad41573d6e19a4fb20cb8387210df7b03992f747af39f5e50c8ca0259fa416724cb060479cbe423fadfc67d61e9e37ec93bfde360467c706ec56087e9cc0c742790171d5360ab5abaa435842f03232f662858c3f2e6ba142470da128577c08f9644b494732a2b65b95a3144bbf4b652477720ad1074802105d9cd05fd97dd897b45f24764d0887e3226d572d87a4fcffc4542f84174efb81adb4ff29150dbe0a11f4aa5dc994d1ab536e6897e6fb46a19aa66809ee1cf7fa05237d6027de1ce5e8df835c6535f79519b6be1af18a69d8912765b34970e46e69180afa0d7f21f84e2249487ebdfc8f7b1e616cd8a32ace54d1c1b1d91df6f3ecc3dd438c427ce1a67df347d2884dc3ac311d10f2a3ad4b7b6bbca79ef0bf44d11db129cdb2e41c5be03b7e99e19e509c5bd6088cc397911dbe4650e67d810c3ebcbf764ae775a73ab627ea324788e9bc2b5689fe8f683e2469b0722f603556695781db24b3e0a0dad24a82005a97cdee9ae7babe21f2ea54f3617c73baa2e730c296f578a72e253d0ec5657c679d66a70b2eafec43dc3e339e5378d35396c6bac86ea1f830300378e5c16600328bf1eaea40349b704230d51d0a9a40c31878a4e23724b1653862e5a1fe4965ede4e033f8f98272eed6446e2cbc4f3d43d6617887f3c4aecc03f0a38fe0248935314f4dbe677bc4a3757c5b5b8b17b4727314c2f1345b2a6dc613b858f3cfab90ea783beb85fc9074ddf5963c795cb6bce4bc81361cd16b38ec4aad4ef703a8dc3326560a1ac54732052bdc435743209cd6b4f41d6123ede51a705f8c729d9445f18d6fd76ad8dbb0d6431a1f0d43b82c9563193d1a9d7b621ce6928caa177d8d0a2c8def6baa8d8bb2f0428816a6eba8f8b108ebc4db2a8bf366b97cb97ab834fa9f67c9cf587c9a9cbde7ee0c4b3394c2051b1cdd40a41abc30b8d6b0709882e0bc0be02e42c1623da8014156a227a8d93a07f1df2dbed0108448cf58dca3352cf84bb31c7175f96f7a3489d8c3c0d36bae61a658693655dd4c7fadb86d9a2df5029e3f4b57f2f0a4d4a57c96aa0aa223e4f8ef6c0c8e53efd2b733281b03729b4c18631d6568a7437c8aabc1c609a7873fae06a4592dbb451c7f24ee6f85eb977f15a3103fda03f640ac5e18182df16cd7791ed12d33d6301b19546a73431317ac027760edbdb65779519eea3d39fd00ef9fe09f9dd99bcb682332cb3891eaf284c512617d9c548cb189ff8cf1bf12577347e917f46dd5901820e2b4b58258ed34fddc0b9da2e093920f9f8dfa6f40c935ffae3ba51c008e83fa01016e2779419e55385e155cac31041479d8fc08b2563b1c4ef41124a4c88b9932926a62f1b89488ba8c30078e5490a93e473db5e58369d3dab571d3aebea367449a0d3d9a7da9cb00547d4d41a762d56b572d9557f2e83b58a797d9e13dbb0e6fa6022947171fe256d453f9d269a7f688e58b070d00aaa691733aea78d598a8437465b81eebdb7f76a17825437b18db24d1a30ea1595fb06ca47d27a734758ca71aed53fafcb673685e7abdbb7a427200402364bb57a823d66c5f3b78dc23323224c3b23f6de44c3fc3a766cab06504bb40e52c123a971ef01d9d2e3c75791c7179c5f535e5c7a74d52252cce8f7fb27620646f4017706ae180341f1fcea2f5880bab42c6cba16c5d17df1c96c69afeeb9f775920d16fb53c23075c860b7daebf59b52c0c4cb1409a1b3ae5a0bd40c23e4a5597c10cde73a9c1b7c499da9d78dcab97894e020ef63c0de76879433320489c167452359b0d0df19cd63ab6b5af0b5dab8510c482ca423e06db592b9ff1952b237112cd683b2d063e8aaa430a0ede17ec0614cb10aaee7dcb2dba26eddf4e571b6c4ed23f7c687fa83df688900adc59e334521064a140b8ac2eaaae4a42c216c93f376b8c72c2b74e942908f5f7b14d51faf40f77145c8cf63fd23a364bf5491d880787368fd6b54913b05c2ecf39c9aeb88ba8a57b9423546aedce7e9c10a7521b68fda5d4afc02f239429b01673cbb4dcc8e1d9e2226295c7b895c6c33c88a1551ed31872dbe983deb55271da4b7d065d3d101bbce2267b00fd985eb07885a4483dd721c3c88c6646a9d276b5617e855b0f6300bafcf436dc7ce684f609d062765b0aa47867949311738c122db65aef58f7af966af5b0aa9325d0cfb9b7373e0bee3a3bd3fee09a5b9ac73c3d636b71a20b75a052fb23b8eac10b15ee7fec7d7faa85225f37036561e32fe05e9170c35fb3638c3ca85d01975f3a84cae43fe94f206c94b9e9615c38d22f6d0860b206790f51e191d1cde6204409353c78b3f10901c5dfe637c029e1191f34b50b8a00bc9750c27d2015497b37726cca2ecba3d54bcd51cc09d0771e048a580aefe9515cc826e982861ead485e793e7cf23f7a1a765c1e6dd754c974c03ac71ad53b1308077156faedce2cd947bc21a6720f24adde76a2be627bfa76f86b5005e96bbe1e96bf3b78cd47d213e04f47f693d3cf7620c0a07ee315bfbbb6dd25e92458d3d430e0dbb86ee66198754b04aae1311b58fc3597730560aae2aeaaea5c93750de11b124eec42fd08e2d3daa5fe5cd2089ad48f740fa6321ad90a0141ffa76bbb2970167771521b55d52d5ba942567f40e70efb71eebdc7301495e7a1226901b676e653b544337a74ab43d40079524279970eb798e3263c171eb25e2de550fe2fecc974ae4cf6d48c5eb62c573e84f8281bdc423ed7824f18ddd90fdb37f13d49bf13411f0c7f4cc8fa8ff74f58abd8c40877967406973feae622855cd53213e8b09b6bb27a8353f6f25823321bff519af93d1c03250b21ffe8814805f20e549b1857606a15253af250fa110ccda2d5e0f2161a5278b3ad3d8a682520be2ffdc6f521c40c1b5d5d02a2b7074ee375497e00d63dace499b572d320ae6b56e0560ea4c2d76d6705dba63348ade5856006c70f21c06264abd6258b48034a3588937877c23b29dca3877ff3b0acc6868465a7cd3946a69230f8022ef95c866c53db905b7d22b4952826c40af136e2c69e53105338667be9e9bdc6c35f378cb2912d769f90755ec59ff26f78cc17471f625f4a250770067afbaae23bfd1f6cd9682924f2ba3f130d8ca631b2fcaab95246f8fa204af3997a9fc0f7dcd2efaa4f00c01e7e247cb18f63066e82b974d20f793dcebd02d174999c07cfed806f27c05162577f01b9274b0334de162f5ed0b98592a73b39c010d836a2f0399d5aa525dfd489bfae7b0821dd22bedc8e041092b48bff325a51a907d6e550da24f53b106d0913d0a9f21ff9a4a89319c1a0a39f3d1b61d1e6f5b63906c1008169d6cf12099c665ebf087a12650d07a10002450e4b49217eb99ec677e46da7b755716bda1c7de9e31d3f185419f26959b2256167d406711740151e26d282f831f74d981b83dc88971fb743484fa0d98408113d9cb78c291ebce9770a7bbca19eb70957cdb7763800de44a8aee8a117f327bed85b4ab1d5bc896333eaa8792962771f3ce76d19388c7f40a8d4790731dfc849f6d165ad1aadde5454e4cb0b59e290cc22eb54e7c3386306c079bc1a144022c24334b73f744696258863403fc9ad9e074bd6f7a143316c49c31ad34ce0b7ea829f3582a855a62d0b5e66cb8129059cc09ea38884ce205026567d5e940c55e3284f07cecf2cb1b97de18a585d2cf59849287b9d2046f06b55523067c9c6aac90aba06b4710244a7ad01085a4e91e8a41fadb9b62b9789d01632a48590aca30d1027cd7e01cc257bb1f64b319efeffc3d9c6edfce366e1718db7056e39a6f92dd1a204a43c5c5122fb25a7f743e063e82a084987b92aa730b78c4df94994ee9b45da11233286e18a19b607502761ce6d7fc38d779d1f793f69bd080f01a055ef6bb6f14611d7378fe93c95d68ba7182d09ff8ee5d8638bac3b0907f49882b146f7746e35a1e7fcdba6c19b14c6310206a51264fe8ba8b0723aa9d5a0a372d6ee7ed4456126f4b05b7abc653adeb137a9b5c85098af94ddd70e8c37dec500940ba8c2bc511957c6068cccaf305470bab9cccd2f214b78fe8c680d542a5557e329c2684f9a58125707dffeb01fca724e2915e5783796cfaabe4fc6f209ae4ee6ae1b04a7a47c051509fd62aaacb722dba051e1e7058e3e8ee975fc5478beef3d3197b84d731b7548eb1de9226d546aecd44d1df6de03a9777c63bc55662de2b4fab796a4e863daf93ba94c91688ec7895a7bee57657c67233a4fbc92622b730bbd9e7500370b48dd1f31c03f69b98a856aa1912f2417f31397fabbc25417a1f669f6e6ee48b3$_$, 'z...j'
)) to stdout with csv;
