Skip to main content

Building and Sharing Your Analysis

Learn, ask questions, and help others build Amplitude charts and gain valuable insights!

  • 975 Topics
  • 2,438 Replies
974 Topics
R
Ryan ChaseNew Member
asked in  Building and Sharing Your Analysis
Average purchase amount per user

I am looking to calculate average purchase amount per user and split users by a specific threshold. For instance, users with an average purchase amount either above or below $10. I know you can do an average of purchase amount across purchase events as well as ARPU but both of these use aggregates across events/users.If that isn’t possible then I would likely have to just group users by whether or not they’ve made purchases above $10. 

2682
R
H
Helpful Hero
Herb LauHelpful Hero
asked in  Building and Sharing Your Analysis
custom metric permitted events and other related things

@jennruAre we not allowed to refer to Cohorts we’ve created as part of custom metrics?For our situation, I’m trying to create a custom metric for the third column in second image below.The first column is just users to a page.  The second column is users to that page who were part of a cohort. That custom cohort is users who viewed a thank-you page, which is for us our final conversion step.Third column is intended to be second column divided by first column, as percentage.Within first image below is the available events, and the event is viewed page filtered to that cohort.  Trying to work out some combination that makes that work in some fashion.Thank you!  

2331
JennRu
Community Manager
M
Maggie LittleNew Member
asked in  Building and Sharing Your Analysis
Daily Login Activity

Hi there,  I am a beginner with the Amplitude platform - I am curious why the line graph for Daily Login Activity shows multiple lables of Monday, Tuesday, Wednesday, etc. and why there is a (none) associated to this activity.  Also I’ve selected Frequency to measure this data but the number of logins that are displayed in the chart are different from the numbers in the line graph. Thanks!

3922
S
J
Helpful Hero
jose.asilisHelpful Hero
asked in  Building and Sharing Your Analysis
All Amplitude IDs should be integers. Please confirm that the file only contains valid Amplitude IDs and no extra columns or characters.

Hi everyone :) I’ve tried reading:Error with uploading csv for cohorts - none of the upload user id matches | Community (amplitude.com) Errors with Amplitude ID importing cohorts | Community But I don’t know what’s wrong.I’ve extracted the list of Amplitude IDs from a Funnel, copied and pasted them on a csv, and .txt files with nothing more than the numbers (no commas, nada). Just line by line, and the platform rejects it.  Any ideas why?  

3363
J
Helpful Hero
U
ursyathiNew Member
asked in  Building and Sharing Your Analysis
Okta certificate revokation

I am using Okta for SAML sign-on. I need to change the default self-signed certificate of Okta and use a certificate signed by third party. I need this because I need to revoke Okta certificate and check the OCSP flow in my server and check whether Okta authentication is rejected. Is this supported in Okta? please help

1700
U
D
Dave BaskindNew Member
asked in  Building and Sharing Your Analysis
Downgrading back to Starter Plan from Plus

Apologies if this isn’t the correct sub-forum to post in—it was the closest I could find!I can’t quite figure this out from the terms or documentation, but is it possible to go onto a Plus plan for a given period of time, such as when we anticipate a large volume of MTUs, and then fall back to Starter again?

3082
D
A
Arran SNew Member
asked in  Building and Sharing Your Analysis
Unclear how filters work (is it AND or OR logic)?

How do filters work in Amplitude?Do they use AND or OR logic?E.g. is the below filtering forwhere path contains “orientation” OR does not contain “integrate”OR IS IT where path contains “orientation” AND does not contain “integrate” If I want to be able to apply OR logic what is the approach?If I want to apply AND logic what is the approach? If someone can point to some clear documentation that would also be useful.  

6251
A
A
Experienced
asivakumarExperienced
asked in  Building and Sharing Your Analysis
Realtime sync from Cohort to a webhook

Hi, I’d like to sync a cohort to a web hook in realtime (without going via UserProfile API), would anyone know if this is possible ? 

2463
K
A
Helpful Hero
aleksandra-asanin
asked in  Building and Sharing Your Analysis
Is Data Table available on Starter plan?

 The website says that Data Tables are available on all plans, and the in-product pricing page links to the website page, however we don’t have access on Data Tables on Starter plan. Does anyone have a similar issue? 

2635
A
Helpful Hero
L
Lisa SadchykovaNew Member
asked in  Building and Sharing Your Analysis
Is there a way to see average count of 1 specific event for users within the first 3 days since they signed-in the app?

