We are looking for a Google Measurement protocol expert that has worked with complex offline transactions before.
In this case we are experiencing race conditions with adding offline transactions to cover transactions that hasnt been added automatically.
We have a current script for this but Im experiencing double transactions on the same ID due to race conditions and the 4 hour limit (i think).
So Im looking for options to have Google 99% vs the internal database we have. Our goal is to be as close as possible with a -+3% margin.
This is ASAP and you should have done similar things before, dont bother if you havent.
How it should look:
Screenshot from DB:
*Net revenue* = Actual amount: Jan 1 - Jan 22: 166 643 Clicks (same as transactions in Google analytics)
*Guessed Price* = The transaction in Google Analytics is not a REAL transaction per say. Its an estimate and could be a real booking months after the click, so therefor the earning is estimated to.
*Clicks *= Should be equivalent to Google Analytics transactions.
*Click ID* = Each click out from our site has their own unique click_id. Saved both server side in a local db and used as product_sku in google analytics.
Screenshot from GA:
MMP = The SKU item of the offline added product within the transaction.
ProductSKU with number = as you see Unique purchases should never be 2. At least the items should never be able to be double since its a unique click.
Current fields used for the transaction sent to Measurement Protocol:
sub create_transaction {
my $market_id = shift;
my $click = shift;
my $t = { } ;
$t->{ qt} = $click->value(queue_time);
$t->{ ti} = $click->value(stat_click_id);
$t->{ cu} = $click->value(currency_code);
$t->{ ta} = $click->value(site);
$t->{ tr} = $click->value(guessed_price);
return $t;
}
sub create_item {
my $market_id = shift;
my $click = shift;
my $i = { } ;
$i->{ qt} = $click->value(queue_time);
$i->{ ti} = $click->value(stat_click_id);
$i->{ cu} = $click->value(currency_code);
$i->{ in} = $click->value(click_type);
$i->{ ip} = $click->value(guessed_price);
$i->{ iq} = 1;
$i->{ ic} = MMP;
$i->{ iv} = $click->value(section);
return $i;
}
About the recuiterMember since May 20, 2018 Ramaswamysunder
from Teleorman, Romania
Candidate shortlisted and hiredHiring open till - Apr 29, 2021
Work from Anywhere
40 hrs / week Looking for help? Checkout our video tutorial
How to search and apply for jobs
How to apply? Do you have more questions about the Job?
See frequently asked questions