Skip to main content

Data Instrumentation

Learn, ask questions, or help others with sending data and extracting data from Amplitude.

  • 1,610 Topics
  • 4,013 Replies
1610 Topics
M
meinfelderNew Member
asked in Data Instrumentation
Is it possible to get the project name via the API?

I’m making a utility for others and don’t want to request information, e.g. project name, if I can it via the API. Thanks!

3431
Saish Redkar
Expert
3 years ago
N
ninodafonteNew Member
asked in Data Instrumentation
Best practice for device_id when there is none available? (external platform + http api)

Hi everyone! A bit of context for the question:Newbie question here. We host our platform with an external provider. The access to the events happening there (student registered, canceled, register for a course, etc) are made available to us via Zapier. From there we could use the event and the data to feed other platforms (n8n, local dbs). I wanted to use that trigger to send the same data to amplitude. The thing is, I don’t have access to device_ids from our users (as the data will be ingested using the http api from one of our servers after receiving the data from Zapier). I’m aware that we will lose track of the relation user↔devices but we can live with it.  My doubtWhat would be the best practice with the device_id value?Not sending anything (not sure if that’s possible though) Send a random uuid for every event? Send a random uuid for every user? Any other options I’m not aware of? Same question applies to session_id (I thought about setting a session start that covers 24h) but

5662
N
3 years ago
R
Novice
ram_manoharNovice
asked in Data Instrumentation
Suggestion for creating a good solution for capturing attribution information

Hi,Our business is divided into mobile web and mobile app users. We use the same code base for both web and app users and use JS SDK of Amplitude. We use Adjust as our mobile attribution tool. The problem we face right now is since Amplitude’s JS SDK doesn’t capture IDFA or IDFV or ADID by default whatever the attribution data we get from Adjust is lost. After going through the documentation I understood that we need to send Attribution IDs to Amplitude via HTTP API. Most of our users are guest users.So, the question here is how do we device a solution where we capture attribution information of all the users whether they are signed in or not?One solution I have in my mind is setting the Amplitude User ID to a random UUID (cookie set on the device) which we also store in our Adjust data exports and from our data lake make HTTP calls to Amplitude using user_id as this UUID cookie value and the IDFA or IDFV or ADID information captured by Adjust.  Other suggestion we need is how do we ge

3112
R
Novice
3 years ago
N
nadjareNew Member
asked in Data Instrumentation
Can I select the information from the event properties of the LAST performed event within a form_id?

Hello!Using our product, the user always has to create a form and work in this form for the entire user flow. A user can have multiple forms, e.g. projects.I would like to give this form a form_id (3456) and then have defined events, like an excel export within this form. The event has properties like excel_export_price and excel_export_price_automatically_chosen.However, I only care about the last event properties of the excel export of the form of the user. Is there a way I can select the information from the event properties of the last performed event within that form_id?For my analysis, I then want to compare the composition of prices and automatically chosen prices across all my users, on their last excel export.So far, I could only find the historical events in the amplitude help center, this does not really help me, as user can export the Excel as many times as they want to.Also if there is already a way of selecting the last event using Segment.io, this could be interesting to

3852
Denis Holmes
Team Member
3 years ago
U
urbanjerroldNew Member
asked in Data Instrumentation
Retention analysis - segment by event

Hi,I’ve been spending some time in Amplitude’s “Retention Analysis” recently, and we’ve had some great insights! Though am a little confused on the best way to segment users based on events.E.g. Say I have is a music player app (like Spotify), I can create a starting / return event of “Played song”.Then I want to see if users who loaded the “Viewed top 40 hits” are more retained or less than baseline.  I would then go to the “...performed by User” section (on the right) pick users “who performed” “Viewed top 40 hits”, which will create a new segment that I can compare.This makes sense, though I’m confused how the different “any time” dropdowns work e.g.If I pick “during last 30 days” (the default), does that mean in the breakdown, any week AFTER 30 days will only contain users who viewed the top 40 hits in the last 30 days?  This doesn’t seem like a good metric so perhaps using “within” makes more sense - so we can get a better understanding of users in the past and not just users who

