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,
the date format comes from Google Sheets. You need to select those cells/rows/columns and change the formatting:
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:
Thanks for you answer 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?
Then, the only way would be to extract all posts and count them on Gsheets?
pretty much so. At least we haven't come up with any other way.