Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a requirement where i need to create a table and for dynamic dimension(in my case its days ) i need to show count values for that particular dimension.
Days opens clicks
28/10/2017 3 3
29/10/2017 1 0
30/10/2017 13 10
01/12/2017 2 1
02/12/2017 4 3
03/12/2017 6 5
This is the table showing stats till today, tommorrow it will be 04/12/2017, day after tommorow it will be 05/12/2017 like this dimensions gets populated dynamically. So for this dimensions i need to show opens and clicks counts autometically. How could i do these?
Please help me on this. Any kind of idea is appreciated.
In a load script this would probably be what you should make:
OpensClicksPerDay:
LOAD
Days,
Sum(opens),
Sum(clicks)
FROM
Webstats.log (txt)
GROUP BY
Days;
You could also fetch in the data as-is without aggregating the data in a load script and then do a simple aggregation with sums in a visualization table in the app:
LOAD
Date( Floor(Days) ) AS Days,
origin_IP,
browser,
opens,
clicks
FROM
Webstats.log (txt);
In a table in a sheet you would:
Add Days as dimension and Sum(opens) in a measure and then Sum(clicks) in a measure.
Hi petter-s
yes your approch works for me only if sent,delievred,opens,clicks, bounce, unsubscribe fields are all in one table.
What if i have 3 tables with fields and differnt datecreated
Table1:
invitation_id,
client_id,
batch_id,
campaign_id,
language_id,
sent,
date_created
from table1:
Table2:
invitation_id,
track_type,
date_created
from table2:
Table3:
invitation_id,
bounce,
unsubscribe,
date_created
from table3:
Table4:
id,
track_type
from table4;// track_type=1 is opened,track_type=2 is clicked
here for each date i want to show counts by campaign_id, batch_id, date_created,language_id;
How could i do this?