Pipes Metrics

Custom Columns

Facebook & DS support custom columns, once set up in the interface you can use them in your dataset, and import them into Pipes Metrics as you would with any other column..

Facebook Breakdowns

When reporting on facebook data you are limited to certain combinations of breakdowns, the full list is: https://developers.facebook.com/docs/marketing-api/insights/breakdowns/#combiningbreakdowns You can add breakdowns as a normal column in the report, for example to see "Platform position" as a breakdown you would need to also include the "Publisher platform" column in your report.

Including Data Up To Now

Ticking this box in Pipes will extend the selected date range so that it ends on the current date. For example choosing "Last Month" and ticking would include data from the beginning of the previous month up to today.

Referencing Data In Other Sheets

Normal cell references may be broken when the report updates. To use the data provided by Pipes Metrics in other sheets you'll need the INDIRECT function: =INDIRECT("SheetName!B10")