Building and Sharing Your Analysis

Learn, ask questions, or help others on the features that help build analyses in Amplitude!

  • 272 Topics
  • 782 Replies

272 Topics

X
Junior Pilot
xiaomeng.zhangJunior Pilot
asked in  Building and Sharing Your Analysis

How to batch select values

Hi, Guys. I want select so much car_no, how do i do it fast？ 

1
Saish Redkar
Galactic Traveler
1 month ago
P
pasha.shwartzNew Member
asked in  Building and Sharing Your Analysis

Files saved in gz format and not csv on the S3

Hi ,I am quite new in Amplitude and recently successfully implemented S3 integration by the book as listed below . https://help.amplitude.com/hc/en-us/articles/360044561111-Integrate-Amplitude-with-Amazon-S3Everything works fine exclude the format of the file is .json.gz instead of CSV as expected . Is there a way to change a format to CSV by default  ?  

2
Yuanyuan Zhang
Employee
1 month ago
S
sam_tooseNew Member
asked in  Building and Sharing Your Analysis

Can User Properties fire as null on events even if a User Property for that user has been seen before?

Hi All,I have a question around user properties with the goal of getting an accurate understanding of our MAUs.We have a platform which allows our admins to impersonate a client user, this allows them to see an identical version of the platform that the client user would see. The admin can then complete tasks on their behalf which fires events as the client user.I want to be able to tell the difference between events fired by a real client user and an admin impersonating a client user.There is a user property we use called impersonating_user_id which captures an id of the admin who is doing task on their behalf.My question is: If an admin 1234 impersonates the client user 5678 on Monday and fires an event the user property impersonating_user_id would capture user 1234 on that event.If the next day the client user 5678 logs onto the platform as does actions themselves and fires events. In this case would the impersonating_user_id property fire as null as no one is impersonating? or does

3
S
1 month ago
L
LeoMNew Member
asked in  Building and Sharing Your Analysis

Frequency Grouped 6-10 Days

Hi Everyone! I am trying to figure out how to ungroup the frequency from 6-10 days to 6 times 7 times 8 times 9 times.

1
Saish Redkar
Galactic Traveler
2 months ago
Andrew B
Stargazer
Andrew BStargazer
asked in  Building and Sharing Your Analysis

Excluding Based on Intent

Looking for insights for an interesting Funnel conversion situation. I’m wanting to exclude users who come to the transaction screens if they managed their giving, except if they actually did a transaction. Here’s a visual of how I’m thinking of it.Transaction metrics​​​​​So if a person does an action on the transaction screen and does a transaction, even if they checked their history, I do want to count their conversion. However, if they only checked their history on the transaction screen, then I don’t want to count them.Here’s the equation I’m thinking of:Transaction Conversions/(Action on Transaction Screen - Manage Actions without Conversion)How do I do that in Amplutide’s Funnel?

4
S
Astronaut
2 months ago
Jeremie Gluckman
Community Manager
Jeremie GluckmanCommunity Manager
posted in  Building and Sharing Your Analysis

What are some tactics you've used in creating your organization's Product Analytics data language?

Join us for this month's Coffee Chat, featuring Amplitude's very own solutions architect, Xin Cao (@CanioX) ! Enjoy a coffee on us while chatting about how to create your company's product analytics data language. We have a question for you:What are some tactics you've used in creating your organization's Product Analytics data language? What have been some of the biggest challenges?Share your thoughts and Xin will be posting here after the event too! Note that to see the latest posts you need to refresh this page. We can’t wait to hear from you! 

6
CanioX
Employee
2 months ago
A
Junior Operator
AmbroiseJunior Operator
asked in  Building and Sharing Your Analysis

How to send a daily reporting to a Slack channel?

I wish to send a daily reporting of key metrics (a “Team Space”, or selected charts) daily, at 8am, on a specific Slack channel. How do I do that? I’ve added the Slack integration and it works, but now I’d like to automate it for a daily reporting and I haven’t found any documentation about that.  

8
K
2 months ago
R
RuslanKNew Member
posted in  Building and Sharing Your Analysis

ghv

gjckgchkc

0
R
2 months ago
H
Stargazer
HarpreetStargazer
asked in  Building and Sharing Your Analysis

Not able to fetch data using amplitude api.

