Skip to main content

Building and Sharing Your Analysis

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

  • 957 Topics
  • 2,430 Replies
956 Topics
Amplitude Admin
Community Manager
Amplitude AdminCommunity Manager
posted in  Building and Sharing Your Analysis
CSV Export Contains Quotation Marks or Leading Spaces - WHY?

Hi Amplitude Community!We would like to provide context about the quotation marks or leading space in CSV exports. Our engineering team modified exported CSVs to include additional quotation and tab characters in front of all values as a preventative measure for a security risk known with CSV downloads (details here). Attackers can potentially use a formula to inject false data or leak data. And in order to prevent formula triggering cells from running, our engineering team revamped our CSV exports by prefixing quotation and tab characters in front of all values.With that being said, while that security issue remains, we received feedback from customers who said that they were willing to take that risk. Therefore, we implemented a way to export CSVs from Amplitude without any characters in front for those users. If you are willing to take that risk as well, you can enable the feature to remove the spaces in your CSV in your Org Settings section on the Profile page. You can scroll down

3190
Amplitude Admin
Community Manager
Amplitude Admin
Community Manager
Amplitude AdminCommunity Manager
posted in  Building and Sharing Your Analysis
Currency Conversion at Amplitude

Hi Amplitude Community, Amplitude currently does not support currency conversion. If you receive revenue in different currencies, then we recommend normalizing to a single currency before you send us revenue data. Amplitude logs the exact revenue value sent to us and treats it as a numerical value (not a currency value). By default, the currency sign we display in the dashboard is the dollar sign, "$".You can change this display under Organizational settings > Projects > Currency Display. Please check this doc for more information: https://help.amplitude.com/hc/en-us/articles/15581410157339. NOTE: Changing the currency display does not modify nor convert the underlying data. ----- please give this post a thumb-up if you find it helpful! This will help us know what content we should publish in the future :) -----Amplitude Team 

2630
Amplitude Admin
Community Manager
Amplitude Admin
Community Manager
Amplitude AdminCommunity Manager
published in  Building and Sharing Your Analysis
Welcome to the building and sharing your analysis forum!

Learn, ask questions, and help others use and build Amplitude charts to gain valuable insights! This is where you can ask and get feedback on questions such as: ✅ How can I calculate DAU/WAU?✅ How can I see the distinct count of devices for users?✅ Why is the conversion rate in my Conversion chart higher than the conversion rates in my Conversion Over Time Chart?✅ How do I calculate the bounce rate?✅ How do I look for users who did not perform an event? Helpful resources: ❓Working with charts: getting started with our charts, advanced topics and semantics of our charts, FAQs on specific charts❓Organizing and sharing your charts: collaboration within your team, and sharing analyses outside your organization❓Advanced analysis tools: cohorts, account-level reporting, cart analysis, sampling, and more❓Amplitude Academy course: Getting Started with Analytics❓Amplitude Academy course: Increase Data Use across your Organization with Amplitude's Collaboration FeaturesStill have questions? Post

16851
P
P
prefecturearrasrendezvousNew Member
asked in  Building and Sharing Your Analysis
prefecture arras rendez vous

Vous avez sélectionné votre préfecture Arras rendez-vous ou sous-préfecture—il est maintenant temps de choisir le service spécifique dont vous avez besoin. Que vous cherchiez à renouveler un titre de séjour, échanger votre permis de conduire ou accomplir d'autres démarches administratives, nous surveillerons la disponibilité et vous enverrons des notifications instantanées lorsque des rendez-vous seront disponibles. https://vousrdv.fr/fr/department/Pas-de-Calais/prefecture/Arras

10
P
C
chromehearthatNew Member
asked in  Building and Sharing Your Analysis
chrome heart hat

Chrome Hearts Clothing Now at our Official store 100 Authentic Chrome Hearts Hoodie and T Shirt available with fast shipping worldwide https://chromeheartshoodie.org/hat/

10
C
H
HarKiDunNew Member
asked in  Building and Sharing Your Analysis
Har Ki Dun

The Har Ki Dun Trek is one of the most captivating trekking experiences in India, nestled in the pristine landscapes of the Garhwal Himalayas. This guide aims to provide you with all the necessary details, including itinerary, dates, food options, and essential trek information to ensure a seamless adventure. https://www.trekupindia.com/har-ki-dun-trek

40
H
C
Helpful Hero
CCrowleyHelpful Hero
asked in  Building and Sharing Your Analysis
Dynamic Cohorts using property "is not" definition seems to underrepresent

