Click references and datafeed help required

[paa1605]

Tweet

Hi guys,

I have a Wordpress affiliate site that uses a plugin to populate posts from a datefeed. I am trying to understand how i can track what items are generating commission through the use of a click reference. I have read articles on affiliate window for example, that state i must add a '&clickref=YOURREFERENCE' to the affiliate link. I understand this, but is there a way to do this quickly and easily to a large number of links that are being automatically pulled from a datafeed. It would take a great deal of time to add this manually to every link in the feed, so i was hoping someone could provide some information as to how they manage their click references when datafeeds are involved?

Many thanks,
Patrick

[scriptmonkey]

Depending on the plugin you're using, you could add the clickref at the point of importing the posts by appending that param to the links.

If you already have hundreds of links in your database without clickrefs, then you could access your wp_posts database table, search and replace in the post_content field;

YOURAWINID=XXXXX
with
YOURAWINID=XXXXX&clickref=YOURCLICKREF

[paa1605]

Thanks for taking the time to reply Scriptmonkey, much appreciated.

I think what i'll do is use the concatenate function in excel and add the click reference part to the url in the aw_deep_link column. When the plugin imports the feed the deeplink should now have the tracking code attached. Hopefully this will work.

Thanks.