Supermetrics Support Forum

Facebook total number of posts in Google Data Studio

Hi there,


I would like to add the total number of posts by page admins for a given (monthly) period. Unfortunately I don't find a matching metric in the tool.


Can you help me there? This would be great as Interactions and Engagement Rate are bound to the number of posts so that would be a valid metric to add to my report.


Thanks,

Alice

  • Hi,


    thanks for your question.


    A metric for total amount of posts for a date range does unfortunately not exist directly in Facebook API. I have anyway added this as a feature request, but it will likely not be implemented very soon.


    Please use a table graph to get your posts, and look at the row amount to see the amount of posts.


    Best,

    Supermetrics team

  •  Hi there,


    But there is. There's the URL https://graph.facebook.com/v3.2/{page_id}/published_posts/

    And it's possible to ask for the total count for a time period by specifying: summary=total_count


    Could you maybe have another go at this?


    Best Regards,

    Martin

  • Hi Martin,


    thanks for your message.

    I'll forward this tip to our developers to see if they would be willing to add the field for Post Count.

    Meanwhile, I hope you noticed our workaround: https://support.supermetrics.com/support/solutions/articles/19000090790-how-do-i-get-the-count-of-posts-in-data-studio-


    Best,

    Heidi / Supermetrics


    1 person likes this
  • Thank you for that! However, it does not seem possible to use this in a Scorecard because it's not really a metric. Am I right?

  • Hi Martin,


    That is true, you are right. You'll need to add it to a graph that contains some metrics.


    Best,

    Heidi / Supermetrics

  • I think I figured it out by doing this (introducing a metric into the calculated field): Comments on post - Comments on post  + (SUM(CASE WHEN Post ID IS NULL THEN 0 ELSE 1 END))


    2 people like this
  • this is genius thanks!

  • I'm confused. Could someone share the instructions step by step to show number of posts per page in a given date range?

  • Hi Delaina,


    The instructions can be found here:

    https://support.supermetrics.com/support/solutions/articles/19000090790-how-do-i-get-the-count-of-posts-in-data-studio-


    If there seems to be errors or issues in getting the post count, you can always contact us through a private support ticket, and we'll be happy to help.


    Best,

    Heidi / Supermetrics team

  • @Martin you are brilliant! Thank you so much!!

  • Doesn't work anymore. Something has changed in SuperMetrics and now adding a metric into a filter doesn't remove the error anymore.




Login to post a comment