4063
Denis Holmes
Team Member
3 years ago
H
HuchNew Member
asked in Data Instrumentation
Deletion List - will amplitude delete our account?

We are a young start-up and have never given much thought to what we track in a meaningful way. So when in doubt, we used to track a lot. This helps us now to improve our product step by step. But we are still a long way from turning it into a profitable business. We have already exceeded the event limit a few times and today we received a letter from an Amplitude employee stating that we have been marked on a deletion list. If we don't upgrade, our account could be deleted. I always thought that only the access to the portal is temporarily blocked. Have any of you had this before?Do we really have to fear that our account will be deleted now?We just can't afford to upgrade yet. Best,Christoph

3622
Saish Redkar
Expert
3 years ago
REM5 Studios
Well-Versed
REM5 StudiosWell-Versed
asked in Data Instrumentation
How do I pull a specific event (with all event properties) and export to CSV?

Hello!I am new to Amplitude, and I am attempting to integrate Amplitude with my VR app. At the conclusion of the VR experience, data about the user’s experience is compiled into an event with about 30 or so event properties (each event property is a datapoint generated by the user’s experience).For the date range of my choice, I need to compile and export (as a CSV) all instances of this specific event, along with all event properties, so that I can analyze aggregate results from the VR experience in Excel.How can I accomplish this?

254312
MikkoKarvonen
Peer Moderator
3 years ago
M
Max1721New Member
asked in Data Instrumentation
How do I get a list of Users ID from a Segment or a Cohort of Users ?

Hi Everyone, I am looking for a way to see a list of User IDs for a specific segment. I’ve been able to find a segment of our users who are super sticky (90% retention on D7) and I’d love to explore the users, understand what they did in their first session etc etc. How do I get the list of users from that segment? 

13292
M
3 years ago
R
rroestorfNew Member
asked in Data Instrumentation
Segment Page Events

In our Web App we use Segment’s Page call to track page events.We can select the event in Amplitude but there is no event traffic coming through.These are our Segment settings:and in Amplitude: 

2981
Denis Holmes
Team Member
3 years ago
J
joao-blueshipNew Member
asked in Data Instrumentation
Retention starting event - "New user" or "Any event"?

Hi folks,I’m confused wether I should track my usage retention by setting the starting event as “New User” (default) or as “Any Event” (as taught in some Amplitude tutorials).Which one would be more accurate?I’m currently setting as “Any event” => came back and did “Active Event”Thanks

3111
ning.chang
Team Member
3 years ago
L
Helpful Hero
liukaichiHelpful Hero
asked in Data Instrumentation
Strange boolean capitalization behavior

We have a strange thing going on with some of our boolean values. When I look up the event property in Amplitude, it shows values that are uppercase (True/False) as well as other values are lowercase (true/false). We have 3 clients -- iOS, Android, and Web. The iOS one is sending mostly lowercase values, while Android and Web tend to show uppercase values.Event properties have clear cut behavior -- Android/Web is purely uppercase boolean, iOS is purely lowercase. However with User Properties, it seems cross-platform behavior will make some bleed between these rules, although the overarching trend is the same -- Android/Web is upper, iOS is lower.I can’t quite believe this is our doing. Android and Web both use languages that are, by default, lowercase booleans. So there would be no reason for us to change the value sent to Amplitude. Has anyone else ran into this issue? Anything we can do about it?

7034
Denis Holmes
Team Member
3 years ago
S
stgo.larrainNew Member
asked in Data Instrumentation
Inconsistent Stickiness and Retention

Hi! I’m new at using amplitude and I’m struggling to understand the relation between stickiness and retention. I have set up a cohort with users that have a strong usage for a specific event (“AddToWishList” event), +5 events during july 2021, and at least one event (“AddToWishList” event) during august 2021. Then I plot a daily retention chart during the period of august 2021 for the same starting event and return event, i.e. “AddToWishList”. Our daily retention is over 40% for the entire period as the figure shows. So far so good. Then I plot the stickiness chart for the same event and time period and cohort. The below chart shows that 18% of users from the segment have emit the event only once and only a few users really “sticked” with the event. Given a +40% of retention for a given cohort, I would have expected a higher stickiness for the same event. This said, I expect users to have used at least 15 days during the same evaluation month. Given the above information, what should b

