Supermetrics Support Forum

Split by and sort by -

Hi,


I am working on mny Facebook reporting and I would like to split my result by campaign. 


However, I would like to sort these results by date, so I get the first week with the first ad set in the first row. Is it possible? 


I have looked in metrics and I can't add it, Neither can I "sort by" in the date section. In the split by, there is a"sort by" section but I can't choose "date"if it's not split by week.

 

Tx!

  • Hi Matthieu,


    I'm not quite sure I understood your request. With the following setup, you'll sort by date and then get for example "Clicks" -metrics from every campaign that you have on the selected dates:


    image


    Best regards,

    -Supermetrics Team


  • Hi,


    You are quick on the answer!


    My problem is that I must "split to row" = campaign.

    On the "split to column" section, I leave it empty since I want my metric to show in column(1 row = 1 campaign with all the metrics in separate column).(see dash 2)


    If I do what you say, the dashboard is not useful anymore since it creates a kind of matrix report.(see dash 1)


    I only want my campaign(row) to be sorted by - date without including the date in the "split ...".

    I can't split by week since my campaign are not exactly 1 week long.


    Tx! 


    dash 2.PNG
    (13.3 KB)
    dash 1.PNG
    (13.8 KB)
  • Hi Matthieu,


    I understand the problem with "matrix" report. The only other option that I can think of is this kind of query:


    image


    Best regards,

    -Supermetrics Team

Login to post a comment