Introducing the Advanced Query Builder in AnalyticsWP

We are thrilled to announce a significant upgrade to AnalyticsWP: the Advanced Query Builder. This powerful new feature empowers you to craft custom, flexible, and nested queries on your analytics data directly from the admin dashboard. With this tool, you can dive deeper into your data, uncover hidden trends, and make data-driven decisions with greater confidence.

Key Features

• Intuitive Query Building: Create complex queries effortlessly using a user-friendly interface.
• Flexible Conditions: Combine multiple conditions with AND and OR operators to refine your data precisely.
• Extensive Field Options: Filter analytics data based on fields like referrer, page URL, user agent, UTM parameters, user ID, user email, and device type.
• Device Type Filtering: Specifically target data from desktop, mobile, or tablet devices.
• Real-Time SQL Preview: See the generated SQL query in real-time as you build your filters, allowing for immediate adjustments.
• Helpful Resources: Access a comprehensive video tutorial directly from the Query Builder modal to get you started quickly.

Benefits

• Enhanced Data Analysis: Drill down into specific segments of your audience to understand their behavior better.
• Custom Reporting: Tailor your analytics reports to focus on metrics that matter most to your business goals.
• Improved Decision-Making: Leverage detailed insights to inform marketing strategies, product development, and operational decisions.

---

Examples of Using the Query Builder

To help you harness the full potential of the new Query Builder, we've compiled a series of examples showcasing how to create powerful queries for actionable insights.

Example 1: Identify Mobile Traffic from Google

Objective: Find all page views where the referrer is Google and the device type is mobile.

How to Build the Query:

1. Rule 1:
   • Field: referrer
   • Operator: contains
   • Value: google
2. Rule 2:
   • Field: device_type
   • Operator: =
   • Value: mobile
3. Combine Rules with: AND

SQL Preview:

WHERE referrer LIKE '%google%' AND device_type = 'mobile'

Insight Gained: Understand the volume and behavior of mobile users coming from Google to optimize mobile SEO strategies.

---

Example 2: Analyze Email Campaign Performance

Objective: Examine page views resulting from a specific email campaign.

How to Build the Query:

1. Rule 1:
   • Field: utm_medium
   • Operator: =
   • Value: email
2. Rule 2:
   • Field: utm_campaign
   • Operator: =
   • Value: summer_promo
3. Combine Rules with: AND

SQL Preview:

WHERE utm_medium = 'email' AND utm_campaign = 'summer_promo'

Insight Gained: Measure the effectiveness of your 'Summer Promo' email campaign to refine future email marketing efforts.

---

Example 3: Segment Users by Email Domain

Objective: Identify users with email addresses from a specific domain, such as @company.com.

How to Build the Query:

1. Rule:
   • Field: user_email
   • Operator: ends with
   • Value: @company.com

SQL Preview:

WHERE user_email LIKE '%@company.com'

Insight Gained: Tailor communications or special offers to users from a particular company or organization.

---

Example 4: Exclude Internal Traffic

Objective: Exclude page views from internal team members to ensure accurate analytics.

How to Build the Query:

1. Rule:
   • Field: user_id
   • Operator: not in
   • Value: 101, 102, 103 (Replace with your internal user IDs)

SQL Preview:

WHERE user_id NOT IN (101, 102, 103)

Insight Gained: Obtain a clearer picture of genuine user behavior without internal data skewing results.

---

Example 5: Target Specific UTM Content Variants

Objective: Compare performance across different UTM content variations within a campaign.

How to Build the Query:

1. Rule 1:
   • Field: utm_campaign
   • Operator: =
   • Value: product_launch
2. Rule 2:
   • Field: utm_content
   • Operator: in
   • Value: video_ad, banner_ad, social_post
3. Combine Rules with: AND

SQL Preview:

WHERE utm_campaign = 'product_launch' AND utm_content IN ('video_ad', 'banner_ad', 'social_post')

Insight Gained: Determine which content type drives the most engagement during your product launch.

---

Example 6: Complex Nested Conditions

Objective: Find users who came from either Google or Bing on a mobile device.

How to Build the Query:

1. Group 1 (Nested Rules):
   • Combine with: OR
   • Rule 1:
     • Field: referrer
     • Operator: contains
     • Value: google
   • Rule 2:
     • Field: referrer
     • Operator: contains
     • Value: bing
2. Rule Outside Group:
   • Field: device_type
   • Operator: =
   • Value: mobile
3. Combine Group and Rule with: AND

SQL Preview:

WHERE (referrer LIKE '%google%' OR referrer LIKE '%bing%') AND device_type = 'mobile'

Insight Gained: Optimize marketing efforts for mobile users originating from major search engines.

---

Example 7: Filter by Multiple UTM Terms

Objective: Analyze the performance of ads targeting specific keywords.

How to Build the Query:

1. Rule 1:
   • Field: utm_term
   • Operator: in
   • Value: keyword1, keyword2, keyword3
2. Rule 2:
   • Field: utm_medium
   • Operator: =
   • Value: cpc
3. Combine Rules with: AND

SQL Preview:

WHERE utm_term IN ('keyword1', 'keyword2', 'keyword3') AND utm_medium = 'cpc'

Insight Gained: Assess which keywords are performing best in your cost-per-click campaigns.

---

Example 8: Focus on Specific Page URLs

Objective: Analyze user behavior on a particular set of pages, such as product pages.

How to Build the Query:

1. Rule:
   • Field: page_url
   • Operator: contains
   • Value: /products/

