Start a new topic
Solved

Tweet like count (Twitter) / Likes count (Instagram)

Why 'Tweet like count' from Twitter and 'Likes count' from Instagram returns me data like 1899-12-30 or 1900-01-04? It seems more like a weird date format... Shouldn't it be a natural number?


By the way, is there any way to get my # of followers on Instagram and Twitter categorized by week and / or month to analyze growth? It's an important data for me.


Thanks in advance,


Tomas






Hi Tomas,


the date format comes from Google Sheets. You need to select those cells/rows/columns and change the formatting:

image



If the query type offers this option, then it's possible to start collecting that data with Supermetrics feature, but neither of those data sources offer historic data of those numbers:

image



Best regards,

-Supermetrics Team




Thanks for you answer Jouni!

Hi Tomás,

glad that we could help!


Best regards,
-Supermetrics Team

Hi Jouni!


Just one more question: do you know from where I can get get the # of posts we' ve done on our Fb page, categorized per week and month?


Thanks again,


Tomas

Hi Tomás. 

unfortunately Facebook doesn't offer such metric from their API.


Best regards,
-Supermetrics Team

Then, the only way would be to extract all posts and count them on Gsheets?

Hi Tomás,


pretty much so. At least we haven't come up with any other way.



Best regards,

-Supermetrics Team

Login or Signup to post a comment