Supermetrics Support Forum

questions about the facebook ads manager connector to google data studio

Hey, 3 questions

1. how can i show in a table only camapaigns that are active? (by delivery) 

2. how can i add a dimension/metric of start date so i can sort the campaigns table by their start date?

3. i want to see the ads of the campaigns themselves: image + text, or at least a link to the ad preview, how can i do that?


  • - update - 

    I have a campaign table with a filer of campaign status = ACTIVE

    but I still see campaigns that are not active, also i see the same campaign duplicated in the table over and over again.

    How can I fix the bug/issue?

    (BTW I succeeded in adding start date dimension)

  • Hi Omer,

    To answer your questions:

    #1 - You should be able to add a filter for "Campaign status (effective status)" to the table and set it to "Equal to" ACTIVE. Inactive campaigns shouldn't show at all, but those paused can and this should remove them.



    #2 - The Dimension "Start Date" should be the one you need.

    #3 - This is not possible, yet. Google just added expanded image functionality to Data Studio this week though, so we are investigating if we can pull the images from the data sources to make this possible. Keep an eye out for this feature in the near future.

    -Thank you

    Supermetrics Team

  • Hi Omer,

    Sorry the ticket didn't update with your update.

    For the status issue, what's the full query you are trying to use?

    -Thank you

    Supermetrics Team

  • image

Login to post a comment