SDITools / adobeanalyticsr

R Client for Adobe Analytics API v2.0
Other
18 stars 9 forks source link

Consider converting "date" to a date data type when returned in a query #11

Closed gilliganondata closed 3 years ago

gilliganondata commented 3 years ago

daterangeday comes back as a string from aa_freeform_report(). It would be nice if that got converted to be a date when it existed.

benrwoodard commented 3 years ago

Added a line to the final data aggregation in aa_freeform_report()

 if("daterangeday" %in% colnames(dat)) {
        dat[names(dat) == 'daterangeday'] <- as.Date(dat$daterangeday, format = '%b %d, %Y')
      }

It's in the "cleanup" branch at this time

benrwoodard commented 3 years ago

Added additional lines to support 'daterangeminute', 'daterangehour', 'daterangeweek' conversion. Note to self: pulling data as Character strings enables easier search functionality so it's not always a bad thing.