I was using cohorts to define a type of user based on a user property being one of several values (call this Cohort A).  I tried to then look at the negative of that cohort using the same set of values but changing property “is” to property “is not” (call this Cohort B).  When I did this, it seemed that both cohorts (Cohort A + Cohort B) do not add up to the total number of users. In fact, there is a huge discrepancy and even when I tried to create a third cohort that represents Cohort A or Cohort B (call it Cohort C), that too does not add up to the total users for that time period. However, if I use the same list of user property values within a segment and create 3 segments in a chart following the way I had defined the cohorts, I do find that Segment A + Segment B = total users. and that Segment C (which can only be Segment A and Segment B) is zero as expected. All this said, the segments work as I would expect, but cohorts seem to be inexplicably inaccurate.

101
Jacenda Davis
Team Member
Q
Helpful Hero
quintinparHelpful Hero
asked in  Building and Sharing Your Analysis
Frequency bucketing based on a user property

I have a user property "purchasecount" showing each user's total count of purchases. I want to do a frequency report on this user property into frequency buckets.I saw this question (though I don't need a funnel). But I was not clear still.https://community.amplitude.com/building-and-sharing-your-analysis-58/bucketing-users-by-properties-for-funnel-analysis-how-do-user-filters-work-1043 I am on a scholarship plan.

253
Q
Helpful Hero
K
Novice
kkarunakaranNovice
asked in  Building and Sharing Your Analysis
Out of session user properties show up on older events.

 We set user properties at ActivateSub using HTTP V2 API. We get the same user properties set automatically on events that are logged prior to ActivateSub. You can see from the attached screenshot StartSession has all the user properties as well. 

173
sydney.koh
Team Member
U
usonlineclasstakerNew Member
asked in  Building and Sharing Your Analysis
US Online Class Takers

US Online Class Takers assist people studying online with their online classes, courses, exams, assignments or dissertation projects. Boasting a qualified and diverse faculty of tutors well versed with a variety of subjects, we guarantee timely submissions, guaranteed grades and 24/7 customer support with a money back guarantee~ https://usonlineclasstaker.com/

110
U
A
automobilmitmotorschNew Member
asked in  Building and Sharing Your Analysis
automobil mit motorschaden verkaufen

Wenn Sie ein Auto mit einem Motorschaden haben, kann der Verkauf in der Tat schwierig sein, da viele Käufer vorsichtig und zögerlich sind, wenn es um Fahrzeuge mit solchen Problemen geht. Aber keine Sorge, wir sind hier, um Ihnen zu helfen https://www.motorschaden-ankauf-zentrale.de/

60
A
S
Sathyavathi D NNew Member
asked in  Building and Sharing Your Analysis
Amplitude in Hybrid mobile app

Hi,    We are using script loading as mentioned in https://amplitude.com/docs/sdks/analytics/browser/browser-sdk-2 in our existing react webapp along with Session replay enabled. We do have hybrid based(Cordova) android and ios app for the same. Shall we use the same approach as browser -sdk-2 or we need to proceed with different approach for the same. Kindly suggest.

332
S
T
TusharNew Member
asked in  Building and Sharing Your Analysis
Automate the 'Refresh All' in Amplitude Link to Sheets Add-on

I am using the following add-on to export chart data directly to my linked google sheet. https://workspace.google.com/u/0/marketplace/app/amplitude_sync_to_drive_and_sheets/998012258772The extension gives a interface that requires the user to ‘Refresh All’ charts data manually.Can someone help me with a way to automate the ‘Refresh All’ button such that is syncs data after a set period of time? I was looking into ways to write a script in google sheets app script but couldn’t find a way. Screenshot of Amplitude Add-on 

2113
B
S
Sofiko PapkhadzeNew Member
asked in  Building and Sharing Your Analysis
Analyzing User Properties Without Event Data

Hi there,We need to build charts and tables based on user properties without relying on event data. Specifically, we want to analyze user counts and segmentation using predefined attributes, even for users who haven't triggered any events.Could you confirm if Amplitude supports this? If so, what would be the best approach?Here are some specific examples of the data we need:Total number of users in the app (including those who haven’t triggered any events). Daily count of users with a specific subscription plan. The number of users with an active subscription at the current moment.Best,Sofiko

381
Saish Redkar
Expert
S
Saad BhuttoNew Member
asked in  Building and Sharing Your Analysis
Amplitude not working

We're experiencing an issue where Amplitude event tracking is not working in certain browsers, but it works fine in incognito mode.We installed and tested the Amplitude Chrome extension, but no logs are being recorded. We attempted to replicate the issue in our local environment, but it works fine both locally and in incognito mode. We verified that: JavaScript is enabled. Cookies (including third-party cookies) are enabled. We manually triggered amplitude.logEvent() and expected an XHR request in the network tab. However, in the affected browsers, no request is sent.Observations:No console errors appear. Amplitude cookies are being set, but events are still not being logged. we have also tried following Remove any VPNs or Ad blockers Try a different internet Clear cache and cookies Update and restart your chrome/browser Restart laptopHas anyone encountered a similar issue? Any insights would be appreciated.

