Pulling social media data into a SQL database- URGENT
- or -
Post a project like this£200(approx. $251)
- Posted:
- Proposals: 3
- Remote
- #1737688
- Expired
Description
Experience Level: Entry
This piece of week needs to be integrated with the existing code we have for this project. This needs to be delivered to us by Friday 6th October AM BST time.
I have the code and will share it once you have been shortlisted.
A solution that downloads all relevant data, for all Organisations, Celebrities and Social Media Entities from the publicly available APIs across this clients key Social Media channels into a SQL database
• All code to be written in C#
• Database to be SQL 2016
We need to pull a number of elements from Twitter- Hashtags, i.e. those that don't have a handle.
This is what we need to pull:
TWITTER – HASHTAGS (FOR PEOPLE WHO DON’T HAVE A HANDLE)
T1. Number of tweets for given hashtag: this needs to simply query the twitter API based on a single hashtag e.g. #barackobama. There needs to be the ability for the client to enter a hashtag of their choice, and it makes a query and delivers a result
T2. Engagement on hashtag- this needs to the total number of times the hashtag has been engaged with - for example how many times the hashtag has been clicked on OR whatever is possible with the API, but something similar.
T3. Number of tweets tagged with said hashtag over a period of time (configurable)-the same as point T1 but configurable, so I want to see how many time #barackobama has been used over say 3 months
T4. Number of likes on above tweets linked to hashtag- so the tweet the hashtag has been included in, the number of time it has been liked.
T5. Number of retweets on above tweets linked to hashtag- same as T4 but the number of times the tweet, that has the hashtag, has been retweeted
I have the code and will share it once you have been shortlisted.
A solution that downloads all relevant data, for all Organisations, Celebrities and Social Media Entities from the publicly available APIs across this clients key Social Media channels into a SQL database
• All code to be written in C#
• Database to be SQL 2016
We need to pull a number of elements from Twitter- Hashtags, i.e. those that don't have a handle.
This is what we need to pull:
TWITTER – HASHTAGS (FOR PEOPLE WHO DON’T HAVE A HANDLE)
T1. Number of tweets for given hashtag: this needs to simply query the twitter API based on a single hashtag e.g. #barackobama. There needs to be the ability for the client to enter a hashtag of their choice, and it makes a query and delivers a result
T2. Engagement on hashtag- this needs to the total number of times the hashtag has been engaged with - for example how many times the hashtag has been clicked on OR whatever is possible with the API, but something similar.
T3. Number of tweets tagged with said hashtag over a period of time (configurable)-the same as point T1 but configurable, so I want to see how many time #barackobama has been used over say 3 months
T4. Number of likes on above tweets linked to hashtag- so the tweet the hashtag has been included in, the number of time it has been liked.
T5. Number of retweets on above tweets linked to hashtag- same as T4 but the number of times the tweet, that has the hashtag, has been retweeted
Isha P.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
11 May 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi,
This seems an interesting job, but I want to clarify few things.
You are saying SQL database, SQL is a language. But which database do you want to use? Like SQL Server or Oracle? And how much of C# code do you have?
Looking forward to hear from you.
Regards,
Chaudhry
515780
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies