CINXE.COM

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="robots" content="noindex">  <meta name="google-site-verification" content="fwM6dGDsBxDav88DtFqz7IY4mYLMT6bBd2cf7ZUQrtw" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta name="generator" content="MediaWiki 1.14.0" /> <meta name="keywords" content="Uploading transaction queries" /> <link rel="shortcut icon" href="/favicon.ico" /> <link rel="search" type="application/opensearchdescription+xml" href="/opensearch_desc.php" title="Wiki (en)" /> <link title="Creative Commons" type="application/rdf+xml" href="/index.php?title=Uploading_transaction_queries&action=creativecommons" rel="meta" /> <link rel="copyright" href="http://www.awin.com/" /> <link rel="alternate" type="application/rss+xml" title="Wiki RSS Feed" href="http://wiki.awin.com/index.php?title=Special:RecentChanges&feed=rss" /> <link rel="alternate" type="application/atom+xml" title="Wiki Atom Feed" href="http://wiki.awin.com/index.php?title=Special:RecentChanges&feed=atom" /> <title>Uploading transaction queries - Wiki</title> <link rel="stylesheet" href="/skins/common/shared.css?195" type="text/css" media="screen" /> <link rel="stylesheet" href="/skins/common/commonPrint.css?195" type="text/css" media="print" /> <link rel="stylesheet" href="/skins/awin/main.css?195" type="text/css" media="screen" />     <link rel="stylesheet" href="/index.php?title=MediaWiki:Common.css&usemsgcache=yes&ctype=text%2Fcss&smaxage=18000&action=raw&maxage=18000" type="text/css" /> <link rel="stylesheet" href="/index.php?title=MediaWiki:Print.css&usemsgcache=yes&ctype=text%2Fcss&smaxage=18000&action=raw&maxage=18000" type="text/css" media="print" /> <link rel="stylesheet" href="/index.php?title=MediaWiki:Awin.css&usemsgcache=yes&ctype=text%2Fcss&smaxage=18000&action=raw&maxage=18000" type="text/css" /> <link rel="stylesheet" href="/index.php?title=-&action=raw&maxage=18000&gen=css" type="text/css" />  <script type= "text/javascript">/*<![CDATA[*/ var skin = "awin"; var stylepath = "/skins"; var wgArticlePath = "/index.php/$1"; var wgScriptPath = ""; var wgScript = "/index.php"; var wgVariantArticlePath = false; var wgActionPaths = {}; var wgServer = "http://wiki.awin.com"; var wgCanonicalNamespace = ""; var wgCanonicalSpecialPageName = false; var wgNamespaceNumber = 0; var wgPageName = "Uploading_transaction_queries"; var wgTitle = "Uploading transaction queries"; var wgAction = "view"; var wgArticleId = "3644"; var wgIsArticle = true; var wgUserName = null; var wgUserGroups = null; var wgUserLanguage = "en"; var wgContentLanguage = "en"; var wgBreakFrames = false; var wgCurRevisionId = "55527"; var wgVersion = "1.14.0"; var wgEnableAPI = true; var wgEnableWriteAPI = true; var wgSeparatorTransformTable = ["", ""]; var wgDigitTransformTable = ["", ""]; var wgRestrictionEdit = []; var wgRestrictionMove = []; /*]]>*/</script> <script type="text/javascript" src="/skins/common/wikibits.js?195"></script>  <link type="text/css" href="/skins/awin/eprivacy.css" rel="stylesheet"/> <script type="text/javascript" src="/skins/common/ajax.js?195"></script> <script type="text/javascript" src="/index.php?title=-&action=raw&gen=js&useskin=awin"></script> </head> <body class="mediawiki ltr ns-0 ns-subject page-Uploading_transaction_queries skin-awin">  <div id="container"> <div id="header"> <div class="portlet" id="p-personal">  <div class="pBody" id="user-menu"> <ul> <li> <ul class="children"> <li id="pt-login" > <a href="/index.php?title=Special:UserLogin&returnto=Uploading_transaction_queries" title="You are encouraged to log in; however, it is not mandatory [o]" accesskey="o" > Log in </a> </li> </ul> </li> </ul> </div> </div> <div id="header_logo"> <a href="/"><img src="/skins/awin/awwiki_logo.png" alt="AWIN | Wiki" title="AWIN | Wiki" /></a> </div> </div>  <div id="globalWrapper"> <div id="column-one">  <script type="text/javascript"> if (window.isMSIE55) fixalpha(); </script> <div id="p-search" class="portlet"> <div id="searchBody" class="pBody">  <form action="/index.php/Special:Search" id="searchform"> <input id="searchInput" name="search" type="text" placeholder='search' title="Search Wiki [f]" accesskey="f" value="" />  <input type='image' src='/skins/awin/images/magnifying_glass.png' name="fulltext" class="searchButton" id="mw-searchButton" value="Search" title="Search the pages for this text" /> </form> </div> </div> <div class='generated-sidebar portlet' id='p-Navigation'> <div class='pBody'> <h5>Navigation</h5> <ul> <li id="n-Advertiser"><a href="/index.php/FAQ_Advertiser">Advertiser</a></li> <li id="n-Interface"><a href="/index.php/Interface">Interface</a></li> <li id="n-Jargon-Buster"><a href="/index.php/Jargon_Buster">Jargon Buster</a></li> <li id="n-Publisher"><a href="/index.php/FAQ_Publisher">Publisher</a></li> <li id="n-Staff"><a href="/index.php/Staff:Employee_Knowledge_Center">Staff</a></li> </ul> </div> </div> <div class='generated-sidebar portlet' id='p-Assistance'> <div class='pBody'> <h5>Assistance</h5> <ul> <li id="n-Wiki-Help"><a href="/index.php/Wiki_FAQ_Wiki">Wiki Help</a></li> <li id="n-Wanted-Pages"><a href="/index.php/Wanted_Pages">Wanted Pages</a></li> </ul> </div> </div> <div class='generated-sidebar portlet' id='p-External_resources'> <div class='pBody'> <h5>External resources</h5> <ul> <li id="n-Interface-Login"><a href="http://ui.awin.com">Interface Login</a></li> <li id="n-Blog"><a href="https://www.awin.com/gb/news-and-events">Blog</a></li> <li id="n-Twitter"><a href="https://twitter.com/UK_Awin">Twitter</a></li> <li id="n-Facebook"><a href="https://www.facebook.com/awin/">Facebook</a></li> </ul> </div> </div> <div class="portlet" id="p-tb"> <div class="pBody"> <h5>tools</h5> <ul> <li id="t-whatlinkshere"><a href="/index.php/Special:WhatLinksHere/Uploading_transaction_queries" title="List of all wiki pages that link here [j]" accesskey="j">What links here</a></li> <li id="t-recentchangeslinked"><a href="/index.php/Special:RecentChangesLinked/Uploading_transaction_queries" title="Recent changes in pages linked from this page [k]" accesskey="k">Related changes</a></li> <li id="t-print"><a href="/index.php?title=Uploading_transaction_queries&printable=yes" title="Printable version of this page [p]" accesskey="p">Printable version</a></li> <li id="t-permalink"><a href="/index.php?title=Uploading_transaction_queries&oldid=55527" title="Permanent link to this version of the page">Permanent link</a></li> </ul> </div> </div> </div> <div id="column-content"> <div id="p-cactions" class="portlet"> <h5>Views</h5> <div class="pBody"> <ul> <li id="ca-nstab-main" class="selected"><a href="/index.php/Uploading_transaction_queries" title="View the content page [c]" accesskey="c">Page</a></li> <li id="ca-talk" class="new"><a href="/index.php?title=Talk:Uploading_transaction_queries&action=edit&redlink=1" title="Discussion about the content page [t]" accesskey="t">Discussion</a></li> <li id="ca-viewsource"><a href="/index.php?title=Uploading_transaction_queries&action=edit" title="This page is protected.
You can view its source [e]" accesskey="e">View source</a></li> <li id="ca-history"><a href="/index.php?title=Uploading_transaction_queries&action=history" title="Past versions of this page [h]" accesskey="h">History</a></li> </ul> </div> </div> <div id="content"> <a name="top" id="top"></a> <h1 id="firstHeading" class="firstHeading">Uploading transaction queries</h1> <div id="bodyContent"> <h3 id="siteSub">From Wiki</h3> <div id="contentSub"></div> <div id="jump-to-nav">Jump to: <a href="#column-one">navigation</a>, <a href="#searchInput">search</a></div>  <p>There are circumstances in which a transaction may not track. In such circumstances we allow you to upload a ‘Transaction Query’ </p><p>When you add a Transaction Query into the system, it will go into a 'New Transaction Query' system in the Advertiser’s account. Any submitted query will be dealt with within 75 days or it will be automatically approved. </p><p>A pre-requisite to uploading your transaction queries is a file of all your claims which fits the Awin data specification. </p> <table id="toc" class="toc" summary="Contents"><tr><td><div id="toctitle"><h2>Contents</h2></div> <ul> <li class="toclevel-1"><a href="#Data_Specification"><span class="tocnumber">1</span> <span class="toctext">Data Specification</span></a></li> <li class="toclevel-1"><a href="#Uploading_a_Transaction_Query"><span class="tocnumber">2</span> <span class="toctext">Uploading a Transaction Query</span></a> <ul> <li class="toclevel-2"><a href="#Automatically"><span class="tocnumber">2.1</span> <span class="toctext">Automatically</span></a></li> <li class="toclevel-2"><a href="#Manually"><span class="tocnumber">2.2</span> <span class="toctext">Manually</span></a></li> </ul> </li> </ul> </td></tr></table><script type="text/javascript"> if (window.showTocToggle) { var tocShowText = "show"; var tocHideText = "hide"; showTocToggle(); } </script> <a name="Data_Specification" id="Data_Specification"></a><h1> <span class="mw-headline">Data Specification</span></h1> <p>Transaction Queries have to be uploaded a certain format or they won't process. We call this format the 'Data Specification' an example is below: </p> <table border="1"> <tr> <th><small>enquiry_id </th><th><small>merchant_id </th><th><small>type </th><th><small>click_ref </th><th><small>amount </th><th><small>commission </th><th><small>date </th><th><small>customer_reference </th><th><small>reference </th><th><small>description </th></tr> <tr> <td><small>3825 </td><td><small>3 </td><td><small>untracked </td><td><small>CR1 (or 0) </td><td><small>650.99 </td><td><small>23.44 </td><td><small>YYYY-MM-DD 00:00:00 </td><td><small>111111-000216 </td><td><small>order-ref123 </td><td><small>user-123 or product-ABC </td></tr></table> <p><br /> </p> <a name="Uploading_a_Transaction_Query" id="Uploading_a_Transaction_Query"></a><h1> <span class="mw-headline">Uploading a Transaction Query</span></h1> <p>Outlined below are the steps you need to take in order to upload a Transaction Query: </p><p><br /> </p> <ul><li>Log in to your Awin account </li></ul> <ul><li>Select Transaction Queries from the Support drop down box </li></ul> <p><a href="/index.php/File:Accessing_transaction_queries.jpg" class="image" title="Accessing transaction queries.jpg"><img alt="" src="/images/thumb/7/77/Accessing_transaction_queries.jpg/650px-Accessing_transaction_queries.jpg" width="650" height="248" border="0" /></a> </p><p>At this stage, you then have two possible options: </p><p><a href="http://wiki.awin.com/index.php/Uploading_transaction_queries#Automatically" class="external text" title="http://wiki.awin.com/index.php/Uploading_transaction_queries#Automatically" rel="nofollow" target="_blank">Automatic upload</a> or <a href="http://wiki.awin.com/index.php/Uploading_transaction_queries#Manually" class="external text" title="http://wiki.awin.com/index.php/Uploading_transaction_queries#Manually" rel="nofollow" target="_blank">Manual upload</a> </p><p><a href="/index.php/File:Transaction_query_screen.jpg" class="image" title="Transaction query screen.jpg"><img alt="" src="/images/thumb/b/bf/Transaction_query_screen.jpg/650px-Transaction_query_screen.jpg" width="650" height="233" border="0" /></a> </p><p><br /> </p><p><br /> </p> <a name="Automatically" id="Automatically"></a><h2> <span class="mw-headline">Automatically</span></h2> <p>This enables you to upload queries via ftp or http </p><p>To automate the process via FTP you will need to contact Support and request a Publisher Window FTP account. </p><p>You will now be able to enter your username and password along with your file type, schedule and whether or not you wish to receive email reports about the result of the process. </p><p>Next, connect to your FTP account (host: ftp.awin.com) and create a folder called ‘transaction_queries’ in the 'uploads' directory (/uploads/transaction_queries/). </p><p><a href="/index.php/File:Using_ftp_screen.jpg" class="image" title="File:Using ftp screen.jpg"><img alt="File:Using ftp screen.jpg" src="/images/2/20/Using_ftp_screen.jpg" width="451" height="83" border="0" /></a> </p><p>Open up this directory and upload your CSV or XML file with the name of data.csv (or data.xml). If you have selected to receive reports on the processing of your file (recommended) then you will receive an e-mail after your file has been processed. </p><p><br /> <a href="/index.php/File:Using_ftp_screen_with_data.jpg" class="image" title="Using ftp screen with data.jpg"><img alt="" src="/images/f/f5/Using_ftp_screen_with_data.jpg" width="650" height="143" border="0" /></a> </p><p>Note: We only update new files, i.e. if you have selected daily but only upload a new file every week – then we will automatically detect this and only process it when it has been updated. </p> <a name="Manually" id="Manually"></a><h2> <span class="mw-headline">Manually</span></h2> <p>This enables you to upload queries using an Excel file containing all queries. After clicking on "manual upload" you are presented with the following screen: </p><p><a href="/index.php/File:Manual_upload_screen.jpg" class="image" title="Manual upload screen.jpg"><img alt="" src="/images/thumb/d/da/Manual_upload_screen.jpg/650px-Manual_upload_screen.jpg" width="650" height="120" border="0" /></a> </p><p>Simply upload your pre-pepared file of claims and wait for feedback on each of your claims. </p> <div class="grey-box"> Feedback on about our Transaction Query tool, please take a few minutes to fill out our <a href="https://airtable.com/shryrvj4K9YuMcsib" class="external text" title="https://airtable.com/shryrvj4K9YuMcsib" rel="nofollow" target="_blank">Product Feedback form</a>.</div> <p></small> </small> </small> </small> </small> </small> </small> </small> </small> </small> </small> </small> </small> </small> </small> </small> </small> </small> </small> </small> </p>   <div class="printfooter"> Retrieved from "<a href="http://wiki.awin.com/index.php/Uploading_transaction_queries">http://wiki.awin.com/index.php/Uploading_transaction_queries</a>"</div>  <div class="visualClear"></div> </div> </div> </div> <div class="visualClear"></div> <div id="footer">  <ul id="f-list"> | <li id="privacy"><a href="https://www.awin.com/gb/privacy" class="external " title="https://www.awin.com/gb/privacy">Privacy Policy</a></li> | <li id="agreement"><a href="http://darwin.affiliatewindow.com/legal-docs/user-agreement" class="external " title="http://darwin.affiliatewindow.com/legal-docs/user-agreement">User Agreement</a></li> | <li id="copyright">© 2024 <a href="http://www.awin.com/" class="external " title="http://www.awin.com/">AWIN</a></li> </ul> </div> <div id="eprivacy"> <div id="section"> <h2>Privacy</h2> <p>Due to new European legislation regarding how websites store information about you, AWIN is updating its privacy policy. You can see the new version of our policy <a href="https://www.awin.com/gb/privacy">here</a>. If you would like to see the information we capture on this website, please click <a href="http://blog.affiliatewindow.com/wp-content/uploads/2012/05/AFFILIATE-WINDOW-COOKIES-WEBSITE-INTERFACE-WIKI-COOKIES.pdf">here</a> for further details. In order to accept cookies on this site please click the 'I ACCEPT' button</p> <button>I ACCEPT</button> </div> </div> </div> <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script type="text/javascript" src="/skins/common/eprivacy.js"></script> <script type="text/javascript">if (window.runOnloadHook) runOnloadHook();</script>  </div> </body></html>