Jump to content

Revive Statistics


Recommended Posts

Hello!

 

I want to change refresh interval of statistics in my Revive. Impressions and clicks are counted after 1h. How to change this process? I would like to accelerate this process to hmm 1 minute per refresh?

Is it possible? Does this sth common with task scheduler?

 

I configured crontab on my adserver:

 

*/1 * * * * /usr/bin/php5 /var/www/html/adserver/revive/scripts/maintenance/maintenance.php root 
 
version: You are currently using Revive Adserver v3.2.0 
 
Example of my last maintenance.php script:
 
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Running Maintenance Engine
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Running Maintenance Statistics Engine
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  - Maintenance statistics will NOT be run
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task complete: OX_Maintenance_Statistics_Task_MigrateBucketData
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversions
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversions
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task begin: OX_Maintenance_Statistics_Task_ManageConversions
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task complete: OX_Maintenance_Statistics_Task_ManageConversions
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task begin: OX_Maintenance_Statistics_Task_SummariseFinal
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task complete: OX_Maintenance_Statistics_Task_SummariseFinal
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task begin: OX_Maintenance_Statistics_Task_LogCompletion
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task complete: OX_Maintenance_Statistics_Task_LogCompletion
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task begin: OX_Maintenance_Statistics_Task_ManageCampaigns
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Maintenance Statistics Engine Completed (Started at 2015-05-30 10:32:01 UTC)
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Running Maintenance Priority Engine
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]    - Selecting Zones forecasts for all managers for OI from 2015-05-30 10:00:00 to 2015-05-30 10:59:59
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  LOAD DATA INFILE / COPY failed or not supported, falling back to INSERTing data by looping over each record...
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Inserted 16 rows in the table tmp_ad_zone_impression
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]    - Selecting Zones forecasts for all managers for OI from 2015-05-30 10:00:00 to 2015-05-30 10:59:59
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  - Selecting All Managers
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]    - Selecting active campaigns with priority = '9' for manager 1
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]    - Selecting active campaigns with priority = '8' for manager 1
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]    - Selecting active campaigns with priority = '7' for manager 1
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]    - Selecting active campaigns with priority = '6' for manager 1
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]    - Selecting active campaigns with priority = '9' for manager 2
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]    - Selecting active campaigns with priority = '8' for manager 2
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]    - Selecting active campaigns with priority = '7' for manager 2
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]    - Selecting active campaigns with priority = '6' for manager 2
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  - Selecting Managers with ECPM priority campaigns running
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Maintenance Priority Engine Completed (Started at 2015-05-30 10:32:01 UTC)
May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [     info]  Maintenance Engine Completed (Started at 2015-05-30 10:32:01 UTC, taking 00:00:00)
In my opinion it's sth with:
OX_Maintenance_Statistics_Task_SetUpdateRequirements
 
this is only running 1 time in hour. Should I change time of this to 1 minutes? How to do this?
 
Waiting for any advice

 

Link to comment
Share on other sites

  • 3 months later...

Hello. I have some problem with this script.
I'm not sure this is the right topic.

My goal is to run the report.

I followed the guide and the only thing that seems to work is not just the maintenance scripts

Does anyone have any idea why it does not work?

