Jump to content

Search the Community

Showing results for tags 'Statistics'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Using and Managing Revive Adserver
    • Documentation
    • Using Revive Adserver
    • Managing Revive Adserver
    • Bugs
  • Advanced Topics
    • Performance, Scalability, and Reliability
    • For Developers
  • Revive Adserver Community
    • Revive Adserver Project News and Announcements
    • Feature Requests
    • Plugins
    • Requests for Consulting
    • Off Topic

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Website URL

Found 32 results

  1. Hello Revive Adserver Community, I am trying to figure out why my community edition of the revive adserver stopped logging the statistics for the banners. Here is what I have found out thus far. The Cron job is running without any errors being entered into /var/logs/cron. If I manually run the maintenance.php script, I get an output of #!/usr/bin/php -q (not sure what that means). Looking in the debug log, I found that the script for maintenance is running, but this line was odd: - Updating the data_summary_ad_hourly table for data after 2016-03-20 15:00:00 UTC. Ironically, that's the day the statistics stopped. I did check into the database and found I had to repair data_bkt_m and thus I did that via phpmyadmin. I am at a stumbling block as I can't seem to figure out why it wont' log any statistics. Any help is appreciated. Thanks.
  2. EDIT: As clarification, I am running Ubuntu 14.04.4 LTS. Hello everyone! New to the forum. I have been digging around the code to find a solution to this problem: looking on Github link, I see the message is originally displayed based on the following condition: $extensionLoaded https://raw.githubusercontent.com/revive-adserver/revive-adserver/eb2a1703e538d157e7a1c2aeeb2a1ce8591795d5/lib/templates/admin/dashboard/graph.html If we follow the use of this variable, it leads us to the file linked below, specifically where the following variable is declared: $gdAvailable https://raw.githubusercontent.com/revive-adserver/revive-adserver/eb2a1703e538d157e7a1c2aeeb2a1ce8591795d5/lib/OA/Dashboard/Graph.php Inspecting the following leads me to believe that GD installation is being detected via the following line: $gdAvailable = extension_loaded('gd'); I performed an echo test with the following snippet: <?php echo extension_loaded('gd'); ?> As expected, the result output is a simple: "1". Having installed GD via the command line below, shows me that I have everything I need: sudo apt-get install php5-gd I have validated in many ways that I do indeed have GD functioning properly. Example output for command: $ php -i | grep -i --color gd /etc/php5/cli/conf.d/20-gd.ini, gd GD Support => enabled GD Version => 2.1.1-dev gd.jpeg_ignore_warning => 0 => 0 Any thoughts?
  3. This should be simple I hope. I had multiple issues doing an upgrade so I just did a fresh install on another server so not to confuse anything. Added a few small sites to test and all seems great except for one minor thing, my stats are blank. Now the graph on the home page shows impressions and the adgraph plugin also show impressions by day also but the reports show nothing. I did the clearing of the 2 folders as suggested - no difference. Checked, via diagnose, all plugins, no issue either. Exporting shows no stats also. Other than that, all seems well. Anyone have any ideas? Thanks howard
  4. Hi there, I've installed and successfully configured Revive, and it is awesome. I'm serving a test ad on a test property right now, and I want to know how frequently the Statistics page in Revive is updated, and if this is a customizable variable. My test ad has been running for about an hour, and I've clicked it several times from external sources, but have not seen the statistics reflected within Revive. Any insight would be greatly appreciated. And thanks again to the Devs/Contributors, this is a pretty amazing platform. EDIT: Turns out I was just being antsy, the stats are showing up now. But I am still curious if the reporting time can be altered.
  5. I have two Revive installations. One of them has been active for 7 years (was OpenX) and is working fine. The other is a couple of months old and is working well except for statistics. On an advertiser/advertiser history page of the older installation I see stats and a date range selector. On the new installation the page is blank. On BOTH of them if I go to Advanced Reports/Campaign Delivery Report I see the date selector/advertiser and site dropdowns and when filled out and submitted I get an xls with stats. Do I need to change a setting somewhere which is preventing me from seeing stats on the advertiser/advertiser history page? Thank you.
  6. Hello, I set up Revive and already managed to set up and deliver a text banner. The impressions of this ad banner are correctly counted (f.x.) on Statistics / Global History. So, as far as I can tell, everything works just fine. Now I would be interested in more fine grained statistics on an impression / request level. Especially I would like to be able to figure out the HTTP Referer information which was sent along with the impression / request. Taking a look at the DB I found to very promising tables: rv_data_raw_ad_requestrv_data_raw_ad_impressionBoth tables contain a field named "referer". But for unknown reasons both tables remain empty. Do I have to switch logging on impression / request level on somewhere? Kind Regards Raffael
  7. Hi all, I'm currently looking at implementing Revive but I need raw impressions and click stats which I understand (reading the forums) was originally part of OpenX but has now been removed in favour of the stats bucket system. Is there an easy way to reenable the recording of raw stats that will include things such as browser type and geo information where available. Thanks, Matt
  8. Hi, for now Revive generates the statistics once per hour. Is there a way to have this done twice per hour or even every 15 minutes? Thanks, Marti
  9. I was wondering if there is any way to remove some columns from statistics page when an Advertiser logged in. Currently it shows the eCPM and Rev. details to advertisers. We can remove those columns globally but not only for advertisers. Is there any way to modify that? Thanks in advance.
  10. I am not able to see any statistics on revive-adserver application. Everything else is working fine on revive adserver except statistics. It is showing only dates and not the adclicks and other information. On further debugging, I found that data is not storing at table rv_data_bkt_m. I am using only google adsense as banner. Is this the reason for not showing statistics Please suggest.
  11. Hi, I have recently installed the Revive Adserver v3.2.2 , I have created 2 campaigns. One remnant and one contract. Both are serving one banner. I have served these banners through Revive and they did appear on the site's zones. There are currently 2 websites and each site has 1 zone each. My Current statistics reports say.: There are currently no statistics available for the period 23-11-2015 to 29-11-2015 I have checked quiet a few solutions online about it. My maintenance is working fine. I have checked the logs in the /var folder. The following are the tables i have in my database: rv_account_preference_assoc | | rv_account_user_assoc | | rv_account_user_permission_assoc | | rv_accounts | | rv_acls | | rv_acls_channel | | rv_ad_category_assoc | | rv_ad_zone_assoc | | rv_affiliates | | rv_affiliates_extra | | rv_agency | | rv_application_variable | | rv_audit | | rv_banners | | rv_campaigns | | rv_campaigns_trackers | | rv_category | | rv_channel | | rv_clients | | rv_data_intermediate_ad | | rv_data_intermediate_ad_connection | | rv_data_intermediate_ad_variable_value | | rv_data_raw_ad_click | | rv_data_raw_ad_impression | | rv_data_raw_ad_request | | rv_data_raw_tracker_impression | | rv_data_raw_tracker_variable_value | | rv_data_summary_ad_hourly | | rv_data_summary_ad_zone_assoc | | rv_data_summary_channel_daily | | rv_data_summary_zone_impression_history | | rv_database_action | | rv_images | | rv_log_maintenance_forecasting | | rv_log_maintenance_priority | | rv_log_maintenance_statistics | | rv_password_recovery | | rv_placement_zone_assoc | | rv_preferences | | rv_session | | rv_targetstats | | rv_tracker_append | | rv_trackers | | rv_upgrade_action | | rv_userlog | | rv_users | | rv_variable_publisher | | rv_variables | | rv_zones | +----------------- Is there something missing that i need to add/remove. Following are the plugins that i have : apStatsGraphs Invocation Tags PluginMaxMind GeoIP PluginBanner Delivery Cache Store PluginReports Plugin3rd Party Servers PluginDelivery Limitations Plugin Banner Types PluginI dont know what i need to. Please help fast.
  12. My Revive installation stopped counting stats all of a sudden the other day. The reason was quite simple, one of the Mysql tables (<prefix>_data_intermediate_ad) was broken (and the var/debug.log grows quite fast). Here's how to fix, in case someone else runs into the same issue: mysqlcheck -uroot -p <revive_database> --repair
  13. Hi. In revive statistics are updated every hour. If that is true, is there any way for faster statistic update?
  14. Hi, Recently we started to note huge differences between the amounts of requests and impressions. There can event be more than twice as many requests as impressions. This problem affects only certain combinations of banners and zones. Thus: What can be the reason for non equal amounts of requests and impressions?Is this problem on server side or something fails in the browserWhat is the typical/acceptable disproportion. (I assume there will always be some difference)Are there any tests we can perform to gather more data about the problem?We are using: Revive Adserver v3.2.1 running on Apache 2.4.7, PHP 5.5.9-1ubuntu4.11 and MySQL 5.6.10-. I will be very grateful for any help. --edited Recently we even note that there are counted requests to the campaigns which invocation codes are nowhere posted.
  15. Hi, I would like to see my reports in UTC or GMT. I do not see such option in the list of timezones in Account preferences, under "Timezone preferences". Currently, "GB" is UTC+1 (in contrary to what the interface states - "GMT+0000"), so I can not really use "GB". I have manually edited database and entered "UTC" instead of "GB" in the table of preferences, and this fixed my issue, but the question is: is there a conventional way to set UTC unsing UI?
  16. After inserting some banners i noticed the last banner do not give me statistics i guess after updating Revive, i noticed the statistics stopped after 9 juli 2015. i also have notice some tables wher not in the database: rv_data_bkt_a rv_data_bkt_a_var rv_data_bkt_c rv_data_bkt_m rv_data_bkt_r rv_data_bkt_vast_e Those tables i inserted in the database and noticed in rv_data_bkt_m some statistics then strange tables rv_z_2c0b71c7be138cd7 rv_z_5b84e47292cda283 and so on.... what is wrong
  17. Hi All, I am new to AdServing and thus have a few questions: 1) I have used various types of image banners, can I use .gif banners like that? 2) For scheduled maintenance, can I use wget on Windows 7? 3) May be this is a silly question but still I wish to ask, how will my clients get convinced by the results when I show them the XML sheets of statistics of the campaign ? It is because they may have doubts that the results are woven by me. Kindly let me know on that as I am a new guy in this business. Thanks a lot !!
  18. I have two sites. a server does not record the impressions revive adserver, as in other accounts. what's different between them?
  19. I have configured geotargetting OK an I show banners with geografical conditions. For Example banners where city= Madrid OR city=Barcelona etc ... but how can I see the number or ads shown in each different cities?
  20. For whatever reason, clicks (via ck.php) don't seem to be tracking in my adserver. The zone tags all display properly, and the click passes through to the correct destination URL via the 'ck.php' delivery script. I've tried: a) enabling the global debug log --> No delivery or impression warnings/notices b ) repairing the stats via the republish & other maintenance tool scripts--no errors in the debug log c) checking `rv_data_intermediate_ad' (no clicks registered)... `rv_data_bkt_r` and `rv_data_bkt_m` (the impression tables) look fine, but `rv_data_bkt_c` is empty d) verified the existence and functionality of the GeoIP plugin (+ php C lib extension) So... not quite sure what to do next. For whatever reason the instance appears to be set up and configured properly, however the compiled click delivery script is somehow failing to log to the DB but without any INSERT errors as I would expect. Any advice? Is there some parameter perhaps that's being caught in a conditional thus causing the click to not register? For what it's worth, this is a development environment with no IP or other restrictions set.
  21. Is there a way to hide/show the nav links on the left side of the stats page based on if the user is an advertiser, publisher, or admin? I'm talking about these links in stats.php: advertiser history, campaigns, website distribution, and advanced reports. Also, is there a way to add additional links there? I can't find where this is handled... Any help would be greatly appreciated! Thanks
  22. Hello friends, okay? I'm using version 3.0.5 and apparently is working perfectly. However, I do not know why, some campaigns and clients, have data and statistics of views and clicks, but some do not have anything. However, the banners are displayed correctly, but do not generate statistics for some advertisers. What can it be? ---- Edited ---- Friends, I am doing a test. I had upgraded from Open X (latest version). With this, all plugins were used in OpenX. I disabled and uninstalled all well then (now). I installed again all existing plugins in the install file of Revive Adserver (.../etc/plugins/). I will await the generation of statistics to see if everything is back to normal now ...
  23. Hello! My employer has been using Revive Adserver for a long time (well before I started early in the year), where over the past couple of months I have been able to successfully migrate it to a new server and perform an upgrade to the latest version with no issues (at least, no issues with the software). A few weeks ago, we came across an issue where stats hadn't migrated for a couple of weeks, which was quickly fixed by running maintenance manually and adjusting its settings. Things were running with no issues until this past Thursday, where it looks like the server it resides on was rebooted in the evening (which I am trying to see why this had happened). Since that reboot, the ox_data_bkt_m table has been recording values as expected, however maintenance runs following that have not migrated data. The debug.log shows "Automatic Maintenance Task not run: could not acquire lock" around that time, which makes sense if that was being run before MySQL was fully running. Here is a set of the debug.log outputs following the reboot: Nov 26 21:05:00 -0500 OX-547686ccc9a95 [ info] Running Automatic Maintenance Task Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] Running Maintenance Engine Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] Running Maintenance Statistics Engine Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] - Maintenance statistics will be run Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] - The intermediate table statistics will be updated Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] - The final table statistics will be updated Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] - The ox_data_bkt_a table is a raw data table. Data logged in real-time, not operation intervals. Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] - Accordingly, pruning of the ox_data_bkt_a table will be performed based on data that has a logged date between Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] 2014-11-27 01:00:00 UTC and 2014-11-27 01:59:59 UTC Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] - The ox_data_bkt_a_var table is a raw data table. Data logged in real-time, not operation intervals. Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] - Accordingly, pruning of the ox_data_bkt_a_var table will be performed based on data that has a logged date between Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] 2014-11-27 01:00:00 UTC and 2014-11-27 01:59:59 UTC Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ error] ERROR: Could not migrate aggregate bucket data from the 'ox_data_bkt_c', 'ox_data_bkt_m', 'ox_data_bkt_r' bucket table(s) Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ error] Error message was: MDB2 Error: Array Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] Task complete: OX_Maintenance_Statistics_Task_MigrateBucketData Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversions Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversions Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageConversions Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageConversions Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] Task begin: OX_Maintenance_Statistics_Task_SummariseFinal Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] Task complete: OX_Maintenance_Statistics_Task_SummariseFinal Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] Task begin: OX_Maintenance_Statistics_Task_LogCompletion Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] Task complete: OX_Maintenance_Statistics_Task_LogCompletion Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageCampaigns Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [ info] - Managing (activating/deactivating) campaigns Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [ info] Maintenance Statistics Engine Completed (Started at 2014-11-27 02:05:01 UTC) Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [ info] Running Maintenance Priority Engine Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting Zones forecasts for all managers for OI from 2014-11-27 02:00:00 to 2014-11-27 02:59:59 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] Inserted 10362 rows in the table tmp_ad_zone_impression Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting Zones forecasts for all managers for OI from 2014-11-27 02:00:00 to 2014-11-27 02:59:59 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting All Managers Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '9' for manager 4 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '8' for manager 4 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '7' for manager 4 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '6' for manager 4 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '9' for manager 3 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '8' for manager 3 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '7' for manager 3 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '6' for manager 3 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '9' for manager 6 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '8' for manager 6 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '7' for manager 6 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '6' for manager 6 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '9' for manager 7 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '8' for manager 7 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '7' for manager 7 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting active campaigns with priority = '6' for manager 7 Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] - Selecting Managers with ECPM priority campaigns running Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] Maintenance Priority Engine Completed (Started at 2014-11-27 02:05:01 UTC) Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [ info] Maintenance Engine Completed (Started at 2014-11-27 02:05:01 UTC, taking 00:00:22) Nov 26 21:05:23 -0500 OX-547686ccc9a95 [ info] Automatic Maintenance Task Completed With anything I've looked up, I haven't been able to find any further information past running maintenance manually, which has not helped. Any assistance or direction would be greatly appreciated. Thank you!
  24. Hi there, Is there a way to see reports of campaigns broken down by country and city, displayed in a table as all other types of standard reports? Cheers, Alex
  25. Hi there: I upgraded to Revive and my stats pages - all of them, Advertisers & Campaigns through Advanced Reports, are blank. I tried the suggestion here: http://forum.revive-adserver.com/topic/1007-displayed-stats-after-305-upgrade/ And that didn't help. Do you have any other suggestion as to how I can restore my statistic reporting and get them to display? Thanks!
×
×
  • Create New...