Discussions

Ask a Question
Back to All

Get Monthly Click Report

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

idcreatedAtshortUrldestinationstatusclickssessionsMayAprMarFebJanDec
cd3ea03a1a17420bae892df009124c4c2021-06-11T18:18:53.000Z2021-06-11domain.subdomain/globalhttps://www.google.com120120204020101020