Hello Guys,I am trying to get data through amplitude api, but I am not able to fetch any data. It's either not returning any data and it's also not showing any error.I am using your api services to get data. I am using python as my backeend.This is one of the api, which I am using. I am using it with key and secret.api = https://amplitude.com/api/2/users?start=20220301&end=20220311It's not returning any user detail. It’s only returning dates only.Please let me know what am I doing wrong here.Thanks

4
H
Stargazer
2 months ago
Y
yaqiNew Member
asked in  Building and Sharing Your Analysis

Dashboard event property filter is not working in User Session schart

I created a User Session chart as below.I added the chart to the dashboard and wanted to filter all charts based on the event prop `store`. As can be seen from the following chart, the filter is working on all charts except the session chart. Is this a known bug or how can I do this?  

1
sydney.koh
Employee
2 months ago
N
nadjareNew Member
asked in  Building and Sharing Your Analysis

Can I exclude weekends from my charts?

Hello everyone, I work for a B2B company and we want to track the monthly development of events by using timelines (see screenshot). Is it possible to exclude the weekends?Thanks for you help. 

3
Denis Holmes
Employee
2 months ago
C
ChristinaLumiNew Member
asked in  Building and Sharing Your Analysis

D60 and D90 retention

Hi,With the retention chart I currently can only get retention up to day 30. How do I get retention beyond that? To day 60 and day 90?Thank you!Cheers,Christina

3
Saish Redkar
Galactic Traveler
2 months ago
yeamal
Employee
yeamalEmployee
posted in  Building and Sharing Your Analysis

Which user behavior metrics matter?

