Scheduled Rebills - Flexstats
The new Affiliate Transactions Report displays transaction data for Affiliate Accounts (merchant accounts do not have access to this report) can be found in the same place as our original reports:
- Sign in to the Admin Portal: https://admin.ccbill.com/loginMM.cgi.
- Select the Reports Mega Menu.
- Click to select the Alphabetical List tab.
- Click the S button on the left.
- Click Scheduled Rebills - FlexStats.
- Click Open Report.
The stats are displayed for Tomorrow, Next 7 Days, Next 14 Days, Next 30 Days, and Next 90 Days, with Next 7 Days being the default for the graph below the Quick Stats.
Each individual break down displays the following:
- Count. The number of rebills scheduled for the indicated timeframe.
- Total $USD. The total dollar amount, in US Dollars, of the rebills scheduled for the timeframe indicated.
Working With GraphsThe graphing tools are located immediately below the Quick Stats section of the report.
The following sections explain the various options available to you when selecting graphing options. Once you’ve selected all of your desired options select the Go! button to load the customized graph.
The graph displayed is fully filterable, allowing you to design a graph with only the data you care about displayed. By default ALL options are pre-selected for you. You may change the data you wish to have displayed in the graph by clicking the All On button.
Clicking the button loads the filter settings for the graph. You may deselect any unwanted items in the Payment Types column, and you may choose to filter by Days of the Week and Countries as well.
Once you have selected all of the option desired, click one of the action buttons at the bottom:
- Update & Run. This option closes the filter options and immediately runs the report with the new filters.
- Update Only. This option saves your filter choices and returns you to the Graphing Options to select further options for the graph run.
- Cancel. This option disregards your changes and removes the Filter Settings menu from view.
Note, because this report is designed for future transactions, you may not select a date range in the past.
After selecting or entering your date range information click one of the following buttons:
- Continue. Selecting this option saves your choices and returns you to the main Graphing Options menu.
- Cancel. Discards your changes and returns you to the main Graphing Options menu.
The drop-down menu beneath Show these values on graph allows you to decide which values you want to view. Select from the following:
- All Scheduled Rebills
- Payment Type
- Rebill #
- Affiliate ID Yes/No
The report can display data in the following time units:
Chart Tweaking, Use, and LegendOnce you’ve loaded a customized graph you can use the options on the left of the graph to further refine your view.
The Scale section allows you to toggle the graph between Count and Amount, basically how many and how much: how many transactions of the selected type and how much is the total of the transactions of the selected type. Selected scale information is represented as the X-axis of the resulting chart.
The Time Unit section allows you to quickly break the graph down into other time units. Be aware that time units can make the graphs difficult to read when you select a broad time range in the Graphing Options and then select a detailed time unit from this menu. Viewing hourly data is best done with a daily graph as opposed to a WTD, MTD, or YTD report. The time unit is represented as the Y-Axis of the resulting chart.
These charts are very interactive. If you hover over any point on the chart it will provide you with pop-up details about that plotted point.
The bottom of the chart provides you with a legend for the plotted data to help you better understand your chart.
On the legend below, the greyed out icons indicate items not included in the chart. The items in color indicate that both Rebills and New Sales are included in the chart above, and displays the line color and plot icon used for those transaction types in the chart.
Working with GraphsFor each action done in the graphing options above the system loads not only the chart that you see immediately, but if you scroll down below that you’ll see that it also loads a Snapshot Graph based on your options and a Legend/List that provides more details.
The graphs are very attractive and display income and deductions—color coded to breakdown the rebill types. The pie chart default can be changed to a bar chart by selecting the other icon in the bottom left of the screen.
As with the charts above, hovering over an item in either report will provide you with further details about the graph area.
If you have experience with CCBill’s reporting system, you know that there’s always a way to further break down reports. With these new reports the Breakdown By happens in the pie or bar charts.
After loading the report, scroll to the bottom and locate the item on the graph that you wish to view breakdown details about, then click that item. A small breakdown by menu pops up.
Once you select an item from the breakdown by menu another graph will load at the bottom of the page. This example breaks down the 6+ Rebill section displayed in the screenshot above by Payment Type:
You’ll notice that again, you have the option at the bottom left of the graph to toggle between pie and bar graphs, and the items in the graph are fully color-coded and defined in the list below the chart.
The Breakdown By drop-down menu can be changed to one of the other available breakdown by options to immediately refresh the graph with the new breakdown data.
You may further breakdown this report by clicking on one of the Slices/Bars in the graph and selecting an additional breakdown by option. The new breakdown will load to the right of the original.
Click the X to close any of the breakdown graphs. Additionally, running a new breakdown by from the first listed graph will clear the previous breakdown by options from the screen.
All of the graphs that you create using the methods above can be downloaded for later use. Click on the icon next to the graph, then select the format you wish to save the graph as from the drop-down menu.
Follow the on-screen prompts to save the file to your computer.