Hiya, I started working with GrowthBook about a mo...
# ask-questions
b
Hiya, I started working with GrowthBook about a month ago and really liked it; I’m trying to build a demo for my company. Unfortunately there are a couple of things I haven’t been able to figure out (how to make a visual experiment get data, and how to understand the metric graphs) and these will block me from suggesting we try GrowthBook in our apps. I took a break for a few weeks due to pressure of other work and have come back to it with a little time left to try to solve these issues…I am sure I’m missing something quite simple but just can’t spot it…would be grateful for any help?
1
f
Hi Shelagh
The visual editor - did you add the SDK to the page?
b
Yes - and the web page is showing the expected changes as defined in the visual editor. But the experiment itself, in GrowthBook, shows No Data, even though the metric it’s tracking has values.
As I say, I also don’t understand the metric charts, which don’t seem to match up to the values shown in (non-visual) experiments or my test data, but the metric definitely does have some values.
f
did you set up the trackingCallback?
b
Yes - I’m seeing events tracked in BigQuery, and I have a couple of other test experiments which are showing results.
f
okay
and your metric query, what does that look like?
b
SELECT
user_id,
user_pseudo_id as anonymous_id,
TIMESTAMP_MICROS(event_timestamp) as timestamp,
1 as value
FROM
``analytics_xxx.events_intraday_*``
WHERE
event_name = 'Click counter button'
AND _TABLE_SUFFIX BETWEEN '20230330' AND '20231130'
UNION ALL
SELECT
user_id,
user_pseudo_id as anonymous_id,
TIMESTAMP_MICROS(event_timestamp) as timestamp,
1 as value
FROM
``analytics_xxx.events_*``
WHERE
event_name = 'Click counter button'
AND _TABLE_SUFFIX BETWEEN '20230330' AND '20231130'
f
and that returns what you expect?
b
Seems to…and…curiously…just while you’ve been talking to me, the experiment has started to return some data! You are clearly magic…
f
hah!
thanks
ya, your setup looks correct
b
The metric chart still puzzles me, because it doesn’t seem to match the values reported in experiments. For example, why doesn’t it have data for today?
Oh now I see, it IS showing 2 May…I just read 30 April as the last date…
But it seems to show hundreds of clicks per user as the daily average? And the number should be more like 3 per user?
The experiment is still not seeing the data it should - just one event, when there have been many users clicking in the test website, and the GrowthBook devtools shows the experiment, and GA is firing according to network tab and GTM debug.
Though, the chart is the more serious issue; as I can’t explain the charts, I can’t talk about the product with any confidence.
the metric chart, and the experiment, just don’t seem to match up. I’m sure that I’ve got something wrong but I just can’t see it…
f
Do you have any aggregation on that metric?
b
I don’t think so? Would it be possible to set up a call with someone to go over this?
f
sure
b
Thanks! How can I set that up please?
b
Thank you, I booked a meeting for 4:30 pm today, giving my work email address shelagh.lewins@lifeworks.com, but I haven’t received the invite yet.