Hi guys! Anyone knows if there is a way to see average count of 1 specific event (how many times users did this event on average) for new users within the first 3 days since they signed-in into the app?Thank you!

1471
Saish Redkar
Expert
A
Ashay JainNew Member
asked in  Building and Sharing Your Analysis
Create alerts to send during a specific time period

Is there a way to setup alerts to only send at a specific time. I only want to receive alerts from 6am-10pm.

3454
Saish Redkar
Expert
H
Hyeongu ChoiNew Member
asked in  Building and Sharing Your Analysis
Slack subscriber issue

I'm trying to connect a dashboard in Amplitude to Slack to automatically receive dashboard updates every day at 9 AM. However, the updates are not arriving in Slack at the scheduled time. What should I do?

2541
Saish Redkar
Expert
P
Conversationalist
peckerbidsConversationalist
asked in  Building and Sharing Your Analysis
Users who performed an action at "any time" before or after another action

Hello,I’m trying to create a chart that shows me the users who performed action A either before or after action B, condensed into a singular percentage value. So I think the 100% value would show the total number of users who triggered action B, and the calculated percentage value would show the number of people who also performed action A, but action A can occur at any time, before or after action B. Would this be feasible?Thanks!

3095
P
Conversationalist
T
Peer Moderator
trevin-bcPeer Moderator
asked in  Building and Sharing Your Analysis
How do I create an engagement matrix of "Top Events" but automatically exclude events based on wildcard?

We have custom events for click tracking and pageviews which is polluting reports and making certain report types very difficult to use. For example, in the Engagement Matrix report, you can’t do any rules on filters. You can choose individual events manually but then after limited to a certain #.If I choose any of the automatic “Top Events”, it will include all the click tracking and pageviews. I can de-select them from the chart, but that just hides them from the chart and doesn’t allow it to bring other events in.What am I missing? Is engagement matrix report just this bare bones that I can’t do what I want?

2924
T
Peer Moderator
P
Conversationalist
peckerbidsConversationalist
asked in  Building and Sharing Your Analysis
Any order between two events in funnel analysis

Hello, I’m currently trying to make an amplitude chart that shows the conversion % between event A and event B. I would like it to consider A to B and B to A at the same time, while also not considering A to A and B to B. I was hoping that the “any order” function would work, but that doesn’t seem to be the case. Would there be a way to present the conversion in the way I listed? Thanks!

2712
P
Conversationalist
H
Harel TussiNew Member
asked in  Building and Sharing Your Analysis
How to sync deviceId with chrome-extension and .domain.com? #666

Hello,I've a Chrome extension, and I have two websites under the domain .mycompany.com. I'm looking for a straightforward method to share the same deviceId between the Chrome extension and my two websites. Is there a convenient way to accomplish this? 

1380
H
S
Conversationalist
srushti.wadekarConversationalist
asked in  Building and Sharing Your Analysis
Median time to convert calculation

Hello,I've a question regarding how Amplitude calculated the median time to convert metric in a Funnel chart.If I've two events in a funnel which are supported to be converted within a 30 days timeframe, does the time to convert here considers -1. Real time taken to complete the funnel irrespective of sessions or website running in the background.2. Time taken to complete the funnel only when the session is active or website is open in the background.3. Time taken to complete the funnel only during active session.4. Something elseThanks!

5771
williamnewton
Team Member
T
Peer Moderator
trevin-bcPeer Moderator
asked in  Building and Sharing Your Analysis
Feature request: Add ability to filter active/inactive events from all chart types

Some amplitude charts (e..g Engagement Matrix) have automatic groupings of events like Top Global Events Top Events for Segment Bottom Global Events The problem with this is there is no way to filter out “inactive” events.  We have many of these that that are commonly fired, but then make it into these reports diluting the value of the report. Sure, I can unselect it from the table which will hide it from the chart, but it still consumes one of the top/bottom 50 slots.What needs to be supported is choices for Active vs Inactive. Even better, it should just add event filters, so we can make a list of events to filter out by wildcard.   

1570
T
Peer Moderator
K
Peer Moderator
kdavisPeer Moderator
asked in  Building and Sharing Your Analysis
Amplitude Hubspot Integration: List Created and Not Populated

