city_statistics.txt
3 years ago
city_statistics_with_woocommerce.txt
3 years ago
country_statistics.txt
3 years ago
create_referrer.txt
3 years ago
create_resource.txt
3 years ago
create_session.txt
3 years ago
create_view.txt
3 years ago
create_visitor.txt
3 years ago
get_campaign.txt
3 years ago
get_campaigns.txt
3 years ago
get_campaigns_with_woocommerce.txt
3 years ago
get_current_session.txt
3 years ago
get_current_traffic.txt
3 years ago
get_geos.txt
3 years ago
get_geos_with_woocommerce.txt
3 years ago
get_referrer.txt
3 years ago
get_referrers.txt
3 years ago
get_referrers_with_woocommerce.txt
3 years ago
get_resource.txt
3 years ago
get_resources.txt
3 years ago
get_visitors_by_minute_interval.txt
3 years ago
get_visitors_by_ten_second_interval.txt
3 years ago
get_campaign.txt
7 lines
| 1 | SELECT * |
| 2 | FROM wp_independent_analytics_campaigns |
| 3 | WHERE utm_campaign = :utm_campaign |
| 4 | AND utm_medium = :utm_medium |
| 5 | AND utm_source = :utm_source |
| 6 | AND (utm_term = :utm_term OR (:ignore_utm_term = 1 AND :utm_term IS NULL)) |
| 7 | AND (utm_content = :utm_content OR (:ignore_utm_content = 1 AND :utm_content IS NULL)) |