Affiliate Stats Dumps - Revision history

OfferitMegan at 15:55, 12 October 2012

2012-10-12T15:55:04Z

OfferitMegan at 18:20, 18 July 2012

2012-07-18T18:20:25Z

OfferitRobC: /* CSV Dumps */

2012-01-03T15:50:11Z

‎CSV Dumps

OfferitJames: Created page with "{{Offerit Manual | show_for_affiliates_section = true }} == Getting Affiliate Stats Dumps == Offerit offers the ability to get dumps of affiliate stats thr..."

2011-11-07T18:29:53Z

Created page with "{{Offerit Manual | show_for_affiliates_section = true }} == Getting Affiliate Stats Dumps == Offerit offers the ability to get dumps of affiliate stats thr..."

New page

{{Offerit Manual
| show_for_affiliates_section = true
}}

== Getting Affiliate Stats Dumps ==

[[Offerit]] offers the ability to get dumps of [[Ct#Affiliate|affiliate]] stats through two languages, XML and CSV. To get access to these dumps, you must use a direct URL in your Offerit install directory.

To get to this URL, type in your [[Offerit]] install directory:

<pre> <Offerit install address>.offerit.com/internal.php?page=dump&period=<value> </pre>
Replace <Offerit install address> with your directory, and replace <value> with a number from 0-9 depending on what time period you want the dumps to reflect:

* 0 = Current Period
* 1 = Last Period
* 2 = Today
* 3 = Yesterday
* 4 = Past Week
* 5 = Past Month
* 6 = Past Year
* 7 = All Time
* 8 = Free Form Date
** Free form dates must be specified in the URL in the order of year, month, day
** The format for free form dates is <...>period=8&start=<start date>&end=<end date>
**For example, <pre>&start=2010-05-12&end=2010-06-09</pre>
* 9 = Unix Timestamp
** This is useful because it does not require dashes and other formatting to specify your date, insted using raw Unix Timestamps when getting dumps
** You can use the same format as [[Offerit Freeform Date|free form dates]], except with Unix values
**For example, <pre>&start=1274068800&end=1276056000</pre>

== XML Dumps ==

[[Offerit]] is configured so that XML is the default dump when you get them through a direct URL. To get XML dumps, go to your URL:
<pre><Offerit install address>.offerit.com/internal.php?page=dump&period=<value></pre>
and set a value for a time period to be displayed.

Once you navigate to the XML dump, you should see numeric values that look like:

<pre> <_1275883200 name="1275883200"> 165 21 799 799 0 15 3 1 1 0 0 0 0 34274 3338 0 0 0 0 0 0 18 37612 2 0 3255 0 0 40867 0 0 0 0 0 0 0 3255 0 <_1275969600 name="1275969600"> 236 23 877 877 0 13 5 1 3 0 0 0 0 23517 9338 0 3822 0 0 0 0 18 32855 4 3822 1778 0 0 38455 0 0 0 0 0 0 0 1778 0 <_1276056000 name="1276056000"> 89 8 339 339 0 5 1 2 10081 3000 1274 6 13081 2 1274 450 14805 0 450 0...</pre>

These are your XML dumps of [[Ct#Affiliate|affiliate]] stats. To get a cleaner list of values, right click and select "View Page Source." This will give you the raw XML code for the data requested.

== CSV Dumps ==

CSV is short for Comma-Seperated Values, another language for organizing database information. The process of getting CSV dumps is similar to the process of attaining XML dumps, with an exception in the URL.

Since XML is the default language for dumping through direct URL access, you must specify that you are requesting a CSV code in the URL. To do this, go to the same directory as you would for an XML dump, but at the end of the URL add &format=csv.

For example: <pre> <Offerit install address>.offerit.com/internal.php?page=dump&period=7&format=csv </pre>

If you get a list of various values that are seperated by commas, the values are your CSV dumps. Once you have navigated to the CSV dump, you should see numeric values that look like this:

<pre>"","Page Views","Unique Visitors","Conversion Rate","EPC","SubAff","Fraud","Sales","Payout";

"1319688000","0","0","0:0","$0.00","","","0","$0.00";
"1319774400","0","0","0:0","$0.00","","","0","$0.00"; </pre>

These are your CSV dumps. These figures can be directly exported to Excel or any software that handles CSV dumps.

[[Category:Offerit Affiliate Information]]

@@ Line 2: / Line 2: @@
 | show_for_affiliates_section = true
 }}
 [[Offerit]] has the ability to get dumps of [[Ct#Affiliate|affiliate]] stats through two languages, XML and CSV. To get access to these dumps, you must use a direct URL in your Offerit install directory.

@@ Line 5: / Line 5: @@
 == Getting Affiliate Stats Dumps ==
-[[Offerit]] offers the ability to get dumps of [[Ct#Affiliate|affiliate]] stats through two languages, XML and CSV. To get access to these dumps, you must use a direct URL in your Offerit install directory.
+[[Offerit]] has the ability to get dumps of [[Ct#Affiliate|affiliate]] stats through two languages, XML and CSV. To get access to these dumps, you must use a direct URL in your Offerit install directory.
 To get to this URL, type in your [[Offerit]] install directory:

@@ Line 51: / Line 51: @@
 If you get a list of various values that are seperated by commas, the values are your CSV dumps. Once you have navigated to the CSV dump, you should see numeric values that look like this:
-<pre>"","Page Views","Unique Visitors","Conversion Rate","EPC","SubAff","Fraud","Sales","Payout";
+<pre>"","Page Views","Unique Visitors","Conversion Rate","EPC","SubAff","Fraud","Sales","Payment";
 "1319688000","0","0","0:0","$0.00","","","0","$0.00";