Open Forum

 View Only
  • 1.  Separating revenue by admission type vs session item

    Posted 02-05-2024 16:10

    Hello Community,

    I am new to Cvent and struggling with the reporting features. I need to find a way to see what revenue came in by admission items only total, separate from session items that have a fee with them. I found how to see how much revenue each separate admission item garnered, but I'd like to see the total of all my admission items without having to do the math myself. We have some sessions that have a fee associated with them, and a donations option and I don't want those included in the total. Just the admission price solely. 

    Thank you for your help!

    -Chelsea


    #Reporting

    ------------------------------
    Chelsea Skalski
    Events Manager
    Georgia Dental AssociationUnited States
    ------------------------------


  • 2.  RE: Separating revenue by admission type vs session item
    Best Answer

    Posted 02-07-2024 10:15

    Hi Chelsea,

    Hope you are well!

    I checked about this and you can try running 'Agenda Item Financial Overview' report. You'll have to change the report data to only display Admission items revenue data in the report. PFB the steps for your reference :

    Please go to your event > Reports > Reports > Search for Agenda Item Financial Overview > Run the report > At top right, click "Data" > Change Report Data > Click on the drop down under 'Agenda Item Type' > Only select "Admission Item > Run.

    When you have the data infront of you then you'll have to filter the data. Below are the steps for that :

    For the graphical representation, click on the ellipses infront of 'Agenda Item' and click on Edit > Under 'Grouping', remove 'Agenda Item Name' > Update > Scroll down to 'Financial Summary' and edit the section the same way and under Groupings tab, only keep 'Agenda Item Type' option > Update > At top right, click on Actions > Export the report in excel format. 

    The second sheet in the file will show the graph at the top and below that it will show you the consolidated sum of the revenue generated from the Agenda items.

    You can refer to the following articles for your reference :

    Which report should I run? == LINK : : https://support.cvent.com/s/communityarticle/Which-Report-Should-I-Run

    Your Guide to Running Reports in Cvent == LINK : : https://support.cvent.com/s/communityarticle/Your-Guide-to-Running-Reports-in-Cvent

    I hope this helps.  Please let us know if you have any further questions.



    ------------------------------
    Raashi Semwal Khati
    Senior Quality Analyst
    Cvent
    ------------------------------



  • 3.  RE: Separating revenue by admission type vs session item

    Posted 02-07-2024 11:53

    Thank you @Raashi Semwal Khati! This is so helpful



    ------------------------------
    Chelsea Skalski
    Events Manager
    Georgia Dental AssociationUnited States
    ------------------------------



  • 4.  RE: Separating revenue by admission type vs session item

    Posted 02-07-2024 12:00

    Hi Chelsea,

    Thank you for your response.

    I am pleased to have provided the necessary assistance and ensured that you received the answer you were seeking.

    I encourage you to mark this answer as 'Best answer' to indicate that it has helped you resolve the query. Marking a response as best answer gives that comment visibility and as a result helps the fellow community users. 

    Do let us know if you have any further questions.

    Have a wonderful week ahead!



    ------------------------------
    Raashi Semwal Khati
    Senior Quality Analyst
    Cvent
    ------------------------------