6206
S
3 years ago
belinda.chiu
Team Member
belinda.chiuAmplitude Support
asked in Data Instrumentation
[Amplitude] What values will appear under the Platform user property?

What values will appear under the Platform user property? It seems like when I use the JS SDK, the Platform will always be Web. 

5541
belinda.chiu
Team Member
3 years ago
J
Novice
jj41Novice
asked in Data Instrumentation
How to Concat a text value using Derived Properties?

I want to concatenate two properties with a “/” in the middle. When I try using CONCAT(property-1,property-2), it works fine. However, when I try using CONCAT(property-1,”/”,property-2), it doesn’t work. Could soemone let me know what is the issue here?  Thanks a lot!

3412
tracy.guo
Team Member
3 years ago
N
NicolasNGNew Member
asked in Data Instrumentation
Hubspot integration. Is it possible to update properties?

Hello, I hope everyone is doing good.We are a Saas, and we connected Adjust to Amplitude to track user behavior depending their sources. The next step for us would be to send these data to Hubspot to update properties of the users in Hubspot with Amplitude data and the Adjust data that have been send to Amplitude. For this we would like to use User ID as matching ID. We have the user ID in Hubspot so that would be easy to match the data from both parts. My question, is, is it possible to send user data to Hubspot for at the end create a workflow in Hubspot to update properties ? Thanks, I hope have been enough clear ! 

3184
Denis Holmes
Team Member
3 years ago
K
kimslava.nambaNew Member
asked in Data Instrumentation
Not all event are ingested over time. NodeJS

I have 1 test project and 1 production.After a proper configuration and tests, we’ve launched analytics in our application, but over some time, some events stopped working at the beginning on test project and a little bit later on production.Limits data is fine. More over most of the events are still coming. Event Limit10M / monthEvents Last Month68Events This Month35Event Usage35 of 10,000,000 (0.000350%) just to make sure that all properties are passing the validation requirements I’ve tried- to remove all properties and send a plain event with no data- to remove insert_id as a unique id per event- change and remove identify propeties the only thing that worked is changing the name of the event. so like before it was `event_name` and after it became `event_name2` and it worked, but I’m still wondering why could it happen so, that only some events are not ingested properly? changing a test project also helped, but I don’t see any difference in configuration of the project

2873
eddie.gaona
Team Member
3 years ago
C
Novice
Carolin KobeltNovice
asked in Data Instrumentation
Aggregated attribution data after iOS14 available in Amplitude?

