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 feature is 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.

You will receive exported data as CSV by email.

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.

Limitations

  • Exported files will be available for 30 days

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

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?

😀 🙁