codingshot commented 5 months ago

Description

See if donors were already following a public profiles on the social.near account

Objective / Business Insight

see if we can strategically target on chain followers to push towards donations
posts forma. project on chain about potlock may convert into donations and may need to encourage projects to increase that

Acceptance Criterion
[ ] see donation field
[ ] append was Fllowing and when if was following
[ ] see if the project followed them or if there was mutaul following
[ ] show average number of unique donors who they donated to and percentage of donations and unique donors by followers

Data Sources

social.near - see follow graph
regisry.potlock.near
Similar Queries
if donros already had near socila profile account and their past on chain activity
Challenges

Resources

How to Present

katarinalaw commented 4 months ago

https://flipsidecrypto.xyz/klaw/did-donors-also-follow-projects-did-donors-also-follow-projects-uN3jmk

Will keep working on it and update the dashboard as I go.

katarinalaw commented 3 months ago

https://flipsidecrypto.xyz/klaw/q/AWd4ytfSnWla/followers-count

Wrote the query to check whether potlock's donors are also following potlock. There are some results when you run it but there are some syntax error which I'm unable to fix (SQL compilation error: syntax error line 72 at position 3 unexpected '.'.) since I'm unable to locate line 72.

yiaduke commented 3 months ago

Sure, I got COVID yesterday. I will try to write the query when I recover.

Get Outlook for Androidhttps://aka.ms/AAb9ysg

From: Katarina Law @.> Sent: Thursday, March 21, 2024 3:53:36 PM To: PotLock/data-queries @.> Cc: Du, Zhuobing @.>; Assign @.> Subject: Re: [PotLock/data-queries] [📊 DATA] Did Donors Also Follow Projects 🟠 (Issue #6)

https://flipsidecrypto.xyz/klaw/q/AWd4ytfSnWla/followers-count

Wrote the query to check whether potlock's donors are also following potlock. There are some results when you run it but there are some syntax error which I'm unable to fix (SQL compilation error: syntax error line 72 at position 3 unexpected '.'.) since I'm unable to locate line 72.

— Reply to this email directly, view it on GitHubhttps://github.com/PotLock/data-queries/issues/6#issuecomment-2013987235, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVNXXYGDWM4TF7AOJACGJ4DYZNQHBAVCNFSM6AAAAABCQ2VT7SVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAMJTHE4DOMRTGU. You are receiving this because you were assigned.Message ID: @.***>

yiaduke commented 3 months ago

https://flipsidecrypto.xyz/klaw/q/AWd4ytfSnWla/followers-count It seems that the query runs well without any syntax error.

katarinalaw commented 3 months ago

Updated the query. Let me know if this is right @codingshot

https://flipsidecrypto.xyz/klaw/did-donors-also-follow-projects-uN3jmk