Eli's WordPress Blog

My WordPress Plugins, and other stuff.

Main menu

Skip to primary content
Skip to secondary content
  • All Posts
  • Anti-Malware
  • Google Analytics
  • Related Posts
  • SHORTcURL
  • SQL Reports

Tag Archives: adsense

Added Google adSense Analytics to the dashboard

Posted on June 11, 2012 by Eli Scheetz
Reply

I just release version 1.2.06.10 of my adSense Widget with a huge new feature. You can now view your adSense Analytics right on the dashboard. I integrated OAuth2 into the Dashboard Widget so you can securely generate graphs of your adSense statistics.


Download of WordCents from WordPress.org

Posted in WordCents adSense Widget | Tagged adsense, analytics, dashboard, widget | Leave a reply

Monetize your blog with my WordCents adSense Widget

Posted on March 16, 2012 by Eli Scheetz
14

This is a simple widget that makes it easy to monetize your site with Google adSense.


Download of WordCents from WordPress.org

Posted in WordCents adSense Widget | Tagged adsense, Google, monetize, widget, WordPress | 14 Replies

Archives

Recomended Software

  • SpiderOak SpiderOak
  • Ubuntu Ubuntu
Proudly powered by WordPress2011 Child Theme by
  Globals Profiler (1,046.97 ms) SQL (93 queries in 16.16 ms) Errors (0) Toggle Close
$_GET = array (
);

$_POST = array (
);

$_COOKIE = array (
);

$_SESSION = array (
  'GOTMLS_SESSION_LAST' => 0,
  'GOTMLS_SESSION_TIME' => 1695757861.88897,
  'GOTMLS_detected_attacks' => '',
  'GOTMLS_login_attempts' => 0,
);

$_SERVER = array (
  'SERVER_SOFTWARE' => 'Apache',
  'REQUEST_URI' => '/tag/adsense/',
  'CONTEXT_DOCUMENT_ROOT' => '/home/elijah/sites/wordpress.ieonly.com/public_html',
  'CONTEXT_PREFIX' => '',
  'DOCUMENT_ROOT' => '/home/elijah/sites/wordpress.ieonly.com/public_html',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'HTTPS' => 'on',
  'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
  'HTTP_ACCEPT_ENCODING' => 'br,gzip',
  'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5',
  'HTTP_AUTHORIZATION' => '',
  'HTTP_CONNECTION' => 'Keep-Alive',
  'HTTP_HOST' => 'wordpress.ieonly.com',
  'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
  'PATH' => '/bin',
  'PERL5LIB' => '/usr/share/awstats/lib:/usr/share/awstats/plugins',
  'QUERY_STRING' => '',
  'REDIRECT_HTTPS' => 'on',
  'REDIRECT_HTTP_AUTHORIZATION' => '',
  'REDIRECT_PERL5LIB' => '/usr/share/awstats/lib:/usr/share/awstats/plugins',
  'REDIRECT_SSL_TLS_SNI' => 'wordpress.ieonly.com',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_UNIQUE_ID' => 'ZRM2JTVV2EjipklB8TuJ5AAAAEc',
  'REDIRECT_URL' => '/tag/adsense/',
  'REMOTE_ADDR' => '3.214.184.223',
  'REMOTE_PORT' => '46036',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_SCHEME' => 'https',
  'SCRIPT_FILENAME' => '/home/elijah/sites/wordpress.ieonly.com/public_html/index.php',
  'SCRIPT_NAME' => '/index.php',
  'SERVER_ADDR' => '158.69.23.200',
  'SERVER_ADMIN' => 'root@localhost',
  'SERVER_NAME' => 'wordpress.ieonly.com',
  'SERVER_PORT' => '443',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'SERVER_SIGNATURE' => '',
  'SSL_TLS_SNI' => 'wordpress.ieonly.com',
  'UNIQUE_ID' => 'ZRM2JTVV2EjipklB8TuJ5AAAAEc',
  'dont_vary' => '1',
  'no_gzip' => '1',
  'PHP_SELF' => '/index.php',
  'REQUEST_TIME_FLOAT' => 1695757861.873365,
  'REQUEST_TIME' => 1695757861,
);