SQL Preview:

WHERE page_url LIKE '%/products/%'

Insight Gained: Understand engagement and conversion rates on product pages to improve merchandising.

---

These examples illustrate the versatility and power of the new Query Builder. By leveraging this tool, you can extract meaningful insights tailored to your specific business needs. We encourage you to experiment with different combinations to unlock the full potential of your analytics data.

---

Need Help Getting Started?

• Watch our Video Tutorial: Click on the "Watch video explanation" link in the Query Builder modal for a step-by-step guide.
• Reach Out to Support: If you have any questions or need assistance, our support team is here to help.

Thank you for choosing AnalyticsWP. We look forward to seeing the insights you uncover with the new Query Builder!

Introducing AnalyticsWP Version 1.9 - A Robust and Reliable Update!

We are thrilled to announce the latest version of AnalyticsWP, packed with enhancements that make your experience smoother, faster, and more reliable. This release is a testament to our ongoing commitment to improving AnalyticsWP, ensuring that it remains the best analytics solution for your WordPress site.

Key Improvements in Version 1.9:

- Refined Codebase for Enhanced Stability: Over the last four weeks, our team has been hard at work, meticulously updating and refactoring the entire codebase. The result? A product that is now 100% type-safe when analyzed by PSALM. This means a more stable and error-resistant experience, ensuring that AnalyticsWP performs flawlessly on your site.

Other:

- Text Overflow Issue Resolved: We've addressed a pesky bug in the WooCommerce Order widget embedded by AnalyticsWP, where text overflow was causing display issues. This fix ensures a cleaner, more professional look for your order data.

- Improved Functionality in Development Environments: Running AnalyticsWP in development or staging environments without HTTPS? No problem! We've implemented a fallback cryptography function, so AnalyticsWP will now work smoothly in setups like LocalWP, even when native browser functions aren't available.

Staying current with updates ensures that your site benefits from the latest performance improvements, bug fixes, and new features. Version 1.9 is all about making AnalyticsWP more reliable, secure, and user-friendly, so you can focus on what matters most—growing your business.

Important Update - Major performance improvements.

This version of AnalyticsWP includes significant performance improvements. We worked with multiple customers, running everything from tiny shared servers to large dedicated high-traffic servers, to identify and fix performance related issues. 

Other additions in this update include:

- The concept of "multiple referrers" for any given order. This is a feature our own team has wanted for a while. The scenario: someone first comes to your site from a Facebook Ad, and then a couple weeks later they come from a Google search, and then finally they come from a block post before making a purchase. Where did the order come from? Facebook, Google, or the blog? AnalyticsWP will now surface all three as multiple referrers.

The same will apply for users that come to your site and signup, for example on a content site that does not use WooCommerce.

- Dozens of smaller improvements, code cleanup, etc.

AnalyticsWP Integrates Advanced Crawler Detection

AnalyticsWP, a leader in privacy-focused and accurate WordPress analytics, is proud to announce the release of its latest version, 1.7, which now features a native integration with the industry-leading Crawler Detector (https://github.com/JayBizzle/Crawler-Detect), enhancing its capabilities in identifying and filtering non-human traffic.

This significant update addresses a common challenge website owners face: the skewing of analytics data by bots and crawlers. By integrating with the Crawler Detector AnalyticsWP v1.7 ensures that analytics reports are more accurate and reflective of actual human activity on users’ websites.

Key Benefits of the Crawler Detector Integration:

Enhanced Accuracy: Users will see a more accurate representation of visitor counts and behavior as data skewed by bots and crawlers is systematically identified and excluded.

Improved Performance: Reducing the load of processing non-human visits, the new integration allows for better resource allocation and faster website performance.

Advanced Analytics Insights: With cleaner data, users gain deeper insights into real user engagement, helping to drive more effective business and content strategies.

Seamless User Experience: The integration operates in the background with no additional setup required from the user, ensuring that the AnalyticsWP experience remains as user-friendly as ever.

“We're simply excited to continue improving our product with this introduction of Crawler Detector integration,” said Mike, Founder of AnalyticsWP. “Our commitment has always been to provide the most accurate, privacy-compliant analytics solutions to WordPress users, and this update is a big step forward in fulfilling that promise.”

The update is immediately available to all existing AnalyticsWP users and can be downloaded from the WordPress plugin repository.

This awesome new update includes foundational support for custom events, paving the road for exciting new partner integrations.

This is an important update for any existing users of AnalyticsWP. We've upgraded and migrated our licensing servers as part of this update to better support a growing number of customers. This includes an all new my account experience on analyticswp.com/my-account. In addition to these changes, the plugin has been improved in the areas of filters, journeys, and WooCommerce HPOS support, and settings to exclude certain users by role from tracking.

This release includes significant updates in the following areas: WooCommerce integration (especially for guest checkouts) and different Timezone support. As with every release, this includes dozens of "small" tweaks and improvements. Updating is highly recommended.

In version 1.3 we focused on performance and optimization improvements, namely to the JavaScript file that is loaded by AnalyticsWP. At the time of this release the file has been reduced to a fairly negligible 1.3Kb.

This release includes the new realtime visitors functionality as well as various tweaks, improvements, and bug-fixes as requested by our initial batch of customer.

The initial public release of AnalyticsWP v1.0 was launched on February 8th, 2024. This is not a beta version, the plugin at this point has undergone many months of usage across our companies and a select group of existing customers of our other product.