Nikki Klock Posted January 4, 2021 Report Share Posted January 4, 2021 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 comment Share on other sites More sharing options...
Ian Posted January 4, 2021 Report Share Posted January 4, 2021 Maybe a web scraper / bot triggering something. Hard to say without any logging or more information Quote Link to comment Share on other sites More sharing options...
cnr210832 Posted January 6, 2021 Report Share Posted January 6, 2021 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 comment Share on other sites More sharing options...
cnr210832 Posted January 12, 2021 Report Share Posted January 12, 2021 This still is going on. ... anyone have possible insight? Quote Link to comment Share on other sites More sharing options...
ajotadmin Posted January 14, 2021 Report Share Posted January 14, 2021 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 comment Share on other sites More sharing options...
JLW Posted March 27, 2021 Report Share Posted March 27, 2021 We have a similar issue where one particular advertiser has 100x more clicks than impressions? :O( Quote Link to comment Share on other sites More sharing options...
Ian Posted March 27, 2021 Report Share Posted March 27, 2021 Try updating to the latest version Quote Link to comment Share on other sites More sharing options...
JLW Posted March 29, 2021 Report Share Posted March 29, 2021 (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, 2021 by JLW Quote Link to comment Share on other sites More sharing options...
JLW Posted April 2, 2021 Report Share Posted April 2, 2021 Resolved ? Quote Link to comment Share on other sites More sharing options...
Ian Posted April 2, 2021 Report Share Posted April 2, 2021 12 minutes ago, JLW said: Resolved ? Please enlighten us ? Quote Link to comment Share on other sites More sharing options...
Janvi Arora Posted February 15, 2022 Report Share Posted February 15, 2022 I also came across this type of situation for one of my project. As I update the application, this got resolved and I could able to receive the expected results. It is very important to get the correct ratio for impressions and clicks. Incorrect information may divert your client. Good to know that this issue has been resolved. Please guide us how did you find the way out of it. Quote Link to comment Share on other sites More sharing options...
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.