Hi folks 👋 Mallory here. I run the Amplitude blog (https://amplitude.com/blog/) and was editing an article when a question came to mind:Which user behavior metrics really matter? There’s retention, churn, and engagement of course, but beyond that—Which user behavior metrics do you care about? Let me know what you think; I’d love to bring the feedback into an upcoming blog post!

1
Jeremie Gluckman
Community Manager
2 months ago
R
Junior Operator
richardJunior Operator
asked in  Building and Sharing Your Analysis

How can I retrieve total conversion rate on the funnel

Hi,I found I can not see the total conversion rate on the funnel, while I could see it before, Does that result from product change or my settings on the charts? If it is from my settings on the charts, where can I retrieve the total conversion rate for the funnel? Thanks! Current chartPrevious chart 

2
Thao Nguyen
Employee
2 months ago
S
Junior Operator
steliosJunior Operator
posted in  Building and Sharing Your Analysis

Give us the option for absolute numbers in retention

I am sorry for the harsh language but this is absolutely bizarre, convoluted and amateurish. I couldn’t wrap my head around it, because I didn’t think you would make such peculiar logic leaps:  So, basically retention gets calculated as a percentage BUT WITH DIFFERENT COHORTS EACH TIME.  This by itself is fine, but who though it was a good idea given said assumptions to put a percentage result??? The least you can do isBy default show calculations for completed cohorts only e.g I have asked for retention over 7 days perdiods show me only the completed 7-day cohorts.  Allow me to see absolute numbers! Allow me to see number of users actually having performed the retention.This, bizarre I repeat combination of calculating + presenting data leads to this head scratcher:Each day here has a different percentage Day-4 seems to have a higher percentage than a previous day.  EVERY SINGLE DAY HAS 6 USERS performing the retentions BUT DIFFERENT PERCENRAGE RESULT.  I have read the relevant thread

3
sydney.koh
Employee
2 months ago
C
Stargazer
chris1008Stargazer
asked in  Building and Sharing Your Analysis

funnel analysis with multiple conversions

Hi all! Is it possible to track multiple conversions in a funnel report?For example, in a 2-step funnel, step 1 would be a single event, but then step 2 could be one a few different events – and a user could complete any number of them, and they’d all be included in the report.Essentially I’m trying to avoid building a separate report for each different event I want to measure in step 2, because step 1 will remain the same (and I also want to break it down by particular property of step 1).Thanks in advance for any thoughts or suggestions!

5
C
Stargazer
2 months ago
A
akhirai560New Member
asked in  Building and Sharing Your Analysis

Amplitude Pull data from my server

Hi All,The current HTTP api want’s you to send events.Can amplitude ask the data from my server api, scheduled / on opening widget.

2
Denis Holmes
Employee
2 months ago
S
Junior Operator
steliosJunior Operator
asked in  Building and Sharing Your Analysis

Retention with zero cohort poputlation

Hello I created a cohort that has zero population: As a test I tried to see retention for this cohort and imagine my surprise when I saw numbers:   However when I downloaded the CSV I got zero’s  Any ideas? 

1
sydney.koh
Employee
2 months ago
S
Junior Operator
steliosJunior Operator
posted in  Building and Sharing Your Analysis

CSV export seems weird?

HelloExporting CSV files seems to be acting weird. The exported file seems to be seperated with the “,” sequence of character quotation marks included, instead of just the , character This has a result neither the Sprig platform nor excel to be able to read them properly. Any ideas?  

11
Denis Holmes
Employee
2 months ago
N
NoaNew Member
asked in  Building and Sharing Your Analysis

Retention after X days from signup

Hi everyone, I am new to Amplitude and wanted to borrow your wisdom.I want to create a cohort of users who are ‘active after X+ days from signup’, that automatically tracks and I can see the # changes of cohort size over time. Is there any way to enable that?   If 1) is not supported by Amplitude, any ideas to get that data with light manual work? I have created ‘unbounded retention’ to get static data. Perhaps getting this data regularly is one way?   Could I further target, who ‘have signed up more than X days ago’ AND still ‘log in monthly (>=1 per month)’??I really appreciate your help! 

1
Jacenda Davis
Employee
2 months ago
N
nadjareNew Member
asked in  Building and Sharing Your Analysis

Product Analytics Playbook

Hey everyone, I signed up for Amplitudes insights on retention analysis, as I am having a hard time understanding our data.Unfortunately, the link does not work https://www.productanalyticsplaybook.com/.Can someone please help me? All the best!

1
Saish Redkar
Galactic Traveler
2 months ago
D
Stargazer
daphneStargazer
asked in  Building and Sharing Your Analysis

hightlight event stream

Remembered I can highlight multiple events in user look up event stream before, but seems I can only highlight single event now, anything wrong? 

4
D
Stargazer
2 months ago
A
Stargazer
Antranik Andreh KiloyanStargazer
asked in  Building and Sharing Your Analysis

Can I see funnel conversion rate from previous step & not initial step?

I am creating a funnel & the conversion rate from step 1 to 2 is quite simple. But any step after the second it shows the conversion rate from the initial steps’ population. Can’t I see the conversion from the previous step?

1
Saish Redkar
Galactic Traveler
2 months ago
Y
yaqiNew Member
asked in  Building and Sharing Your Analysis

How to PROPSUM with unique users

according to the docThe PROPSUM does:Returns the sum of the property values you are grouping the specified event by. However I am interested in the sum of the property values by unique users. The use case is: I want to know the total value of the out of stock product each day. However, a user could visit one product page multiple times per day but if we assume the user would only convert once per day, then PROPSUM(price) would be elevated. I want to know the PROPSUM(price) for distinct users.  

3
S
Astronaut
2 months ago
S
santiagovaldesNew Member
asked in  Building and Sharing Your Analysis

Inactive users who return

We are using Amplitude to measure the Retention, in general terms, of our service. As an ecommerce, we are interested in the specific event of add to wishlist.Our idea is to separate our current user base of total users in this buckets:Weekly Active (users who did add to wishlist event in the last 7 days) Inactive (users who created accout but had never done add to wishlist)For Inactive we want to measure the rate of “resurrection” (weekly). So we need to calculate the total amount of users in that state and get how many got back each week. I have not been able to found a way to do this so far. I haven’t found a way to show what is the total number of users in this state and the weekly amount of “resurrected”. What I’ve tried but didn’t work:Using a Lifecycle graph. The numbers do not match to what we expect. For example, if I get the Weekly Active Users (from Amplitude) and multiply that for the retention rate weekly (also from Amplitude), I should get how many of these users are movi

3
Saish Redkar
Galactic Traveler
2 months ago

Badge Earners

  • Lift-Off
    user73has earned the badge Lift-Off
  • Lift-Off
    segilmezhas earned the badge Lift-Off
  • Lift-Off
    Ayonhas earned the badge Lift-Off
  • Lift-Off
    Mateja Tomekhas earned the badge Lift-Off
  • Lift-Off
    Linahas earned the badge Lift-Off
Show all badges
Terms & Conditions