Application Support:Reporting
From HasOffers
HasOffers provides the most advanced tracking and reporting technology available, improving affiliate network management by tracking your online initiatives in real time. All data is tracked, computed and displayed in real-time. Audit the success of your affiliates at any time with reports showing the most current information. View statistics on a network level or drill-down to more specific filtering for further insight. Statistics reports are located under the Reports Tab.
Under the Reports Tab you will notice several reports that will automatically generate for you. However, each of these reports can be completely customized to your unique requirements.
Contents |
Summary Stat Reports
There are five predefined summary stat reports for admins. These report give summary impression, click and conversion data. There are several options on these reports to group, filter and easily customize them.
Daily and Hourly Stat Reports
The reports give you a quick glance at statistics for your network within a certain time frame. These give you quick reference to what is currently happening with various campaigns and affiliates. Click Options at the top of the page to customize this report further. Presets for these reports include Date, Impressions, Clicks, Conversions, Cost, CPC, Revenue, RPC, and Profit.
Affiliate Report
Quickly view the activity of each of your affiliates by clicking this report. Click Options at the top of the page to customize this report further. The default preset shows you activity for today as well as Clicks, Conversions, Cost, CPC, Revenue, RPC, and Profit.
Advertiser Report
Quickly view the activity of each of your advertisers by clicking this report. Click Options at the top of the page to customize this report further. The default preset shows you activity for today as well as Clicks, Conversions, Cost, CPC, Revenue, RPC, and Profit.
Offers Report
Quickly view statistics for each offer receiving traffic through your network by clicking this report.
Ad Campaigns Report
This report allows you to see statistics on each of your advertising campaigns that are set up through the Ad Manager. Filter by Campaigns to drill down to a single campaign or sort by data, statistics, calculations, or interval by clicking Options. Export this report to CSV by clicking in the upper right corner of the report.
Options
You can easily customize any of the per-defined summary stat reports using the options panel.
Data
Choose the specific data points that you want to see in your customized report. By clicking the box next to a specific data point, a new column will be created in the report.
- Affiliate
- Affiliate Manager
- Advertiser Advertiser
- Manager
- Offer
- Goal
- Payout Type
- Revenue Type
- Offer URL
- Affiliate Source
- Affiliate Sub ID 1
- Affiliate Sub ID 2
- Affiliate Sub ID 3
- Affiliate Sub ID 4
- Affiliate Sub ID 5
- Category
- Campaign
- Creative
- Browser
- Country
- Currency
Statistics
Available for click level reporting, Statistics allows you to choose which statistics are provided in your customized report.
- Impressions - Number of times the impression pixels was displayed with creatives. These are usually ad views.
- Gross Clicks - Total number of clicks on a tracking link.
- Unique Clicks - Only number of clicks where the user / visitor is unique.
- Clicks - Either gross clicks or unique clicks depending on the select metric in the Tracking Settings.
- Conversions - Number of approved conversions.
- Cost - Total cost based on the offer payout types and corresponding actions that is owed to affiliates and publishers.
- Revenue - Total revenue based on the offer revenue types and corresponding actions that advertisers owe you for.
- Sales - Total number of sales on approved conversions.
- Profit - Revenue minus cost.
Calculations
Available for click level reporting, Calculations allows you to make automatic statistics calculations.
- CTR - CTR stands for Click Through Rate. This is the number of clicks divided by the number of impressions.
- CR - CR stands for Conversion Rate. This is calculated by dividing conversions by clicks and multiplying by 100.
- CPM - RPM stands for Cost Per Thousand Impressions. This is calculated by dividing cost by each 1000 impressions.
- CPC - CPC stands for Cost Per Click. This is calculated by dividing cost by clicks.
- CPA - CPA stands for Cost Per Acquisition. This is calculated by dividing cost by number of conversions.
- RPM - RPM stands for Revenue Per Thousand Impressions. This is calculated by dividing revenue by each 1000 impressions.
- RPC - RPC stands for Revenue Per Click. This is calculated by dividing revenue by clicks.
- RPA - RPA stands for Revenue Per Acquisition. This is calculated by dividing revenue by number of conversions.
Interval
Available for click level reporting, Interval allows you to divide up statistics based on Year, Month, Week, Date, or Hour.
- Year
- Month
- Week
- Date
- Hour
Filters
Available for all reports, filtering helps you drill down to only include specific data in your report. Filters are like doing a where clause and only including the data that meets the selected filters. Choose the option you wish to filter your report by and select the specific filter. You can choose more than one by holding the Ctrl key. For example, to filter by a specific offer, check the box to the left of 'Offer' and choose the offer for which you want to see statistics.
- Affiliates
- Affiliate Managers
- Advertiser
- Advertisers Managers
- Offers
- Goals
- Payout Type
- Revenue Type
- Campaigns
- Creatives
- Browsers
- Countries
- Currencies
Timeframe
Generate a customized report for a specific range of time. Choose a preset by toggling or set specific dates in the fields provided. When finished setting your timeframe, click the Run Report button.
Timezone
You can have the summary stats or conversion data adjusted to a new timezone by selecting the new timezone from the drop down menu. The data will then be shifted from the network's default timezone to the new timezone based on the hours differences.
Saved Report
Customized summary stat reports can be saved. Only your user has access to reports you save. They are saved with the data, statistics and filters. These saved reports can then be loaded from the report page. Links to saved reports are included in the “Quick Links” panel on the snapshot page for quick and easy access to regularly run reports.
Conversion Report
The Conversion Report provides a list of every conversion that has occurred through your network. The basic conversion report shows the offer that converted, the affiliate who made the conversion, the time of conversion, payout, revenue, sale amount, and more.
Options
You can easily customize any of the per-defined summary stat reports using the options panel. You can learn more about customizing summary stat reports here Customizing reports and displaying data fields. Below is the option panel for summary stat reports.
Data
Choose the specific data points that you want to see in your customized report. By clicking the box next to a specific data point, a new column will be created in the report.
- Offer
- Goal
- Affiliate
- Affiliate Manager
- Advertiser
- Advertiser Manager
- Customer Provided ID
- Offer URL
- Session Date / Time
- Date / Time
- Date / Time Diff
- Status
- Status Message
- Note
- Payout
- Revenue
- Sale Amount
- Session IP
- IP
- Transaction ID
- Affiliate Source
- Affiliate Sub ID 1
- Affiliate Sub ID 2
- Affiliate Sub ID 3
- Affiliate Sub ID 4
- Affiliate Sub ID 5
- Advertiser Sub ID
- Tracking Link Referral
- Conversion Pixel Referral
- Country
- Browser
- User Agent
- Currency
- Adjustment
Filters
Available for all reports, filtering helps you drill down to only include specific data in your report. Filters are like doing a where clause and only including the data that meets the selected filters. Choose the option you wish to filter your report by and select the specific filter. You can choose more than one by holding the Ctrl key. For example, to filter by a specific offer, check the box to the left of 'Offer' and choose the offer for which you want to see statistics.
- Affiliates
- Advertisers
- Offers
- Goals
- Countries
- Browsers
- Status
- Adjustments
Timeframe
Generate a customized report for a specific range of time. Choose a preset by toggling or set specific dates in the fields provided. When finished setting your timeframe, click the Run Report button.
Timezone
You can have the summary stats or conversion data adjusted to a new timezone by selecting the new timezone from the drop down menu. The data will then be shifted from the network's default timezone to the new timezone based on the hours differences.
Saved Report
Customized summary stat reports can be saved. Only your user has access to reports you save. They are saved with the data, statistics and filters. These saved reports can then be loaded from the report page. Links to saved reports are included in the “Quick Links” panel on the snapshot page for quick and easy access to regularly run reports.
Search Conversions
You can search for specific conversions in the Conversions Report using the search functionality. You can search by the following data fields: IP address, transaction ID, affiliate source, affiliate sub ID 1, affiliate sub ID 2, affiliate sub ID 3, affiliate sub ID 4, affiliate sub ID 5, advertiser sub ID, tracking link referral or conversion pixel referral. Simply select the data field to search in and enter the search criteria. If want to make bulk / mass updates to the conversions returned in the results, you can then export this information to CSV, make updates and then upload the conversions data. Learn more about Uploading Conversions.
Conversion view
You can view information about a specific conversion when viewing the conversion report by clicking the magnifying glass icon to the right of the conversion. This gives you detailed information on the conversion made for that specific transaction ID
Approve and Reject Conversions
If you have the Conversion Management feature, you can also approve or reject conversions directly from this report by clicking the Reject link under the Status column. After refreshing, you can also revert rejected conversions to Approved by clicking the Approved link.
If an offer has conversion approval enabled, pending conversions can be approved or rejected as well from the Conversion Report.
Upload Conversions
From the Conversion Report you can upload conversions as well. You can upload conversions associated with a Transaction ID or record new conversions using affiliate and offer IDs. Learn more about how to Upload Conversions.
Conversion Status Report
This report provides unique insight on the number of approved, pending and rejected conversions along with corresponding metrics. This report is helpful to further analyze affiliate fraud.
Traffic Referral Report
Traffic referrals allow you to view where users are being directed to offers from. The HasOffers application allows you to track referrals for both the tracking link referrals and the conversion pixel referrals, so you can track what page the conversion pixel is being fired from.
View this report by hovering the Report tab and selecting "Traffic referrals" You can the select the options from the drop down menu to filter the reports to your needs, additionally you may select the dates for which you would like the report to encompass. This report may be exported by clicking the "Export to CSV" on the to right hand side of the panel.
Affiliate Fraud Report
This report shows a complete list of your affiliate accounts, providing the profile and activity fraud score for each account. You can sort this list by affiliate name, Profile fraud score, or Activity fraud score. This report will also provide the reasons for each affiliate's fraud score. Learn more about customizing and managing Fraud Score Features.
Server Logs Report
The Ad Server report provides a complete log of click and conversion actions. Actions designated as “clicks” report all errors in tracking links and reasons for offer redirections, such as lead caps, conversion redirect, country targeting, and browser targeting. A “conversion” action shows all activity requesting the conversion pixel. This log is an excellent way to help affiliates with conversion problems or tracking errors as well as detect fraudulent activity. Hover over the “Reports” tab and click “Ad Server Report”. This report displays the date and time of each server log, the type of log (notice, debug, error, etc.), the action (conversion or click), the server message and the URL.
Here are some responses that the ad server will return and what they mean:
- Offer is Paused and no other offers to redirect to - This notice means that affiliate traffic is going to a paused offer. Since there is no Redirect Offer set, the affiliate traffic goes to a white page and the user isn’t redirected anywhere. To eliminate this notice, update the offer and set a Redirect Offer. All affiliate traffic will then be redirected to the Redirect Offer selected.
- Offer Geo Targeting does not match user location, no valid group redirect offer - This notice means that a user clicked on a link for an offer and the offer has geo targeting set that doesn’t match the user’s location. Since the offer is not in an offer group or the offer group doesn’t include an offer with geo-targeting that matches the user’s location, the user goes to a white page and the user isn’t redirected anywhere. To eliminate this offer, add the offer to an offer group or disable enforce geo-targeting. If you want to redirect the user to an offer that matches the user’s location then add the offer to an offer group. Then if a user clicks on a link for an offer and their targeting doesn’t match the offer targeting, the ad server will check to see which offer group the offer is in and then check the other offers in the group to see if there is an offer that has geo targeting that matches the user’s location. If there is an offer in an offer group that matches the user’s location, the user will be redirected to this offer instead. To setup an offer to be in an offer group, in the Targeting panel click edit. Then select the Offer Groups that the offer should be included in. You can add an offer to multiple offer groups. If you don’t want to redirect the user to an offer that matches their location, you should disable Enforce Geo Targeting. If you disable Enforce Geo Targeting then the user will still be redirect to the Offer URL for the offer. When Enforce Geo Targeting is disabled, geo targeting is just informational and doesn’t restrict users from access the offer based on their location.
- No active session found for offer and no transaction ID provided. - This notice means that the conversion pixels or postback URL was loaded for a user that didn’t have a valid session. This means that the advertiser is displaying the offer’s conversion pixel or calling the offer’s postback URL for people that you didn’t refer. The user never saw a creative that set a session on impression or clicked on a tracking link to create a session, but the advertiser is still displaying the offer’s conversion pixel or calling the postback URL. If these conversions were recorded, this would cause your network to record more conversions than the advertiser will record for you since your network didn’t refer these users to the advertiser’s offer. However, if the offer uses Server Postback and your network isn’t recording conversions for the offer then this notice can tell you that the advertiser isn’t passing in a transaction ID into the Postback URL. You will need to work with the advertiser and have them pass in the transaction ID into the postback URL. Since offers that user Server Postback require you to pass the transaction ID {transaction_id} to the advertiser on click, they need to include the value in the Postback URL to record a conversion.
- Invalid Transaction ID - This error means that the advertiser is passing in the wrong value into the Postback URL. Offers that user Server Postback require you to pass the transaction ID {transaction_id} to the advertiser on click. You can pass your transaction ID into the advertiser’s system via a sub ID. Then when the advertiser calls the Postback URL, they need to include the transaction ID value that you passed to them on click (and stored as a sub ID in their system) into the offer’s Postback URL to record a conversion. Transaction ID values are usually longer than 8 characters in length. You can view the Conversion Report to see sample transaction ID values.
- Test mode is enabled. Geo targeting and browser targeting skipped. - This debug notice means that an affiliate or network employee is testing a tracking link. When an affiliate or network employee logs in, a test cookie is set. Then when they test a tracking link the ad server detects the test cookie. If the test cookie is set, geo targeting and browser targeting is skipped so that the affiliate or network employee can test the offer.You can read more about how the ad server handles the test cookie here: What does Test Cookie Do
- Test mode enabled, Setting payout, revenue and sale amount to '0' - This conversion notice means that an advertiser or network employee is testing an offer using the offer test link. The offer test link is found when viewing the offer conversion tracking pixel or postback URL. When viewing an offer click on the Tracking Pixel or Postback URL link in the details panel. The tracking pixel and postback URL page displays a test link that include &source=testoffer&aff_sub=testoffer . When source equals “testoffer” or affiliate sub ID equals “testoffer” then the ad server sets payout, revenue and sale amount to 0. Since it is a test conversion, these values are set to 0 so that it won’t affect statistics. If you want to test an offer without test mode enabled, simply generate a tracking link for affiliate ID 1 (your affiliate account) and then test the offer.
- Request Invalid - This click error means that the link that is being requested isn’t valid. More than likely, there isn’t a valid affiliate ID or offer ID in the tracking link or there is a weird character that isn’t valid for offer ID or affiliate ID. Or the request includes no affiliate ID or offer ID because the tracking link isn’t being created or formatted correctly.
- Affiliate not found - This click error means that the tracking link that is being requested is for an invalid affiliate ID. Either the affiliate ID is wrong or the affiliate was deleted or blocked. Your ad servers only load affiliates that have status of active, pending and paused. The ad server doesn’t load affiliates with any other status. So if the affiliate account is set to a status that your ad servers don’t load, then the ad server won’t be able to find the affiliate. The ad server returns a white page for these requests. If the link is suppose to work and the affiliate account is set to a status loaded by your ad servers, then the tracking link isn’t formatted correctly and need to be updated.
- Offer not found - This click error means that the tracking link that is being requested is for an invalid offer ID. Either the offer ID is wrong or the offer was deleted or inactive. Your ad servers only load offers that have status of active, pending and paused. The ad server doesn’t load offers with any other status. So if the offer is set to a status that your ad servers don’t load like deleted, then the ad server won’t be able to find the offer. The ad server returns a white page for these requests. If the offer was active and is not deleted, you should update the offer to be paused instead of deleted. This way you can setup a Redirect Offer and the traffic will be forwarded to the specified redirect offer. Offers that are deleted don’t forward traffic to the redirect offer.
Exporting Reports
You can export any report in CSV. To export a report in CSV, simply select the CSV link and you will be will be prompted to open the CSV file with Excel or other compatible computer program.
Reporting Questions
To see any frequently asked questions for our reporting features, please visit our frequently asked reporting questions section.
Email this page to a friend or co-worker