Profiler Initiaded 0.0000 ms 36337 kB
Profiler Noise 0.0038 ms 36337 kB
Profiler Stopped 1,046.9730 ms 93672 kB
0.2520 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1;
0.0861 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1;
0.1268 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_scan_log/3.214.184.223/1695757862.004' LIMIT 1;
0.2720 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'at_options' LIMIT 1;
0.0858 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_edit_links_calypso_redirect' LIMIT 1;
0.1531 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
0.2561 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_allow_tracking' LIMIT 1;
0.1562 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
0.0830 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors' LIMIT 1;
0.0839 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_error_idc' LIMIT 1;
0.1750 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;
0.1149 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1;
0.1171 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_excluded_extensions' LIMIT 1;
0.2348 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_navigation_enabled' LIMIT 1;
0.1049 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;
0.1340 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;
0.1211 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_view_subscriptions_endpoint' LIMIT 1;
0.1340 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_account_data' LIMIT 1;
0.1190 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_platform_checkout' LIMIT 1;
0.1268 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_customer_multi_currency' LIMIT 1;
0.1440 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_currency_format' LIMIT 1;
0.1619 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_currency_format' LIMIT 1;
0.1311 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_locale_info' LIMIT 1;
2.7471 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_locale_info' LIMIT 1;
0.1070 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_upe' LIMIT 1;
0.1140 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_non_blocking' LIMIT 1;
0.2129 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_logging_enabled' LIMIT 1;
0.1280 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_display_enabled' LIMIT 1;
0.1330 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_services' LIMIT 1;
0.1240 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_setup_automated_taxes' LIMIT 1;
0.0939 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_disabled_plugins' LIMIT 1;
0.1390 [ms]
SELECT * FROM wp_posts WHERE ID = 1676 LIMIT 1;
0.1020 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcs_do_subscriptions_exist' LIMIT 1;
0.0949 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcs_do_subscriptions_exist' LIMIT 1;
0.1171 [ms]
SELECT ID FROM wp_posts WHERE post_type = 'shop_subscription' LIMIT 1;;
0.0951 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'webpc_settings' LIMIT 1;
0.0842 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'webpc_token_data' LIMIT 1;
0.1841 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'medium_crop' LIMIT 1;
0.1030 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'medium_large_crop' LIMIT 1;
0.0741 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'large_crop' LIMIT 1;
0.0951 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_thumbnail_cropping' LIMIT 1;
0.0970 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_retrieval_error' LIMIT 1;
0.0992 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_cached_currencies' LIMIT 1;
0.0660 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enabled_currencies' LIMIT 1;
0.0632 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_charm_usd' LIMIT 1;
0.0482 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_rounding_usd' LIMIT 1;
0.0501 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_exchange_rate_usd' LIMIT 1;
0.0861 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enable_auto_currency' LIMIT 1;
0.0808 [ms]
SELECT zone_id, zone_name, zone_order FROM wp_woocommerce_shipping_zones order by zone_order ASC, zone_id ASC;;
0.1049 [ms]
SELECT location_code, location_type FROM wp_woocommerce_shipping_zone_locations WHERE zone_id = 0;
0.0789 [ms]
SELECT method_id, method_order, instance_id, is_enabled FROM wp_woocommerce_shipping_zone_methods WHERE zone_id = 0;
0.0839 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_flat_rate_settings' LIMIT 1;
0.0801 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_free_shipping_settings' LIMIT 1;
0.0670 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_international_delivery_settings' LIMIT 1;
0.0620 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_delivery_settings' LIMIT 1;
0.0730 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_pickup_settings' LIMIT 1;
0.0539 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_doing_cron' LIMIT 1;
0.0942 [ms]
SELECT option_value FROM wp_options WHERE option_name = '_transient_doing_cron' LIMIT 1;
0.4618 [ms]
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1695757862.3684630393981933593750', 'yes') ON
DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
0.3679 [ms]

			SELECT  t.term_id
			FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
			WHERE tt.taxonomy IN ('post_tag') AND t.slug IN ('adsense')
			
			LIMIT 1
		;
