FB(api) to Google Data Studio

I'm facing a problem that when I set the dimension to AD name, the "reach" metric shows "null", how can I solve this? 


Thank you.


1 person has this problem
  • Here's the screen shot.

  • There's more in my case, looks like more things don't work. A lot of metric won't show and there are problems with dimensions as well.

  • Hi Liu Andy, 


    With unique metrics such as 'reach' where the data source calculates the metric to be a unique count, it's usually doing the calculation based on a specific object - ad, campaign, account, post, etc. So, if the query isn't split in a unique enough way, you could get a null result. In this case, I'd guess that you have ads with the exact same name and Supermetrics has tried to sum those and failed to do so as they should be unique counts for unique objects.


    Basically what is happening behind the scenes is this error:

    Can't Be Calculated, Would Require Summing Deduplicated Values


    So basically, adding Ad ID as a dimension to your query should resolve the issue. Please see this article for more information.


    Best regards,

    -Supermetrics Team

  • Hi Philips CEE_North, 


    Please take a few minutes to submit a support ticket about whatever issues you've encountered and we'd be happy to assist in resolving them.


    Best regards,

    -Supermetrics Team

Login to post a comment