I have a use case that calls for a "Sent Date" field that is actually a date field and not a date time field in "Email Logs"
Use Case: Customer wants to create a report where we are looking at email stats grouped by "Triggered Date" and "Batch Name".
What we've noticed is that in reporting this leads to scenario's where we see "duplicates" (same "date, same batch name.... 2 row instead of 1)
In debugging this issue, you are not able to "Summarize By" a Date/Time field which is causing these multiple entries entries to occur. In looking at email logs there doesn't appears to be a "Sent Date" that is just a date and not a date time. Is this something we have plans to add? Its holding up a key report that we're trying to build.
New Idea
Simple "Date" Field For Email Logs (Triggered Date/Triggered On)
- reneehouse
- john_apple
- alison_kaprielian
- jean.nairon
- jessie_brainerd
- ben
- sarah_johnson
- link_black
- hitesh_sharma
- angie_delarosa
- phil_kowalski
- katie_b
- mark_gecsey
- melissa_davenport
- anthonysabato
- asaf_alshech
- nadav_shemtov
- christin_sambor
- phil_hart
- cmultanen
- lane_h
- andrew_biehle
- seth
- lesliediephuis
- jeffrey_boyer
- tom_gerth
- heather_hansen
- pele
- darkknight
- spencer_engel
- dan_ahrens
- lorena_vargas
- sai_ram
- denim
- David_Fink
- veneza_viamontes
- nora_soza
- lauren_s
- rbegley
- amy_perrin
- amanda_sepe
- sophie
- shiv_kumar_katiyar
- jeremy_curry
- colleen_ayres
- chuen_moschetti_1466d2
- nick_cellini
- ana_g
- jnunes
- iloukanova
- sashasoci
- edleguizamo
- gunjanm
- cynthiam
- tammy_c
- jochle
- thomascardamone
- robinmeijer
- CurtisValentine
- lmnmegan
- bradley
- Megrob15
- Steph Costa
- caroline.harris
+2Hi Steve, the fall release will have a function in the rules engine to convert DateTime to Date:
See this doc: https://docs.google.com/document/d/13OlzSoHBeqnQLyX8WIiBA92za6Jkr5EHcX331mCcbjk/edit#heading=h.b16pryozflna
Section 3 covers the new functions.
Would this work for your use case?
See this doc: https://docs.google.com/document/d/13OlzSoHBeqnQLyX8WIiBA92za6Jkr5EHcX331mCcbjk/edit#heading=h.b16pryozflna
Section 3 covers the new functions.
Would this work for your use case?
VP of Customer Success at Forcepoint
1 person likes this
+2Dan, Can you slack me and maybe we'll setup a few minutes to chat about it. My short answer.... not sure 🙂
+2Sure thing.
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.