I need to cross reference Twitter followers to understand audience overlaps
- or -
Post a project like this3881
$$
- Posted:
- Proposals: 1
- Remote
- #308284
- Awarded
Description
Experience Level: Intermediate
I have the follower profiles for a newspaper. It serves a city with two football teams. It has two other accounts, one for each team.
I want to compare the followers of the publication against the followers of each team account. From this I want to get:
How many people follow both a team page AND the publication
How many people that follow the team page AND a team page
What % of the followers of the publication account follow one team and not the other
To add to that, I have the followers of the official teams. I want to repeat the process as above so I start to better understand the audience profile, based on what else the followers like.
So ultimately I need the following reports:
1. How many followers of the publication follow one or the other Publication Team Page
2. Demonstrate this as a number and as a percentage of publication followers
3. How many (and what percentage of) the publication followers follow the official team fan page
4. How many (and what percentage of) the publication followers follow BOTH a publication team page AND an official team fan page
5. How many (and what percentage of) followers follow an official team fan page BUT NOT the publication team page.
I need the data in Excel or similar format so I can see the workings
I need the key results to be presented in a graph/graphical format (ideally powerpoint) so I can use it.
Deadline: I have the data ready to go. I would like to have the results back on Tuesday 27th August 2013.
Once we have this overlap data there may be additional analysis like ranking followers by number of followers or number of tweets. We can look at that as a separate cost.
Each account has a unique ID which is their Twitter ID. I have had similar work done before on pivot tables but I am no expert!
All the data is in mulitple .csv files with some accounts stretching across 4 csv files. IN all there are about 2 million rows.
I'm happy to share example files on request and show you previous examples of work I have had done. I have attached one .csv file to show you the fields.
Feel free to ask questions.
Thanks!
I want to compare the followers of the publication against the followers of each team account. From this I want to get:
How many people follow both a team page AND the publication
How many people that follow the team page AND a team page
What % of the followers of the publication account follow one team and not the other
To add to that, I have the followers of the official teams. I want to repeat the process as above so I start to better understand the audience profile, based on what else the followers like.
So ultimately I need the following reports:
1. How many followers of the publication follow one or the other Publication Team Page
2. Demonstrate this as a number and as a percentage of publication followers
3. How many (and what percentage of) the publication followers follow the official team fan page
4. How many (and what percentage of) the publication followers follow BOTH a publication team page AND an official team fan page
5. How many (and what percentage of) followers follow an official team fan page BUT NOT the publication team page.
I need the data in Excel or similar format so I can see the workings
I need the key results to be presented in a graph/graphical format (ideally powerpoint) so I can use it.
Deadline: I have the data ready to go. I would like to have the results back on Tuesday 27th August 2013.
Once we have this overlap data there may be additional analysis like ranking followers by number of followers or number of tweets. We can look at that as a separate cost.
Each account has a unique ID which is their Twitter ID. I have had similar work done before on pivot tables but I am no expert!
All the data is in mulitple .csv files with some accounts stretching across 4 csv files. IN all there are about 2 million rows.
I'm happy to share example files on request and show you previous examples of work I have had done. I have attached one .csv file to show you the fields.
Feel free to ask questions.
Thanks!
Jamie R.
100% (6)Projects Completed
39
Freelancers worked with
18
Projects awarded
73%
Last project
6 Sep 2013
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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