This guide is for event managers who do not have build access to their events, who's events live in a separate organiser account and they have been looped in for reporting access. For venues / promoters who own their events, see AREP's guide here.
To Get Started
Ensure you have:
- An active Moshtix account with reporting access
- An active Audience Republic accountShare your Moshtix Control Room Credentials with your Audience Republic Customer Success Manager
-
Make sure your Audience Republic Customer Success Manager has provided you with:
Optional Path (this should be your Promoter OID)
Access Key
Secret Key
1) Locate the 'Joint Ownership Data' feature - if you do not see this feature, contact your Audience Republic Success Manager.
2) Pull your export credentials.
3) Log in to the Moshtix Control Room.
4) Navigate to Reports > Insights > Audience Tab
Select the "Purchases by Ticket" Report
5) Configure two reports: one for historical data (Send) and one for ongoing data (Schedule)
- Click on the 'Actions' gear and select 'Schedule'
6) - Name your schedule
- Select ‘Amazon S3’ as the report destination
- Enter the AWS credentials and bucket details:
- Bucket: ar-integrations-moshtix
- Optional Path: use your Promoter OID provided by Audience Republic
- Access Key and Secret Key: use credentials provided by Audience Republic
- Region: Asia Pacific (Sydney) - ap-southeast-2
Set the file format to CSV
7) Configure the filters
- Booking Transaction Timestamp Time: "in the past 2 days"
- Client (For Event) Shared Client: select ‘any value’
- "Event is not null" ensures that all ticket orders are attached to a valid event
- "Orders Subscribed To" Event Organiser - is any value
Under ‘Advanced Options', ensure the Limit ‘All Results’ is selected, otherwise, exports are limited to 5,000 rows by default.
- Click Save All
8) Click Save All, then reopen the report and click Send Test
Verify Connection
Once the credentials have been added, please notify your customer success manager or customer support so they can check this has been set up correctly. Please note that as this is a scheduled daily report this data will not automatically sync into your account. Please wait until the following day for the data to load into your account.
Connect the integration in your Arep account
By following these steps, you'll be able to set up a scheduled report in Moshtix that will automatically send data to Audience Republic, streamlining your event management process.
Exporting historical data
You may also wish to do a historical export. To do this, open the ‘Send’ menu item from the action gear. Fill out the form as per the scheduled report (obviously, there is no scheduled in this version of the form).
The only difference should be the Booking Transaction Timestamp Time, which you can configure as per the customer’s historical data needs.
After pressing ‘Send’, keep an eye on the S3 bucket to ensure the data arrives.
What data is included?
Contact ID, name, email address, mobile number,
Date of birth and gender,
State, postcode and city
Event name, ID and event time,
Event images aren't included in Moshtix exports
Sync Tickets/Orders
Ticket price
Only contacts that have ordered something are synced
Auto sync frequency is Daily
Historical time limit is 24 months
Marketing Opt in available from provider
What data is not included?
Country
Tags
Webhook syncs
Event images
Data availability
Please be aware that due to the limitations of the Moshtix Control Room, some sales statistics may be one day behind.
Comments
0 comments
Article is closed for comments.