Merchant Reporting: Difference between revisions
No edit summary |
|||
| (12 intermediate revisions by the same user not shown) | |||
| Line 7: | Line 7: | ||
[[File:Export options.PNG|none|border|200px]] | [[File:Export options.PNG|none|border|200px]] | ||
There are certain restrictions to the downloading of reports | There are certain restrictions to the downloading of reports; you are only able to download a three month span of any report but this can be from any time. For example if you would like to download January-March of 2017 this is possible but downloading January-September of this year is not. | ||
If the report you would like to download | If the report you would like to download exceeds the above restrictions you can save it to TAG. Where it will be stored indefinitely and accessible through the drop down menu below reports. | ||
[[File:Save Report - merchant.PNG|none|border|650px]] | [[File:Save Report - merchant.PNG|none|border|650px]] | ||
On most reports you can view impression made by creatives affiliates have pulled form TAG; to do so ensure you have checked the 'include impressions' tick box on the customise report banner to the left. | |||
==Standard Report== | ==Standard Report== | ||
| Line 41: | Line 43: | ||
The program report will show you clicks and sales by program with the program each row is referring to displayed in the far left column. | The program report will show you clicks and sales by program with the program each row is referring to displayed in the far left column. | ||
[[File:Program report.png|border|none|650px]] | |||
Similar to the affiliate and standard reports you can customise the features using the drop down menus on the left. | Similar to the affiliate and standard reports you can customise the features using the drop down menus on the left. | ||
| Line 59: | Line 61: | ||
[[File:Customise - Creative report.PNG|border|none|200px]] | [[File:Customise - Creative report.PNG|border|none|200px]] | ||
You can also click through the creatives name to display the creative in a pop-up. This can help remind you of the creative in question. | You can also click through the creatives name to display the creative in a pop-up. This can help remind you of the creative in question. By checking the 'include impressions' box you are able to also view the impressions made by your specific creatives. | ||
==Landing Report== | ==Landing Report== | ||
| Line 65: | Line 67: | ||
Also similar to the standard report is the landing report that will tell you the clicks, sales and conversion rates for your different landing pages. | Also similar to the standard report is the landing report that will tell you the clicks, sales and conversion rates for your different landing pages. | ||
[[File:Landing Page Report.png|border|none|650px]] | |||
This can also be customised using the drop down menus on the left and by typing in an affiliate name. | This can also be customised using the drop down menus on the left and by typing in an affiliate name. | ||
| Line 75: | Line 77: | ||
If you are using Sub Id's this report could prove very useful and you will be able to keep track and effectively monitor them | If you are using Sub Id's this report could prove very useful and you will be able to keep track and effectively monitor them | ||
[[File:SUB ID's report.png|none|border|650px]] | |||
Similar to the standard report you can customise this report by period and program. You can also group the results by either Sub Id or program. | |||
==Voucher Report== | ==Voucher Report== | ||
| Line 87: | Line 85: | ||
If you are using Voucher Codes and they are listed on TAG you can use the Voucher Report to monitor the usage and effectiveness of them. | If you are using Voucher Codes and they are listed on TAG you can use the Voucher Report to monitor the usage and effectiveness of them. | ||
[[File:Voucher report.png|none|border|650px]] | |||
The voucher report will display the Voucher code, Number of sales, Total value and Commission. This report can assist you in keeping track of how frequently and effectively your voucher codes are used. | The voucher report will display the Voucher code, Number of sales, Total value and Commission. This report can assist you in keeping track of how frequently and effectively your voucher codes are used. | ||
| Line 99: | Line 97: | ||
The Transaction report will display all sales including those that are pending. It is from here you can approve and cancel sales. | The Transaction report will display all sales including those that are pending. It is from here you can approve and cancel sales. | ||
[[File:Transaction Report.png|none|border|650px]] | |||
The mandatory columns relate to TID (Transaction ID), Affiliate, Program, Date/time (Purchase), Order Id, Status and then buttons to approve/reject a sale (using the buttons at the top you can approve/reject all sales displayed). There are then further optional columns for the transaction report: | The mandatory columns relate to TID (Transaction ID), Affiliate, Program, Date/time (Purchase), Order Id, Status and then buttons to approve/reject a sale (using the buttons at the top you can approve/reject all sales displayed). There are then further optional columns for the transaction report: | ||
| Line 114: | Line 112: | ||
*Conversion Type. | *Conversion Type. | ||
You can adjust which of the optional fields you show using the button in the top right corner and | You can adjust which of the optional fields you show using the [[File:Transaction Report optional.png|text bottom|56x29px]] button in the top right corner and the check boxes on the pop-up. As with all reports it is possible to customise the transaction report. You can do this using the drop down menus on the left hand side. | ||
As with all reports it is possible to customise the transaction report. You can do this using the drop down menus on the left hand side. | |||
[[File:Customise - transaction report.PNG|border|none|200px]] | [[File:Customise - transaction report.PNG|border|none|200px]] | ||
Providing the radio button in the top left hand corner is selected you can customise your report by time period, program, status, conversion type (click through, post back, batch upload and missing claim), any Sub Id's used and by typing category code, affiliate or CRID. This | Providing the radio button in the top left hand corner is selected you can customise your report by time period, program, status, conversion type (click through, post back, batch upload and missing claim), any Sub Id's used and by typing category code, affiliate or CRID. This enables you to filter down to the pending sales with a certain category code or placed on a certain day. | ||
Below the standard customising choices there is the option to filter by Order or Transaction ID. Use the radio button in the top left corner (above where it says 'order id) and you can then selected whether to use Order ID or Transaction ID. | Below the standard customising choices there is the option to filter by Order or Transaction ID. Use the radio button in the top left corner (above where it says 'order id) and you can then selected whether to use Order ID or Transaction ID. | ||
| Line 128: | Line 122: | ||
[[File:Filter by order or transaction id.PNG|border|none|200px]] | [[File:Filter by order or transaction id.PNG|border|none|200px]] | ||
You can then enter | You can then enter order ID's into the box and 'filter' to view only these sales. | ||
This feature is particularly useful should you need to cancel or approve a large batch of sales. For example if you had all the order ID's of returned sales for the past 10 days providing your within your sales validation period you can input all the Order Ids and use the cancellation button at the very top to batch cancel before saving. | This feature is particularly useful should you need to cancel or approve a large batch of sales. For example if you had all the order ID's of returned sales for the past 10 days, providing your within your sales validation period, you can input all the Order Ids and use the cancellation button at the very top to batch cancel before saving. It is worth noting you can only batch cancel or approve sales on one page at a time, therefore if you have multiple pages of pending sales you will need to batch approve/reject page by page. | ||
You cannot use the two customising options at the same time. | You cannot use the two customising options at the same time. | ||
''While the transaction report will show you the most up to date statistics on your sales it may not reflect the exact cost of your next invoice. This is because the costs displayed are exclusive of VAT and override, further the amount you will be invoiced for will depend upon your sales validation period. For further information on invoices and billing please check [[Merchant Billing Cycle]]'' | |||
Latest revision as of 14:59, 26 July 2019
There are nine different types of merchant report available in TAG. These are Standard, Affiliate, Program, Creative, Landing, Sub Id, Category, Voucher and Transaction. You can easily navigate through the different reports using the list on the far left of the screen. All of the reports can be customised in some way using the drop down menus on the left of the screen.

All the reports can also be downloaded as either a PDF or CSV by using the export options at the foot of each report.
There are certain restrictions to the downloading of reports; you are only able to download a three month span of any report but this can be from any time. For example if you would like to download January-March of 2017 this is possible but downloading January-September of this year is not.
If the report you would like to download exceeds the above restrictions you can save it to TAG. Where it will be stored indefinitely and accessible through the drop down menu below reports.
On most reports you can view impression made by creatives affiliates have pulled form TAG; to do so ensure you have checked the 'include impressions' tick box on the customise report banner to the left.
Standard Report
The standard report will show you an overview of your account as a whole.
On the standard report you will see all sales and clicks on your programs. The columns denote Date, Clicks, Sales, Conversion Rate, Total Value, Commission and Earnings Per Click (EPC - in this case it is calculated as earnings per 100 clicks), You can alter the period shown and which program you are looking at using the 'customise report' box on the left.
From here you can also view a graph of your report.
Affiliate Report
Similar to the standard report the affiliate report will show you all clicks and sales for your programs by affiliate.

In this report the 'Date' column from the standard report is removed and replaced with 'Affiliate'. As with the standard report you can customise Time Period, Program and Activity using the drop down menus on the left
This particular report is useful for assessing your highest performing affiliates and determining the individual conversation rates and total sales for specific affiliates. You can adjust the order of the affiliates by using the arrows at the side of the column titles.
Program Report
The program report will show you clicks and sales by program with the program each row is referring to displayed in the far left column.

Similar to the affiliate and standard reports you can customise the features using the drop down menus on the left.
This report is useful if you are running multiple programs through TAG to ascertain which of your programs is performing the best.
Creative Report
If you have creatives on your account and affiliates are using them you can use the creative report to ascertain which are working the most successfully. The creative report is similar to the standard report but with a 'Creative' column first.

You can customise this report to show certain affiliates, programs, time period and activity using the drop down menus on the left.
You can also click through the creatives name to display the creative in a pop-up. This can help remind you of the creative in question. By checking the 'include impressions' box you are able to also view the impressions made by your specific creatives.
Landing Report
Also similar to the standard report is the landing report that will tell you the clicks, sales and conversion rates for your different landing pages.

This can also be customised using the drop down menus on the left and by typing in an affiliate name.
The landing report will be useful if you have multiple landing pages to see if there are specific landing pages that convert better than others.
Sub Id Report
If you are using Sub Id's this report could prove very useful and you will be able to keep track and effectively monitor them

Similar to the standard report you can customise this report by period and program. You can also group the results by either Sub Id or program.
Voucher Report
If you are using Voucher Codes and they are listed on TAG you can use the Voucher Report to monitor the usage and effectiveness of them.

The voucher report will display the Voucher code, Number of sales, Total value and Commission. This report can assist you in keeping track of how frequently and effectively your voucher codes are used.
As with all reports you can customise the voucher report by time period and program.
Transaction Report
The Transaction report will display all sales including those that are pending. It is from here you can approve and cancel sales.

The mandatory columns relate to TID (Transaction ID), Affiliate, Program, Date/time (Purchase), Order Id, Status and then buttons to approve/reject a sale (using the buttons at the top you can approve/reject all sales displayed). There are then further optional columns for the transaction report:
- Date/Time (Visit)
- CRID
- Order Value
- Affiliate Commission
- Click Source
- Sub Id
- Voucher Code
- Card Type
- Payment Type
- Conversion Type.
You can adjust which of the optional fields you show using the
button in the top right corner and the check boxes on the pop-up. As with all reports it is possible to customise the transaction report. You can do this using the drop down menus on the left hand side.
Providing the radio button in the top left hand corner is selected you can customise your report by time period, program, status, conversion type (click through, post back, batch upload and missing claim), any Sub Id's used and by typing category code, affiliate or CRID. This enables you to filter down to the pending sales with a certain category code or placed on a certain day.
Below the standard customising choices there is the option to filter by Order or Transaction ID. Use the radio button in the top left corner (above where it says 'order id) and you can then selected whether to use Order ID or Transaction ID.
You can then enter order ID's into the box and 'filter' to view only these sales.
This feature is particularly useful should you need to cancel or approve a large batch of sales. For example if you had all the order ID's of returned sales for the past 10 days, providing your within your sales validation period, you can input all the Order Ids and use the cancellation button at the very top to batch cancel before saving. It is worth noting you can only batch cancel or approve sales on one page at a time, therefore if you have multiple pages of pending sales you will need to batch approve/reject page by page.
You cannot use the two customising options at the same time.
While the transaction report will show you the most up to date statistics on your sales it may not reflect the exact cost of your next invoice. This is because the costs displayed are exclusive of VAT and override, further the amount you will be invoiced for will depend upon your sales validation period. For further information on invoices and billing please check Merchant Billing Cycle