Supermetrics Support Forum

Back to website Post to forum Submit a ticket Feature requests My Tickets
Welcome
Login
  1. Discussions
  2. Supermetrics for Data Studio
  3. Problems & Solutions

Facebook total number of posts in Google Data Studio

W
Wonderlab Media
started a topic about 3 years ago

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

  • Heidi Virta
    said about 3 years ago

    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

  • M
    Martin Frönmark
    said over 2 years ago

     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

  • Heidi Virta
    said over 2 years ago

    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
  • M
    Martin Frönmark
    said over 2 years ago

    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?

  • Heidi Virta
    said over 2 years ago

    Hi Martin,


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


    Best,

    Heidi / Supermetrics

  • M
    Martin Frönmark
    said over 2 years ago

    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
  • D
    David Steinmayr
    said over 2 years ago

    this is genius thanks!

  • D
    Delaina McCormack
    said over 2 years ago

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

  • Heidi Virta
    said over 2 years ago

    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

  • J
    Janaye Steadman
    said almost 2 years ago

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

  • W
    Webadmin
    said almost 2 years ago

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




Topics in this forum
View all (611)

Didn't find what you were looking for?

Start a new topic