1. Pendo Help Center
  2. Community
  3. Integrations

Guide Events Primary Key

Avatar
h p

Is there a set of keys to uniquely identify my guide events records ie. (Primary Key for guide events records)

I have more than 12000 records for "guide_events", but at the destination side I am missing out on rows because of Primary Key selection, currently I am having the following Primary Key, however it does not identify each record uniquely.

['account_id', 'visitor_id', 'server_name', 'remote_ip']

Here is the sample response we get from `guide_events` endpoint:

{
    "accountIds": [
        "ACC-TEST-ID"
    ],
    "browserTime": 1607122240407,
    "country": "US",
    "elementPath": "BODY",
    "eventId": "",
    "type": "guideSeen",
    "guideId": "hsd5h2s-pfw72tESt55n6j8L34",
    "guideSeenReason": "auto",
    "guideStepId": "D31V104QGRfraTeSt3bQRtyTeST",
    "latitude": 19.955524,
    "loadTime": 0,
    "longitude": -85.123272,
    "oldVisitorId": "reason:auto",
    "region": "ab",
    "remoteIp": "bbb.aaa.aaa.bbb",
    "serverName": "test.com",
    "title": "ANd7wdvHVE8VbbjbVHevKENbdfebdTESTGebdefeABHEBh72y75HVH262JBDtestDebfjebfeuAT6r5fJBJVHCGjfbehvfhe8yy7575879767BTesTHVCbGCGCGVhbgtt7y8gjbdw6FDtEsT6Yvydey",
    "url": "http://test.com/",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X) AppleWebKit/123.45 (KHTML, like Test) Chrome/99.0.9999.99 Safari/123.45",
    "visitorId": "_PENDO_T_AJTEst11q20",
    "appId": -635363,
    "accountId": "ACC-TEST-ID"
}

 

Does anyone know what `guideStepId` in the response suggests?

 

Thank you.

0

Comments

1 comment
Date Votes
  • Avatar
    Howard Lio

    Hello,

    guideStepId is the unique identifier of the guide step within a guide. (Check out our API documentation for more info - https://developers.pendo.io/docs/?bash#source-specification)
     
    A guide that has 3 guide steps will generate 3 guideSeen events with three unique guideStepId’s. you can group those events together by the guideId because that’ll be the unique ID of the guide in question.
     
    For your 12,000 events, it could happen if you have 400 visitors that see 10 guides w/ 3 steps a piece - leading you with 40*10*3 worth of guideSeen events
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post