michaela18
Technical User
I have 2 tables, Traffic, Site
I want the campaign_name,website_views, website_clicks from the Traffic table and the site_name from the site table where traffic_site_id=site.id
I want to seaparte the data by Tiers of website_views. Like how many views does it take for the site_name to reach 1 click, 2 clicks, 3 clicks, up to 20 clicks. So say on 1/1 there was 1 click for yahoo.com and it took 100 views, but then for the 2nd click it took another 5000 views.
The database has date as hourly.
Is there a way to do this?
I want the campaign_name,website_views, website_clicks from the Traffic table and the site_name from the site table where traffic_site_id=site.id
I want to seaparte the data by Tiers of website_views. Like how many views does it take for the site_name to reach 1 click, 2 clicks, 3 clicks, up to 20 clicks. So say on 1/1 there was 1 click for yahoo.com and it took 100 views, but then for the 2nd click it took another 5000 views.
The database has date as hourly.
Is there a way to do this?