Skip to main content

Data Instrumentation

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

  • 1,688 Topics
  • 4,132 Replies
1686 Topics
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 ?   

4662
Saish Redkar
Expert
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? 

33785
tracy.guo
Team Member
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!

15553
ning.chang
Team Member
A
antoniott15New Member
asked in Data Instrumentation
Update user ID by session

Is there a way to update the session ID by the user?I set the email as the user id after the user login, but before that i hace in the user id a numeric one, so to keep tracking the same user in the session i want to update the user id in the session. (The email address is not changeable so is unique forever), in another topic is there any way to track the download electron app? and track the same user in the app downloaded by passing session or something like this? 

7491
Jacenda Davis
Team Member
M
Conversationalist
miteshmakwanaConversationalist
asked in Data Instrumentation
is this possible to get below data if yes then how?

Can we get hourly report for the active user? On Which bases you can identify new user ? How many users uninstall the application ?

3521
ning.chang
Team Member
M
Conversationalist
miteshmakwanaConversationalist
asked in Data Instrumentation
Can I know about how many users uninstall the application ?

I want to know how may users uninstall the application.

14031
ning.chang
Team Member
C
Novice
CamilleNovice
asked in Data Instrumentation
Get session ID for UXCAM

Hello everyone,My team is using Amplitude on our react-native projects (@amplitude/react-native@2.3.3). We’re also using UXCAM to track user’s interactions with our apps. What we would like to do is to link both Amplitude and UXCAM, and we came across this article (https://help.uxcam.com/hc/en-us/articles/360050569672-Amplitude). Quite easy to understand but we have an issue with the last part (Log Amplitude metadata with UXCam). It says we need to get the Amplitude session ID to give it to UXCAM so it can link Amplitude events with UXCAM sessions. But we can’t seem to find this session ID anywhere. Nor can we find the “getSessionID” method. Do we need to install another library or will it be added in the future ?Thanks for you Help ! Camille

5266
C
Novice
Bill
Experienced
BillExperienced
asked in Data Instrumentation
How is "active" defined in Cohort definition?

If I am adding a condition in cohort definition “The Users who ...had been ‘active’ during last 30 days”, does it mean the user had logged at least one event every day in the past 30 days?  Or does it mean the user had logged at least one event in the past 30 days?

3792
tracy.guo
Team Member
Bill
Experienced
BillExperienced
asked in Data Instrumentation
Is there a way to export properties of events?

Hi,Is there a way to export the full list of events and their properties?I can export events, but can not find how to export properties.Bill

10281
Saish Redkar
Expert
M
Conversationalist
miteshmakwanaConversationalist
asked in Data Instrumentation
How can I show previous day(s) user event in user Look-up?

As currently I can show only todays events performed by user. I can not able to see previous events perform by user.

5411
Saish Redkar
Expert
Z
zlotkoNew Member
asked in Data Instrumentation
Why does User Activity API return empty list of events?

Hi everyone!I am trying to get list of events with event properties for a user. I see that events are shown in Events Stream on UI, however User Activity API returns OK response, but empty list of events.I send cURL like this based on API documentation:curl -u API_Key:Secret_Key 'https://amplitude.com/api/2/useractivity?user={AmplitudeID}'Please advise what is wrong. Maybe it is a bug? Thanks!

5113
eddie.gaona
Team Member
R
rishi_New Member
asked in Data Instrumentation
Array in user Property

can we get all the array element which are set against any particular key while setting values. or any way to delete any element in array.

17531
Saish Redkar
Expert
amplitude
amplitudeNew Member
asked in Data Instrumentation
Cohort by conversion rate?

Hi! I’m new to the platform and I was wondering whether I could create a cohort based on a particular conversion rate.An example would be if I wanted to study the behaviors (and events, etc) of those with a conversion rate (eg. Purchase) above a particular % or on a top percentile.Maybe I am looking at this the wrong way and there is a tool to do this already baked in :)Thanks!

3582
amplitude
R
raheelNew Member
asked in Data Instrumentation
View the usage of a property

We have a property that was previously being misreported by one of the clients. We plan to switch to a new property that reports this correctly.Is there a way to view all the charts that make use of an existing property (so we could switch them to use the new property)?

3862
Jacenda Davis
Team Member
D
dakkineniNew Member
asked in Data Instrumentation
Ingest user_properties other than user_id and device_id using NodeJS SDK