372
J
Experienced
L
loxoneteileNew Member
asked in  Building and Sharing Your Analysis
loxone teile

Die Heimautomatisierung ist die Zukunft des modernen Lebens und kombiniert Spitzentechnologie mit benutzerfreundlichen Lösungen, um den Komfort, die Sicherheit und die Energieeffizienz Ihres Zuhauses zu erhöhen. https://lxworld.at/

80
L
S
soutienscolaireNew Member
asked in  Building and Sharing Your Analysis
soutien scolaire Lausanne

Les meilleurs répétiteurs pour réussir à tous les niveaux : à l’école, au gymnase ou à l’université. Nos cours d’appui s’adaptent de façon personnalisée à la situation et au besoin de chaque élève. https://cogitoswiss.com/lausanne/

150
S
L
Lizz RennieNew Member
asked in  Building and Sharing Your Analysis
Compatabile App for Shopify Extensibility

Shopify confirmed that third-party browser-based tools, like Amplitude JS, will no longer be compatible with Shopify’s new checkout Extensibility. Shopify only exposes limited custom events in their new, more secure sandbox environment, and these tools will no longer have access to the window and document objects. Community posts here suggest that there used to be an app for Amplitude in the Shopify App Store; however, our team can’t see it in Shopify’s App Store. We’d like to know if Amplitude is working on making an Extensibility-compatible Shopify app or any other compatible tooling.

5662
A
S
Shabab K.New Member
asked in  Building and Sharing Your Analysis
Revenue Retention in cohort analysis

Hi,Is there a way to calculate Revenue Retention in Amplitude while doing cohort analysis?Computation is the closest thing I could find but that would require me to create computations for each month (or week or quarter) for every cohort, which is not feasible. Shabab

160
S
S
SelfpacedLearningNew Member
asked in  Building and Sharing Your Analysis
Self-paced Learning

At SyberOffense, we offer comprehensive online courses focused on Microsoft technologies, cybersecurity, and Python programming. Our expert-led training programs are tailored to help individuals and organizations master essential skills in these critical areas. https://syberoffense.com/

120
S
C
Ced5anNew Member
asked in  Building and Sharing Your Analysis
How to deterministically define the number of rows from chart API response

I've created a data table chart that I'd like to use as source to export data using the Dashboard API (GET https://amplitude.com/api/3/chart/chart_id/query). The issue I'm currently facing is that the number of rows I'm getting on the response varies depending on interval I query for. When specifying 12 months in the data table interval I get an API response with 13k rows but if I change the date interval for only a single month (so that I'd get the most amount of data per month) I get only 1000 rows.Am I missing a parameter on the API endpoint to configure this? Otherwise what would be the API request to get all of the data from a data table (in this case filtering the event of interest) without using the export API which would export all events.Thanks in advance 

220
C
A
Alex PrismotrovNew Member
asked in  Building and Sharing Your Analysis
Response status code does not indicate success: 400 (Bad Request)

Hi! Getting error 400. My code: public async Task TrackEventAsync(string userId, string eventType, object eventProperties){ var eventData = new { api_key = _apiKey, event_type = eventType, user_id = userId, event_properties = eventProperties }; var json = JsonSerializer.Serialize(eventData); var content = new StringContent(json, Encoding.UTF8, "application/json"); try { var response = await _httpClient.PostAsync("https://api.amplitude.com/2/httpapi", content); response.EnsureSuccessStatusCode(); _logger.LogInformation("Event tracked successfully: {EventType}", eventType); } catch (HttpRequestException ex) { _logger.LogError(ex, "Error sending event to Amplitude: {EventType}", eventType); }}Any ideas how to figure out the issue?

281
A
M
menscopperbraceletNew Member
asked in  Building and Sharing Your Analysis
mens copper bracelet with magnets

copper and its many alloys have playsd essential role in many civilizations : from the egyptions to the romans, greeks and enen all he modern day culture use copper in a nearly limitless capacity.

190
M
S
screenprintsNew Member
asked in  Building and Sharing Your Analysis
screen prints

This store offers high-quality custom printing transfers and sheets renowned for their vibrant colors, sharp details, and durability. Customers rave about the professional results, seamless application process, and exceptional customer service. https://dtfcenter.com/

150
S
C
ccixdNew Member
asked in  Building and Sharing Your Analysis
Event property with url parameter

In our product, customer page URLs include dynamic values in the format like /stores/:id/popular. Currently, when testing the integration with Amplitude, the actual id values are being sent, which makes it difficult to analyze the data effectively. How can I ensure events are sent correctly to Amplitude while addressing this issue?

280
C

Recent Tips & Tricks

Terms & ConditionsCookie settings