I need someone to
1) go through a spreadsheet of shortened links we've used to track clicks;
2) visit the link and record the dates (year, month and day) in column B (this data is in the hover over of the bar graph on that page), number of clicks for those dates in column C, the current date in column D, and total clicks in column E of the spreadsheet.
The separator in lists of columns B and C should be ', ' meaning comma and space.
Large clicks count numbers should not contain commas or dots.
Example: 214072 instead of 214,072 or the European 214.072
All dates should be in YYYY-MM-DD format. Use the 1st of the month to represent a month from the graph of a bit.ly link.
Example: "November 2017" should be represented as 2017-11-01.
The dates in column B and corresponding counts in column C should be in chronological order from earliest to latest.
You will need to create a bit.ly account and log in before you will be able to get the data correctly. If you aren't logged into a bit.ly account, you will see clicks by day and for a smaller range than needed.
I'll get you on a spreadsheet with examples once you're contracted.
More than 30 hrs/week
Less than 1 month< 1 monthProject LengthDuration
I am looking for freelancers with the lowest rates