Discussions
Get Monthly Click Report
over 1 year ago by Isaiah Davis
Hi Rebrandly,
Can your API be enhanced to export a summary report of clicks (bonus would include a column for unique clicks) per month?
Psuedo Code
def startdate: <"2021-06-11T18:18:53.000Z"> #any datetime format
def month: <6> #6 months from startdate (e.g. Sunday, May 14, 2023)
def monthSort: "desc"
def columns: [ id, createdAt, shortUrl, destination, status, clicks, sessions, months:desc ]
Expected Result
id | createdAt | shortUrl | destination | status | clicks | sessions | May | Apr | Mar | Feb | Jan | Dec |
---|---|---|---|---|---|---|---|---|---|---|---|---|
cd3ea03a1a17420bae892df009124c4c | 2021-06-11T18:18:53.000Z | 2021-06-11 | domain.subdomain/global | https://www.google.com | 120 | 120 | 20 | 40 | 20 | 10 | 10 | 20 |