Calculate the number of days between two dates supermetrics datastudio

Dan Robertson

started a topic about 2 years ago

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

Heidi Virta
said about 2 years ago

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