I am using NodeJS SDK to insert events and event_properties using HTTP API v2, and user_properites using identifyMy sample code block looks as belowimport { Identify } from '@amplitude/identify'import * as Amplitude from '@amplitude/node'const client = Amplitude.init(amplitude_api);const identify = new Identify();const payload ={event_type: eventType,device_id: row.deviceid,user_id: row.userid,event_properties: row,event_date: moment(row.timestamp).format('YYYY-MM-DD'),timestamp: new Date(row.timestamp),update_timestamp:new Date().toISOString(),context: {ip: row.ipaddress},// "user_properties": {// user_id: row.userid,// device_id: row.deviceid,// partner_id: row.partnerid,// slotid: row.slotid// },}identify.set('user_id', row.userid).set('device_id',row.deviceid)const userProperties = {'partner_id':row.partner_id as string,'osname':row.osname,'devicetype': row.devicetype}identify.append('partner_id',row.partner_id as string) const identifyEvent = identify.identifyUser('user_id','devic

6423
ning.chang
Team Member
A
aurelNew Member
asked in Data Instrumentation
What happened to the Series Color picker?

Hi there, This might seem really picky, but… We’ve got a large number of dashboards / charts that were affected by a recent change a few weeks ago to the series color picker. On this link: https://amplitude.com/blog/amplitude-dashboards-charts, the series color picker at the bottom has 15 separate colors… but a recent change that I couldn’t find in any changelog, seems to have completely changed which colors are applied to which series. The color picker now only contains 12 colors:  While ultimately, that’s fine - these colors are still great, the fundamental problem we’ve run into is that we’ve lost the ability to have colors that also indicate their meaning. Previously, for instance, we had a chart that contained something along the lines of GOOD, WARNING, ERROR, which we were able to indicate using green/yellow/red, but with the recent changes, it’s hard to get the colors to look like they’re indicating the same things.  The purplish red that’s highlighted in the second image is… fi

9161
ning.chang
Team Member
A
aniyaNew Member
asked in Data Instrumentation
Storing information as Event vs User Property

I'm trying to work out the best way to set up information, so that we're able to utilise the data as we hope in Amplitude. We would like to store the following info:- If a user is pregnant, when they are due (So that we can see how many users are due in a specific period, and extract this for comms)- If a user has multiple children, the birthdates of those children (So that we can see how many users have children under 2, over 2, etc.)What would be the best way to store these, so we could utilise Amplitude to show those charts?

6274
Saish Redkar
Expert
L
lorenzonanniniNew Member
asked in Data Instrumentation
Group user property values in buckets within user composition report

Hi! I’m trying to work out whether it’s possible to group several values within a user property into buckets, but haven’t found a way to do it yet.Specifically, I have a user property with users’ age with values indicating individual ages, and I would like to group them in custom buckets “i.e. 20 to 30 years old”.Can this be done with Amplitude? 

8761
Saish Redkar
Expert
K
KevComplimentNew Member
asked in Data Instrumentation
How debug when graph doesn't load?

Hi folk  ,Recently, I notice that for any reasons for some of my graphs, data aren’t loaded for the last 7 days tab.I can’t explain why and I would like to know if you have any clue about debugging such situation.What I did:- Check if data for related event was correctly send to amplitude (via network tab in the browser web console)- Since everything look okay I played with other tab (different durations) and everything look okay as well.- Check if it’s a pricing issue since I’m running into the free version at the moment, but again here, didn’t see any mention about that kind of limitation. So here I’m stuck, not able to see my last 7 days data which is super annoying regarde our growth strategy who need to be tested every weeks. Does anyone have a clue ?Thanks in advance for your time & help.Kev

3721
sydney.koh
Team Member
D
davidgoughNew Member
asked in Data Instrumentation
Checkout Event with Multiple Products

Hello, I´m new to Amplitude.Recently I discovered a few errors with the implementation that was done at my company before I started.And I would like some practical examples to show my IT team so we can fix it.One of the errors encontered was Check Out / Cart with Multiple ProductsAs Revenue = Price x QuantityBut what if you have two different priced products.Our implementation was “adding” the prices, adding the quantities and multiplying … but obviously this is wrong.What is the best way to solve this?Precalculate an average price based on quantities??

9774
sydney.koh
Team Member
C
chrishanNew Member
asked in Data Instrumentation
Device type displaying as "Apple iPhone"

On a User Composition chart I have that composes by Device Type, there is a large segment for the device type “Apple iPhone” – however, there are a bunch of individual models of the iPhone below – iPhone 12 Pro, iPhone X, iPhone 7 Plus, etc...I really want to know the composition of that larger iPhone category. Is this something I have configured incorrectly?

8071
Saish Redkar
Expert
B
bhillNew Member
asked in Data Instrumentation
Before/After Pages?

Is it possible to see what page a user came from (even if from an outside source) or what page they went to after a particular event?Thinking beyond the limitations of funnels.What drove a user to this particular page or where did they go after leaving?

5651
Saish Redkar
Expert
Bill
Experienced
BillExperienced
asked in Data Instrumentation
How to delete a chart in amplitude?

After creating a chart, how could I delete it?

20326
L
G
gbulutNew Member
asked in Data Instrumentation
Analysis with a dynamic date

Hey,I’m creating a Funnel Analysis to find out user/account count who performed specific events in an order in 7 days from their first date, but I also need to eliminate the users who haven’t had any events after 19 days of their sign up.Is there a way to enter the opposite of this filter? (like after 19 days of first use) Thank you!Gozde

4121
Saish Redkar
Expert
J
Novice
jguerinetNovice
asked in Data Instrumentation
Filtering Out Employees / Job Applicants

Hello, I am looking for a way to filter out specific users in a backwards compatible manner. The scenario is the following: We have some of our employees and job applicants creating some accounts in our production environment and we would like to filter out all of their activity from our various charts and analyses. We have come up with a simple tagging system, i.e. tagging the user as “employee” or “applicant” in a custom user property. However, the user properties are time-based, so any events that have happened before we set the user property are still included in the charts. I am therefore looking for a way to look at specific events while using the CURRENT user properties of the users, as opposed to the user properties the user had at the time the event happened. If this is possible, any insight on how you have approached a similar situation would be greatly appreciated!  Cheers, Julien

3376
J
Novice

Recent Tips & Tricks

Terms & ConditionsCookie settings