How to upload your Amazon and Facebook Ads to AHS

How to upload your Amazon and Facebook Ads to AHS

Grabbing your Facebook Ads data


There are two ways you can get your Facebook Ads data. One of them is to go to the Facebook Ads Manager, set everything up appropriately, choose your timeframe, and download the data. Then, once you have it, go to the Author Helper Suite and upload the file you downloaded. If this is your first time using the Author Helper Suite you will want to do this method so you can grab your historical data. 
​

The second way is to connect your Author Helper Suite account with our Facebook App so we can automatically grab your Facebook ads data for you. IMPORTANT NOTE: The app will only download the last 7 days worth of data. So if you miss a week, you will still need to manually download from the Facebook Ads Manager. 

Method 1: Manually Downloading/Uploading Facebook Ads data

Step 1: In order to get an ROI, we need to have some ads data. Assuming you use Facebook ads, let’s jump over to your ads manager and get set up. Once there, click on the Ads tab and then view the dropdown (it is usually defaulted to Performance) and select Customize Columns.


Step 2: Using the middle section of the window that pops up, verify that all of the items listed in the following image are showing up.

NOTE: You do not need to remove any columns from the list that are already present, unless you choose to. We just need to make sure that all the columns on the image below are there. Additional columns will not impact anything negatively.


Step 3: Once you have added all the required items, look at the bottom left of the window and you’ll see an option for Save As Preset. Click the checkbox and a field will appear for you to name the preset. Type The Author Helper Suite into that field and then click Apply.


Step 4: We now have The Author Helper Suite view all set, but to make things easier for reporting, you can make it the default view. Doing this will make it so you don’t have to change the view to The Author Helper Suite every time you want to export your data. If you don’t want this as your default view, that’s fine but make sure you change it to The Author Helper Suite with each export.


Step 5: When you go to export a Facebook ads report for The Author Helper Suite, you need to verify three things.

  1. You’re on the Ads tab
  2. The columns view is set to The Author Helper Suite
  3. You’ve selected the correct date

If all three of these things are set, you’re ready to click the Reports dropdown and select Export Table Data.

Note: If you’re on the wrong tab or you don’t have the The Author Helper Suite column view selected (or it hasn’t been configured correctly), you’ll get an error when uploading to The Author Helper Suite.


Uploading by date range

You may also upload your ads report by date range (up to 31 days). Follow these steps for details…

First, choose the date range. If you select more than 31 days, The Author Helper Suite system will give you an error.


Next, choose the Breakdown tab.


Set the breakdown to be BY TIME and DAY. 


If you also want to be able to filter on the main charts by country, and see your Facebook ads data broken down accordingly, make sure to also filter by country.


Continue on to the next step, doing the exports as normal and then upload to The Author Helper Suite system.

Step 6: The only item you want selected on the Facebook ads report export popup window is Export as .csv. Everything else should be unselected. Once that’s in place, click the export button and save the file to a place on your computer that you can easily find.


Step 7: Now go back to The Author Helper Suite and click the Upload ads report button at the top. Choose the file you just downloaded from Facebook and upload it to The Author Helper Suite. If you set up everything correctly, it should upload without a hitch.


Step 8: Head to Reports | Manage Ad Assignments and assign each ad to the correct book. 

Step 9: Now that you have the Facebook ads data imported, you can head to the Homepage or Book pages and check out your ROI. You’ll need to upload multiple days for this to be accurate, of course.




Method 2: Using the AHS Facebook App To Get Your Ads Data

Step 1: Click the Import Facebook Ads button on the home page.


Step 2: Authorize the AHS Facebook App. 





Step 3: If you have multiple ads accounts, you’ll need to select the one that you plan to use on AHS. NOTE: We only support one connection.


Step 4: Verify that everything looks right before you import your data. If it does, click the import button and do a little happy dance.


