I'm attempting to do a basic analysis of email promotion response windows, as I feel like I've noticed changes in patterns over the last year. Is there a (not-highly-custom set up) way of pulling First Order and Last Order dates per Source in Analytics?
While I'm reasonably comfortable that I could accurately wrangle a data set to export and then manipulate in a spreadsheet, this sounds dreadful as a project and I'd love a path into it that doesn't require data scrubbing first.I did try to search for existing threads like this and found nothing, but please feel free to point me to something already posted as your reply. Thank you!
Hi Jamie,
If you have Source on rows of a Pivot table widget, you could create values for:
MIN( [Calendar Year] * 10000 + [Calendar Month] * 100 + [Calendar Day of Month] )MAX( [Calendar Year] * 10000 + [Calendar Month] * 100 + [Calendar Day of Month] )
Where each of those value fields is selected from the ORDER DATE dimension.