This is the log:

Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Running Maintenance Engine
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Running Maintenance Statistics Engine
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Maintenance start run time is 2015-09-29 12:43:00 UTC
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Getting the details of when maintenance statistics last ran on the basis of the operation interval
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Maintenance statistics has never been run before, and no logged delivery data was located in 
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    the database, so maintenance statistics will not be run for the intermediate tables
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Getting the details of when maintenance statistics last ran on the basis of the hour
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Maintenance statistics has never been run before, and no logged delivery data was located in 
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    the database, so maintenance statistics will not be run for the final tables
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  - Maintenance statistics will NOT be run
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task complete: OX_Maintenance_Statistics_Task_MigrateBucketData
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversions
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversions
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task begin: OX_Maintenance_Statistics_Task_ManageConversions
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task complete: OX_Maintenance_Statistics_Task_ManageConversions
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task begin: OX_Maintenance_Statistics_Task_SummariseFinal
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task complete: OX_Maintenance_Statistics_Task_SummariseFinal
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task begin: OX_Maintenance_Statistics_Task_LogCompletion
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Logging the completion of the maintenance statistics run
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task complete: OX_Maintenance_Statistics_Task_LogCompletion
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task begin: OX_Maintenance_Statistics_Task_ManageCampaigns
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Maintenance Statistics Engine Completed (Started at 2015-09-29 12:43:00 UTC)
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Running Maintenance Priority Engine
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  Running Maintenance Priority Engine: Get Required Ad Impressions for High Priority Campaigns
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Where campaign lifetime target(s) and end date are set
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  Running Maintenance Priority Engine: Get Required Ad Impressions for High Priority Campaigns
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Where a daily target is set
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  Running Maintenance Priority Engine: Allocate Zone Impressions
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Getting the impression inventory data for all zones
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]    - Selecting Zones forecasts for all managers for OI from 2015-09-29 12:00:00 to 2015-09-29 12:59:59
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Found that Zone ID 0 is inactive: Using default forecast
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Found that Zone ID 6 is inactive: Using default forecast
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Found that Zone ID 7 is inactive: Using default forecast
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Found that Zone ID 8 is inactive: Using default forecast
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Found that Zone ID 9 is inactive: Using default forecast
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Found that Zone ID 10 is inactive: Using default forecast
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Found that Zone ID 11 is inactive: Using default forecast
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Creating the tmp_ad_zone_impression table
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Inserted 8 rows in the table tmp_ad_zone_impression
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  Running Maintenance Priority Engine: Priority Compensation
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Obtaining maintenance process run information from rv_log_maintenance_priority
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Building zone and creative objects
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Getting the impression inventory data for all zones
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]    - Selecting Zones forecasts for all managers for OI from 2015-09-29 12:00:00 to 2015-09-29 12:59:59
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Getting all of the zones with ad impressions allocated
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Getting all creatives where delivery limitations have changed
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Getting details of previous creative/zone delivery
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Getting details of contract campaign creative/zone pairs that delivered last OI
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Getting details of contract campaign creative/zone pairs that did not deliver last OI (but should have)
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]      - Found 0 contract campaign creative/zone pairs that did not deliver last OI (but should have)
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Finding contract campaign creative/zone pairs set to deliver, but with no past data yet
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Calculating priority values for creative/zone pairs
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Calculating priority values for creatives in Zone ID 0: Basic
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Calculating priority values for creatives in Zone ID 6: Compensated
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Calculating priority values for creatives in Zone ID 7: Compensated
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Calculating priority values for creatives in Zone ID 8: Compensated
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Calculating priority values for creatives in Zone ID 9: Compensated
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Calculating priority values for creatives in Zone ID 10: Compensated
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Calculating priority values for creatives in Zone ID 11: Compensated
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Updating priorities
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Zeroing category-based priorities
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Saving calculated priorities WITHOUT transaction support
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]      - Getting all existing ad/zone pairs with priorities
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]      - Calculating which existing ad/zone pair priorities need to be zeroed
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]      - Zeroing required existing ad/zone pair priorities
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]      - Updating required existing ad/zone pair priorities
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Epiring old priority values in data_summary_ad_zone_assoc
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]    - Adding new priority values to data_summary_ad_zone_assoc
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Recording completion of the Priority Compensation task
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Logging maintenance process run information into rv_log_maintenance_priority
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  Running Maintenance Priority Engine: ECPM value calculation
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Obtaining maintenance process run information from rv_log_maintenance_priority
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  - Selecting All Managers
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]    - Selecting active campaigns with priority = '9' for manager 1
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]    - Selecting active campaigns with priority = '8' for manager 1
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]    - Selecting active campaigns with priority = '7' for manager 1
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]    - Selecting active campaigns with priority = '6' for manager 1
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Recording completion of the ECPM value calculation
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Logging maintenance process run information into rv_log_maintenance_priority
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  Running Maintenance Priority Engine: ECPM for Remnant
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Obtaining maintenance process run information from rv_log_maintenance_priority
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  - Selecting Managers with ECPM priority campaigns running
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Recording completion of the ECPM for Remnant
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [    debug]  - Logging maintenance process run information into rv_log_maintenance_priority
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Maintenance Priority Engine Completed (Started at 2015-09-29 12:43:00 UTC)
Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [     info]  Maintenance Engine Completed (Started at 2015-09-29 12:43:00 UTC, taking 00:00:00)

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