I’m running into problems getting Amplitude Hubspot Integration to work.I’ve followed the instructions detailed in Send Cohorts to HubSpot and they seem to almost work.Amplitude setup step works Send a cohort works according to the Amplitude UIHowever, when i examine the Cohorts in HubSpot, I find that a contacts list is created with the correct name, i.e. with the Amplitude_ prefix, but the list is empty and remains empty despite Amplitude claiming it has synced users to the list.

93938
sydney.koh
Team Member
W
Novice
Will DNovice
asked in  Building and Sharing Your Analysis
How to create a Segmentation chart that captures users who have performed the same event multiple times?

Hi there,We’re having trouble building the chart we want in Amplitude analytics. Is there a way to chart the count of users who have performed an event more than once over time? This boils down to a normal segmentation chart except instead of counting the user if they’ve performed the event, they would have had to perform the event >1 time within the given time period. Thanks,Will

2882
W
Novice
S
Seth AndersonNew Member
asked in  Building and Sharing Your Analysis
Passing UTM parameters cross-domain

We are trying to set up tracking between our standard marketing website and our product which lives in a web app. Because these live on two different domains we are trying to figure out how to pass back the UTM parameters from the landing page on our marketing site into the User data when they sign up on our web app.We were thinking of passing back the device_id from the marketing site (example.com) to the web app (app.example.com). Is it possible to associate UTM parameters to that device_id so that when they fill out the form on the web app we can keep the parameters on the user’s data?

8241
rox.chang
Team Member
E
Helpful Hero
Ed LandauHelpful Hero
asked in  Building and Sharing Your Analysis
Why is data on website different from HTTP V2 API result?

We are a startup… still on free tier. Hoping to move up soon :).I’m new to Amplitude so hoping this is not a silly question:On the https://app.amplitude.com/, I can create a new segmentation chart and just one event “EVENT-A” and apply one filter (User ID = ABD).  I then view both “event totals” and “Uniques”.  For Event totals, I get number such as 151, 43, 200 for the past 3 days.When using HTTP V2, and querying with the same event with the same filter, I get values such as 5768.  Why are these so different?   I made sure to use the “m” : “totals”.   Below is my curl.  I’m hoping there is something obvious I missed?   Looking at other similar posts:  I only have one project so the API key I’m using is by definition the only project I have access to. curl -X GET 'https://amplitude.com/api/2/events/segmentation' -H 'Content-Type: application/json' -d 'e={"event_type": "EVENT-A"}' -d 'f=[[{"prop": "user_id", "op": "is", "values": ["ABCD"]}]]' -d 'start=20240126' -d 'end=20240130' -d 'm=

35013
JennRu
Community Manager
N
NicholasNew Member
asked in  Building and Sharing Your Analysis
Remove real-time event stream from home page

My home page and the customizable organization home page has real-time widgets for an event stream and a map of the world. Neither of these widgets provide any value to me, but I do not understand how to remove them. Other widgets have a 3-dot menu that allows for removal. How do I remove these pieces of information? 

2442
N
G
Geoff CanyonNew Member
asked in  Building and Sharing Your Analysis
I want a list of every Amplitude ID + the email address associated with that user

What it says in the title: I want to get a list of every Amplitude User ID I’ve recorded, along with the email address (if any) associated with that user. I have a bar chart of session starts, grouped by ID, and that seems to do the “summarizing” part, but I don’t see how to add email (or anything) to the table of results to export.

2912
G
S
Novice
srahmanNovice
asked in  Building and Sharing Your Analysis
Chart ID for Dashboard API into python notebook?

I am looking to grab data from a chart into a Python Notebook I have followed the instructions here: https://www.docs.developers.amplitude.com/analytics/apis/dashboard-rest-api/#get-results-from-an-existing-chartimport requestsurl = "https://amplitude.com/api/3/chart/:chart_id/query"payload={}auth=requests.auth.HTTPBasicAuth('api-key', 'secret-key')response = requests.request("GET", url, auth=auth, data=payload)print(response.text)However, I keep getting URL not found.I have the api-key and secret-key. I believe the line of code where there is the issue is the second line.The URL where chart resides is :https://app.amplitude.com/analytics/[CompanyName]/chart/at54vy8pCould someone help me with what should this line of code be:url = "https://amplitude.com/api/3/chart/:chart_id/query"I have tried following options without success:url = "https://amplitude.com/api/3/chart/:at54vy8p/query" url = "https://amplitude.com/api/3/chart/at54vy8p/query" url = "https://amplitude.com/analytics/[Compan

3242
S
Novice

Recent Tips & Tricks

Terms & ConditionsCookie settings