0.2069 [ms]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (50);
0.3040 [ms]

					SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
					WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (53)
) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')))
					GROUP BY wp_posts.ID
					ORDER BY wp_posts.post_date DESC
					LIMIT 0, 10
				;
0.1261 [ms]
SELECT FOUND_ROWS();
0.1361 [ms]
SELECT wp_posts.* FROM wp_posts WHERE ID IN (353,280);
0.1590 [ms]
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (353,280) ORDER BY meta_id ASC;
0.3321 [ms]

			SELECT DISTINCT t.term_id, tr.object_id
			FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id =
tt.term_taxonomy_id
			WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (353, 280)
			ORDER BY t.name ASC
			
		;
0.2301 [ms]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (54,72,17,49,20,48,108);
0.1171 [ms]
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REMOTE_ADDR' AND meta_value = '3.214.184.223';
0.1740 [ms]
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_USER_AGENT' AND meta_value = 'CCBot/2.0 (https://commoncrawl.org/faq/)';
0.1330 [ms]
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_REFERER' AND meta_value = '';
0.0880 [ms]
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REQUEST_URI' AND meta_value = '/tag/adsense/';
0.3829 [ms]
INSERT INTO wp_shareable_hits (`MONTH_OF`, REMOTE_ADDR, HTTP_USER_AGENT, HTTP_REFERER, REQUEST_URI, last_view, wp_user, hit_count) VALUES ('2023-09',
40690, 7541, 16079, 118, '2023-09-26 19:51:03', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2023-09-26 19:51:03', wp_user = 0, hit_count = hit_count +
1;
0.1190 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cart_page_id' LIMIT 1;
0.0730 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_checkout_page_id' LIMIT 1;
0.0708 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_page_id' LIMIT 1;
0.1030 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'sharedaddy_disable_resources' LIMIT 1;
0.1202 [ms]
SELECT * FROM wp_posts WHERE ID = 1677 LIMIT 1;
0.0892 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1;
0.0949 [ms]
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_demo_store' LIMIT 1;
0.1709 [ms]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 105;
0.2880 [ms]

			SELECT   wp_posts.*
			FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
			WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (108)
) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish'))
			GROUP BY wp_posts.ID
			ORDER BY wp_posts.menu_order ASC
			
		;
0.3421 [ms]
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (620,623,624,626,628,629) ORDER BY meta_id ASC;
0.1712 [ms]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (44,103,21,84,35);
0.1552 [ms]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 22;
0.3331 [ms]
SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;
0.0861 [ms]
SELECT * FROM wp_users WHERE ID IN (1);
0.1988 [ms]

			SELECT DISTINCT t.term_id
			FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id =
tt.term_taxonomy_id
			WHERE tt.taxonomy IN ('category') AND tr.object_id IN (353)
			ORDER BY t.name ASC
			
		;
0.1869 [ms]

			SELECT DISTINCT t.term_id
			FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id =
tt.term_taxonomy_id
			WHERE tt.taxonomy IN ('category') AND tr.object_id IN (280)
			ORDER BY t.name ASC
			
		;
0.2351 [ms]
SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts  WHERE post_type = 'post' AND post_status = 'publish'
GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC ;
0.1872 [ms]

					SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					FROM wp_posts 
					WHERE 1=1  AND ( 
  ( YEAR( wp_posts.post_date ) = 2022 AND MONTH( wp_posts.post_date ) = 9 )
) AND ( 
  YEAR( wp_posts.post_date ) < 2023
) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')))
					
					ORDER BY wp_posts.post_date ASC
					LIMIT 0, 15
				;
0.1500 [ms]

			SELECT  t.term_id
			FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
			WHERE tt.taxonomy IN ('link_category') AND t.term_id IN ( 43 ) AND tt.count > 0
			ORDER BY t.name ASC
			
		;
0.1180 [ms]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (43);
0.2329 [ms]
SELECT *    FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON
tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 43 ) AND taxonomy = 'link_category'    ORDER BY
link_name ASC;