Supermetrics Support Forum

Calculate the number of days between two dates supermetrics datastudio

Is it possible to create a formula to generate the campaign length in days by using the campaign start date & campaign end date dimension?


For example, campaign start date 13, July - campaign end date 20, July = 7 


  • Hi Dan,


    Thanks for your question. 


    This doesn't really go into our support scope as the formulas are a Data Studio feature, but I think there are some options for this. Please check out the DATE_DIFF function in https://support.google.com/datastudio/table/6379764?hl=en.


    Best,

    Heidi / Supermetrics

Login to post a comment