Changes for page Export Tool

Last modified by rijo on 2022/07/28 16:10
From version 2.1
edited by Admin
on 2021/05/01 19:06
Change comment: There is no comment for this version
To version 3.1
edited by Admin
on 2022/04/24 11:25
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,23 +1,51 @@
1 1  You can set up automated export from ONEcount to an FTP or SFTP site using the Export Tool.  Export Jobs are scheduled by the system and run every hour. Jobs run in parallel and can take from a few minutes to several hours to complete. You can enter an e-mail address into your job. If you do, an e-mail will be sent to the e-mail address when your job completes, including relevant information about errors, problems with the job, etc.
2 2  
3 -To start, choose Export Tool under Utilities on the main menu:
3 +To start, choose Export Tool under Utilities on the Data Management Menu.  You will see a list of import jobs that are already in the system. Click Create New Import/Export job in the upper-right corner to create a new import job:
4 4  
5 -[[image:attach:Import Tool Nav.png]]
5 +[[image:attach:Export-job-list.png||width="1000"]]
6 6  
7 7  \\
8 8  
9 -You will see a list of import jobs that are already in the system. Click Create New Import/Export job in the upper-right corner to create a new import job:
9 +Now you'll create your import job. First, give the job a name and a brief description. Next, choose which DExTr mapping you will apply to this import. These are the mappings you created in the [[DExTr>>doc:Utilities - DExTr]] tool, also under Data Management.
10 10  
11 -[[image:attach:List of Import Jobs.png]]
11 +[[image:attach:Import Job Choose Mapping.png]]
12 12  
13 -Now you'll create your import job. First, give the job a name and a brief description.
13 +=== Export Types: ===
14 14  
15 -[[image:attach:Import Job.png]]
15 +ONEcount offers multiple types of data exports. Choosing a data type will present you with export options specific to that export type. The simplest type of export is the **User Export.** This exports user demographic data from the system. This option will export data for ALL users in the system:
16 16  
17 -Next, choose which DExTr mapping you will apply to this import. These are the mappings you created in the [[DExTr>>doc:Utilities - DExTr]] screen.
17 +[[image:attach:User-Export.png||width="1000"]]
18 18  
19 -[[image:attach:Import Job Choose Mapping.png]]
19 +\\
20 20  
21 +Another type of export is **Transaction Export.** This option allows you to export data relating to product or package transactions that have been recorded in ONEcount. You may choose product OR package export, and you can choose the specific source code, product or package TERM that you would like exported. Please note that all of these options are// limiting //options. To export all transactions, leave the product, TERM and source code options blank.
22 +
23 +Examples: To export all transactions used by a specific source code or codes, enter the codes you would like exported and leave the product/TERM options blank. To export all transactions for a product or TERM, choose the product(s) or TERM(s) and leave the source code field blank. Remember, these options are //limiting //options.
24 +
25 +[[image:attach:Transaction-Export.png||width="1000"]]
26 +
27 +\\
28 +
29 +The third type of export is an **E-Mail Engagement Export. **With this option you can export e-newsletter engagement data from the system. When you choose e-mail export, you will need to pick the e-mail vendor for this export (the pull-down will show all of the e-mail systems that are configured for your system). Then you can select the newsletter list(s) or specific campaign(s) that you would like exported. Again these fields are limiting fields, so if you want to export e-mail engagement for all campaigns across all lists for a vendor, leave these fields blank.
30 +
31 +\\
32 +
33 +[[image:attach:e-mail-engagement-export.png||width="1000"]]
34 +
35 +Another type of export is** Web Engagement Export. **This exports web engagement data for all users across the entire ecosystem. There are no limiters for this export other than the date range export at the bottom of the screen.
36 +
37 +\\
38 +
39 +[[image:attach:Email-Engagement-Export.png||width="1000"]]
40 +
41 +The final type of export is **Banner Engagement Export.  **This screen allows you to export banner data that has been collected by ONEcount. The options here are limiter options, meaning if you choose an option, the export is limited to the engagement for that option. For example, to export only engagement for a specific advertiser, choose an advertiser from the Advertiser list. To export only a certain campaign from that advertiser, enter the campaign(s). To limit the output to users who were acquired (subscribed) through a specific source code, enter that source code into the box.
42 +
43 +For example, to export all impression and click data for Angel Oak's Q1 2022 campaign, select Angel Oak as the advertiser and then choose the specific campaign you are interested in. If you would like to only report banner activities from users who were either part of an advertiser List Match or that were part of a specific product or segment, add the Source Code for that List Match in the Source Code box and the only activity that will be exported will be that of users who have that source code in their transaction history.ff
44 +
45 +[[image:attach:Banner-Export.png||width="1000"]]
46 +
47 +\\
48 +
21 21  Now choose whether the file should be accessed via FTP, SFTP, or URL. We recommend using SFTP or an HTTPS URL, since most imports involve some sort of PII. You will need to enter the full file path to your file, including the file name.
22 22  
23 23  For example, if you are importing a file called CRM-data.csv, and  your file is on an SFTP site and it is in the /files/outgoing/, then in the File Path field you would enter: /files/outgoing/CRM-data.csv.
... ... @@ -44,10 +44,8 @@
44 44  
45 45  Next enter the FTP/SFTP/URL login credentials required by the remote system. ONEcount will use these credentials to fetch your file and import it.
46 46  
47 -Finally, choose the frequency for this import. Available options are Daily, Monthly, One-Time or Weekly.
75 +Finally, choose the frequency for this import. Available options are Daily, Monthly, One-Time or Weekly, and the date range you would like exported. This allows you to set up a feed of data to your advertisers or partners that include data from the last N days, etc.
48 48  
49 -[[image:attach:Import Job Frequency.png]]
50 -
51 51  When you are done, hit Save and your Import Job will be saved into the system. It will run the next time ONEcount scans your queue for jobs, and you'll receive an e-mail notifying you when the job is completed.
52 52  
53 53  \\
Confluence.Code.ConfluencePageClass[0]
id
... ... @@ -1,1 +1,1 @@
1 -66715785
1 +77496324
url
... ... @@ -1,1 +1,1 @@
1 -https://info.onecount.net//wiki/spaces/OD/pages/66715785/Export Tool
1 +https://info.onecount.net//wiki/spaces/OD/pages/77496324/Export Tool