Skip to main content

Summary

Do you have the need to review your revenue per each content type you sell and identify trends year over year? Keep reading to learn how!

Requirement Overview:

If any of these requirements fit your end goal, this may be the play for you.

  • Requirement 1: Show the revenue per content type per year
  • Requirement 2: Show the trend of revenue over the past X years
  • Requirement 3: Display the data in an easy to read line graph

Functional area to be used:

  • Reporting > Create

Core Functionality Configurations:

Description:

Using any Explore in the Transaction (Site) section of the Create page, display Total Net revenue and year of transaction, then pivot on the content type. 

Configuration

  1. Navigate to the Reporting > Create page (/learn/manager/reporting-hub/custom-reports).
  2. Choose any report under the Transactions section.
  3. Choose the below fields to display and filter (add other filters if required also).
    • In the screenshot, we selected Item Type Translated, Year-Timestamp Date, and Total Net to display. We selected Email, Successful Payment (Yes/No), Time-Timestamp Date, and Title to filter.
      AD_4nXcfHwbWGlAxT9Szt36ZouOhHiECJ2AXqDhHV1DvtKLc2wT4k0AI1K5K1OEq8PJr4WQuyImMqxkz_vhrcTTu1SE6CEeGspnbQmy-Aarx5UVkV_daR1cnthPuvPV1s3FT1hAgsLY3?key=U8GGlspiLqEtGWXxELEgj2zs
  4. Ensure to choose the Pivot icon on the Item Type Translated label.
    AD_4nXff89TtUHPk9JrSEVtnhZ6V_jL_Lw4JMIhcH6ei3Eo2O9xWGFGwfCtG6Kt4mq7DuwMqi353GMMxX9bJYqWh17opDfP5tuO4p2ElpmCrArpAMzfUsAK-k9Ycn2czDvHBSj83aNOLzg?key=U8GGlspiLqEtGWXxELEgj2zs
  5. Click into the Visualization tab to change from a table format to a line graph format.AD_4nXf4ipb3SjlwJ4o3fIHChC7YA52dAbTeiE_doUHtOLmEwzIMmyLX3ZqvLqfSdsmue2jfp-L6uJCLxhx2aa0_LJeVR5pgTNqw0ljbEIDuy00_zxqh_XEdGxX1CIPx0MboSBg2L22Vtg?key=U8GGlspiLqEtGWXxELEgj2zs
  6. Enter the settings below to show a dot at each date marker as well as the corresponding value. You can change the colors of the lines here if you wish also.

    AD_4nXeHrEAI7ZX_RNTiFXaDPMC57T-qEu3-XND0UX3bVD7W-ZO4i68NIAZQ14vCSYr0pFTGcuivfTi548XWSXsvZ4XQxbbG-rKCdCszLVjFOC7hv62OTUNnN3uYxIyUFFTdtpGuiVrTcg?key=U8GGlspiLqEtGWXxELEgj2zs   AD_4nXcyYDMzp7uLM3GcqyopnzWd2FRXSdufVj_wvDeddgduD6HgRWfQGNok4SfSfNTsvKsiC4OQjZPrt78A31SvTmNr0wFgAkR4tZCiZ6HmDoWjmEIJI9cf2mihgsXS3oAP7vQ4ZMp7Mw?key=U8GGlspiLqEtGWXxELEgj2zs    AD_4nXc5rr4Wx2Jt4YY5LSrOiyWaM6LmzmyPuPLMh4tVq5C2b1QNJuu8xdhSOJ3-GR4HEKjkuAh7ad14OSXl2O7HIg5Hy1VR4D35eHD006Rw231U4TpQSyfc13Fq7Cxavhgx3QvuQYLv?key=U8GGlspiLqEtGWXxELEgj2zs     AD_4nXc-_Py2s-o0boQqUN0lQ9qWSapNqYLGEhHs0W6uGYsq31GqZj_w4QNtYPlmFu5lhrx3FDQyPTAef27Abk5f0tRbNm8lHHGGfuA_foElqIfw8F7nquzTHCCJ1UaBQksQBrHeWWN8?key=U8GGlspiLqEtGWXxELEgj2zs       AD_4nXfzRxJVcWG_Tx2JZeO7YpkDCMHMuDX7uYhW0wz4EPK5h_7jNjsTnoPMFAB8WTm1Vt_nViJPeJwjP_wEBoHTmX_vfYjLMwLwgz1XcIRRbBoeDH079Ed42n-VJzyk3yWNRYNXCGxRjA?key=U8GGlspiLqEtGWXxELEgj2zs

  7. Click on AD_4nXen4fobjoPGQbDVOvrMRJ7G2CMbuwMm7HTGz_tzbo9pS1Fq4y-Uk2oXiDXtgGg-IldlsXX9lXTxgTHu3WRR5b7zmWBgSosuf32HpiL7u0f33DQmlR0r_JEXectcgJ5HnGPD9RbfFw?key=U8GGlspiLqEtGWXxELEgj2zs  and your graph will now look like this:AD_4nXe8dCK5hd0FQaEe9Zk6ciKrI69Qs4jr1fJaZiiRC6lXwo2l0_JKN3YpU4zi8lyLSD6497SUdgqv-3K9canONAbdPyH2HuhrWWED568wgGwoLoLVxQluMF1tRbnjKB_STtbkNDrcbA?key=U8GGlspiLqEtGWXxELEgj2zs
  8. If you prefer, you can change from line graph to bar graph for a different comparison perspective:AD_4nXe9SHFV0bcuL9mX-nzxez2J8cTRksoEGeh1HgbUBx5ruDNy4QlSkqghOH09hnjBloyRjJdyf4WDMej8Df-qDv0Jm-rZozH9iKA7jfLRrQzwwNqA-i7Q8IQmL4fh4aWAM7wPUGwixw?key=U8GGlspiLqEtGWXxELEgj2zs
  9. Once you are happy with your graph, click the gear icon in the top right corner and choose whether you want to save as a Look or to an existing or new Dashboard.

    AD_4nXdNn0sVgGUv49caNr8q54hj6MmDjxnqR9MImTO812Xi0M8QthG0nHe5ApdL4tZ2wuZd4aBXhKPgvIPvlV9reU5qXL9G8eI9RQQnS-lk7mdNdb7H6DGKJMmzCv4hXoDSZcr7hYNu?key=U8GGlspiLqEtGWXxELEgj2zs

    You cannot use the save to new dashboard option at this step if you'd like it to be in the Group folder and therefore, visible to other users. Choose save to an existing dashboard to add it to a dashboard within a Group folder.

Risks and considerations:

  • Your report may need to be filtered differently if you only charge for one content type.
  • You can change your Timestamp date to Month if you want to see the trajectory over a year and not compare year over year.
  • If you have a large volume of content types, you may need to limit the number of types you report on in order to get a readable display.
Be the first to reply!

Reply