Start a new topic
Solved

Date dimension in Facebook public data connector.

Hi,



I'm using Facebook public page data connector


I would like to see daily total reactions breakdown by day but now there is no date dimension. I have to use post create time instead.


image


image



Question is...

1.  Do you have date dimension? If yes, how can I use it?


2. Do you have any ways to convert  create time dimension to date dimension?




Thank you,


Noppon 


1 Comment

Hi Noppon,

#1 - Sadly not, the public data connector mostly works off of lifetime totals for the reaction metrics and aren't affected by date ranges, which is why it's not included. Note that the Facebook Insights connector has the same kind of problem - it only shows the reactions based on the publish date of the post and aggregates them over the lifetime of the post. It can't show what reaction was given on a certain day after that.


#2 - As noted above though, it only works off the published date of the post anyway so you can't use standard dates to gather the reactions on each day. Only over the post's lifetime. 


-Thank you

Supermetrics Team

Login or Signup to post a comment