Skip to content

Exporting Users

Export the user’s details and social behavior that power the GetSocial Analytics if you want to make a deeper analysis or integrate with another analytics provider.

The export option is available inside Data Export → CSV Export in the GetSocial Dashboard and through the HTTP API

Is is also available through Smart Audiences:

  1. Navigate to your GetSocial Dashboard.
  2. Create a new Smart Audience or open Smart Insights of an existing one.
  3. Press Export Users button.

The exported data is current as of the time of export.

The exporting process can take from a few seconds to a couple of hours depending on the volume of data.
Once finished, the files will be available via webhooks.

Additionally, the files will be sent by email if requested through the GetSocial Dashboard.

Exported files will be available for 30 days.

Format

The data will be exported as CSV files, gzip compressed with a maximum size of 500 MB per file.
One single export can generate multiple files.

Available Properties

All Users

This is the list of all available properties when exporting users from a Smart Audience.

Property Description
distinct_id GetSocial Unique User ID
e.g., 110236346286681927
channel Name of the channel this user came from
e.g., whatsapp
campaign_id GetSocial Unique ID of Smart Link Campaign
e.g., 11023
marketing_link_id GetSocial Unique ID of Smart Link
e.g., 11023
medium Smart Link Campaign medium
e.g., cpc
identities Custom identities of the User (in JSON)
e.g., {"facebook":"1234567890", "custom":"0987654321"}
app_version Version + Build of the App
e.g., 1.0.1 (1017103015)
sdk_version Version of the GetSocial SDK
e.g., 6.10.1
city City (based on GeoIP)
e.g., Toronto
region Region (based on GeoIP)
e.g., Ontario
country Country Code ISO Alpha 2 (based on GeoIP)
e.g., CA
idfa ID for Advertising of the device (if available)
e.g., 4AF27B96-2E2D-4430-96E6-55B3AA30CFFF
ifv ID for Vendor of the device (if available)
e.g., 86F1FE93-07B6-420A-A019-F2F4B80DEFFF
user_language Language defined for the GetSocial SDK (full list)
e.g., en
device_language Language and Locale from the device
e.g., en-CA
device_timezone Device Timezone (full list)
e.g., America/Toronto
manufacturer Manufacturer of the device
e.g., Apple
model Model of the device
e.g., iPhone10,4
app_platform Platform
e.g., iOS, Android
os_version Version of the Operating System
e.g., 11.0.3
first_session UTC Timestamp of the first session
e.g., 2017-11-01 04:39:54
last_session UTC Timestamp of the last session
e.g., 2017-11-01 04:39:54
count_sessions Number of total session
e.g., 184
first_invite_sent UTC Timestamp of the first invite sent
e.g., 2017-11-01 04:39:54
last_invite_sent UTC Timestamp of the last invite sent
e.g., 2017-11-01 04:39:54
count_invites_sent Number of total invites sent
e.g., 184
first_activity_posted UTC Timestamp of the first activity posted
e.g., 2017-11-01 04:39:54
last_activity_posted UTC Timestamp of the last activity posted
e.g., 2017-11-01 04:39:54
count_activities_posted Number of total activities posted
e.g., 184
first_comment_posted UTC Timestamp of the first comment posted
e.g., 2017-11-01 04:39:54
last_comment_posted UTC Timestamp of the last comment posted
e.g. 2017-11-01 04:39:54
count_comments_posted Number of total comments posted
e.g. 184
first_install_generated UTC Timestamp of the first install generated
e.g. 2017-11-01 04:39:54
last_install_generated UTC Timestamp of the last install generated
e.g. 2017-11-01 04:39:54
count_installs_generated Number of total installs generated
e.g. 184
first_friend_added UTC Timestamp of the first friend added
e.g. 2017-11-01 04:39:54
last_friend_added UTC Timestamp of the last friend added
e.g. 2017-11-01 04:39:54
count_friends Number of total friends
e.g. 184
public_properties Public user property defined by the developer
e.g. colour
private_properties Public user property defined by the developer
e.g. weapon_type
referrer_user_id GetSocial Unique User ID of a referrer user
e.g. 110236346286681927
first_purchase UTC Timestamp of the first invite sent
e.g. 2017-11-01 04:39:54
last_purchase UTC Timestamp of the last invite sent
e.g. 2017-11-01 04:39:54
count_purchases Number of purchases by the user
e.g. 3
ltv Total purchased (USD) by the user
e.g. 3.99
social_ltv Aggregated Lifetime Value (USD) of the referred users
e.g. 8.25
ban_expiry If set, indicates the UTC Timestamp when the ban should be lifted
e.g. 2023-11-01 04:39:54
ban_reason Custom reason why the user was banned
e.g. Cursing and Improper language
is_verified Boolean value that indicates if the user is or not verified by the developer
e.g. true or false
can_moderate Boolean value that indicates if the user can moderate content automatically when reporting
e.g. true or false

Facebook Users

This is the list of all available properties when exporting Facebook users, from a Smart Audience, to create Facebook Custom Audiences and Facebook Audience Lookalikes.

Property Description
ct City (based on GeoIP)
e.g. Toronto
st Region (based on GeoIP)
e.g. Ontario
country Country Code ISO Alpha 2 (based on GeoIP)
e.g. CA
madid ID for Advertising of the device (if available)
e.g. 4AF27B96-2E2D-4430-96E6-55B3AA30CFFF
uid Facebook User ID
e.g. 1234567890
value Customer lifetime value
e.g. $4.75

Give us your feedback! Was this article helpful?

😀 🙁