id brand_id affiliate_id affiliate_type placeholder_id group_id action visit_type source_id source_type entry 198 723062 723032 link 722962 2 impression referer 722964 singular 2023-09-30 19:44:22 200 723062 722977 asset 722962 1 impression referer 722964 singular 2023-09-30 19:44:24 201 723062 723031 link 722962 1 impression referer 722964 singular 2023-09-30 19:44:29 203 723062 722976 asset 722962 2 impression referer 722964 singular 2023-09-30 19:44:31 204 723062 723032 link 722962 2 impression referer 722964 singular 2023-09-30 19:45:16 206 723062 722977 asset 722962 1 impression referer 722964 singular 2023-09-30 19:45:18 207 723062 723032 link 722962 2 impression referer 722964 singular 2023-09-30 19:45:23 209 723062 722977 asset 722962 1 impression referer 722964 singular 2023-09-30 19:45:26 212 723062 723032 link 722962 2 impression referer 722964 singular 2023-09-30 19:50:34 214 723062 722977 asset 722962 1 impression referer 722964 singular 2023-09-30 19:50:37 217 723062 723032 link 722962 2 impression referer 722964 singular 2023-09-30 19:51:12 218 723062 722977 asset 722962 1 impression referer 722964 singular 2023-09-30 19:51:14 219 723062 723032 link 722962 2 impression referer 722964 singular 2023-09-30 19:51:45 221 723062 722977 asset 722962 1 impression referer 722964 singular 2023-09-30 19:51:48 222 723062 723032 link 722962 1 click referer 722964 singular 2023-09-30 19:51:50 224 723062 723032 link 722962 2 impression referer 722964 singular 2023-09-30 19:52:00 225 723062 722977 asset 722962 1 impression referer 722964 singular 2023-09-30 19:52:03 226 723062 722977 asset 722962 1 click referer 722964 singular 2023-09-30 19:52:05 Here, Placeholder ID: 722962 Links: Affiliate type "link" comparizon from: Group 1 vs Group 2 vs Group 3 vs Group 4 vs Group n ID | Type | Clicks | Impressions 723031 | link | 1 | 1 723032 | link | 0 | 7 SELECT affiliate_id, SUM(CASE WHEN action = 'click' THEN 1 ELSE 0 END) AS total_clicks, SUM(CASE WHEN action = 'impression' THEN 1 ELSE 0 END) AS total_impressions FROM wp_affilinks WHERE placeholder_id = 722962 AND affiliate_type = 'link' GROUP BY group_id, affiliate_type ORDER BY group_id, affiliate_type Assets: Affiliate type "asset" comparizon from: Group 1 vs Group 2 vs Group 3 vs Group 4 vs Group n ID | Type | Clicks | Impressions 722977 | asset | 1 | 7 722976 | asset | 0 | 1 SELECT affiliate_id, SUM(CASE WHEN action = 'click' THEN 1 ELSE 0 END) AS total_clicks, SUM(CASE WHEN action = 'impression' THEN 1 ELSE 0 END) AS total_impressions FROM wp_affilinks WHERE placeholder_id = 722962 AND affiliate_type = 'asset' GROUP BY group_id, affiliate_type ORDER BY group_id, affiliate_type --- Share the SQL query to get comparizon data for 'link' and another query for 'asset' Creating both a free and paid version of your plugin is a common strategy to attract users and monetize your product. Let's separate the features for each version and then explore some sample pricing strategies and a list of competitors with their pricing tables. **Free Version:** 1. Affiliate Link Management 2. Affiliate Resource Management 3. Affiliate Categories and Tags 4. Shortcodes for Display 5. Basic A/B Testing and Rotation 6. Basic Analytics and Click Tracking 7. Limited Affiliate Earnings Tracking 8. Basic User Permissions 9. Email Notifications (Limited) 10. Documentation and Basic Support **Paid (Pro) Version:** 1. All Free Version Features 2. Advanced A/B Testing and Rotation 3. Enhanced Analytics and Reporting 4. Detailed Affiliate Earnings Tracking 5. Advanced User Permissions and Access Control 6. Email Notifications (Advanced) 7. Backup and Restore 8. Premium Support **Sample Pricing Strategies:** 1. **Freemium Model:** - **Free Version:** Offer the basic features for free. - **Pro Version:** Charge a one-time fee or subscription (monthly/yearly) for access to advanced features. - **Sample Price:** Free version + Pro version for $49/year. 2. **Tiered Pricing:** - Offer multiple pricing tiers with varying levels of features. - **Sample Prices:** - Basic Plan: $29/year - Pro Plan: $79/year - Premium Plan: $149/year 3. **Lifetime License:** - Charge a one-time fee for a lifetime license of the Pro version. - **Sample Price:** Pro version for $199 (lifetime access). 4. **Add-ons and Modules:** - Provide the core plugin for free and offer additional paid add-ons or modules. - **Sample Prices:** A/B Testing Module for $39/year, Enhanced Analytics Module for $29/year. 5. **Free Trial and Money-Back Guarantee:** - Offer a 14-day free trial of the Pro version. - Provide a money-back guarantee within the first 30 days of purchase. **Competitors and Their Pricing:** Please note that the competitive landscape may change over time, and new competitors may emerge. Here's a sample list of competitors in the WordPress affiliate marketing plugin space, along with their pricing (as of my last knowledge update in September 2021): 1. **ThirstyAffiliates:** - Pricing: Free (basic) / $49 - $149/year (Pro) 2. **Pretty Links:** - Pricing: Free (basic) / $49 - $199/year (Pro) 3. **AffiliateWP:** - Pricing: $149 - $499/year (depending on features and licenses) 4. **AdSanity:** - Pricing: $49 - $149/year (depending on licenses) 5. **Affiliates Manager:** - Pricing: Free (basic) / $39.95 - $129.95/year (Pro) 6. **ThirstyAffiliates:** - Pricing: Free (basic) / $49 - $149/year (Pro) 7. **Affiliate Royale:** - Pricing: $85 - $165/year (depending on licenses) Please visit the websites of these competitors to check for the most up-to-date pricing information and to see how their features compare to your plugin. Keep in mind that pricing can vary based on your target audience, the value your plugin provides, and your marketing strategy. Conducting market research and competitor analysis regularly will help you fine-tune your pricing strategy over time.