Step 5: You’re all set, so you can jump back to the home page and continue about your day. NOTE: Please remember that the AHS Facebook App can only import back 7 days, so make sure you do the importing every few days so you can avoid having to manually download/upload your reports.



Grabbing your Amazon Ads data

In order to get your ads reports for Amazon up on The Author Helper Suite, please follow these steps.

STEP 1 – Make sure you’re on the main campaigns page and select the date you want to download. 

NOTE: Amazon often updates the data multiple days later, so you should always go back a few days to make sure that you have the latest data. How many days is unknown, but we tend to look back 10 days, personally.

NOTE: DO NOT use date ranges. Amazon does not split the data up over date ranges. You must upload only ONE day at a time. If you do a date range and upload it, you’ll just see a big spike for that day. If that happens, simply download the single day’s worth of data and then upload it again.

Follow this image for details.

INTERNATIONAL REPORTS: If you are using Amazon ads for countries other than the United States, please note you’ll need to make sure to upload a report from each country you’re using.

At current, we only support the following countries for Amazon Ads reports:

  • US
  • UK
  • CA
  • AU
  • DE (see below for special requirements for the DE report!)

In order to use German reports, you must set the language to Deutsch before downloading. This is because the report looks identical to the UK report otherwise, and the AHS system will assume it is the UK report. By changing the language to Deutsch before downloading, the report itself will be in German, thus making it clear the report is a German report to the AHS system.

If you do not speak German (Deutsch), it is recommended that you first set up your timeframe for the report and then change the language before exporting.

After changing the language, you would click the Exportieren button to download the report. 

You can then set the language back, as necessary. 

STEP 2 – Make sure you name the file correctly.

No matter what date you select when you filter your ads data, Amazon will put today’s date as the file name. Make sure you change that name accordingly.

Follow this image for details.

STEP 3 – Upload your report to The Author Helper Suite

The key component here is that you want to make sure you select the right date for your report. This is only necessary for Amazon ads reports because–for reasons we can’t explain–Amazon does not put the date in their reports.

NOTE: The Author Helper Suite has no way of knowing if the date of the report is correct for the date you select. The good news is that if you accidentally select the wrong date you can now simply upload the report again using the right date! Just remember that you’ll also need to re-upload the report for the date you had accidentally selected.

Follow this image for details.

STEP 4 – Do sanity checks on the data

At certain intervals, you’ll want to check the data to make sure that Amazon hasn’t updated your daily spends. About 10 days into the month, take a day to fully look over the previous month’s data, for example. 

Follow these images for details.



    • Related Articles

    • I'm an international author. How does The Author Helper Suite handle Amazon, Facebook Ads, AMS Ads, and other critical data?

      AHS supports international authors with the following: You can choose your AHS currency for Australia, Canada, US, GB and Euro. The following reports can be uploaded as-is, with no manual conversion required of you: Amazon KDP from all countries can ...

    • How do I upload Amazon Ads to AHS?

      In order to get your ads reports for Amazon on The Author Helper Suite, please follow these steps. STEP 1 – Make sure you’re on the main campaigns page and select the date you want to download. NOTE: Amazon often updates the data multiple days later, ...

    • How can I delete an ads report?

      You can delete ads by doing the following: 1. Select Account/Subscription from Settings. 2. On the Settings page, click 'Remove Ads Data' tab. 3. In either the Facebook or the Amazon section, enter the date for the ad report you'd like to delete and ...

    • My Facebook Ads report won't upload to ReaderLinks

      The most common reason for this is the Campaign Name column missing from the report. The reason for this is when the Facebook custom report is not crafted from the Ads tab on Facebook, the final report doesn't include the Campaign Name data. To fix ...

    • How do I assign ads to different pen names?

      1. Upload your ads report to your default pen name. 2. Go to the AuthorAnalytics drop-down menu at the top of the page and select "Manage Ad Assignments" 3. On this page, assign each ad to its respective book for that pen name. 4. Assign ads that do ...