Jump to content

Inaccurate clicks report?


Recommended Posts

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. 

Link to comment
Share on other sites

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

 

Link to comment
Share on other sites

  • 2 months later...

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-.
 

 

 
info.gif   Your version of Revive Adserver is up-to-date. There are currently no updates available.
Edited by JLW
Link to comment
Share on other sites

  • 10 months later...

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.

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...