Another update for version 3.0 of our platform is out. In fact, small updates come out almost every day, but we’re too lazy to write about each one.
Major updates:
– You can now move orders between companies, either carrying over or resetting their processing history. Leads that ended up in the wrong place can now be redirected to the right destination in two clicks — even if they’ve already been processed.
– Companies are now blocked once they hit their account balance limit. There’s no better motivation for your advertisers to pay their overdue invoices than cutting off access to orders and the integration mechanism.
– Your affiliates can now use additional analytics systems in their Flows: VK and Facebook pixels, Google Tag Manager
– For convenience, we’ve finally turned on automatic detection of duplicate orders as they’re added. This option is backward compatible with existing integration mechanisms, so you won’t have to bother your agents.
Miscellaneous minor fixes:
– Traffic breakdown by GEO has now been added to the internal analytics tools as well.
– Fixed a bug in GEO detection on landing pages. Just one line added, and yet so many problems left behind…
– We’ve now completely abandoned Flow-style links such as ?12-34, since they’ve stopped working correctly in more than half of all cases.
– Improved the mechanism for splitting incoming orders by share. Distribution accuracy is now higher. You can now set fractional distribution percentages. Why not — what if you’ve got 10K leads a day?
Important! After updating the files, be sure to run the following SQL query in the database, or the dark side of the Force won’t be able to bring you cookies:
ALTER TABLE `cpa_call` ADD `call_geo` CHAR(2) NOT NULL AFTER `call_cur`, ADD INDEX (`call_geo`);
UPDATE `cpa_call` SET call_geo = ( SELECT order_country FROM cpa_order WHERE cpa_order.order_id = cpa_call.order_id );
ALTER TABLE `cpa_call` ADD `call_delivery` TINYINT UNSIGNED NOT NULL AFTER `call_price`, ADD INDEX (`call_delivery`);
UPDATE `cpa_call` SET call_delivery = ( SELECT order_delivery FROM cpa_order WHERE cpa_order.order_id = cpa_call.order_id );
ALTER TABLE `cpa_flow` ADD `flow_fb` VARCHAR(100) NOT NULL AFTER `flow_mtrk`, ADD `flow_vk` VARCHAR(100) NOT NULL AFTER `flow_fb`, ADD `flow_ga` VARCHAR(100) NOT NULL AFTER `flow_vk`;
ALTER TABLE `cpa_cash` ADD `cash_uid` VARCHAR(32) NOT NULL AFTER `cash_time`, ADD INDEX (`cash_uid`);
ALTER TABLE `cpa_comp` ADD `comp_block` INT NOT NULL AFTER `comp_name`;