Supermetrics Support Forum

Date gets an empty header row if also split to columns

I have a query for Google Analytics that is Split to Rows: "Year & Month" and Split to Columns: "Campaign".

I need the data in Google Data Studio but the problem is that Google doesn't give me the first column as a dimension because using both Split to Rows and Split to Columns makes it so the first cell is empty (instead of containing "Month" as I expected).


I need the header row to update with future queries because the names of the Campaigns can change. How do I get "Month" into the first cell so that Google Data Studio will allow me to use that column as a date dimension?


1 person has this problem
  • Hi,


    have you checked that your formatting for that column isn't doing this? If it's not about the formatting, could you please list us the details from your query:


    -Date range

    -Metrics

    -Split by values (rows and columns)


    Best regards,

    -Supermetrics Team

  • Hi was there a solution to this problem? I am getting the same error?

  • Hi Tim,


    when I do a query like this, I get the headers correctly:


    image


    Best regards,

    -Supermetrics Team


  • Hi Im querying DFP (Google Double Click for publisher) no matter what I try I get the same error. Unless I remove the Split by Columns the Header just disappears. This means I cant use the data in Data studio? Any other ideas?

Login to post a comment