Nikki Klock 0 Posted January 4 Report Share Posted January 4 An advertiser brought to my attention today that their regular automatic statistics report showed a huge spike in impressions and clicks for their ad on 2 days during the reporting period and was wondering what that was about. Like they usually get 0-5 clicks per week and the report shows 450 in one day. We didn't have a commensurate spike in web traffic that day so I'm not sure what to tell him. Has anyone found a likely culprit for an inexplicable spike in the clicks report? I hate to undermine our advertisers' trust in the data we're showing them on their ad's performance. Quote Link to post Share on other sites
Ian vM 59 Posted January 4 Report Share Posted January 4 Maybe a web scraper / bot triggering something. Hard to say without any logging or more information Quote Link to post Share on other sites
cnr210832 0 Posted January 6 Report Share Posted January 6 How would one go about searching and finding out of this was a bot or scraper? What logs would log this data? A server-wide log? Or how would one set up logging to catch if this is going on? Well, I found the debug.log. It's full of these pieces of text, pretty much the same text over and over so just this piece I think suffices to paste? Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Running Maintenance Engine Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Running Maintenance Statistics Engine Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] MaxMind GeoIP2 license key missing, skipping auto-update Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - Maintenance statistics will be run Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - The intermediate table statistics will be updated Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - The final table statistics will be updated Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - The kq29bzox_data_bkt_a table is a raw data table. Data logged in real-time, not operation intervals. Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - Accordingly, pruning of the kq29bzox_data_bkt_a table will be performed based on data that has a logged date between Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] 2021-01-06 22:00:00 UTC and 2021-01-06 22:59:59 UTC Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - The kq29bzox_data_bkt_a_var table is a raw data table. Data logged in real-time, not operation intervals. Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - Accordingly, pruning of the kq29bzox_data_bkt_a_var table will be performed based on data that has a logged date between Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] 2021-01-06 22:00:00 UTC and 2021-01-06 22:59:59 UTC Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task complete: OX_Maintenance_Statistics_Task_MigrateBucketData Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversions Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversions Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageConversions Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageConversions Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task begin: OX_Maintenance_Statistics_Task_SummariseFinal Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task complete: OX_Maintenance_Statistics_Task_SummariseFinal Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task begin: OX_Maintenance_Statistics_Task_LogCompletion Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task complete: OX_Maintenance_Statistics_Task_LogCompletion Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageCampaigns Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - Managing (activating/deactivating) campaigns Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Maintenance Statistics Engine Completed (Started at 2021-01-06 23:06:35 UTC) Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Running Maintenance Priority Engine Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - Selecting Zones forecasts for all managers for OI from 2021-01-06 23:00:00 to 2021-01-06 23:59:59 Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - Selecting Zones forecasts for all managers for OI from 2021-01-06 23:00:00 to 2021-01-06 23:59:59 Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - Selecting All Managers Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - Selecting active campaigns with priority = '9' for manager 1 Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - Selecting active campaigns with priority = '8' for manager 1 Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - Selecting active campaigns with priority = '7' for manager 1 Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - Selecting active campaigns with priority = '6' for manager 1 Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] - Selecting Managers with ECPM priority campaigns running Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Maintenance Priority Engine Completed (Started at 2021-01-06 23:06:35 UTC) Jan 06 18:06:35 -0500 OX-maintenance-5ff6427b90ca7 [ info] Maintenance Engine Completed (Started at 2021-01-06 23:06:35 UTC, taking 00:00:00) Jan 06 18:06:35 -0500 OX-5ff6427b90ca7 [ info] Automatic Maintenance Task Completed Quote Link to post Share on other sites
cnr210832 0 Posted January 12 Report Share Posted January 12 This still is going on. ... anyone have possible insight? Quote Link to post Share on other sites
ajotadmin 1 Posted January 14 Report Share Posted January 14 I had similar issues with Hosted Edition where on a couple of days it was out of control. Ridiculous impressions in a couple hours and insane click numbers for a coupe of hours. More than 10x the average clicks on a couple days. These are with email ads, which shouldn't even be seen by bots. Quote Link to post Share on other sites
JLW 1 Posted March 27 Report Share Posted March 27 We have a similar issue where one particular advertiser has 100x more clicks than impressions? :O( Quote Link to post Share on other sites
Ian vM 59 Posted March 27 Report Share Posted March 27 Try updating to the latest version Quote Link to post Share on other sites
JLW 1 Posted March 29 Report Share Posted March 29 (edited) Hi Ivan, We are on the latest version... :O( You are currently using Revive Adserver v5.2.0 running on Apache, PHP 7.1.33 and MySQL 5.7.33-. Your version of Revive Adserver is up-to-date. There are currently no updates available. Edited March 29 by JLW Quote Link to post Share on other sites
Ian vM 59 Posted April 2 Report Share Posted April 2 12 minutes ago, JLW said: Resolved 🙂 Please enlighten us 🙂 Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.