We are using Adjust as attribution tool and forward the data to Amplitude. With iOS14 an the SKAd Network we see aggregated data in Adjust for our paid networks but this data is not forwarded to Amplitude. My understanding is that Amplitude needs the IDFA or IDVF to match the attribution data with actual users, otherwise the data will be dropped. So currently the aggregated data from paid networks on iOS14 is completely missing in Amplitude. In the documentation on this topic (https://help.amplitude.com/hc/en-us/articles/360047228311-FAQ-Apple-s-iOS-14-IDFA-Changes#does-amplitude-require-idfa-on-attribution-events) I stumbled over this sentence: “We are working with attribution vendors to see whether there is any aggregated data that our customers can send to Amplitude.” Any news on that…? 

4763
belinda.chiu
Team Member
3 years ago
B
BoryanaNew Member
asked in Data Instrumentation
Content organisation

Dear community,Our team is relatively new to amplitude, but we already have a large amount of content and are currently brainstorming ideas how best to organise the charts, reports, and teams spaces. Therefore, we are wondering what the best practices are.Looking forward to your ideas! 

2421
Saish Redkar
Expert
3 years ago
R
Novice
robin.bonduelleNovice
asked in Data Instrumentation
Filter on user domain not working

Hi, I try to filter out my internal users with the domain, with a condition like “domain is not claap”.When I do a segment “domain is claap”, the segment is correctly filtered to list all my claap internal users.However, when I do the segment “domain is not claap”, some of the suers with a claap domain (not all of them) are not correctly filtered out. Note that I also tried all variants “does not contain”, and so on…This pb also appears when I filter on the email directly.I tried to investigate on the root cause (either our instrumentation or the way Amplitude works), but I can’t understand why the filter works to include but not to exclude. For instance the screenshot below illustrates this with a specific user. I would expect segment 2 to return 559 users and not 560 (ie all users). Am I missing something? Thanks for your help!

6846
R
Novice
3 years ago
V
vtabanNew Member
asked in Data Instrumentation
COPPA - IDFV

We're developing Kids games, therefore we're using Amplitude in COPPA mode however in COPPA mode Amplitude does not allow to collect IDFV besides IDFA, city, IP address and location tracking.  However since IDFV is a publisher level ID, Apple does not not restrict the collection IDFV which helps us to identify same users among our games. Is there any chance that Amplitude collects IDFV in COPPA mode ? Or any workarounds ?

7383
Nadia
Team Member
3 years ago
S
sasanktkNew Member
asked in Data Instrumentation
Deleting event types

Hi,I deleted all event types from Govern page, but I see still says I exceeded 2000 event types - “Your instrumentation is approaching the maximum allowed number event types or properties.” and no new events are being logged. How can I fix this? 

3811
tracy.guo
Team Member
3 years ago
R
RosieC.New Member
asked in Data Instrumentation
Is there anyway to view the cohort population over a longer time horizon?

I’ve setup a cohort on uninstalls as we have quite a few users that reinstall our app (so the query is based on uninstall events being > install events, to correctly capture uninstalls). I’d like to see this over a longer term time horizon than 30 days, or alternatively if possible, add the cohort to an event segmentation so i can run it that way. Is this at all possible?

2832
eddie.gaona
Team Member
3 years ago
V
Conversationalist
vjbhaktaConversationalist
asked in Data Instrumentation
What are the means to import data from Microsoft Azure Data Explorer ?

Hello there,I have my product (a device) data stored in Microsoft Azure Data Explorer. The important events that happened in the device are captured and stored in json format in a table with time-stamp and device-identifier.How to import this data to Amplitude for analytics? Is there some form of connector for Microsoft Azure Data Explorer?I have seen the Batch API. Is it the only way to import in my case? What tool do you suggest here , a python script or NodeJS Amplitude SDK to write script to download data from our database and use Batch API to import in Amplitude ?   

3782
Saish Redkar
Expert
3 years ago
B
bhillNew Member
asked in Data Instrumentation
Data retention

See the latest Starter plan updates hereStarter plans have access to query up to 1 year of data (could be last 365 days or between n date - n+1year date with only 365 days at max) Plus plans have access to query up to 2 years of data (could be last 24 months or between n month - n+24month) Scholarship/Growth/Enterprise have access to query unlimited years of data  How long does Amplitude retain (and make accessible)our user/event data? 

29935
tracy.guo
Team Member
3 years ago
B
bwardNew Member
posted in Data Instrumentation
Derive Property REGEXEXTRACT & logic help

Hello everyone,I’m pretty new to Amplitude and not very experienced with regular expressions, hoping for some help with my formula please.Background:  We operate overlay or banner ads on our website and, in this case, when a user clicks on one of these call to action buttons we pass a utm_content parameter which contains “yield” in the query string of the destination URL.I have something incorrect, a combination of a incorrect regular expression for “Contains” using REGEXEXTRACT, and/or my logic is incorrect with the statement.Here’s the Formula I currently have:IF(    REGEXEXTRACT(utm_content, "/yield") == "yield",        'true',        'false'    )When I create this Derived Property and select it, I only receive “false” as a filter option - so the function is incorrect and never resolves as true. Now, if I use a straight utm_content property then I can see all the campaigns where this occurs: Many thanks!

13223
ning.chang
Team Member
3 years ago

Recent Tips & Tricks

Terms & ConditionsCookie settings