The purpose of this connector is to create a database (that can be located on your site, or hosted by ourselves) which holds a copy of the majority of your analytics in a format best suited for creating dashboards.
This feature is designed for Microsoft Power Business Intelligence
If you purchase this feature, we can provide the data to a PostgreSQL server which customer can host either with us or by themselves. As we are using PostgreSQL to host the data, we're able to not only service the majority of dashboard providers but also can give you direct access to give you the ability to query it yourself.
These databases are updated regularly so you have fresh data to work from. Below is an outline of the tables and fields that the database would hold:
- User - Table of all the Users in Orlo
-
- ID
- Email Address - Users email address
-
- Team - Table of all the teams in Orlo
-
- Name - The name of the team
- ID - The ID of the team to be joined with “User Team” table
-
- User Team - Used to join “Team” and “User” table together
-
- Team ID - ID of the team to be joined with “Team” table
- User ID - ID of the user to be joined with “User” table
-
- Social Account - Table of all your connected social networks with Orlo
-
- ID - ID of the account in Orlo
- Name - Name of the social account
- Username - Username of the social account
- Alias - Alias entered by you the customer of what you call the social network
- Account type id - Account type id to be joined with “Account Type” table
-
- Account Type - Table to join with to give you the name of the type of account
-
- ID - To be joined with “Account type ID” in the “Social Account” table
- Name - Readable name of type of account e.g. Twitter, Facebook
-
- Campaign - Table containing details of all the campaign information
-
- ID - ID of the campaign
- Name - Name of the campaign within Orlo
- Parent Campaign ID - The ID of the parent campaign if there is one
- Started At - When the campaign was started
- Closed At - When the campaign finished
-
- Followers - Table detailing the total followers per day per account
-
- Account ID - The ID of the account which can be joined with “Account” table
- Date - The date the sample value was taken
- Value - The total number of followers on the data
-
- Outbox - Table of all sent messages through Orlo
-
- ID - ID of the social post in Orlo
- Type - Type of post e.g. Text, Image
- Account ID - The ID of the account, can be joined with the “Account” table
- Social ID - The social ID given by the social network when we posted it
- Campaign ID - If this post was associated with a campaign the ID will be here and can be joined with the “Campaign Table”
- User ID - ID of the user who posted it, can be joined with “User” table
- Date Time - Time that the post was sent to the social network
- Like Count - The total likes the post received
- Share Count -The total shares the post received
- Comment Count - The total comments the post received
- Impressions - The total impressions the post received
- Reach - The total reach the post received
- Text - The body of the outbox message
- Native URL - URL linking to the post as it appears socially
- Orlo URL - URL linking to the post as it appears in Orlo
-
- Inbox Activity - Table containing inbound and outbound activity, essentially a view of the inbox
-
- ID - ID of the activity in Orlo
- Account ID - Account ID the
- Social ID - Social ID of the activity in question provided by the social network
- Parent ID - The ID of the parent if this is a sub comment
- Thread ID - The ID of the thread that this activity is involved in
- Campaign ID - If this is related to a campaign the ID from the “Campaign” table will be displayed
- Date Time - Timestamp of when the activity happened
- Tags - Tags applied by agents in the inbox
- Sentiment ID - ID of the sentiment applied, this is to be joined with the “Sentiment” table
- Assigned to User ID - ID of the user if assigned, to be joined with “User” table
- Assigned to Team ID - ID of the team if assigned, to be joined with “Team” table
- Actioned By ID - ID of the user who actioned the message, to be joined with “User” table.
- Actioned At - Timestamp of when the activity was actioned
- Author ID - Social ID of the author
- Author Username - The social username of the message author
- Is Private - Flag to indicate if the message was sent privately
- Is Inbound - Flag to show if the message was sent to you or received
- Orlo URL - URL linking to the post as it appears in Orlo
- Social ID - The ID of the message as provided by the relevant social network
- Language - The language of the message
-
- Sentiment Names - Table containing all the sentiment names
-
- ID - ID of the sentiment, to be joined with “Activity” table “Sentiment ID”
- Value - Value of the sentiment, can be “positive”, “semi_positive”, “neutral”, “semi_negative”, “negative”
-
For more information about this feature, please contact your CSM